Go Back   HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials > Linux Forums > Server Operation

Do you like HowtoForge? Please consider supporting us by becoming a subscriber.
Reply
 
Thread Tools Display Modes
  #1  
Old 14th January 2007, 18:22
Ovidiu Ovidiu is offline
Senior Member
 
Join Date: Sep 2005
Posts: 1,258
Thanks: 76
Thanked 23 Times in 19 Posts
Default mysql + phpmyadmin => optimization?

hello,

I recently upgraded to the latest phpmyadmin version and found out, it gives you optimization tips. Now I am curious about some sample tips its giving me:

Code:
Qcache_queries_in_cache  	11 k  	 The number of queries registered in the cache.
Qcache_inserts 	915 k 	The number of queries added to the cache.
Qcache_hits 	3,249 k 	The number of cache hits.
Qcache_lowmem_prunes 	7,052 	The number of queries that have been removed from the cache to free up memory for caching new queries. This information can help you tune the query cache size. The query cache uses a least recently used (LRU) strategy to decide which queries to remove from the cache.
Qcache_not_cached 	11 k 	The number of non-cached queries (not cachable, or not cached due to the query_cache_type setting).
Qcache_free_memory 	11 M 	The amount of free memory for query cache.
Qcache_free_blocks 	2,708 	The number of free memory blocks in query cache.
Qcache_total_blocks 	26 k 	The total number of blocks in the query cache.
what baffles me is the red part: it says I should optimize my cache size, althoug just below that it says I still have Qcache_free_memory = 11 M so there is plenty of free cache.

Code:
Created_tmp_disk_tables  	5,643  	The number of temporary tables on disk created automatically by the server while executing statements. If Created_tmp_disk_tables is big, you may want to increase the tmp_table_size value to cause temporary tables to be memory-based instead of disk-based.
Created_tmp_tables 	7,553 	The number of in-memory temporary tables created automatically by the server while executing statements.
Created_tmp_files 	617 	How many temporary files mysqld has created.
again I am unsure about the red part, as my values are these:

Code:
 max tmp tables  	32
Code:
tmp table size  	67,108,864
tmp table size was 32 M I changed it to 64 M and its still in red....

what about this:
Code:
Select_full_join  	131  	The number of joins that do not use indexes. If this value is not 0, you should carefully check the indexes of your tables.
I have clients so I cannot influence their DB usage...
and this:

Code:
Sort_merge_passes  	257  	The number of merge passes the sort algorithm has had to do. If this value is large, you should consider increasing the value of the sort_buffer_size system variable.
current values:

Code:
 myisam sort buffer size  	8,388,608
sort buffer size  	8,388,600
I was unsure which value to increase,... by default my values were 8M and 2M so I increased the second value to 8M but phpmyadmin still suggests I increase - is it talking about the myisam value or about the other one?

and what about his?

Code:
Open_tables  	128  	 The number of tables that are open.
Opened_tables 	2,204 	The number of tables that have been opened. If opened tables is big, your table cache value is probably too small.
Table_locks_immediate 	1,510 k 	The number of times that a table lock was acquired immediately.
Table_locks_waited 	1,749 	The number of times that a table lock could not be acquired immediately and a wait was needed. If this is high, and you have performance problems, you should first optimize your queries, and then either split your table or tables or use replication.
current values:
Code:
table cache  	128
this was 64 before, I increased it to 128 still the value is in red...

can someone give me some explanations? or am I worrying too much?
Reply With Quote
Sponsored Links
  #2  
Old 15th January 2007, 18:43
falko falko is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 41,701
Thanks: 1,900
Thanked 2,727 Times in 2,565 Posts
Default

Did you restart MySQL after your changes?

I haven't noticed these optimization tips from phpMyAdmin yet though...
__________________
Falko
--
Download the ISPConfig 3 Manual! | Check out the ISPConfig 3 Billing Module!

FB: http://www.facebook.com/howtoforge

nginx-Webhosting: Timme Hosting | Follow me on:
Reply With Quote
  #3  
Old 15th January 2007, 19:48
Ovidiu Ovidiu is offline
Senior Member
 
Join Date: Sep 2005
Posts: 1,258
Thanks: 76
Thanked 23 Times in 19 Posts
Default

of course I did :-) you'll find them when you click on the "status" tab.
Reply With Quote
  #4  
Old 16th January 2007, 15:42
falko falko is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 41,701
Thanks: 1,900
Thanked 2,727 Times in 2,565 Posts
Default

Maybe phpMyAdmin (or your browser) caches the values somewhere?
__________________
Falko
--
Download the ISPConfig 3 Manual! | Check out the ISPConfig 3 Billing Module!

FB: http://www.facebook.com/howtoforge

nginx-Webhosting: Timme Hosting | Follow me on:
Reply With Quote
  #5  
Old 16th January 2007, 16:48
Ovidiu Ovidiu is offline
Senior Member
 
Join Date: Sep 2005
Posts: 1,258
Thanks: 76
Thanked 23 Times in 19 Posts
 
Default

no they do change if I refresh
Reply With Quote
Reply

Bookmarks

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Messed up ISPConfig-2.2.8 Upgrade Morons Installation/Configuration 4 29th November 2006 12:17
I'm dying! m u r Installation/Configuration 41 17th September 2006 13:44
Getting MySql errors after uninstalling phpMyAdmin ProgressiveBastion General 1 2nd July 2006 18:15
perfect setup suse 10 - phpmyadmin & mysql question reddog Server Operation 7 17th June 2006 12:59
Mandriva 10.2 Perfect Setup Install Problems... ctroyp Installation/Configuration 12 30th December 2005 16:04


All times are GMT +2. The time now is 16:43.


Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2014, vBulletin Solutions, Inc.