{"id":141,"date":"2013-09-27T14:08:00","date_gmt":"2013-09-27T14:08:00","guid":{"rendered":"http:\/\/blog.chen-hongyi.com\/?p=141"},"modified":"2013-09-27T14:31:16","modified_gmt":"2013-09-27T14:31:16","slug":"example-to-use-mk-query-digest-to-check-the-live-queries","status":"publish","type":"post","link":"https:\/\/chen-hongyi.com\/?p=141","title":{"rendered":"Example to use mk-query-digest to check the live queries"},"content":{"rendered":"<p>From: <a title=\"http:\/\/yueliangdao0608.blog.51cto.com\/397025\/312602\/\" href=\"http:\/\/yueliangdao0608.blog.51cto.com\/397025\/312602\/\">http:\/\/yueliangdao0608.blog.51cto.com\/397025\/312602\/<\/a><\/p>\n<p>mk-query-digest &#8211;select Query_time,Lock_time,Rows_sent,Rows_examined\u00a0 &#8211;processlist h=localhost,u=root,p=password<\/p>\n<p>use Ctrl+C to stop.<\/p>\n<p>OPTION:<\/p>\n<p>&#8211;select<\/p>\n<p>&#8211;processlist DSN<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>From: http:\/\/yueliangdao0608.blog.51cto. &hellip; <a href=\"https:\/\/chen-hongyi.com\/?p=141\">\u7ee7\u7eed\u9605\u8bfb <span class=\"meta-nav\">&rarr;<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-141","post","type-post","status-publish","format-standard","hentry","category-uncategorized"],"_links":{"self":[{"href":"https:\/\/chen-hongyi.com\/index.php?rest_route=\/wp\/v2\/posts\/141","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/chen-hongyi.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/chen-hongyi.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/chen-hongyi.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/chen-hongyi.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=141"}],"version-history":[{"count":3,"href":"https:\/\/chen-hongyi.com\/index.php?rest_route=\/wp\/v2\/posts\/141\/revisions"}],"predecessor-version":[{"id":143,"href":"https:\/\/chen-hongyi.com\/index.php?rest_route=\/wp\/v2\/posts\/141\/revisions\/143"}],"wp:attachment":[{"href":"https:\/\/chen-hongyi.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=141"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/chen-hongyi.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=141"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/chen-hongyi.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=141"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}