[Phpmyadmin-devel] 20 seconds lost in header_meta_style.inc.php
Marc.Delisle at cegepsherbrooke.qc.ca
Thu Apr 13 10:29:05 CEST 2006
Marc Delisle a écrit :
> Garvin Hicking a écrit :
>> Hi Marc!
>>> ok, using this require_once './libraries/header_http.inc.php';
>>> $time_before =
>>> microtime(true); require_once './libraries/header_meta_style.inc.php';
>>> $time_after = microtime(true);
>>> echo $time_after - $time_before;
>>> I only get .0006 seconds. No significant differences when OBgzip is true
>>> or false. But still 20 seconds on my watch.
>> Okay, basically what I thought it would yield.
>>> Web server A (Apache 1.3.34) is on a different machine than MySQL server
>>> B (MySQL 5.1.7, with 4400 dbs). When connecting Web server A to MySQL
>>> server C (MySQL 5.0.18, 100 dbs) there is almost no delay. I'm using
>> I do think that the time delay you experience comes from the server table
>>> So, something else is eating time but it's difficult to find using
>>> conventional tracing. I guess I'll have to use a debugger.
>> Absolutely, yes. I'd suggest using the XDebug2 Profiler, I think I
>> you'Ve worked with that before?
> Yes, to find that blowfish.php was eating many cycles, this is when we
> added mcrypt support. I don't have a machine nearby for this, it'll have
> to wait.
With $cfg['ShowStats'] set to false, I save about 5 seconds. So we are
probably really waiting for the MySQL server to count records or
retrieve something from information_schema.
More information about the Developers