{"id":34,"date":"2011-02-05T23:03:06","date_gmt":"2011-02-06T04:03:06","guid":{"rendered":"http:\/\/backup-my-data.com\/blog\/?p=34"},"modified":"2011-02-05T23:03:06","modified_gmt":"2011-02-06T04:03:06","slug":"mysql-database-optimizer-for-oscommerce","status":"publish","type":"post","link":"https:\/\/backup-my-data.com\/blog\/?p=34","title":{"rendered":"MySQL Database Optimizer for osCommerce"},"content":{"rendered":"<p>All osCommerce shops require a MySQL database to function but little attention is given to it. Just ask yourself when was the last time you optimized your database. Unfortunately, this is a big mistake since MySQL is prone to developing problems. Many are fixed as the database runs but many are not and, over time, these grow and can severely effect your shops performance. This addon will automatically tune-up the database (the cron setup is required) and cure many known short-comings of MySQL.  Here are some of its features:<\/p>\n<ul>\n<li>Defragment the tables<\/li>\n<li>Optimize the keys<\/li>\n<li>Strip the customers tables of old data<\/li>\n<li>Strip the sessions table of old data<\/li>\n<li>Strip the user tracking table (if present) of old data<\/li>\n<li>Remove old credit card numbers<\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>All osCommerce shops require a MySQL database to function but little attention is given to it. Just ask yourself when was the last time you optimized your database. Unfortunately, this is a big mistake since MySQL is prone to developing &hellip; <a href=\"https:\/\/backup-my-data.com\/blog\/?p=34\">Continue reading <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":[1],"tags":[],"class_list":["post-34","post","type-post","status-publish","format-standard","hentry","category-general-announcements"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v20.13 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>MySQL Database Optimizer for osCommerce - Oscommerce Solution<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/backup-my-data.com\/blog\/?p=34\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"MySQL Database Optimizer for osCommerce - Oscommerce Solution\" \/>\n<meta property=\"og:description\" content=\"All osCommerce shops require a MySQL database to function but little attention is given to it. Just ask yourself when was the last time you optimized your database. Unfortunately, this is a big mistake since MySQL is prone to developing &hellip; Continue reading &rarr;\" \/>\n<meta property=\"og:url\" content=\"https:\/\/backup-my-data.com\/blog\/?p=34\" \/>\n<meta property=\"og:site_name\" content=\"Oscommerce Solution\" \/>\n<meta property=\"article:published_time\" content=\"2011-02-06T04:03:06+00:00\" \/>\n<meta name=\"author\" content=\"Greg\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Greg\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/backup-my-data.com\/blog\/?p=34\",\"url\":\"https:\/\/backup-my-data.com\/blog\/?p=34\",\"name\":\"MySQL Database Optimizer for osCommerce - Oscommerce Solution\",\"isPartOf\":{\"@id\":\"https:\/\/backup-my-data.com\/blog\/#website\"},\"datePublished\":\"2011-02-06T04:03:06+00:00\",\"dateModified\":\"2011-02-06T04:03:06+00:00\",\"author\":{\"@id\":\"https:\/\/backup-my-data.com\/blog\/#\/schema\/person\/a1c7749a587f0abfc2261d49a5f848d6\"},\"breadcrumb\":{\"@id\":\"https:\/\/backup-my-data.com\/blog\/?p=34#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/backup-my-data.com\/blog\/?p=34\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/backup-my-data.com\/blog\/?p=34#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/backup-my-data.com\/blog\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"MySQL Database Optimizer for osCommerce\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/backup-my-data.com\/blog\/#website\",\"url\":\"https:\/\/backup-my-data.com\/blog\/\",\"name\":\"Oscommerce Solution\",\"description\":\"Blog for oscommerce-solution and its related sites\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/backup-my-data.com\/blog\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/backup-my-data.com\/blog\/#\/schema\/person\/a1c7749a587f0abfc2261d49a5f848d6\",\"name\":\"Greg\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/backup-my-data.com\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/f8382385f886f1e5a16e4db718eb0f8f?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/f8382385f886f1e5a16e4db718eb0f8f?s=96&d=mm&r=g\",\"caption\":\"Greg\"},\"url\":\"https:\/\/backup-my-data.com\/blog\/?author=1\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"MySQL Database Optimizer for osCommerce - Oscommerce Solution","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/backup-my-data.com\/blog\/?p=34","og_locale":"en_US","og_type":"article","og_title":"MySQL Database Optimizer for osCommerce - Oscommerce Solution","og_description":"All osCommerce shops require a MySQL database to function but little attention is given to it. Just ask yourself when was the last time you optimized your database. Unfortunately, this is a big mistake since MySQL is prone to developing &hellip; Continue reading &rarr;","og_url":"https:\/\/backup-my-data.com\/blog\/?p=34","og_site_name":"Oscommerce Solution","article_published_time":"2011-02-06T04:03:06+00:00","author":"Greg","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Greg","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/backup-my-data.com\/blog\/?p=34","url":"https:\/\/backup-my-data.com\/blog\/?p=34","name":"MySQL Database Optimizer for osCommerce - Oscommerce Solution","isPartOf":{"@id":"https:\/\/backup-my-data.com\/blog\/#website"},"datePublished":"2011-02-06T04:03:06+00:00","dateModified":"2011-02-06T04:03:06+00:00","author":{"@id":"https:\/\/backup-my-data.com\/blog\/#\/schema\/person\/a1c7749a587f0abfc2261d49a5f848d6"},"breadcrumb":{"@id":"https:\/\/backup-my-data.com\/blog\/?p=34#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/backup-my-data.com\/blog\/?p=34"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/backup-my-data.com\/blog\/?p=34#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/backup-my-data.com\/blog"},{"@type":"ListItem","position":2,"name":"MySQL Database Optimizer for osCommerce"}]},{"@type":"WebSite","@id":"https:\/\/backup-my-data.com\/blog\/#website","url":"https:\/\/backup-my-data.com\/blog\/","name":"Oscommerce Solution","description":"Blog for oscommerce-solution and its related sites","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/backup-my-data.com\/blog\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/backup-my-data.com\/blog\/#\/schema\/person\/a1c7749a587f0abfc2261d49a5f848d6","name":"Greg","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/backup-my-data.com\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/f8382385f886f1e5a16e4db718eb0f8f?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/f8382385f886f1e5a16e4db718eb0f8f?s=96&d=mm&r=g","caption":"Greg"},"url":"https:\/\/backup-my-data.com\/blog\/?author=1"}]}},"_links":{"self":[{"href":"https:\/\/backup-my-data.com\/blog\/index.php?rest_route=\/wp\/v2\/posts\/34","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/backup-my-data.com\/blog\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/backup-my-data.com\/blog\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/backup-my-data.com\/blog\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/backup-my-data.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=34"}],"version-history":[{"count":1,"href":"https:\/\/backup-my-data.com\/blog\/index.php?rest_route=\/wp\/v2\/posts\/34\/revisions"}],"predecessor-version":[{"id":35,"href":"https:\/\/backup-my-data.com\/blog\/index.php?rest_route=\/wp\/v2\/posts\/34\/revisions\/35"}],"wp:attachment":[{"href":"https:\/\/backup-my-data.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=34"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/backup-my-data.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=34"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/backup-my-data.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=34"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}