PHPmyadmin in Plesk really slow

[D.D]

Today a customer (old admin my company) call me and tells me PHPmyadmin is really slow above 1 minute for view a db table in Plesk.



After investigation next result:
* load is not high
* rest server is not slow
* Plesk interface is working fast
* memory is not full
* io is ok
* restart httpd and nginx no result
* restart psa no result

 

[D.D]

New installed phpmyadmin on a test site is working without problems, it looks only phpmyadmin in plesk is slow!

 

[D.D]

After contact with Plesk support they say:

The loading time of phpMyAdmin depends on the number of the sites and you have about 1000 sites.

I don't understand why phpMyadmin in Plesk is so slow because the server has enough resources and only phpMyadmin is slow. If I install my own phpMyadmin and I login with root account it's not slow so I think this is a problem in Plesk phpMyadmin version.

Anybody same problem or solution?

 

[Excelentic]

Yes, we have the same problem with Plesk 11.0.9 #53 using Centos 6.3. We applied this change in Table.class.php:

static public function isView($db = null, $table = null)
{
if (empty($db) || empty($table)) {
return false;
}

// use cached data or load information with SHOW command
if (isset(PMA_Table::$cache[$db][$table]) || $GLOBALS['cfg']['Server']['DisableIS']) {
$type = PMA_Table::sGetStatusInfo($db, $table, 'TABLE_TYPE');
return $type == 'VIEW';
}

// query information_schema
//$result = PMA_DBI_fetch_result(
// "SELECT TABLE_NAME
// FROM information_schema.VIEWS
// WHERE TABLE_SCHEMA = '" . PMA_sqlAddSlashes($db) . "'
// AND TABLE_NAME = '" . PMA_sqlAddSlashes($table) . "'");
//return $result ? true : false;
return false;
}

and the issue seems to have disappeared.

I hope this will help you.