phpMyAdmin and big tables

phpmyadmin

Solution

Paste these lines into the bottom of your config.inc.php file within your phpMyAdmin installation:

//http://future500.nl/phpmyadmin-slow-on-startup/:
$cfg['MaxExactCountViews'] = 0;//disable trying to count the number of rows in any view
$cfg['MaxExactCount'] = 0;//disable correcting the InnoDB estimates

Thank you to future500.nl!

I wish I'd found this fix hours earlier, before I accidentally deleted all my data. :-(

Problem

Trying to access to database with big tables (at least 15 tables in this database not less then 1 million, maximum - 20 million). Once I select database - phpMyAdmin loading at least 5 minutes (and more). How can I speed-up load of page with tables?

Original source