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.
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.