Hi, my name is Unfaiir, not because I'm an Unfaiir person, but because that's my name. This is my first question ever on a Stack Exchange site and I wonder if its even worthy, but I'm asking anyway! Haters beware, I will hate back! Lovers, I love you too :)
Oh and don't give annoying replies like, "you spelled (such and such) wrong, or... why don't you just not use "MySQL" or "phpMyAdmin"... that's just lame and it just makes you look like you have no idea what the answer is but still want to seem smart so you reply with useless information completely ignoring the actual question... but guess what... you achieve the opposite results.. you look dumb.. anyway... I'm going to post this question despite all the hate I've seen and hope for the best! Give me love fellow nerds!
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.
So now you have some idea of the bane of my existence. Will you help me or will you mock my suffering? I hope you will help! :)
Some Version Info:
CentOS release 6.5 (Final)
Server: Localhost via UNIX socket
Software version: 5.1.71-log - Source distribution
Protocol version: 10
Database client version: libmysql - 5.1.71
PHP extension: mysqli Documentation
Version information: 184.108.40.206, latest stable version: 4.1.5