tuning-primer.sh MySQL Report

Source: Internet
Author: User
Tags mysql version

[[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

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.