mySQL Performance Degrades Over Time

[andytwiz]

Hi,

I've noticed a definite degradation in the mySQL performance on our box over time (a few days). Snappy performance is restored by simply stopping and restarting the service.

I've tried various configs, huge and large seem to make the degradation in performance worse (box has 4cpus and 4gb ram).

Admittedly our SQL and tables could be optimised massively to improve performance but we don't have the resources to do that now.

I've noticed the tmp folder is used quite a lot with mySQL creating files up to a few 100mb big.

If anyone has any idea why the performance degrades over time or how to resolve it that would be much appreciated.

Thanks for your time.

[andytwiz]

I've also noticed that task manager shows mysql is reading and writing massive amounts of data (reading about 1gb every 1 minute or so).

Our whole database is about 100mb. Cant this fit into memory (virtual size of process is 350mb)?