加载 innoDB 数据库主页时 phpMyAdmin 非常慢
我遇到的问题:
我从 phpMyAdmin 中加载了我的一个 innoDB 数据库的数据库页面，但加载速度非常慢.我们正在谈论最多 5 分钟的加载时间.这仅发生在 MAIN 页面上，这意味着当您查看数据库时，显示所有表的左侧边栏会出现.
I load the database page for one of my innoDB databases from within phpMyAdmin and it loads EXTREMELY slow. We're talking like up to 5 minutes of load time. This only happens on the MAIN page, meaning, when you view the database and the left sidebar that shows all the tables shows up.
在初始加载时间之后，每个单独的表都可以点击并几乎立即加载.但是这些表是在 iframe 中加载的，而无需重新加载数据库表的左侧边栏，这就是它们加载如此之快的原因.
After that initial load time, each individual table can be clicked on and load almost immediately. But those tables are loaded in an iframe without reloading the left sidebar of database tables which is why they load so quickly.
在初始加载时间之后，每个单独的表都可以立即在新选项卡/窗口中打开，但这样做不包括数据库表的左侧边栏，我确信这就是它们加载如此之快的原因.
After that initial load time, each individual table can be opened in a new tab/window immediately, but doing it that way does not include the left sidebar of database tables, which I am sure is the reason they load so quickly.
我期望发生的事情:
我希望能够从 phpMyAdmin 中加载我的 innoDB 数据库的主页，而无需花费 5 分钟来加载.
I expect to be able to load the main page of my innoDB database from within phpMyAdmin without it taking 5 minutes to load.
我的尝试:
这个问题我已经有几个月了，它每天都让我发疯.事实上，我已经接受了它.我只是每天立即加载那个初始页面，然后去做其他事情，这样我就不必看它了，因为它只会让我生气.
I've had this issue for months and it drives me crazy every day. I've come to live with it actually. I simply load that initial page immediately every day, and go do something else so i don't have to watch it, because it just makes me angry.
我将超时设置为大约 15 分钟，所以如果我认为它超过 10 分钟，我将在不同的选项卡中打开显示localhost"的位置，这会将我带到登录屏幕，重新登录，然后它带我进入数据库列表，该列表加载速度很快.这是因为如果我只是加载该主页，然后登录，它会将我带回该索引页面，我将再等待 5 分钟以加载它.咕噜..
I have my timeout set to about 15 minutes, so if I think its been longer than 10 minutes, I will open where it says "localhost" in a different tab, which brings me to the login screen, log back in, and then it brings me to the list of databases, which loads quickly. This is because if I simply load that main page, then log in, it will bring me back to that index page and i'll wait another 5 minutes for it to load. Grr..
好吧，我在谷歌上搜索并搜索了很多关于使 innoDB 不进行行计数之类的建议.我已经尝试了所有这些.什么都不起作用！:(
OK so, I Googled and Googled and found tons of suggestions about making innoDB not do row counts and stuff like that. I've tried all of them. Nothing is working! :(
我发现了一个叫做$cfg['Server']['IgnoreSomeISrows'] = true;"的东西这没有任何帮助.我什至不知道它做了什么，但它不起作用，所以我删除了它，但我忘记删除那部分，所以我只是把它留在那里.不，将其注释掉也无济于事，谢谢.
I found something called "$cfg['Server']['IgnoreSomeISrows'] = true;" which did not help whatsoever. I don't even know what it did, but it didn't work, so I removed it, but I forgot to remove that part and so I just left it there. No, commenting it out does not help either thank you.
一些版本信息:
操作系统
CentOS release 6.5 (Final)
数据库:
Server: Localhost via UNIX socket
Software: MySQL
Software version: 5.1.71-log - Source distribution
Protocol version: 10
网络服务器
Apache/2.2.15 (CentOS)
Database client version: libmysql - 5.1.71
PHP extension: mysqli Documentation
phpMyAdmin
Version information: 3.5.8.2, latest stable version: 4.1.5
推荐答案
就个人而言，当我在查看"表中查看时，使用 phpmyadmin 的速度也非常慢.我所做的是将phpmyadmin升级到最新版本，然后我的问题就解决了.也许你可以试试 phpymadmin v4
Personally I also experience extremely slow with phpmyadmin, when I view in "View" Table. What I did is upgrade the phpmyadmin to the latest version, then my problem is solved. Maybe u can give a try for phpymadmin v4
相关文章