Perfomance Tuning for MySQL and PHP: Plesk 11

Olawale

New Pleskian
I need real help in tuning my Plesk 11 box.
I have Intel Core I3-3220 3.30 Ghz, 8GB memory and 1TB hard drive.
I have noticed that I rarely use above 1GB memory at any time, yet the CPU runs heavy in excess of 150% for long.

The nature of my service involves high Select * Query, Insert and heavy read.
I have tried different my.cnf but all seems to only compensate for one aspect of the other.
either improves the read, or the insert but not the overall.

I need help.
 
Back
Top