{"id":208,"date":"2007-08-26T17:03:50","date_gmt":"2007-08-26T15:03:50","guid":{"rendered":"http:\/\/www.kill-9.it\/blog\/index.php\/2007\/08\/26\/mysql-and-low-memory-help-needed\/"},"modified":"2007-08-26T17:03:50","modified_gmt":"2007-08-26T15:03:50","slug":"mysql-and-low-memory-help-needed","status":"publish","type":"post","link":"https:\/\/www.kill-9.it\/blog\/index.php\/2007\/08\/26\/mysql-and-low-memory-help-needed\/","title":{"rendered":"MySQL and low memory(?), help needed"},"content":{"rendered":"<p>Dear lazyweb,<br \/>\nas you may have seen sometimes the SQL backend of this blog dies.<br \/>\nI believe this is caused by the amount of ram available on the machine, but feel free to teach me.<br \/>\nRight now mysql uses<br \/>\n<code><br \/>\nPID USERNAME PRI NICE   SIZE   RES STATE      TIME   WCPU    CPU COMMAND<br \/>\n23902 mysql     18    0    42M   28M sigwait    0:12  0.83%  0.83% mysqld<br \/>\n<\/code><\/p>\n<p>I tried to optimize it a little, but had small to none real effect using<br \/>\n<code><br \/>\nquery_cache_type = 1<br \/>\nquery_cache_size = 1M<br \/>\nquery_cache_limit = 1M<br \/>\nthread_cache_size = 3<br \/>\ntmp_table_size = 50000000<br \/>\nkey_buffer_size = 6291456<br \/>\n<\/code><\/p>\n<p>Given that all I have are 192Megs of ram, and the machine is performing happiliy if it weren&#8217;t for the DB dying, is there anything I can do? (&#8220;Move over to a bigger iron&#8221; is not a valid answer).<br \/>\nI think I&#8217;m not using InnoDB, and that all tables are MyISAM &#8211; if that makes a difference.<br \/>\nI&#8217;m on 5.0.2x train already.<\/p>\n<p>In other news, I&#8217;m @home in Bologna and I have fever.<br \/>\nIt won&#8217;t be fun to reach Milan tonight or tomorrow morning. :|<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Dear lazyweb, as you may have seen sometimes the SQL backend of this blog dies. I believe this is caused by the amount of ram available on the machine, but feel free to teach me. Right now mysql uses PID USERNAME PRI NICE SIZE RES STATE TIME WCPU CPU COMMAND 23902 mysql 18 0 42M &hellip; <a href=\"https:\/\/www.kill-9.it\/blog\/index.php\/2007\/08\/26\/mysql-and-low-memory-help-needed\/\" class=\"more-link\">Continue reading<span class=\"screen-reader-text\"> &#8220;MySQL and low memory(?), help needed&#8221;<\/span><\/a><\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[6,3],"tags":[],"class_list":["post-208","post","type-post","status-publish","format-standard","hentry","category-english","category-geek"],"_links":{"self":[{"href":"https:\/\/www.kill-9.it\/blog\/index.php\/wp-json\/wp\/v2\/posts\/208","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.kill-9.it\/blog\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.kill-9.it\/blog\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.kill-9.it\/blog\/index.php\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.kill-9.it\/blog\/index.php\/wp-json\/wp\/v2\/comments?post=208"}],"version-history":[{"count":0,"href":"https:\/\/www.kill-9.it\/blog\/index.php\/wp-json\/wp\/v2\/posts\/208\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.kill-9.it\/blog\/index.php\/wp-json\/wp\/v2\/media?parent=208"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.kill-9.it\/blog\/index.php\/wp-json\/wp\/v2\/categories?post=208"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.kill-9.it\/blog\/index.php\/wp-json\/wp\/v2\/tags?post=208"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}