{"id":413,"date":"2007-04-11T16:18:18","date_gmt":"2007-04-11T22:18:18","guid":{"rendered":"http:\/\/www.mooreds.com\/wordpress\/archives\/000413"},"modified":"2007-04-11T16:22:46","modified_gmt":"2007-04-11T22:22:46","slug":"mysql-tuning","status":"publish","type":"post","link":"https:\/\/www.mooreds.com\/wordpress\/archives\/413","title":{"rendered":"MySQL tuning"},"content":{"rendered":"<p>If you&#8217;re trying to tune MySQL, make sure you measure before and after.  <a href=\"http:\/\/hackmysql.com\/mysqlreport\">mysqlreport<\/a> is a great way to measure a number of aspects of mysql (make sure you <a href=\"http:\/\/hackmysql.com\/mysqlreportguide\">check out the guide<\/a>).  If you want graphing and long term tracking for mysqlreport and just about any other measure you care to track, I recommend <a href=\"http:\/\/cacti.net\/\">cacti<\/a>, which works with <a href=\"http:\/\/oss.oetiker.ch\/rrdtool\/\">rrdtool<\/a>.<\/p>\n<p>[tags]mysql performance, monitoring[\/tags]<\/p>\n","protected":false},"excerpt":{"rendered":"<p>If you&#8217;re trying to tune MySQL, make sure you measure before and after. mysqlreport is a great way to measure a number of aspects of mysql (make sure you check [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[13,28],"tags":[],"class_list":["post-413","post","type-post","status-publish","format-standard","hentry","category-databases","category-mysql"],"_links":{"self":[{"href":"https:\/\/www.mooreds.com\/wordpress\/wp-json\/wp\/v2\/posts\/413","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.mooreds.com\/wordpress\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.mooreds.com\/wordpress\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.mooreds.com\/wordpress\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.mooreds.com\/wordpress\/wp-json\/wp\/v2\/comments?post=413"}],"version-history":[{"count":0,"href":"https:\/\/www.mooreds.com\/wordpress\/wp-json\/wp\/v2\/posts\/413\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.mooreds.com\/wordpress\/wp-json\/wp\/v2\/media?parent=413"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.mooreds.com\/wordpress\/wp-json\/wp\/v2\/categories?post=413"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.mooreds.com\/wordpress\/wp-json\/wp\/v2\/tags?post=413"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}