Plesk 12.5.30 and phpMyAdmin slowness

[pegasx]

Hello,

Since Plesk 12, phpMyAdmin is really slow. There is no load on server and there are a few databases. Does somebody have same problem?

Thanks.

 

[abdi]

Hi Pegasx,

What are the specs of your server + is it a VPS or Dedicated?

 

[pegasx]

It is dedicated and it has Xeon(R) CPU E5620 @ 2.40GHz (16 core(s)) and 24 gb ram, runs Centos 6.7.

I think there is a problem on phpMyAdmin. Query has finished in 0.0003 seconds but phpMyAdmin shows the result in 3 seconds.

 

[IgorG]

Any related error messages in /var/log/sw-cp-server/error_log ?

 

[abdi]

Sometimes there could be a single table with millions or records, this also can cause PhpMyAdmin to become extremely slow while loading it ..

 

[pegasx]

There is no related error message in /var/log/sw-cp-server/error_log. There are some tables with millions, but I do not view them, or query on them in phpMyAdmin.

 

[abdi]

Hi Pegasx,

Can this help: http://stackoverflow.com/questions/10811405/phpmyadmin-and-big-tables

 

[pegasx]

I have read this page, but there is no config.inc.php, there is one config.sample.inc.php but I don't know if it is related. So where is the configuration file of phpMyAdmin?