Comment

Thanks. We just bumped up the innodb_files_open to about 1000 and doubled the innodb buffer pool to 8gb (was 4gb before).

Queries are in a mixed state as we have a mixture of old application and a new one. The new one is being tuned on a weekly basis and we always send more queries for them to optimize.

However this seems to only happen when we get overwhelmed with traffic.

I noticed that normally we have about 10mbps inbound traffic to mysql and at that time it hit 100mbps.

Also why do you recommend disabling the query cache? I know its only about 50% utilized but does something stick out from the info above? What will be pros/cons be against this? We have started to use memcache for some data as well.