phpMyAdmin run very slowly and use too many CPU

Asked Mar 21 '15 at 19:02

Active Mar 22 '15 at 11:32

Viewed 542 times

I am using phpMyAdmin, it run very slowly. For everything I do, I see loading dialogs in about 5-10 seconds. When I use phpMyAdmin, Apache use around 60% CPU.

When phpMyAdmin do something, Apache for one second changes ports to 55617 and 55618.

In my apps communication with database is not slow as in phpMyAdmin and Apache use CPU under 10% of.

Why?

EDIT: SOLVED. I remembered when it started and i think it started when i enable XDebug. I set xdebug.profiler_enable = 0 and it works good.

Enabling XDebug in XAMPP slows down phpmyadmin

edited May 23 '17 at 12:22

Community

asked Mar 21 '15 at 19:02

Misaz

3,694
2
26
42

SHOW PROCESSLIST -- what queries are you running? – Rick James Mar 21 '15 at 22:34
screenshot: [link](http://misaz.moxo.cz/sended/phpmyadmin_slow.png) – Misaz Mar 21 '15 at 23:12
Hmmm... Can't see to get the link to work. – Rick James Mar 22 '15 at 01:57
On screenshot are two proceses. One by user pma and second by root. pma run command sleep on host http://localhost:69148 and root run Query on host http://localhost:69149. Info for root´s proces is 'SHOW PROCESSLIST'. – Misaz Mar 22 '15 at 09:46

phpMyAdmin run very slowly and use too many CPU

0 Answers0