I am using InnoDB instead of MyISAM for a couple of months right now, and it has really optimized my game database-wise. I was aware of the danger of deadlocks, but hadn't had any problems with it, until about a week ago.
I've had a deadlock because two cronjobs were clashing with each other, I believe. Anyway, we've got that fixed by killing both queries and running the cronjobs after each other manually.
All seemed good, except for the fact that the server load is peeking a lot since then (about every 5 minutes) which I don't really know why. I've checked the running queries at those moments and they seem fine.
Do you have any tips where to look on how to fix this? Couldn't find too many information about this on the internet. Thanks in advance.
Best Answer
may be you need to clear or reload various internal caches use these commands flush tables ; flush logs ; you can find more details about flush command in this link http://dev.mysql.com/doc/refman/5.0/en/flush.html