MySysop : MYSQL SYSTEM OPTIMIZER FOR TUNING PERFORMANCE

UPTIME_INFORMATIONS

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

SLOW_QUERIES

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

MAX_CONNECTIONS

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

KEY_BUFFER

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

QUERY_CACHE

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

SORT_OPERATIONS

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

JOINS

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

TABLE_CACHE

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

TABLE_LOCKING

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.

MySysop : MySql System Optimizer