{"id":672,"date":"2020-06-22T12:08:09","date_gmt":"2020-06-22T04:08:09","guid":{"rendered":"https:\/\/www.zeroheart.xyz\/wordpress\/?p=672"},"modified":"2020-06-23T13:39:35","modified_gmt":"2020-06-23T05:39:35","slug":"%e6%85%a2%e6%97%a5%e5%bf%97%e6%9f%a5%e8%af%a2%e7%bb%9f%e8%ae%a1","status":"publish","type":"post","link":"https:\/\/www.zeroheart.xyz\/wordpress\/?p=672","title":{"rendered":"\u6162\u65e5\u5fd7\u67e5\u8be2\u7edf\u8ba1"},"content":{"rendered":"\n

mysqldumpslow \u6162\u65e5\u5fd7\u5206\u6790\u5de5\u5177
\u547d\u4ee4\uff1a<\/p>\n\n\n\n

-s \u6309\u7167\u90a3\u79cd\u65b9\u5f0f\u6392\u5e8f
     c:\u8bbf\u95ee\u8ba1\u6570
     l:\u9501\u5b9a\u65f6\u95f4
     r:\u8fd4\u56de\u8bb0\u5f55
     al:\u5e73\u5747\u9501\u5b9a\u65f6\u95f4
     ar:\u5e73\u5747\u8bbf\u95ee\u8bb0\u5f55\u6570
     at:\u5e73\u5747\u67e5\u8be2\u65f6\u95f4
-t \u662ftop n\u7684\u610f\u601d\uff0c\u8fd4\u56de\u591a\u5c11\u6761\u6570\u636e\u3002
-g \u53ef\u4ee5\u8ddf\u4e0a\u6b63\u5219\u5339\u914d\u6a21\u5f0f\uff0c\u5927\u5c0f\u5199\u4e0d\u654f\u611f\u3002

\u5b8c\u6574\u7684\u53c2\u6570
--verbose    verbose
--debug      debug
--help       write this text to standard output
 

-v           verbose
-d           debug
-s ORDER     what to sort by (al, at, ar, c, l, r, t), 'at' is default
                 al: average lock time
                 ar: average rows sent
                 at: average query time
                  c: count
                  l: lock time
                  r: rows sent
                  t: query time  
-r           reverse the sort order (largest last instead of first)
-t NUM       just show the top n queries
-a           don't abstract all numbers to N and strings to 'S'
-n NUM       abstract numbers with at least n digits within names
-g PATTERN   grep: only consider stmts that include this string
-h HOSTNAME  hostname of db server for *-slow.log filename (can be wildcard),
                default is '*', i.e. match all
-i NAME      name of server instance (if using mysql.server startup script)
-l           don't subtract lock time from total time <\/pre>\n\n\n\n
\u5f97\u5230\u8fd4\u56de\u8bb0\u5f55\u6700\u591a\u768420\u4e2asql
mysqldumpslow -s r -t 20 \/usr\/local\/mysql\/data\/slowSql.log <\/pre>\n\n\n\n
\u5e73\u5747\u8bbf\u95ee\u65f6\u95f4\u6700\u957f\u768420\u4e2asql
mysqldumpslow -s at -t 20 \/usr\/local\/mysql\/data\/slowSql.log <\/pre>\n\n\n\n
\u5f97\u5230\u5e73\u5747\u8bbf\u95ee\u6b21\u6570\u6700\u591a,\u5e76\u4e14\u91cc\u9762\u542b\u6709select\u5b57\u7b26\u768420\u6761sql
mysqldumpslow -s ar -t 20 -g \"select\" \/usr\/local\/mysql\/data\/slowSql.log<\/pre>\n\n\n\n
\u5982\u679c\u51fa\u73b0 -bash: mysqldumpslow: command not found \u9519\u8bef\uff0c\u8bf7\u6267\u884c
ln -s \/usr\/local\/mysql\/bin\/mysqldumpslow  \/usr\/bin<\/pre>\n\n\n\n
\u5982\u679c\u51fa\u73b0\u5982\u4e0b\u9519\u8bef\uff0cDied at \/usr\/bin\/mysqldumpslow line 161, <> chunk 405659.\u8bf4\u660e\u4f60\u8981\u5206\u6790\u7684sql\u65e5\u5fd7\u592a\u5927\u4e86\uff0c\u8bf7\u62c6\u5206\u540e\u518d\u5206\u6790

\u62c6\u5206\u7684\u547d\u4ee4\u4e3a\uff1atail -100000 mysql-slow.log > mysql-slow.20180725.log<\/pre>\n\n\n\n
\u5173\u95edmysql\u67e5\u8be2\u7f13\u5b58
set global query_cache_size=0<\/strong>
set global query_cache_type=0<\/strong><\/pre>\n\n\n\n
\u53c2\u8003\uff1ahttps:\/\/blog.csdn.net\/sunyuhua_keyboard\/article\/details\/81204020<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"
mysqldumpslow \u6162\u65e5\u5fd7\u5206\u6790\u5de5\u5177\u547d\u4ee4\uff1a -s \u6309\u7167\u90a3\u79cd\u65b9\u5f0f\u6392\u5e8f c:\u8bbf\u95ee\u8ba1\u6570 l:\u9501\u5b9a\u65f6\u95f4 r:\u8fd4\u56de […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[12],"tags":[33,32],"_links":{"self":[{"href":"https:\/\/www.zeroheart.xyz\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/672"}],"collection":[{"href":"https:\/\/www.zeroheart.xyz\/wordpress\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.zeroheart.xyz\/wordpress\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.zeroheart.xyz\/wordpress\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.zeroheart.xyz\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=672"}],"version-history":[{"count":19,"href":"https:\/\/www.zeroheart.xyz\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/672\/revisions"}],"predecessor-version":[{"id":691,"href":"https:\/\/www.zeroheart.xyz\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/672\/revisions\/691"}],"wp:attachment":[{"href":"https:\/\/www.zeroheart.xyz\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=672"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.zeroheart.xyz\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=672"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.zeroheart.xyz\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=672"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}