Hallo Leute,
habe das primer tuning script nun für fast 7 Tage laufen lassen. Was könnte ich noch verbessern. Bin für jeden Vorschlag dankbar..
Gruß,
Tim
MySQL Version 5.0.18-Max-log i686
Uptime = 6 days 18 hrs 17 min 57 sec
Avg. qps = 18
Total Questions = 10636813
Threads Connected = 3
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:
MySQL AB :: MySQL 5.0 Reference Manual :: 5.1.3 System Variables
SLOW QUERIES
Current long_query_time = 3 sec.
You have 3587 out of 10636813 that take longer than 3 sec. to complete
The slow query log is enabled.
Your long_query_time seems to be fine
MAX CONNECTIONS
Current max_connections = 130
Current threads_connected = 3
Historic max_used_connections = 22
The number of used connections is 16% of the configured maximum.
Your max_connections variable seems to be fine.
WORKER THREADS
Current thread_cache_size = 12
Current threads_cached = 10
Current threads_per_sec = 0
Historic threads_per_sec = 0
Your thread_cache_size is fine
MEMORY USAGE
/usr/bin/tuning.sh: line 994: let: expression expected
Max Memory Ever Allocated : 252 M
Configured Max Memory Limit : 502 M
Total System Memory : 5078 M
KEY BUFFER
Current MyISAM index space = 23 M
Current key_buffer_size = 128 M
Key cache miss rate is 1 / 8692
Key buffer fill ratio = 15.00 %
Your key_buffer_size seems to be too high.
Perhaps you can use these resources elsewhere
QUERY CACHE
Query cache is enabled
Current query_cache_size = 64 M
Current query_cache_used = 20 M
Current Query cache fill ratio = 31.50 %
SORT OPERATIONS
Current sort_buffer_size = 2 M
Current record/read_rnd_buffer_size = 256.00 K
Sort buffer seems to be fine
JOINS
Current join_buffer_size = 128.00 K
You have had 153091 queries where a join could not use an index properly
You should enable "log-queries-not-using-indexes"
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 accommodate larger joins in one pass.
TABLE CACHE
Current table_cache value = 1412 tables
You have a total of 631 tables
You have 1105 open tables.
The table_cache value seems to be fine
TEMP TABLES
Current tmp_table_size = 32 M
57% of tmp tables created were disk based
Perhaps you should increase your tmp_table_size
TABLE SCANS
Current read_buffer_size = 128.00 K
Current table scan ratio = 182 : 1
read_buffer_size seems to be fine
TABLE LOCKING
Current Lock Wait ratio = 1 : 182
You may benefit from selective use of InnoDB.
