{"id":836,"date":"2005-01-05T12:46:59","date_gmt":"2005-01-05T12:46:59","guid":{"rendered":"\/?p=836"},"modified":"2009-01-17T16:49:37","modified_gmt":"2009-01-17T09:49:37","slug":"mysql-tuning","status":"publish","type":"post","link":"https:\/\/harry.sufehmi.com\/archives\/2005-01-05-mysql-tuning\/","title":{"rendered":"MySQL tuning"},"content":{"rendered":"<p>I&#8217;ve been notified of &#8220;Too many connections&#8221; errors lately (thanks to <a href=\"http:\/\/www.harrysufehmi.com\/phpwiki\/index.php\/SettingUpLinuxServer#logcheck\">logcheck<\/a>), and I just realized that I think I&#8217;ve missed a few emails from Yahoogroups.<\/p>\n<p>So looking around, I found out that MySQL&#8217;s table_cache was set to 64, and max_connections at 100. While table_cache really should be (max_connections * N), where N is the max number of tables that may be in a JOIN operation at anytime. <\/p>\n<p>No wonder that, when checked with <strong>mysqladmin -p status<\/strong>, table_cache always peaked at its maximum.<br \/>\nO-u-c-h.<\/p>\n<p>table_cache has been raised to 512, and the server is running happily now.<\/p>\n<p>For those who suspect that they need to tune their MySQL installation, here are 2 good links :<br \/>\n[ <a href=\"http:\/\/www.databasejournal.com\/features\/mysql\/article.php\/10897_1402311_2\">Tuning MySQL<\/a> ]<br \/>\n[ <a href=\"http:\/\/www.databasejournal.com\/features\/mysql\/article.php\/3367871\">Tuning MySQL 4<\/a> ]<\/p>\n<p>Enjoy.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>I&#8217;ve been notified of &#8220;Too many connections&#8221; errors lately (thanks to logcheck), and I just realized that I think I&#8217;ve missed a few emails from Yahoogroups. So looking around, I found out that MySQL&#8217;s table_cache was set to 64, and max_connections at 100. While table_cache really should be (max_connections * N), where N is the &hellip; <a href=\"https:\/\/harry.sufehmi.com\/archives\/2005-01-05-mysql-tuning\/\" class=\"more-link\">Continue reading <span class=\"screen-reader-text\">MySQL tuning<\/span> <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":[51,2],"tags":[],"class_list":["post-836","post","type-post","status-publish","format-standard","hentry","category-open-source","category-teknoblogia"],"_links":{"self":[{"href":"https:\/\/harry.sufehmi.com\/wp-json\/wp\/v2\/posts\/836"}],"collection":[{"href":"https:\/\/harry.sufehmi.com\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/harry.sufehmi.com\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/harry.sufehmi.com\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/harry.sufehmi.com\/wp-json\/wp\/v2\/comments?post=836"}],"version-history":[{"count":1,"href":"https:\/\/harry.sufehmi.com\/wp-json\/wp\/v2\/posts\/836\/revisions"}],"predecessor-version":[{"id":1943,"href":"https:\/\/harry.sufehmi.com\/wp-json\/wp\/v2\/posts\/836\/revisions\/1943"}],"wp:attachment":[{"href":"https:\/\/harry.sufehmi.com\/wp-json\/wp\/v2\/media?parent=836"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/harry.sufehmi.com\/wp-json\/wp\/v2\/categories?post=836"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/harry.sufehmi.com\/wp-json\/wp\/v2\/tags?post=836"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}