High Load mysql server

Кирюшкин Владимир vk at jasystem.net
Fri Oct 28 17:35:33 UTC 2011


Hello,

> So, what i`ve must to do again.?

you should do this:

> General recommendations:
>     Add skip-bdb to MySQL configuration to disable BDB
>     Run OPTIMIZE TABLE to defragment tables for better performance
>     Reduce your overall MySQL memory footprint for system stability
>     Enable the slow query log to troubleshoot bad queries

also you should lower key_buffer_size to e.g. 64M (recommendation = "Reduce your overall MySQL memory footprint for system stability")


Cheers,

Vladimir



More information about the nginx mailing list