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.19-1~dotdeb.1 x86_64
(B[m[0m
[0mUptime = 58 days 21 hrs 6 min 51 sec
(B[m[0m[0mAvg. qps = 0
(B[m[0m[0mTotal Questions = 3335435
(B[m[0m[0mThreads Connected = 9
(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;31m943(B[m[0m[0m out of (B[m[0m[1;31m3335456(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 (B[m[0m[1;31mNOT (B[m[0m[0menabled.
(B[m[0m[31mYou will not be able to do point in time recovery
(B[m[0m[33mSee http://dev.mysql.com/doc/refman/5.6/en/point-in-time-recovery.html
(B[m[0m
[1;34mWORKER THREADS
(B[m[0m[0mCurrent thread_cache_size = 8
(B[m[0m[0mCurrent threads_cached = 5
(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 = 151
(B[m[0m[0mCurrent threads_connected = 9
(B[m[0m[0mHistoric max_used_connections = 33
(B[m[0m[0mThe number of used connections is (B[m[0m[32m21% (B[m[0m[0mof the configured maximum.
(B[m[0m[32mYour max_connections variable seems to be fine.
(B[m[0m
[1;34mINNODB STATUS
(B[m[0m[0mCurrent InnoDB index space = 8.41 G
(B[m[0m[0mCurrent InnoDB data space = 8.29 G
(B[m[0m[0mCurrent InnoDB buffer pool free = 10 %
(B[m[0m[0mCurrent innodb_buffer_pool_size = 128 M
(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 : 203 M
(B[m[0m[0mConfigured Max Per-thread Buffers : 160 M
(B[m[0m[0mConfigured Max Global Buffers : 168 M
(B[m[0m[0mConfigured Max Memory Limit : 328 M
(B[m[0m[0mPhysical Memory : 3.87 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 = 1.45 G
(B[m[0m[0mCurrent key_buffer_size = 8 M
(B[m[0m[0mKey cache miss rate is 1 : 239
(B[m[0m[0mKey buffer free ratio = 81 %
(B[m[0m[32mYour key_buffer_size seems to be fine
(B[m[0m
[1;34mQUERY CACHE
(B[m[0m[32mQuery cache is enabled
(B[m[0m[0mCurrent query_cache_size = 16 M
(B[m[0m[0mCurrent query_cache_used = 17 K
(B[m[0m[0mCurrent query_cache_limit = 1 M
(B[m[0m[0mCurrent Query cache Memory fill ratio = .10 %
(B[m[0m[0mCurrent query_cache_min_res_unit = 4 K
(B[m[0m[31mYour query_cache_size seems to be too high.
(B[m[0m[31mPerhaps you can use these resources elsewhere
(B[m[0m[33mMySQL won't cache query results that are larger than query_cache_limit in 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 3091 queries where a join could not use an index properly
(B[m[0m[31mYou have had 5 joins without keys that check for key usage after each row
(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 = 1024 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 = 431 tables
(B[m[0m[0mCurrent table_definition_cache = 615 tables
(B[m[0m[0mYou have a total of 849 tables
(B[m[0m[0mYou have (B[m[0m[1;31m431 (B[m[0m[0mopen tables.
(B[m[0m[0mCurrent table_cache hit rate is (B[m[0m[1;31m0%
(B[m[0m[0m, while (B[m[0m[1;31m100% (B[m[0m[0mof your table cache is in use
(B[m[0m[31mYou should probably increase your table_cache
(B[m[0m[31mYou should probably increase your table_definition_cache value.
(B[m[0m
[1;34mTEMP TABLES
(B[m[0m[0mCurrent max_heap_table_size = 16 M
(B[m[0m[0mCurrent tmp_table_size = 16 M
(B[m[0m[0mOf 53084 temp tables, 30% 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 = 2928 : 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[0m0 : 3335711
(B[m[0m[32mYour table locking seems to be fine
(B[m[0m