{"id":443,"date":"2009-03-23T09:03:57","date_gmt":"2009-03-23T08:03:57","guid":{"rendered":"http:\/\/wp.devco.net\/?p=443"},"modified":"2009-10-09T13:56:43","modified_gmt":"2009-10-09T12:56:43","slug":"mysql_defaults_and_load_time","status":"publish","type":"post","link":"https:\/\/www.devco.net\/archives\/2009\/03\/23\/mysql_defaults_and_load_time.php","title":{"rendered":"MySQL Defaults and Load time"},"content":{"rendered":"

We all know not to use the default mysql config, right?<\/p>\n

Well I accidentally left a machine to defaults, then tried to load a massive dump file into it, a month later I finally killed the process loading the data.  I gave up on it ages ago but it got to the point where it was some curiosity to see just how long it will take.<\/p>\n

<\/center>As you can see from above, it was pretty dismal, slowly creeping up over time – the big jump in the beginning is when I scp’d the data onto the machine.  So after killing it I had another look at the config and noticed it was the default distributed one, tuned it to better use the memory for innodb buffers and got the result below.<\/p>\n

<\/center>That’s just short of 2 days to load the data, still pretty crap, but so much better at the same time.<\/p>\n","protected":false},"excerpt":{"rendered":"

We all know not to use the default mysql config, right? Well I accidentally left a machine to defaults, then tried to load a massive dump file into it, a month later I finally killed the process loading the data.  I gave up on it ages ago but it got to the point where it […]<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_et_pb_use_builder":"","_et_pb_old_content":"","footnotes":""},"categories":[5],"tags":[19,34,33],"_links":{"self":[{"href":"https:\/\/www.devco.net\/wp-json\/wp\/v2\/posts\/443"}],"collection":[{"href":"https:\/\/www.devco.net\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.devco.net\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.devco.net\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.devco.net\/wp-json\/wp\/v2\/comments?post=443"}],"version-history":[{"count":1,"href":"https:\/\/www.devco.net\/wp-json\/wp\/v2\/posts\/443\/revisions"}],"predecessor-version":[{"id":508,"href":"https:\/\/www.devco.net\/wp-json\/wp\/v2\/posts\/443\/revisions\/508"}],"wp:attachment":[{"href":"https:\/\/www.devco.net\/wp-json\/wp\/v2\/media?parent=443"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.devco.net\/wp-json\/wp\/v2\/categories?post=443"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.devco.net\/wp-json\/wp\/v2\/tags?post=443"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}