{"id":368,"date":"2007-02-07T11:47:43","date_gmt":"2007-02-07T11:47:43","guid":{"rendered":"http:\/\/neosmart.net\/blog\/2007\/mysql-on-the-fritz\/"},"modified":"2013-08-26T18:09:17","modified_gmt":"2013-08-26T23:09:17","slug":"mysql-on-the-fritz","status":"publish","type":"post","link":"https:\/\/neosmart.net\/blog\/mysql-on-the-fritz\/","title":{"rendered":"MySQL on the Fritz"},"content":{"rendered":"<p>Earlier today (according to UTC at any rate), NeoSmart Technologies had a severe MySQL problem. After some very heavy load on our resource-intensive <a href=\"http:\/\/neosmart.net\/gallery\/album\/index\/\" rel=\"follow\">NST Gallery<\/a>&nbsp;it seems that MySQL just started coughing up bytes, nuts, and bolts. It&#8217;s all fixed now though, and we&#8217;re sorry for the downtime.\n<\/p>\n<p>The reason it took so long is that we decided to &#8220;seize the moment&#8221; to upgrade MySQL to the new 5.1.x series, and unfortuantely, we ran into a bug that has been in the 5.1.x series for a while that stops InnoDB tables from loading up. We tried to go back to the 5.0.x line, but that didn&#8217;t work either. It took a long time to get our binary recovery data from MySQL to another server to get a SQL dump of the data, then completely scrub the main NST server clean of all MySQL residue, then restore the SQL dumps.\n<\/p>\n<p>Hopefully everything is well now, and we&#8217;ve put in some safeguards that should prevent or at least minimize this kind of problem in the future. If you notice anything weird still happening, please do let us know. Some of the symptoms included an inability to view Forum posts, crashes when commenting here on The NeoSmart Files, and some problems in the Gallery. Again, our sincerest apologies for the downtime.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Earlier today (according to UTC at any rate), NeoSmart Technologies had a severe MySQL problem. After some very heavy load on our resource-intensive NST Gallery&nbsp;it seems that MySQL just started coughing up bytes, nuts, and bolts. It&#8217;s all fixed now &hellip; <a href=\"https:\/\/neosmart.net\/blog\/mysql-on-the-fritz\/\">Continue reading <span class=\"meta-nav\">&rarr;<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_feature_clip_id":0,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_post_was_ever_published":false},"categories":[1],"tags":[248,142],"class_list":["post-368","post","type-post","status-publish","format-standard","hentry","category-software","tag-mysql","tag-servers"],"aioseo_notices":[],"aioseo_head":"\n\t\t<!-- All in One SEO 5.0.4 - aioseo.com -->\n\t<meta name=\"description\" content=\"Earlier today (according to UTC at any rate), NeoSmart Technologies had a severe MySQL problem. After some very heavy load on our resource-intensive NST Gallery it seems that MySQL just started coughing up bytes, nuts, and bolts. It&#039;s all fixed now though, and we&#039;re sorry for the downtime. The reason it took so long is that\" \/>\n\t<meta name=\"robots\" content=\"max-image-preview:large\" \/>\n\t<meta name=\"author\" content=\"NeoSmart Technologies\"\/>\n\t<link rel=\"canonical\" href=\"https:\/\/neosmart.net\/blog\/mysql-on-the-fritz\/\" \/>\n\t\t<meta name=\"generator\" content=\"All in One SEO (AIOSEO) 5.0.4\" \/>\n\t\t<script type=\"application\/ld+json\" class=\"aioseo-schema\">\n\t\t\t{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/neosmart.net\\\/blog\\\/mysql-on-the-fritz\\\/#article\",\"name\":\"MySQL on the Fritz | The NeoSmart Files\",\"headline\":\"MySQL on the Fritz\",\"author\":{\"@id\":\"https:\\\/\\\/neosmart.net\\\/blog\\\/author\\\/neosmart\\\/#author\"},\"publisher\":{\"@id\":\"https:\\\/\\\/neosmart.net\\\/blog\\\/#organization\"},\"datePublished\":\"2007-02-07T11:47:43-06:00\",\"dateModified\":\"2013-08-26T18:09:17-05:00\",\"inLanguage\":\"en-US\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/neosmart.net\\\/blog\\\/mysql-on-the-fritz\\\/#webpage\"},\"isPartOf\":{\"@id\":\"https:\\\/\\\/neosmart.net\\\/blog\\\/mysql-on-the-fritz\\\/#webpage\"},\"articleSection\":\"Software, mysql, servers\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/neosmart.net\\\/blog\\\/mysql-on-the-fritz\\\/#breadcrumblist\",\"itemListElement\":[{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/neosmart.net\\\/blog\\\/#listItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/neosmart.net\\\/blog\\\/\",\"nextItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/neosmart.net\\\/blog\\\/category\\\/software\\\/#listItem\",\"name\":\"Software\"}},{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/neosmart.net\\\/blog\\\/category\\\/software\\\/#listItem\",\"position\":2,\"name\":\"Software\",\"item\":\"https:\\\/\\\/neosmart.net\\\/blog\\\/category\\\/software\\\/\",\"nextItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/neosmart.net\\\/blog\\\/mysql-on-the-fritz\\\/#listItem\",\"name\":\"MySQL on the Fritz\"},\"previousItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/neosmart.net\\\/blog\\\/#listItem\",\"name\":\"Home\"}},{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/neosmart.net\\\/blog\\\/mysql-on-the-fritz\\\/#listItem\",\"position\":3,\"name\":\"MySQL on the Fritz\",\"previousItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/neosmart.net\\\/blog\\\/category\\\/software\\\/#listItem\",\"name\":\"Software\"}}]},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/neosmart.net\\\/blog\\\/#organization\",\"name\":\"The NeoSmart Files\",\"description\":\"Recovery software and more\",\"url\":\"https:\\\/\\\/neosmart.net\\\/blog\\\/\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/neosmart.net\\\/blog\\\/author\\\/neosmart\\\/#author\",\"url\":\"https:\\\/\\\/neosmart.net\\\/blog\\\/author\\\/neosmart\\\/\",\"name\":\"NeoSmart Technologies\",\"image\":{\"@type\":\"ImageObject\",\"@id\":\"https:\\\/\\\/neosmart.net\\\/blog\\\/mysql-on-the-fritz\\\/#authorImage\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/f542321efe8fccee6fb0b3322c2f647e2ab44a861d6b18ff16a79d032f8574cd?s=96&d=mm&r=pg\",\"width\":96,\"height\":96,\"caption\":\"NeoSmart Technologies\"}},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/neosmart.net\\\/blog\\\/mysql-on-the-fritz\\\/#webpage\",\"url\":\"https:\\\/\\\/neosmart.net\\\/blog\\\/mysql-on-the-fritz\\\/\",\"name\":\"MySQL on the Fritz | The NeoSmart Files\",\"description\":\"Earlier today (according to UTC at any rate), NeoSmart Technologies had a severe MySQL problem. After some very heavy load on our resource-intensive NST Gallery it seems that MySQL just started coughing up bytes, nuts, and bolts. It's all fixed now though, and we're sorry for the downtime. The reason it took so long is that\",\"inLanguage\":\"en-US\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/neosmart.net\\\/blog\\\/#website\"},\"breadcrumb\":{\"@id\":\"https:\\\/\\\/neosmart.net\\\/blog\\\/mysql-on-the-fritz\\\/#breadcrumblist\"},\"author\":{\"@id\":\"https:\\\/\\\/neosmart.net\\\/blog\\\/author\\\/neosmart\\\/#author\"},\"creator\":{\"@id\":\"https:\\\/\\\/neosmart.net\\\/blog\\\/author\\\/neosmart\\\/#author\"},\"datePublished\":\"2007-02-07T11:47:43-06:00\",\"dateModified\":\"2013-08-26T18:09:17-05:00\"},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/neosmart.net\\\/blog\\\/#website\",\"url\":\"https:\\\/\\\/neosmart.net\\\/blog\\\/\",\"name\":\"The NeoSmart Files\",\"description\":\"Recovery software and more\",\"inLanguage\":\"en-US\",\"publisher\":{\"@id\":\"https:\\\/\\\/neosmart.net\\\/blog\\\/#organization\"}}]}\n\t\t<\/script>\n\t\t<!-- All in One SEO -->\n\n","aioseo_head_json":{"title":"MySQL on the Fritz | The NeoSmart Files","description":"Earlier today (according to UTC at any rate), NeoSmart Technologies had a severe MySQL problem. After some very heavy load on our resource-intensive NST Gallery it seems that MySQL just started coughing up bytes, nuts, and bolts. It's all fixed now though, and we're sorry for the downtime. The reason it took so long is that","canonical_url":"https:\/\/neosmart.net\/blog\/mysql-on-the-fritz\/","robots":"max-image-preview:large","keywords":"","webmasterTools":{"miscellaneous":""},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/neosmart.net\/blog\/mysql-on-the-fritz\/#article","name":"MySQL on the Fritz | The NeoSmart Files","headline":"MySQL on the Fritz","author":{"@id":"https:\/\/neosmart.net\/blog\/author\/neosmart\/#author"},"publisher":{"@id":"https:\/\/neosmart.net\/blog\/#organization"},"datePublished":"2007-02-07T11:47:43-06:00","dateModified":"2013-08-26T18:09:17-05:00","inLanguage":"en-US","mainEntityOfPage":{"@id":"https:\/\/neosmart.net\/blog\/mysql-on-the-fritz\/#webpage"},"isPartOf":{"@id":"https:\/\/neosmart.net\/blog\/mysql-on-the-fritz\/#webpage"},"articleSection":"Software, mysql, servers"},{"@type":"BreadcrumbList","@id":"https:\/\/neosmart.net\/blog\/mysql-on-the-fritz\/#breadcrumblist","itemListElement":[{"@type":"ListItem","@id":"https:\/\/neosmart.net\/blog\/#listItem","position":1,"name":"Home","item":"https:\/\/neosmart.net\/blog\/","nextItem":{"@type":"ListItem","@id":"https:\/\/neosmart.net\/blog\/category\/software\/#listItem","name":"Software"}},{"@type":"ListItem","@id":"https:\/\/neosmart.net\/blog\/category\/software\/#listItem","position":2,"name":"Software","item":"https:\/\/neosmart.net\/blog\/category\/software\/","nextItem":{"@type":"ListItem","@id":"https:\/\/neosmart.net\/blog\/mysql-on-the-fritz\/#listItem","name":"MySQL on the Fritz"},"previousItem":{"@type":"ListItem","@id":"https:\/\/neosmart.net\/blog\/#listItem","name":"Home"}},{"@type":"ListItem","@id":"https:\/\/neosmart.net\/blog\/mysql-on-the-fritz\/#listItem","position":3,"name":"MySQL on the Fritz","previousItem":{"@type":"ListItem","@id":"https:\/\/neosmart.net\/blog\/category\/software\/#listItem","name":"Software"}}]},{"@type":"Organization","@id":"https:\/\/neosmart.net\/blog\/#organization","name":"The NeoSmart Files","description":"Recovery software and more","url":"https:\/\/neosmart.net\/blog\/"},{"@type":"Person","@id":"https:\/\/neosmart.net\/blog\/author\/neosmart\/#author","url":"https:\/\/neosmart.net\/blog\/author\/neosmart\/","name":"NeoSmart Technologies","image":{"@type":"ImageObject","@id":"https:\/\/neosmart.net\/blog\/mysql-on-the-fritz\/#authorImage","url":"https:\/\/secure.gravatar.com\/avatar\/f542321efe8fccee6fb0b3322c2f647e2ab44a861d6b18ff16a79d032f8574cd?s=96&d=mm&r=pg","width":96,"height":96,"caption":"NeoSmart Technologies"}},{"@type":"WebPage","@id":"https:\/\/neosmart.net\/blog\/mysql-on-the-fritz\/#webpage","url":"https:\/\/neosmart.net\/blog\/mysql-on-the-fritz\/","name":"MySQL on the Fritz | The NeoSmart Files","description":"Earlier today (according to UTC at any rate), NeoSmart Technologies had a severe MySQL problem. After some very heavy load on our resource-intensive NST Gallery it seems that MySQL just started coughing up bytes, nuts, and bolts. It's all fixed now though, and we're sorry for the downtime. The reason it took so long is that","inLanguage":"en-US","isPartOf":{"@id":"https:\/\/neosmart.net\/blog\/#website"},"breadcrumb":{"@id":"https:\/\/neosmart.net\/blog\/mysql-on-the-fritz\/#breadcrumblist"},"author":{"@id":"https:\/\/neosmart.net\/blog\/author\/neosmart\/#author"},"creator":{"@id":"https:\/\/neosmart.net\/blog\/author\/neosmart\/#author"},"datePublished":"2007-02-07T11:47:43-06:00","dateModified":"2013-08-26T18:09:17-05:00"},{"@type":"WebSite","@id":"https:\/\/neosmart.net\/blog\/#website","url":"https:\/\/neosmart.net\/blog\/","name":"The NeoSmart Files","description":"Recovery software and more","inLanguage":"en-US","publisher":{"@id":"https:\/\/neosmart.net\/blog\/#organization"}}]}},"aioseo_meta_data":{"post_id":"368","title":null,"description":null,"keywords":null,"keyphrases":null,"primary_term":null,"canonical_url":null,"og_title":null,"og_description":null,"og_object_type":"default","og_image_type":"default","og_image_url":null,"og_image_width":null,"og_image_height":null,"og_image_custom_url":null,"og_image_custom_fields":null,"og_video":null,"og_custom_url":null,"og_article_section":null,"og_article_tags":null,"twitter_use_og":false,"twitter_card":"default","twitter_image_type":"default","twitter_image_url":null,"twitter_image_custom_url":null,"twitter_image_custom_fields":null,"twitter_title":null,"twitter_description":null,"schema":{"blockGraphs":[],"customGraphs":[],"default":{"data":{"Article":[],"Course":[],"Dataset":[],"FAQPage":[],"Movie":[],"Person":[],"Product":[],"ProductReview":[],"Car":[],"Recipe":[],"Service":[],"SoftwareApplication":[],"WebPage":[]},"graphName":"","isEnabled":true},"graphs":[]},"schema_type":null,"schema_type_options":null,"pillar_content":false,"robots_default":true,"robots_noindex":false,"robots_noarchive":false,"robots_nosnippet":false,"robots_nofollow":false,"robots_noimageindex":false,"robots_noodp":false,"robots_notranslate":false,"robots_max_snippet":null,"robots_max_videopreview":null,"robots_max_imagepreview":"large","priority":null,"frequency":null,"location":null,"local_seo":null,"breadcrumb_settings":null,"limit_modified_date":false,"ai":null,"created":"2020-12-23 20:04:59","updated":"2026-01-10 21:40:16","focus_keyword":null,"additional_keywords":null,"truseo_locale":null,"seo_analyzer_scan_date":null},"aioseo_breadcrumb":"<div class=\"aioseo-breadcrumbs\"><span class=\"aioseo-breadcrumb\">\n\t\t\t<a href=\"https:\/\/neosmart.net\/blog\/\" title=\"Home\">Home<\/a>\n\t\t<\/span><span class=\"aioseo-breadcrumb-separator\">\u00bb<\/span><span class=\"aioseo-breadcrumb\">\n\t\t\t<a href=\"https:\/\/neosmart.net\/blog\/category\/software\/\" title=\"Software\">Software<\/a>\n\t\t<\/span><span class=\"aioseo-breadcrumb-separator\">\u00bb<\/span><span class=\"aioseo-breadcrumb\">\n\t\t\tMySQL on the Fritz\n\t\t<\/span><\/div>","aioseo_breadcrumb_json":[{"label":"Home","link":"https:\/\/neosmart.net\/blog\/"},{"label":"Software","link":"https:\/\/neosmart.net\/blog\/category\/software\/"},{"label":"MySQL on the Fritz","link":"https:\/\/neosmart.net\/blog\/mysql-on-the-fritz\/"}],"jetpack_shortlink":"https:\/\/wp.me\/p4xDa-5W","jetpack_sharing_enabled":true,"jetpack_featured_media_url":"","_links":{"self":[{"href":"https:\/\/neosmart.net\/blog\/wp-json\/wp\/v2\/posts\/368","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/neosmart.net\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/neosmart.net\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/neosmart.net\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/neosmart.net\/blog\/wp-json\/wp\/v2\/comments?post=368"}],"version-history":[{"count":1,"href":"https:\/\/neosmart.net\/blog\/wp-json\/wp\/v2\/posts\/368\/revisions"}],"predecessor-version":[{"id":1931,"href":"https:\/\/neosmart.net\/blog\/wp-json\/wp\/v2\/posts\/368\/revisions\/1931"}],"wp:attachment":[{"href":"https:\/\/neosmart.net\/blog\/wp-json\/wp\/v2\/media?parent=368"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/neosmart.net\/blog\/wp-json\/wp\/v2\/categories?post=368"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/neosmart.net\/blog\/wp-json\/wp\/v2\/tags?post=368"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}