tuning-primer.sh MySQL Report

[[email protected] mytop-1.6]# wget http://Www.day32.com/Mysql/Tuning-primer.sh--2016-07-03 19:42:33--http://www.day32.com/MySQL/tuning-primer.shResolving www.day32.com ...192.237.221.190Connecting toWww.day32.com|192.237.221.190|: the... connected. HTTP request sent, awaiting response ... $oklength:51892(51K)[Application/x-sh]Saving to: "Tuning-primer.sh " -%[=========================================================================>] Wuyi,892109K/Sinch 0. 5s .- --Geneva  +: the: the(109Kb/S-"Tuning-Primer.sh "Saved[51892/51892][[email protected] mytop-1.6]# chmod+X tuning-primer.sh[[email protected] mytop-1.6]# ./Tuning-primer.sh Using LoginValues  from ~/. MY.CNF-INITIAL LOGIN attempt FAILED-Testing forstored webmin passwords:none foundcould notAuto Detect login info! Found Potential sockets:/Tmp/mysql.sock5using:/Tmp/mysql.sock5would like  toProvide a different socket?:[y/n]Ysocket:/Tmp/Mysql.sock5do You have your login handy?[y/n]: YUser: Rootpassword:aa@12345would likeMe to CreateA~/. my.cnffile  forYou?[y/n]: N--MYSQL Performance TUNING PRIMER--             -  by: Matthew Montgomery-MySQL Version5.6. -X86_64uptime= 0Days2Hrs - min  AsecAVG. QPs= 0Total Questions= 892Threads Connected= 3Warning:server has notbeen running forAt least 48hrs. It May notBe safe to  Usethese Recommendations toFind out more information onhow each oftheseruntime Variables Effects performance visit:http://Dev.mysql.com/Doc/Refman/5.6/En/Server-System-variables.htmlvisit http://Www.mysql.com/Products/Enterprise/advisors.html forInfo about MySQL's Enterprise monitoring and advisory Serviceslow queriesthe slow query log is not enabled. Current Long_query_time = 10.000000 sec. You have 0 out of 913, longer than 10.000000 sec. to Completeyour Long_query_time seems to be finebinary UPDATE L Ogthe binary update log is not enabled. You are not being able to does point in time Recoverysee Http://dev.mysql.com/doc/refman/5.6/en/point-in-time-recovery.htmlWO Rker threadscurrent thread_cache_size = 9Current threads_cached = 0Current threads_per_sec = 0Historic threads_per_sec = 0 Your thread_cache_size is Finemax connectionscurrent max_connections = 151Current threads_connected = 3Historic max_used_ Connections = 3The number of used connections is 1% of the configured maximum. You is using less than 10% of your configured max_connections. Lowering max_connections could help-avoid an over-allocation of Memorysee "MEMORY USAGE" sections to make sure your is n OT over-allocatinginnodb statuscurrent InnoDB index space = 1.47 Gcurrent InnoDB DATA space = 1.28 gcurrent InnoDB buffer pool free =%current Innodb_buffer_pool_size = + mdepending on how much space Your InnoDB indexes take-up it could be safeto increase the value to 2/3 of the total system memorymemory Usagemax Memo  Ry ever allocated:60 mconfigured max Per-thread buffers:169 mconfigured Max Global buffers:57 mconfigured Max Memory limit:226 mphysical memory:1.30 GMax Memory limit seem to be within acceptable Normskey buffercurrent MyISAM Index SP Ace = 118 Kcurrent key_buffer_size = 8 Mkey Cache Miss Rate was 1:16key buffer free ratio = Bayi%your key_buffer_size seem s to being finequery cachequery cache is enabledcurrent query_cache_size = 1 Mcurrent query_cache_used = all kcurrent Query_ca Che_limit = 1 mcurrent Query cache Memory Fill ratio = 1.64%current Query_cache_min_res_unit = 4 Kyour query_cache_size s Eems to is too high. Perhaps you can use these resources Elsewheremysql won'T cache query results that is larger than query_cache_limitinchSizesort OPERATIONS CurrentSort_buffer_size=  theK CurrentRead_rnd_buffer_size=  theKNo Sort operations has been performedsort buffer seems toBe finejoins CurrentJoin_buffer_size= 260.00Kyou have had0QuerieswhereAJoinCould not  UseAnIndexProperlyyour joins seem tobe using indexes properlyOPENFILES LIMIT CurrentOpen_files_limit=  thefilesthe open_files_limit should typically beSet  toAt least 2x-3xthat ofTable_cacheifYou have heavy MyISAM usage. Your Open_files_limit value seems toBe fineTABLECACHE CurrentTable_open_cache=  -Tables CurrentTable_definition_cache= 1400Tablesyou has a total of 113Tablesyou has117 Opentables. The Table_cache value seems toBe fineTEMPTABLES CurrentMax_heap_table_size=  -M CurrentTmp_table_size=  -M of 1072 TempTables6%were created on DiskCreatedDisktmp tables ratio seems fineTABLESCANS CurrentRead_buffer_size=  -K Current TableScan ratio=  the:1Read_buffer_size seems toBe fineTABLELOCKING CurrentLock Wait ratio= 0:1168YourTableLocking seems toBe fine

tuning-primer.sh MySQL Report