{"id":819,"date":"2010-12-10T00:28:25","date_gmt":"2010-12-10T05:28:25","guid":{"rendered":"http:\/\/www.migrate2cloud.com\/blog\/?p=819"},"modified":"2016-03-21T02:49:51","modified_gmt":"2016-03-21T07:49:51","slug":"mysql-optimization","status":"publish","type":"post","link":"https:\/\/www.migrate2cloud.com\/blog\/mysql-optimization\/","title":{"rendered":"MySQL Optimization"},"content":{"rendered":"<p>Database optimization is the process of configuring database to use system resource efficiently and perform tasks quickly. To optimize mysql you should know the work flow of entire system, your hardware, operating system, disk I\/O performance etc.<br \/>\n<strong>Why to Optimize<\/strong><br \/>\nYou can do more with less. The default mysql setup is optimized for a minimal system because it should work well on a minimal hardware. But when you use a dedicated mysql server with high traffic and complex queries you have to optimize mysql.<br \/>\n<strong>MySQL Server tuning Considerations<\/strong><br \/>\nHere you will find some common optimization parameters.<\/p>\n<ul>\n<li>MySQL variables<\/li>\n<li>Hardware<\/li>\n<li>Disk<\/li>\n<li>Application<\/li>\n<\/ul>\n<p><strong>MySQL Optimization<\/strong><br \/>\nMySQL global variables don&#8217;t have any predefined optimum values. It is a trial and monitor process. It depends on all the above parameters. Here you will see some of the common parameters.<br \/>\n<strong>Key-buffer-size<\/strong><br \/>\nIt is size of the buffer used to index blocks for MyISAM tables. On a dedicated mysql server with MyISAM storage engine 25-30% of systems total memory you can allocate for key_buffer_size. To fine tune key_buffer_size you can compare the variables key_reads and the key_read_requests.<br \/>\nThis ratio should be at least 1:100.<\/p>\n<p>SHOW STATUS LIKE &#8216;%key_read%&#8217;;<br \/>\n+&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;-+&#8212;&#8212;&#8212;&#8212;-+<br \/>\n| Variable_name | Value |<br \/>\n+&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;-+&#8212;&#8212;&#8212;&#8212;-+<br \/>\n| Key_read_requests | 10726813161 |<br \/>\n| Key_reads | 92790146 |<br \/>\n+&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;-+&#8212;&#8212;&#8212;&#8212;-+<br \/>\nHere the ratio is 1:115 which is acceptable.<br \/>\nBut suppose you get a ratio 1: 10 then you need to add more key buffer and upgrade hardware accordingly.<br \/>\n<strong>Query Cache<\/strong><br \/>\n\u201cMy website is too slow while loading dynamic pages\u201d. If it is a mysql database related issue, following MySQL variables will be your solution.<br \/>\n<strong>query_cache_type<\/strong><br \/>\nSet the query cache type. There are 3 values 0 ,1 or 2<\/p>\n<table border=\"0\" width=\"100%\" cellspacing=\"1\" cellpadding=\"0\">\n<tbody>\n<tr>\n<td>0<\/td>\n<td>Do not cache any query result<\/td>\n<\/tr>\n<tr>\n<td>1<\/td>\n<td>Cache query results.<\/td>\n<\/tr>\n<tr>\n<td>2<\/td>\n<td>Cache results ondemand. Cacheable queries that begin with SELECT SQL_CACHE.<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p><strong>query_cache_size<\/strong><br \/>\nThe amount of memory used to cache query result. Default is 0 which disable query cache.<br \/>\nThe optimum value is depend on your application.<br \/>\n<strong>query_cache_limit<\/strong><br \/>\nDo not cache results that are larger than this number of bytes. The default value is 1MB.<br \/>\nStatus checking<br \/>\nSHOW STATUS LIKE &#8216;%qcache%&#8217;;<br \/>\n+&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;-+&#8212;&#8212;&#8212;-+<br \/>\n| Variable_name | Value |<br \/>\n+&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;-+&#8212;&#8212;&#8212;-+<br \/>\n| Qcache_free_blocks | 1 |<br \/>\n| Qcache_free_memory | 8371272 |<br \/>\n| Qcache_hits | 23547551 |<br \/>\n| Qcache_inserts | 46909131 |<br \/>\n| Qcache_lowmem_prunes | 5110536 |<br \/>\n| Qcache_not_cached | 2760196 |<br \/>\n| Qcache_queries_in_cache | 0 |<br \/>\n| Qcache_total_blocks | 1 |<br \/>\n+&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;-+&#8212;&#8212;&#8212;-+<br \/>\nThere were 46909131 queries and out which 23547551 queries cached and remaining not cached. Here the issue will either the result is greater than query_cache_limit or greater than query_cache_size itself. You have to trial and monitor \ud83d\ude42<br \/>\n<strong>Qcache_lowmem_prunes.<\/strong><br \/>\nWhen a query is removed from the query cache, this value will be incremented. If it increases quickly, and you still have memory to spare, you can set query_cache_size high, If it never increases, you can reduce the cache size.<\/p>\n<p><strong>sort_buffer<\/strong><br \/>\nThe sort_buffer is a useful for speed up myisamchk operations. It can also be useful when performing large numbers of sorts.<\/p>\n<p><strong>tmp_table_size<\/strong><\/p>\n<p>This variable determines the maximum size for a temporary table in memory. The maximum in memory size is minimum of tmp_table_size and max_heap_table_size. You can compare<br \/>\nCreated_tmp_disk_tables and Created_tmp_tables to optimize tmp_table_size.<\/p>\n<p><strong>innodb_buffer_pool_size<\/strong><\/p>\n<p>This variable is target for innodb table and it is similar to key_buffer_size in MyISAM table.<br \/>\nOn a dedicated mysql server using innodb you can set this upto 80% of RAM.<br \/>\n<strong>Hardware for mysql<\/strong><br \/>\nIf you have large tables(&gt;3GB), you should consider 64 bit hardware as mysql uses a lots of 64bit integers internally.<\/p>\n<p>You need more memory(RAM) if you want mysql to handle large number of connections simultaneously. More RAM will speed up key updates by keeping most of the pages in RAM<\/p>\n<p>Another consideration is Ethernet device, You can use a 1G Ethernet for a dedicated mysql server for fast remote connections.<\/p>\n<p>Disk performance is also an important parameter.<br \/>\n<strong>Disk Optimization<\/strong><br \/>\nStriping disk (RAID 0) will increase both read and write throughput.<\/p>\n<p>Don\u2019t use RAID 1 or mirroring on disk for temporary files.<\/p>\n<p>On Linux, mount the disks with async (default) and noatime.<br \/>\n<strong>Optimizing your application<\/strong><br \/>\nCache process in your application<\/p>\n<p>Specify the column name in queries(eg dont use SELECT * FROM&#8230;&#8230;)<\/p>\n<p>Use persistent connections<\/p>\n<p>USE EXPLAIN to explain!!.You will see detail below.<\/p>\n<p><strong>Queries and Indexes<\/strong><\/p>\n<p>Let us start with a simple query SELECT firstname FROM student WHERE id=&#8217;145870&#8242;;<br \/>\nMySQL start searching from the beginning row to find the student with id 145870. It does not even know it exist or not. An index is a sorted file which have an entry for each row.MySQL can find the corresponding record very quickly by referring this index.<br \/>\nEXPLAIN is a nice tool to understand your queries<\/p>\n<p>EXPLAIN SELECT firstname,lastname FROM student WHERE id=&#8217;145870&#8242;;<\/p>\n<p>+&#8212;&#8212;&#8212;-+&#8212;&#8212;+&#8212;&#8212;&#8212;&#8212;&#8212;+&#8212;&#8212;+&#8212;&#8212;&#8212;+&#8212;&#8212;+&#8212;&#8212;+&#8212;&#8212;&#8212;&#8212;+<br \/>\n| table | type | possible_keys | key | key_len | ref | rows | Extra |<br \/>\n+&#8212;&#8212;&#8212;-+&#8212;&#8212;+&#8212;&#8212;&#8212;&#8212;&#8212;+&#8212;&#8212;+&#8212;&#8212;&#8212;+&#8212;&#8212;+&#8212;&#8212;+&#8212;&#8212;&#8212;&#8212;+<br \/>\n| student | ALL | NULL | NULL | NULL | NULL |10000 | where used |<br \/>\n+&#8212;&#8212;&#8212;-+&#8212;&#8212;+&#8212;&#8212;&#8212;&#8212;&#8212;+&#8212;&#8212;+&#8212;&#8212;&#8212;+&#8212;&#8212;+&#8212;&#8212;+&#8212;&#8212;&#8212;&#8212;+<br \/>\nThe possible_keys is null. In this case mysql will check all the 10000 rows. We can say this query(or table) is not optimized.<\/p>\n<p>Now suppose we have use index for above table and run EXPLAIN again then we will get<br \/>\n+&#8212;&#8212;&#8212;-+&#8212;&#8212;-+&#8212;&#8212;&#8212;&#8212;&#8212;+&#8212;&#8212;&#8212;+&#8212;&#8212;&#8212;+&#8212;&#8212;-+&#8212;&#8212;+&#8212;&#8212;-+<br \/>\n| table | type | possible_keys | key | key_len | ref | rows | Extra |<br \/>\n+&#8212;&#8212;&#8212;-+&#8212;&#8212;-+&#8212;&#8212;&#8212;&#8212;&#8212;+&#8212;&#8212;&#8212;+&#8212;&#8212;&#8212;+&#8212;&#8212;-+&#8212;&#8212;+&#8212;&#8212;-+<br \/>\n| employee | const | PRIMARY | PRIMARY | 10 | const | 1 | |<br \/>\n+&#8212;&#8212;&#8212;-+&#8212;&#8212;-+&#8212;&#8212;&#8212;&#8212;&#8212;+&#8212;&#8212;&#8212;+&#8212;&#8212;&#8212;+&#8212;&#8212;-+&#8212;&#8212;+&#8212;&#8212;-+<br \/>\nThe type is &#8220;const&#8221;, which means that the table has only one matching row. The primary key is being used to find this particular record.<\/p>\n<p>There are many more optimization variables and indxing methods. It is difficult include everything in a single article. But you can start mysql fine tuning while you database is underperfoming.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Database optimization is the process of configuring database to use system resource efficiently and perform tasks quickly. To optimize mysql you should know the work flow of entire system, your hardware, operating system, disk I\/O performance etc. Why to Optimize You can do more with less. The default mysql setup is optimized for a minimal [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","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":[67],"tags":[495,502,123,143,496,66,318,497,187,501,494,120,498,63,64,267,256,499,65,500,252,433,136,503],"class_list":["post-819","post","type-post","status-publish","format-standard","hentry","category-mysql","tag-aria","tag-bit-hardware","tag-cache","tag-company-mysql-ab","tag-database-engine","tag-disk-optimization","tag-ethernet","tag-innodb","tag-linux","tag-minimal-hardware","tag-myisam","tag-mysql-2","tag-mysql-cluster","tag-mysql-optimization","tag-mysql-server","tag-odb","tag-operating-system","tag-outline-of-mysql","tag-query_cache_type","tag-raid","tag-ram","tag-sql","tag-technologyinternet","tag-upgrade-hardware"],"aioseo_notices":[],"aioseo_head":"\n\t\t<!-- All in One SEO 4.9.10 - aioseo.com -->\n\t<meta name=\"description\" content=\"Database optimization is the process of configuring database to use system resource efficiently and perform tasks quickly.\" \/>\n\t<meta name=\"robots\" content=\"max-image-preview:large\" \/>\n\t<meta name=\"author\" content=\"DevOps Team\"\/>\n\t<link rel=\"canonical\" href=\"https:\/\/www.migrate2cloud.com\/blog\/mysql-optimization\/\" \/>\n\t<meta name=\"generator\" content=\"All in One SEO (AIOSEO) 4.9.10\" \/>\n\t\t<meta property=\"og:locale\" content=\"en_US\" \/>\n\t\t<meta property=\"og:site_name\" content=\"Migrate to Cloud - we make the clouds rain\" \/>\n\t\t<meta property=\"og:type\" content=\"article\" \/>\n\t\t<meta property=\"og:title\" content=\"MySQL Optimization - Migrate to Cloud\" \/>\n\t\t<meta property=\"og:description\" content=\"Database optimization is the process of configuring database to use system resource efficiently and perform tasks quickly.\" \/>\n\t\t<meta property=\"og:url\" content=\"https:\/\/www.migrate2cloud.com\/blog\/mysql-optimization\/\" \/>\n\t\t<meta property=\"article:published_time\" content=\"2010-12-10T05:28:25+00:00\" \/>\n\t\t<meta property=\"article:modified_time\" content=\"2016-03-21T07:49:51+00:00\" \/>\n\t\t<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n\t\t<meta name=\"twitter:title\" content=\"MySQL Optimization - Migrate to Cloud\" \/>\n\t\t<meta name=\"twitter:description\" content=\"Database optimization is the process of configuring database to use system resource efficiently and perform tasks quickly.\" \/>\n\t\t<script type=\"application\/ld+json\" class=\"aioseo-schema\">\n\t\t\t{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"BlogPosting\",\"@id\":\"https:\\\/\\\/www.migrate2cloud.com\\\/blog\\\/mysql-optimization\\\/#blogposting\",\"name\":\"MySQL Optimization - Migrate to Cloud\",\"headline\":\"MySQL Optimization\",\"author\":{\"@id\":\"https:\\\/\\\/www.migrate2cloud.com\\\/blog\\\/author\\\/admin\\\/#author\"},\"publisher\":{\"@id\":\"https:\\\/\\\/www.migrate2cloud.com\\\/blog\\\/#organization\"},\"datePublished\":\"2010-12-10T00:28:25-05:00\",\"dateModified\":\"2016-03-21T02:49:51-05:00\",\"inLanguage\":\"en-US\",\"commentCount\":1,\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.migrate2cloud.com\\\/blog\\\/mysql-optimization\\\/#webpage\"},\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.migrate2cloud.com\\\/blog\\\/mysql-optimization\\\/#webpage\"},\"articleSection\":\"MySQL, Aria, bit hardware, cache, Company: MySQL AB, Database engine, Disk Optimization, ethernet, InnoDB, Linux, minimal hardware, MyISAM, Mysql, MySQL Cluster, MySQL Optimization, MySQL Server, ODB, Operating System, Outline of MySQL, query_cache_type, RAID, RAM, SQL, Technology\\\/Internet, upgrade hardware\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.migrate2cloud.com\\\/blog\\\/mysql-optimization\\\/#breadcrumblist\",\"itemListElement\":[{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/www.migrate2cloud.com\\\/blog#listItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.migrate2cloud.com\\\/blog\",\"nextItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/www.migrate2cloud.com\\\/blog\\\/category\\\/mysql\\\/#listItem\",\"name\":\"MySQL\"}},{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/www.migrate2cloud.com\\\/blog\\\/category\\\/mysql\\\/#listItem\",\"position\":2,\"name\":\"MySQL\",\"item\":\"https:\\\/\\\/www.migrate2cloud.com\\\/blog\\\/category\\\/mysql\\\/\",\"nextItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/www.migrate2cloud.com\\\/blog\\\/mysql-optimization\\\/#listItem\",\"name\":\"MySQL Optimization\"},\"previousItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/www.migrate2cloud.com\\\/blog#listItem\",\"name\":\"Home\"}},{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/www.migrate2cloud.com\\\/blog\\\/mysql-optimization\\\/#listItem\",\"position\":3,\"name\":\"MySQL Optimization\",\"previousItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/www.migrate2cloud.com\\\/blog\\\/category\\\/mysql\\\/#listItem\",\"name\":\"MySQL\"}}]},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/www.migrate2cloud.com\\\/blog\\\/#organization\",\"name\":\"Migrate to Cloud\",\"description\":\"we make the clouds rain\",\"url\":\"https:\\\/\\\/www.migrate2cloud.com\\\/blog\\\/\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.migrate2cloud.com\\\/blog\\\/author\\\/admin\\\/#author\",\"url\":\"https:\\\/\\\/www.migrate2cloud.com\\\/blog\\\/author\\\/admin\\\/\",\"name\":\"DevOps Team\",\"image\":{\"@type\":\"ImageObject\",\"@id\":\"https:\\\/\\\/www.migrate2cloud.com\\\/blog\\\/mysql-optimization\\\/#authorImage\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/20b51e018d8f61e1739f60911fcf45cc9d09284569e448583a87f7fd0ac3d9dc?s=96&d=mm&r=g\",\"width\":96,\"height\":96,\"caption\":\"DevOps Team\"}},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.migrate2cloud.com\\\/blog\\\/mysql-optimization\\\/#webpage\",\"url\":\"https:\\\/\\\/www.migrate2cloud.com\\\/blog\\\/mysql-optimization\\\/\",\"name\":\"MySQL Optimization - Migrate to Cloud\",\"description\":\"Database optimization is the process of configuring database to use system resource efficiently and perform tasks quickly.\",\"inLanguage\":\"en-US\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.migrate2cloud.com\\\/blog\\\/#website\"},\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.migrate2cloud.com\\\/blog\\\/mysql-optimization\\\/#breadcrumblist\"},\"author\":{\"@id\":\"https:\\\/\\\/www.migrate2cloud.com\\\/blog\\\/author\\\/admin\\\/#author\"},\"creator\":{\"@id\":\"https:\\\/\\\/www.migrate2cloud.com\\\/blog\\\/author\\\/admin\\\/#author\"},\"datePublished\":\"2010-12-10T00:28:25-05:00\",\"dateModified\":\"2016-03-21T02:49:51-05:00\"},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.migrate2cloud.com\\\/blog\\\/#website\",\"url\":\"https:\\\/\\\/www.migrate2cloud.com\\\/blog\\\/\",\"name\":\"Migrate to Cloud\",\"description\":\"we make the clouds rain\",\"inLanguage\":\"en-US\",\"publisher\":{\"@id\":\"https:\\\/\\\/www.migrate2cloud.com\\\/blog\\\/#organization\"}}]}\n\t\t<\/script>\n\t\t<!-- All in One SEO -->\n\n","aioseo_head_json":{"title":"MySQL Optimization - Migrate to Cloud","description":"Database optimization is the process of configuring database to use system resource efficiently and perform tasks quickly.","canonical_url":"https:\/\/www.migrate2cloud.com\/blog\/mysql-optimization\/","robots":"max-image-preview:large","keywords":"","webmasterTools":{"miscellaneous":""},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"BlogPosting","@id":"https:\/\/www.migrate2cloud.com\/blog\/mysql-optimization\/#blogposting","name":"MySQL Optimization - Migrate to Cloud","headline":"MySQL Optimization","author":{"@id":"https:\/\/www.migrate2cloud.com\/blog\/author\/admin\/#author"},"publisher":{"@id":"https:\/\/www.migrate2cloud.com\/blog\/#organization"},"datePublished":"2010-12-10T00:28:25-05:00","dateModified":"2016-03-21T02:49:51-05:00","inLanguage":"en-US","commentCount":1,"mainEntityOfPage":{"@id":"https:\/\/www.migrate2cloud.com\/blog\/mysql-optimization\/#webpage"},"isPartOf":{"@id":"https:\/\/www.migrate2cloud.com\/blog\/mysql-optimization\/#webpage"},"articleSection":"MySQL, Aria, bit hardware, cache, Company: MySQL AB, Database engine, Disk Optimization, ethernet, InnoDB, Linux, minimal hardware, MyISAM, Mysql, MySQL Cluster, MySQL Optimization, MySQL Server, ODB, Operating System, Outline of MySQL, query_cache_type, RAID, RAM, SQL, Technology\/Internet, upgrade hardware"},{"@type":"BreadcrumbList","@id":"https:\/\/www.migrate2cloud.com\/blog\/mysql-optimization\/#breadcrumblist","itemListElement":[{"@type":"ListItem","@id":"https:\/\/www.migrate2cloud.com\/blog#listItem","position":1,"name":"Home","item":"https:\/\/www.migrate2cloud.com\/blog","nextItem":{"@type":"ListItem","@id":"https:\/\/www.migrate2cloud.com\/blog\/category\/mysql\/#listItem","name":"MySQL"}},{"@type":"ListItem","@id":"https:\/\/www.migrate2cloud.com\/blog\/category\/mysql\/#listItem","position":2,"name":"MySQL","item":"https:\/\/www.migrate2cloud.com\/blog\/category\/mysql\/","nextItem":{"@type":"ListItem","@id":"https:\/\/www.migrate2cloud.com\/blog\/mysql-optimization\/#listItem","name":"MySQL Optimization"},"previousItem":{"@type":"ListItem","@id":"https:\/\/www.migrate2cloud.com\/blog#listItem","name":"Home"}},{"@type":"ListItem","@id":"https:\/\/www.migrate2cloud.com\/blog\/mysql-optimization\/#listItem","position":3,"name":"MySQL Optimization","previousItem":{"@type":"ListItem","@id":"https:\/\/www.migrate2cloud.com\/blog\/category\/mysql\/#listItem","name":"MySQL"}}]},{"@type":"Organization","@id":"https:\/\/www.migrate2cloud.com\/blog\/#organization","name":"Migrate to Cloud","description":"we make the clouds rain","url":"https:\/\/www.migrate2cloud.com\/blog\/"},{"@type":"Person","@id":"https:\/\/www.migrate2cloud.com\/blog\/author\/admin\/#author","url":"https:\/\/www.migrate2cloud.com\/blog\/author\/admin\/","name":"DevOps Team","image":{"@type":"ImageObject","@id":"https:\/\/www.migrate2cloud.com\/blog\/mysql-optimization\/#authorImage","url":"https:\/\/secure.gravatar.com\/avatar\/20b51e018d8f61e1739f60911fcf45cc9d09284569e448583a87f7fd0ac3d9dc?s=96&d=mm&r=g","width":96,"height":96,"caption":"DevOps Team"}},{"@type":"WebPage","@id":"https:\/\/www.migrate2cloud.com\/blog\/mysql-optimization\/#webpage","url":"https:\/\/www.migrate2cloud.com\/blog\/mysql-optimization\/","name":"MySQL Optimization - Migrate to Cloud","description":"Database optimization is the process of configuring database to use system resource efficiently and perform tasks quickly.","inLanguage":"en-US","isPartOf":{"@id":"https:\/\/www.migrate2cloud.com\/blog\/#website"},"breadcrumb":{"@id":"https:\/\/www.migrate2cloud.com\/blog\/mysql-optimization\/#breadcrumblist"},"author":{"@id":"https:\/\/www.migrate2cloud.com\/blog\/author\/admin\/#author"},"creator":{"@id":"https:\/\/www.migrate2cloud.com\/blog\/author\/admin\/#author"},"datePublished":"2010-12-10T00:28:25-05:00","dateModified":"2016-03-21T02:49:51-05:00"},{"@type":"WebSite","@id":"https:\/\/www.migrate2cloud.com\/blog\/#website","url":"https:\/\/www.migrate2cloud.com\/blog\/","name":"Migrate to Cloud","description":"we make the clouds rain","inLanguage":"en-US","publisher":{"@id":"https:\/\/www.migrate2cloud.com\/blog\/#organization"}}]},"og:locale":"en_US","og:site_name":"Migrate to Cloud - we make the clouds rain","og:type":"article","og:title":"MySQL Optimization - Migrate to Cloud","og:description":"Database optimization is the process of configuring database to use system resource efficiently and perform tasks quickly.","og:url":"https:\/\/www.migrate2cloud.com\/blog\/mysql-optimization\/","article:published_time":"2010-12-10T05:28:25+00:00","article:modified_time":"2016-03-21T07:49:51+00:00","twitter:card":"summary_large_image","twitter:title":"MySQL Optimization - Migrate to Cloud","twitter:description":"Database optimization is the process of configuring database to use system resource efficiently and perform tasks quickly."},"aioseo_meta_data":{"post_id":"819","title":"","description":"Database optimization is the process of configuring database to use system resource efficiently and perform tasks quickly.","keywords":[{"label":"MySQL Optimization","value":"MySQL Optimization"},{"label":"MySQL Server","value":"MySQL Server"},{"label":"query cache type","value":"query cache type"},{"label":"Disk Optimization","value":"Disk Optimization"}],"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":"default","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,"local_seo":null,"limit_modified_date":false,"created":"2022-12-27 09:16:42","updated":"2026-07-21 15:28:32","ai":null,"breadcrumb_settings":null,"seo_analyzer_scan_date":null},"aioseo_breadcrumb":"<div class=\"aioseo-breadcrumbs\"><span class=\"aioseo-breadcrumb\">\n\t\t\t<a href=\"https:\/\/www.migrate2cloud.com\/blog\" title=\"Home\">Home<\/a>\n\t\t<\/span><span class=\"aioseo-breadcrumb-separator\">&raquo;<\/span><span class=\"aioseo-breadcrumb\">\n\t\t\t<a href=\"https:\/\/www.migrate2cloud.com\/blog\/category\/mysql\/\" title=\"MySQL\">MySQL<\/a>\n\t\t<\/span><span class=\"aioseo-breadcrumb-separator\">&raquo;<\/span><span class=\"aioseo-breadcrumb\">\n\t\t\tMySQL Optimization\n\t\t<\/span><\/div>","aioseo_breadcrumb_json":[{"label":"Home","link":"https:\/\/www.migrate2cloud.com\/blog"},{"label":"MySQL","link":"https:\/\/www.migrate2cloud.com\/blog\/category\/mysql\/"},{"label":"MySQL Optimization","link":"https:\/\/www.migrate2cloud.com\/blog\/mysql-optimization\/"}],"jetpack_featured_media_url":"","jetpack-related-posts":[],"jetpack_sharing_enabled":true,"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/www.migrate2cloud.com\/blog\/wp-json\/wp\/v2\/posts\/819","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.migrate2cloud.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.migrate2cloud.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.migrate2cloud.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.migrate2cloud.com\/blog\/wp-json\/wp\/v2\/comments?post=819"}],"version-history":[{"count":21,"href":"https:\/\/www.migrate2cloud.com\/blog\/wp-json\/wp\/v2\/posts\/819\/revisions"}],"predecessor-version":[{"id":2156,"href":"https:\/\/www.migrate2cloud.com\/blog\/wp-json\/wp\/v2\/posts\/819\/revisions\/2156"}],"wp:attachment":[{"href":"https:\/\/www.migrate2cloud.com\/blog\/wp-json\/wp\/v2\/media?parent=819"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.migrate2cloud.com\/blog\/wp-json\/wp\/v2\/categories?post=819"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.migrate2cloud.com\/blog\/wp-json\/wp\/v2\/tags?post=819"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}