What's your recommendation server specs for this?

Uptime: 1718  Threads: 3  Questions: 159333  Slow queries: 3  Opens: 132  Flush tables: 1  Open tables: 125  Queries per second avg: 92.743  

Code (markup):

Now running on Core2due 2.2Ghz 3GB RAM

Website is slow now...

 

Xeon is the best and very fast

 

It seems to be query related issue. The number of open tables is okay with the amount of ram.

To identify the exact issue, you may want to enable slow query log. Installation of adodbcache may help you as well.

 

here at the heavy time

Uptime: 48676 Threads: 3 Questions: 7446247 Slow queries: 1165 Opens: 287 Flush tables: 1 Open tables: 275 Queries per second avg: 152.975

 

I'm doing 500 queries per second on average with a quad core on a dedicated mysql server. Do you have a dedicated for the sql? You could probably optimize your DB to handle the 150 per second just fine. I peak at like 800-1000 per second.

 

Have you implemented a cache system? this can reduce your mysql load by a lot of factor.

 

IBM X series server is the best ,,,with issue

Manoj KUmar