Forum Moderators: open

Message Too Old, No Replies

Very slow mysql on bigger traffic

Mysql works slowly when we have more traffic

         

belen

5:56 am on Sep 14, 2009 (gmt 0)

10+ Year Member



Hello,

the issue is, that on bigger traffic mysql works so slowly....
I have a quite big website, with few servers in cluster. Works quite good. But I got x3 more traffic, and seems website working very slowly, the reason is mysql.... We moved mysql to separate server, a lit helped but still not so good... Could anybody help me to optimzate mysql performance (queries, tables and etc...)

Thanks

StoutFiles

6:05 am on Sep 14, 2009 (gmt 0)

WebmasterWorld Senior Member 10+ Year Member



I would look up MySQL caching.

belen

6:27 am on Sep 14, 2009 (gmt 0)

10+ Year Member



StoutFiles > could you please explain more about mysql caching?

belen

12:49 pm on Sep 14, 2009 (gmt 0)

10+ Year Member



mysql caching is already enabled and using