Shared Hosting
Shared HostingKnowledgebase
Portal Home > Knowledgebase > Articles Database > Help needed in order to understand what's wrong
Help needed in order to understand what's wrong
 |
 |
 |
Posted by SecondSight, 07-21-2010, 04:26 AM Hello ! My server is doing rather well but I want to optimize it and I can't make it... For instance, yesterday and the days before, Query cache prunes per day = 0 and this morning, Query cache prunes per day = 2295... According to the information I give below, what changes should I make, in your opinion ? - My server is a 64 bit Bi Xeon Quad 8x 2.33+ with 16GB RAM and two 1TB HDD (RAID), with : Apache 2.2.15 PHP 5.2.9 MySQL 5.0.89 EAccelXCache Only one web site : an Invision Power board - Here is my.cnf : - Below, you'll find the output of MySQL Tuner and Tuning Primer :: Thank you for your help !
Posted by jroes, 07-21-2010, 12:47 PM Here's a little info I dug up for you from the MySQL docs: Give that a shot, let me know how it goes.
Posted by SecondSight, 07-21-2010, 01:53 PM Thank you ! I had already set query_cache_min_res_unit to 2 (instead of 4) because MySQLTuner said I needed to run "flush query cache" because the memory was 33% fragmented, etc. Now I have set query_cache to 96M instead of 64M and I'm waiting to see if it's ok. Up to now, MySQLTuner gives me : I suppose 48.2% is not efficient enougth ? How can I have query_cache more efficient ? Tuning Primer gives me : Thank you ! Last edited by SecondSight; 07-21-2010 at 01:59 PM.
Add to Favourites 
Print this Article
Also Read
