Shared Hosting
Shared HostingKnowledgebase
Portal Home > Knowledgebase > Articles Database > howto Mysql tuning ?
howto Mysql tuning ?
 |
 |
 |
Posted by map007, 12-19-2008, 09:07 AM howto Mysql tuning ? Hi, I have Linux server with WHM/Cpanel with 2000 domains now my problem is.Mysql is using 90-100% CPU usage and 1500-2000 queries are running at a time so please guide me how can i optimize it and how can i tune mysql server so it doesn't go high. I have configure my.cnf file as ---> max_allowed_packet = 4M set-variable = max_connections=100 safe-show-database query_cache_limit=1M query_cache_size=128M query_cache_type=1 key_buffer_size=256M long_query_time = 3 table_cache=9092 SO please guide me how can i do this and any changes is require ? Thanks in advance.
Posted by MikeDVB, 12-19-2008, 09:14 AM Tuning MySQL is not a straightforward process and is often a process of trial and error unless you're very experienced. You may be able to find an experienced server administrator that can do this for you at a reasonable price. Unless the server is a very very very high end server then 2000 domains is likely pushing it to it's limits and you're not likely to be able to do much with MySQL to bring the load down much. You may want to consider obtaining a server purely for MySQL or getting a secondary server to offset the load. __________________â Michael Denney - MDDHosting, LLC - Professional Hosting Solutionsâ Shared, Reseller, Semi-Dedicated, VPS, and Dedicated â http://www.mddhosting.com/
Posted by vapetrov, 12-19-2008, 09:58 AM Try script from www.mysqltuner.com But on shared hosting usually main problem is not optimal queries. And it toooooo hard to force users to optimize their sites/queries... You need to find most hard queries. Slow log will help you. Also may help just to run "show full processlist" many times at row - by this way you can find not too long, moderately hard but frequent queries. __________________ Private remote administrator of Linux servers - www.petrov.ks.ua Quality hosting - Host-Web-Site.com
Add to Favourites 
Print this Article
Also Read
