MySysop : MySql System OptimizerAbout MySysop and Mysql tuning

none none none
none SERVER

Please select server to analyse
XML Output
none
none none none

none none none
none SERVER_VERSION Refresh sectionAuto Refresh section

MySQL Version 4.1.22-standard
View variables in my.cnf format
none
none none none

none none none
none UPTIME_INFORMATIONS Refresh sectionAuto Refresh section

Uptime = 25 Weeks, 2 days, 6 hours, 57 minutes, 42 seconds.
Avg. qps = 43.26
Total Questions = 662,625,518
Threads Connected = 2
Aborted_clients = 109966
Aborted_connects=25482
Opened_tables = 72479

Server has been running for over 48hrs.
It should be safe to follow these recommendations

To find out more information on how each of these
runtime variables effects performance visit:
http://dev.mysql.com/doc/refman/4.1/en/server-system-variables.html
none
none none none

none none none
none LIVE_VALUES Refresh sectionAuto Refresh section

Click on Refresh or Auto Refresh button
none
none none none

none none none
none PROCESS Refresh sectionAuto Refresh section
12185794  eximstats  localhost  eximstats  Sleep  10     
12185799  root  localhost    Query  0    show full processlist /* MySysop */ 
none
none none none

none none none
none SLOW_QUERIES Refresh sectionAuto Refresh section

Current long_query_time = 10 sec.
You have 12,232 out of 662,625,520 that take longer than 10 sec. to complete

The slow query log is disabled.
Your long_query_time may be too high, I typicaly set this under 5 sec.
Adjust your slow long query time
none
none none none

none none none
none MAX_CONNECTIONS Refresh sectionAuto Refresh section

Current max_connections = 300
Current threads_connected = 2
Historic max_used_connections = 151
The number of used connections is 50.33% of the configured maximum.
Your max_connections variable seems to be fine.
Your max_connections variable is good for your actual load.
Adjust your max_connections
none
none none none

none none none
none WORKER_THREADS Refresh sectionAuto Refresh section

Current thread_cache_size = 128
Historic threads_per_sec = 0.00

Your thread_cache_size is fine
Adjust your thread_cache_size
none
none none none

none none none
none KEY_BUFFER Refresh sectionAuto Refresh section

Current key_buffer_size = 256.0 Mo
Key cache miss rate is 1 / 9,514
Key buffer fill ratio = 10.59%

Your key_buffer_size seems to be too high.
Perhaps you can use these resources elsewhere

Adjust your buffer size
none
none none none

none none none
none QUERY_CACHE Refresh sectionAuto Refresh section

Query cache is enabled
Current query_cache_size = 40.0 Mo
Current query_cache_used = 19.8 Mo
Current Query cache fill ratio = 49%

However, 5,025,684 queries have been removed from the query cache due to lack of memory
Perhaps you should raise query_cache_size

Your query cache limit for each query is between query_cache_min_res_unit=4.0 Ko and query_cache_limit=1.0 Mo
Your cached was used by 428,804,545 queries and you have 11,735 queries in your cache.
Your query cache ratio : 64.73%
Perhaps you could Defrag your cache memory with a 'FLUSH QUERY CACHE'.
Flush your query cache
Adjust your query cache size
Adjust your query query_cache_limit
Adjust your query query_cache_min_res_unit
none
none none none

none none none
none SORT_OPERATIONS Refresh sectionAuto Refresh section

Current sort_buffer_size = 32.0 Mo
Current record/read_rnd_buffer_size = 1020.0 Ko

Sort buffer seems to be fine
Adjust your sort buffer size
Adjust your read buffer size
none
none none none

none none none
none JOINS Refresh sectionAuto Refresh section

Current join_buffer_size = 1020.0 Ko
You have had 15,707 queries where a join could not use an index properly
You have had 238 joins without keys that check for key usage after each row
You should enable "log-long-format" for 3.23 or 4.0 you should enable "log-queries-not-using-indexes" under +4.1 Then look for non indexed joins in the slow query log. If you are unable to optimize your queries you may want to increase your join_buffer_size to accomidate larger joins in one pass.
Adjust your join_buffer_size
none
none none none

none none none
none TEMP_TABLES Refresh sectionAuto Refresh section

Current tmp_table_size = 32.0 Mo
Created disk tmp tables ratio seems fine
Adjust your tmp_table_size
none
none none none

none none none
none TABLE_CACHE Refresh sectionAuto Refresh section

Current table_cache value = 360 tables
You have 360 open tables. Current table_cache hit rate is 0.50%, while 100.00% of your table cache is in use You should probably increase your table_cache
Adjust your table_cache
none
none none none

none none none
none TABLE_LOCKING Refresh sectionAuto Refresh section

Some table locks were not immediate
1 / 1,633 of your queries must wait to aquire a lock
This could be the result of a poorly optimized query. If this seems high look in the slow query log for a query with alot of time in lock status. If you are using MyISAM you may need to run "OPTIMIZE TABLE tablename" to allow for concurrent inserts Or you may benifit from selective use of InnoDB.
none
none none none

none none none
none TABLE_SCANS Refresh sectionAuto Refresh section

Current read_buffer_size = 2.0 Mo
read_buffer_size seems to be fine
Adjust your read_buffer_size
none
none none none

none none none
none OPEN_FILES Refresh sectionAuto Refresh section

Current opened files : 685
Your open_files_limit : 1500
Your open_files_limit seems good.
none
none none none


MySysop Copyleft Frederic Fillon
Go to Webstore Web Site