Untitled

[0m
(B[m[0m[1;34m   -- MYSQL PERFORMANCE TUNING PRIMER --
(B[m[0m[0m       - By: Matthew Montgomery -
(B[m[0m
[0mMySQL Version 5.6.17-log x86_64
(B[m[0m
[0mUptime = 2 days 19 hrs 19 min 26 sec
(B[m[0m[0mAvg. qps = 16
(B[m[0m[0mTotal Questions = 4076318
(B[m[0m[0mThreads Connected = 3
(B[m[0m
[0mServer has been running for over 48hrs.
(B[m[0m[0mIt should be safe to follow these recommendations
(B[m[0m
[31mTo find out more information on how each of these
(B[m[0m[31mruntime variables effects performance visit:
(B[m[0m[1;34mhttp://dev.mysql.com/doc/refman/5.6/en/server-system-variables.html
(B[m[0m[1;34mVisit http://www.mysql.com/products/enterprise/advisors.html
(B[m[0m[1;34mfor info about MySQL's Enterprise Monitoring and Advisory Service
(B[m[0m
[1;34mSLOW QUERIES
(B[m[0m[0mThe slow query log is (B[m[0m[1;31mNOT(B[m[0m[0m enabled.
(B[m[0m[0mCurrent long_query_time = 10.000000 sec.
(B[m[0m[0mYou have (B[m[0m[1;31m472628(B[m[0m[0m out of (B[m[0m[1;31m4076339(B[m[0m[0m that take longer than 10.000000 sec. to complete
(B[m[0m[32mYour long_query_time seems to be fine
(B[m[0m
[1;34mBINARY UPDATE LOG
(B[m[0m[0mThe binary update log is enabled
(B[m[0m
[1;34mWORKER THREADS
(B[m[0m[0mCurrent thread_cache_size = 50
(B[m[0m[0mCurrent threads_cached = 20
(B[m[0m[0mCurrent threads_per_sec = 0
(B[m[0m[0mHistoric threads_per_sec = 0
(B[m[0m[32mYour thread_cache_size is fine
(B[m[0m
[1;34mMAX CONNECTIONS
(B[m[0m[0mCurrent max_connections = 500
(B[m[0m[0mCurrent threads_connected = 3
(B[m[0m[0mHistoric max_used_connections = 23
(B[m[0m[0mThe number of used connections is (B[m[0m[31m4% (B[m[0m[0mof the configured maximum.
(B[m[0m[31mYou are using less than 10% of your configured max_connections.
(B[m[0m[31mLowering max_connections could help to avoid an over-allocation of memory
(B[m[0m[31mSee "MEMORY USAGE" section to make sure you are not over-allocating
(B[m[0m
[1;34mINNODB STATUS
(B[m[0m[0mCurrent InnoDB index space = 33 M
(B[m[0m[0mCurrent InnoDB data space = 58 M
(B[m[0m[0mCurrent InnoDB buffer pool free = 88 %
(B[m[0m[0mCurrent innodb_buffer_pool_size = 1.00 G
(B[m[0m[0mDepending on how much space your innodb indexes take up it may be safe
(B[m[0m[0mto increase this value to up to 2 / 3 of total system memory
(B[m[0m
[1;34mMEMORY USAGE
(B[m[0m[0mMax Memory Ever Allocated : 1.07 G
(B[m[0m[0mConfigured Max Per-thread Buffers : 578 M
(B[m[0m[0mConfigured Max Global Buffers : 1.04 G
(B[m[0m[0mConfigured Max Memory Limit : 1.61 G
(B[m[0m[0mPhysical Memory : 31.29 G
(B[m[0m[32mMax memory limit seem to be within acceptable norms
(B[m[0m
[1;34mKEY BUFFER
(B[m[0m[0mCurrent MyISAM index space = 90 M
(B[m[0m[0mCurrent key_buffer_size = 32 M
(B[m[0m[0mKey cache miss rate is 1 : 1637
(B[m[0m[0mKey buffer free ratio = 28 %
(B[m[0m[31mYour key_buffer_size seems to be too high.
(B[m[0m[31mPerhaps you can use these resources elsewhere
(B[m[0m
[1;34mQUERY CACHE
(B[m[0m[31mQuery cache is supported but not enabled
(B[m[0m[31mPerhaps you should set the query_cache_size
(B[m[0m
[1;34mSORT OPERATIONS
(B[m[0m[0mCurrent sort_buffer_size = 256 K
(B[m[0m[0mCurrent (B[m[0m[0mread_rnd_buffer_size (B[m[0m[0m= 256 K
(B[m[0m[32mSort buffer seems to be fine
(B[m[0m
[1;34mJOINS
(B[m[0m[0mCurrent join_buffer_size = 260.00 K
(B[m[0m[0mYou have had 11509 queries where a join could not use an index properly
(B[m[0m[0mYou should enable "log-queries-not-using-indexes"
(B[m[0m[0mThen look for non indexed joins in the slow query log.
(B[m[0m[0mIf you are unable to optimize your queries you may want to increase your
(B[m[0m[0mjoin_buffer_size to accommodate larger joins in one pass.
(B[m[0m
[1;31mNote! This script will still suggest raising the join_buffer_size when
(B[m[0m[1;31mANY joins not using indexes are found.
(B[m[0m
[1;34mOPEN FILES LIMIT
(B[m[0m[0mCurrent open_files_limit = 20990 files
(B[m[0m[33mThe open_files_limit should typically be set to at least 2x-3x
(B[m[0m[33mthat of table_cache if you have heavy MyISAM usage.
(B[m[0m[32mYour open_files_limit value seems to be fine
(B[m[0m
[1;34mTABLE CACHE
(B[m[0m[0mCurrent table_open_cache = 10240 tables
(B[m[0m[0mCurrent table_definition_cache = 4096 tables
(B[m[0m[0mYou have a total of 2763 tables
(B[m[0m[0mYou have (B[m[0m[32m5175 (B[m[0m[0mopen tables.
(B[m[0m[32mThe table_cache value seems to be fine
(B[m[0m
[1;34mTEMP TABLES
(B[m[0m[0mCurrent max_heap_table_size = 32 M
(B[m[0m[0mCurrent tmp_table_size = 32 M
(B[m[0m[0mOf 386270 temp tables, 39% were created on disk
(B[m[0m[1;31mPerhaps you should increase your tmp_table_size and/or max_heap_table_size
(B[m[0m[1;31mto reduce the number of disk-based temporary tables
(B[m[0m[33mNote! BLOB and TEXT columns are not allow in memory tables.
(B[m[0m[33mIf you are using these columns raising these values might not impact your
(B[m[0m[33mratio of on disk temp tables.
(B[m[0m
[1;34mTABLE SCANS
(B[m[0m[0mCurrent read_buffer_size = 128 K
(B[m[0m[0mCurrent table scan ratio = 84 : 1
(B[m[0m[32mread_buffer_size seems to be fine
(B[m[0m
[1;34mTABLE LOCKING
(B[m[0m[0mCurrent Lock Wait ratio = (B[m[0m[31m1 : 13240
(B[m[0m[32mYour table locking seems to be fine
(B[m[0m