-- MYSQL PERFORMANCE TUNING PRIMER -- - By: Matthew Montgomery - MySQL Version 5.0.45-log i686 tuning-primer.sh: line 388: bc: command not found tuning-primer.sh: line 389: bc: command not found tuning-primer.sh: line 390: bc: command not found tuning-primer.sh: line 391: bc: command not found tuning-primer.sh: line 392: bc: command not found tuning-primer.sh: line 393: bc: command not found Uptime = days hrs min sec Avg. qps = 39 Total Questions = 96999 Threads Connected = 6 Warning: Server has not been running for at least 48hrs. It may not be safe to use these recommendations To find out more information on how each of these runtime variables effects performance visit: http://dev.mysql.com/doc/refman/5.0/en/server-system-variables.html Visit http://www.mysql.com/products/enterprise/advisors.html for info about MySQL's Enterprise Monitoring and Advisory Service SLOW QUERIES Current long_query_time = 10 sec. You have 1 out of 97017 that take longer than 10 sec. to complete The slow query log is NOT enabled. Your long_query_time may be too high, I typically set this under 5 sec. WORKER THREADS Current thread_cache_size = 16 Current threads_cached = 4 Current threads_per_sec = 0 Historic threads_per_sec = 0 Your thread_cache_size is fine MAX CONNECTIONS Current max_connections = 768 Current threads_connected = 7 Historic max_used_connections = 11 The number of used connections is 1% of the configured maximum. You are using less than 10% of your configured max_connections. Lowering max_connections could help to avoid an over-allocation of memory See "MEMORY USAGE" section to make sure you are not over-allocating MEMORY USAGE tuning-primer.sh: line 1164: bc: command not found tuning-primer.sh: line 1165: bc: command not found tuning-primer.sh: line 1189: bc: command not found tuning-primer.sh: line 1192: bc: command not found tuning-primer.sh: line 1193: bc: command not found tuning-primer.sh: line 1195: bc: command not found tuning-primer.sh: line 1197: [: -gt: unary operator expected tuning-primer.sh: line 350: [: max_memoryHR: integer expression expected tuning-primer.sh: line 356: [: max_memoryHR: integer expression expected tuning-primer.sh: line 362: [: max_memoryHR: integer expression expected tuning-primer.sh: line 369: export: `0=max_memoryHR': not a valid identifier Max Memory Ever Allocated : bytes tuning-primer.sh: line 350: [: per_thread_buffersHR: integer expression expected tuning-primer.sh: line 356: [: per_thread_buffersHR: integer expression expected tuning-primer.sh: line 362: [: per_thread_buffersHR: integer expression expected tuning-primer.sh: line 369: export: `0=per_thread_buffersHR': not a valid identi fier Configured Max Per-thread Buffers : bytes tuning-primer.sh: line 350: [: global_buffersHR: integer expression expected tuning-primer.sh: line 356: [: global_buffersHR: integer expression expected tuning-primer.sh: line 362: [: global_buffersHR: integer expression expected tuning-primer.sh: line 369: export: `0=global_buffersHR': not a valid identifier Configured Max Global Buffers : bytes tuning-primer.sh: line 350: [: total_memoryHR: integer expression expected tuning-primer.sh: line 356: [: total_memoryHR: integer expression expected tuning-primer.sh: line 362: [: total_memoryHR: integer expression expected tuning-primer.sh: line 369: export: `0=total_memoryHR': not a valid identifier Configured Max Memory Limit : bytes tuning-primer.sh: line 331: bc: command not found Physical Memory : G Max memory limit seem to be within acceptable norms KEY BUFFER tuning-primer.sh: line 331: bc: command not found tuning-primer.sh: line 612: bc: command not found tuning-primer.sh: line 613: bc: command not found tuning-primer.sh: line 331: bc: command not found Current MyISAM index space = M tuning-primer.sh: line 331: bc: command not found Current key_buffer_size = M Key cache miss rate is 1 : 81 Key buffer fill ratio = % tuning-primer.sh: line 646: [: -ge: unary operator expected tuning-primer.sh: line 650: [: -ge: unary operator expected tuning-primer.sh: line 654: [: -le: unary operator expected Your key_buffer_size seems to be fine QUERY CACHE tuning-primer.sh: line 685: bc: command not found tuning-primer.sh: line 686: bc: command not found Query cache is enabled tuning-primer.sh: line 331: bc: command not found Current query_cache_size = M tuning-primer.sh: line 331: bc: command not found Current query_cache_used = M tuning-primer.sh: line 331: bc: command not found Current query_cache_limit = M Current Query cache Memory fill ratio = % tuning-primer.sh: line 331: bc: command not found Current query_cache_min_res_unit = K tuning-primer.sh: line 699: bc: command not found tuning-primer.sh: line 700: bc: command not found tuning-primer.sh: line 701: [: -gt: unary operator expected tuning-primer.sh: line 708: [: -le: unary operator expected MySQL won't cache query results that are larger than query_cache_limit in size SORT OPERATIONS tuning-primer.sh: line 331: bc: command not found Current sort_buffer_size = M tuning-primer.sh: line 331: bc: command not found Current record/read_rnd_buffer_size = M Sort buffer seems to be fine JOINS tuning-primer.sh: line 331: bc: command not found Current join_buffer_size = M You have had 0 queries where a join could not use an index properly Your joins seem to be using indexes properly join_buffer_size >= 4 M This is not advised OPEN FILES LIMIT Current open_files_limit = 65535 files The open_files_limit should typically be set to at least 2x-3x that of table_cache if you have heavy MyISAM usage. Your open_files_limit value seems to be fine TABLE CACHE Current table_cache value = 2048 tables You have a total of 4893 tables You have 2048 open tables. Current table_cache hit rate is 19%, while 100% of your table cache is in use You should probably increase your table_cache TEMP TABLES tuning-primer.sh: line 331: bc: command not found Current max_heap_table_size = M tuning-primer.sh: line 331: bc: command not found Current tmp_table_size = M Of 251 temp tables, 20% were created on disk Effective in-memory tmp_table_size is limited to max_heap_table_size. Created disk tmp tables ratio seems fine TABLE SCANS tuning-primer.sh: line 331: bc: command not found Current read_buffer_size = M Current table scan ratio = 68 : 1 read_buffer_size seems to be fine TABLE LOCKING Current Lock Wait ratio = 0 : 97318 Your table locking seems to be fine