High Load mysql server

[Кирюшкин Владимир]

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