phpmyadmin非常缓慢地打开MySQL表列表 [英] phpmyadmin opens MySQL table lists very slowly

问题描述

我可以登录phpmyadmin并快速查看数据库.一旦我单击其中之一并尝试查看表格列表，它的运行速度将非常慢.有什么我想念的吗?从Ubuntu 10.04升级到Ubuntu 12.04之前，我没有这种情况.

I can log into phpmyadmin and see databases very quickly. Once I click on one of them and try to see the tables list it's very slow. Is there anything I'm missing? I didn't have this situation before updating from Ubuntu 10.04 to Ubuntu 12.04.

推荐答案

打开\ config.inc.php文件，并在其中添加以下两行代码:

Open \config.inc.php file and add these two lines of code in it:

$cfg['MaxExactCount'] = 0;
$cfg['MaxExactCountViews'] = 0;

当然，如果您在数据库中没有任何视图，则可以跳过第二行.

And of course you can skip second line if you have not any views at the database.

这篇关于phpmyadmin非常缓慢地打开MySQL表列表的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！