Exsessive memory usage.

[kilburn]

It's ok as per default ispcp installation (little reserved memory for caching), but can be modified in /etc/mysql/my.cnf:

Code:

phoenix ~ # cat /etc/mysql/my.cnf | grep cache
thread_cache_size    = 8
#table_cache            = 64
query_cache_limit       = 1M
query_cache_size        = 16M

You can google around about mysql performance to see what all these numbers mean, which values should you use for your workload, etc. I personally have lost a lot of time fiddling with mysql setup, and never saw significant advantages against the deafault configuration.