Perfomance Tuning for MySQL and PHP: Plesk 11

[Olawale]

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.

 

[IgorG]

Look at this thread - https://talk.plesk.com/threads/help-with-optimise-my-mysql.303685/
Maybe it will be useful for you.