phpMyAdmin的速度极慢时加载InnoDB数据库的主页 [英] phpMyAdmin EXTREMELY slow when loading innoDB database main page
问题描述
我的问题，我有：的
我从内部的phpMyAdmin加载我的InnoDB数据库的一个数据库页面，它加载非常缓慢。我们谈论像长达5分钟的加载时间。这只是发生在主页上，这意味着，当您查看数据库和左侧栏，显示所有的表显示出来。
这是初始加载时间之后，每个表可以点击，几乎立即加载。但这些表是装在一个iframe无需重新加载数据库表的左侧边栏这就是为什么他们加载这么快。
这是初始加载时间之后，每个表可以在新标签/立即窗口中打开，但这样做这样的说法并不包括数据库表，我敢肯定的左侧边栏是他们如此快速加载的原因。
我的期望是发生：的
我希望能够从内部的phpMyAdmin载入我的InnoDB数据库的主要页面，而它用5分钟的加载。
我已经试过：的
我有这个问题了几个月，它的疯狂，每天催着我。我来的实际生活吧。我只是每天都立即加载初始页面，去做些别的事情，所以我不必看它，因为它只是让我很生气。
我有我的超时设置为15分钟左右，所以如果我认为它已经超过10分钟，我会打开它在不同的标签，这使我的登录屏幕说：本地主机，重新登录，然后它带给我的数据库列表，从而快速载入。这是因为如果我只是加载主页，然后登录，它会带给我回到那个索引页，我会再等5分钟，它加载。 GRR ..
行，所以，我用Google搜索和Google搜索，发现吨的意见有关使InnoDB的不行行数之类的东西。我已经试过所有的人。没有什么工作！ （
我发现了一种叫$ CFG桩[服务器] ['IgnoreSomeISrows'] =真;这没有任何帮助。我甚至不知道这是什么做的，但它没有工作，所以我删除它，但我忘了删除的部分，所以我刚刚离开它。不，注释掉它也没有帮助谢谢你。
一些版本信息：的
OS
CentOS版本6.5（决赛）
数据库：
服务器：通过UNIX套接字本地主机
软件：MySQL的
软件版本：71年1月5日日志 - 源代码分发
协议版本：10
Web服务器
的Apache / 2.2.15（CentOS的）
数据库客户端版本的libmysql - 71年1月5日
PHP扩展：文档的mysqli
的phpMyAdmin
版本信息：3.5.8.2，最新的稳定版本：4.1.5
我个人也经历极其缓慢与phpMyAdmin，当我在查看表视图。我所做的是升级的phpMyAdmin到最新版本，那么我的问题就解决了。也许ü可以给phpymadmin V4一试
My Problem I am Having:
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.
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.
What I Expect To Be Happening:
I expect to be able to load the main page of my innoDB database from within phpMyAdmin without it taking 5 minutes to load.
What I've tried:
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.
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..
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! :(
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.
Some Version Info:
OS
CentOS release 6.5 (Final)
Database:
Server: Localhost via UNIX socket
Software: MySQL
Software version: 5.1.71-log - Source distribution
Protocol version: 10
Web Server
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
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
这篇关于phpMyAdmin的速度极慢时加载InnoDB数据库的主页的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
