{"id":2395,"date":"2021-05-21T11:08:12","date_gmt":"2021-05-21T15:08:12","guid":{"rendered":"https:\/\/ekozel.com\/?p=2395"},"modified":"2021-05-21T11:08:34","modified_gmt":"2021-05-21T15:08:34","slug":"phpmyadmin-slow-in-loading-table-list","status":"publish","type":"post","link":"https:\/\/ekozel.com\/2021\/05\/21\/phpmyadmin-slow-in-loading-table-list\/","title":{"rendered":"PHPMyAdmin slow in loading table list"},"content":{"rendered":"\n<p>When you have innoDB tables with many rows, InnoDB does not store the number of rows in a table but MyISAM does. <\/p>\n\n\n\n<p>So for each InnoDB table PHPMyAdmin invokes\u00a0<code>SELECT count(*) FROM<\/code>\u00a0query which is very slow if number of rows is very high. To resolve this you should edit\u00a0<code>config.inc.php<\/code>\u00a0file and set\u00a0<code>$cfg['MaxExactCount']<\/code>. This will invoke\u00a0<code>count(*)<\/code>\u00a0sql for tables that has less\u00a0<code>MaxExactCount<\/code>\u00a0rows.<\/p>\n\n\n\n<p>Open \\config.inc.php file and add these two lines of code in it:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>$cfg&#91;'MaxExactCount'] = 0;\n$cfg&#91;'MaxExactCountViews'] = 0;<\/code><\/pre>\n\n\n\n<p>Resource: <a href=\"https:\/\/stackoverflow.com\/questions\/14027351\/phpmyadmin-opens-mysql-table-lists-very-slowly\/53140805\">https:\/\/stackoverflow.com\/questions\/14027351\/phpmyadmin-opens-mysql-table-lists-very-slowly\/53140805<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>When you have innoDB tables with many rows, InnoDB does not store the number of rows in a table but MyISAM does. So for each InnoDB table PHPMyAdmin invokes\u00a0SELECT count(*) FROM\u00a0query which is very slow if number of rows is very high. To resolve this you should edit\u00a0config.inc.php\u00a0file and set\u00a0$cfg[&#8216;MaxExactCount&#8217;]. This will invoke\u00a0count(*)\u00a0sql for tables [&hellip;]<\/p>\n","protected":false},"author":3,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[1],"tags":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v21.8.1 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>PHPMyAdmin slow in loading table list - Ewout Alexander Kozel<\/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:\/\/ekozel.com\/2021\/05\/21\/phpmyadmin-slow-in-loading-table-list\/\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"kozel\" \/>\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:\/\/ekozel.com\/2021\/05\/21\/phpmyadmin-slow-in-loading-table-list\/\",\"url\":\"https:\/\/ekozel.com\/2021\/05\/21\/phpmyadmin-slow-in-loading-table-list\/\",\"name\":\"PHPMyAdmin slow in loading table list - Ewout Alexander Kozel\",\"isPartOf\":{\"@id\":\"https:\/\/ekozel.com\/#website\"},\"datePublished\":\"2021-05-21T15:08:12+00:00\",\"dateModified\":\"2021-05-21T15:08:34+00:00\",\"author\":{\"@id\":\"https:\/\/ekozel.com\/#\/schema\/person\/6a1492e8788678b531eefdd0ac4661cf\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/ekozel.com\/2021\/05\/21\/phpmyadmin-slow-in-loading-table-list\/\"]}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/ekozel.com\/#website\",\"url\":\"https:\/\/ekozel.com\/\",\"name\":\"Ewout Alexander Kozel\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/ekozel.com\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/ekozel.com\/#\/schema\/person\/6a1492e8788678b531eefdd0ac4661cf\",\"name\":\"kozel\",\"sameAs\":[\"https:\/\/kozel.wpengine.com\"],\"url\":\"https:\/\/ekozel.com\/author\/kozel\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"PHPMyAdmin slow in loading table list - Ewout Alexander Kozel","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:\/\/ekozel.com\/2021\/05\/21\/phpmyadmin-slow-in-loading-table-list\/","twitter_misc":{"Written by":"kozel","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/ekozel.com\/2021\/05\/21\/phpmyadmin-slow-in-loading-table-list\/","url":"https:\/\/ekozel.com\/2021\/05\/21\/phpmyadmin-slow-in-loading-table-list\/","name":"PHPMyAdmin slow in loading table list - Ewout Alexander Kozel","isPartOf":{"@id":"https:\/\/ekozel.com\/#website"},"datePublished":"2021-05-21T15:08:12+00:00","dateModified":"2021-05-21T15:08:34+00:00","author":{"@id":"https:\/\/ekozel.com\/#\/schema\/person\/6a1492e8788678b531eefdd0ac4661cf"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/ekozel.com\/2021\/05\/21\/phpmyadmin-slow-in-loading-table-list\/"]}]},{"@type":"WebSite","@id":"https:\/\/ekozel.com\/#website","url":"https:\/\/ekozel.com\/","name":"Ewout Alexander Kozel","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/ekozel.com\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/ekozel.com\/#\/schema\/person\/6a1492e8788678b531eefdd0ac4661cf","name":"kozel","sameAs":["https:\/\/kozel.wpengine.com"],"url":"https:\/\/ekozel.com\/author\/kozel\/"}]}},"jetpack_sharing_enabled":true,"jetpack_featured_media_url":"","_links":{"self":[{"href":"https:\/\/ekozel.com\/wp-json\/wp\/v2\/posts\/2395"}],"collection":[{"href":"https:\/\/ekozel.com\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/ekozel.com\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/ekozel.com\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/ekozel.com\/wp-json\/wp\/v2\/comments?post=2395"}],"version-history":[{"count":0,"href":"https:\/\/ekozel.com\/wp-json\/wp\/v2\/posts\/2395\/revisions"}],"wp:attachment":[{"href":"https:\/\/ekozel.com\/wp-json\/wp\/v2\/media?parent=2395"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/ekozel.com\/wp-json\/wp\/v2\/categories?post=2395"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/ekozel.com\/wp-json\/wp\/v2\/tags?post=2395"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}