{"id":326,"date":"2007-11-23T12:16:32","date_gmt":"2007-11-23T17:16:32","guid":{"rendered":"http:\/\/blogs.n1zyy.com\/n1zyy\/2007\/11\/23\/db-stats\/"},"modified":"2007-11-23T12:16:32","modified_gmt":"2007-11-23T17:16:32","slug":"db-stats","status":"publish","type":"post","link":"https:\/\/blogs.n1zyy.com\/n1zyy\/2007\/11\/23\/db-stats\/","title":{"rendered":"DB Stats"},"content":{"rendered":"<p>I&#8217;ve been playing with phpMyAdmin and doing a bit of optimization of it. A few stats:<\/p>\n<ul>\n    <li>Since I upgraded the kernel, MySQL has been up for a little under 3 days and 11 hours.<\/li>\n    <li>The DB server has moved 841 MiB of traffic. This is 10 MiB an hour.<\/li>\n    <li>It&#8217;s processed 131,048 queries. This is about 1,580 an hour.<\/li>\n    <li>132,000 inserted rows.<\/li>\n    <li>96K queries served out of MySQL&#8217;s query cache.<\/li>\n    <li>1,393 temporary tables created <em>on disk<\/em> to handle queries. This seems like a bottleneck, although it is only a tiny percentage.<\/li>\n<\/ul>\n<p>I&#8217;ve just restarted MySQL to apply some configuration changes. (Actually, I could have changed them on the fly now that I think about it&#8230;) I tweaked the settings a bit: MySQL allows you to set limits on how much RAM it can use for various operations, and I tend to be very frugal. But I think I was shooting myself in the foot there: it was relying on disk a bit too much. It&#8217;s not like I&#8217;m running a load average of 25 and am moving gigs of traffic a day, where tuning is really vital, but it still bothers me that it&#8217;s not as efficient as it could be.<\/p>","protected":false},"excerpt":{"rendered":"<p>I&#8217;ve been playing with phpMyAdmin and doing a bit of optimization of it. A few stats: Since I upgraded the kernel, MySQL has been up for a little under 3 days and 11 hours. The DB server has moved 841 &hellip; <a href=\"https:\/\/blogs.n1zyy.com\/n1zyy\/2007\/11\/23\/db-stats\/\">Continue reading <span class=\"meta-nav\">&rarr;<\/span><\/a><\/p>","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[4,11,18,22],"tags":[],"class_list":["post-326","post","type-post","status-publish","format-standard","hentry","category-computers","category-insanity","category-ocd","category-programming"],"_links":{"self":[{"href":"https:\/\/blogs.n1zyy.com\/n1zyy\/wp-json\/wp\/v2\/posts\/326","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/blogs.n1zyy.com\/n1zyy\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blogs.n1zyy.com\/n1zyy\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blogs.n1zyy.com\/n1zyy\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/blogs.n1zyy.com\/n1zyy\/wp-json\/wp\/v2\/comments?post=326"}],"version-history":[{"count":0,"href":"https:\/\/blogs.n1zyy.com\/n1zyy\/wp-json\/wp\/v2\/posts\/326\/revisions"}],"wp:attachment":[{"href":"https:\/\/blogs.n1zyy.com\/n1zyy\/wp-json\/wp\/v2\/media?parent=326"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blogs.n1zyy.com\/n1zyy\/wp-json\/wp\/v2\/categories?post=326"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blogs.n1zyy.com\/n1zyy\/wp-json\/wp\/v2\/tags?post=326"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}