#47998 [NEW]: Queries like 'show keys from *' take a while to complete with mysqlnd

From: valderama at gmail dot com Operating system: Mac OS X Tiger PHP version: 5.3.0RC1 PHP Bug Type: Performance problem Bug description: Queries like 'show keys from *' take a while to complete with mysqlnd Description: ------------ When using PHP 5.3 with Typo3 4.2.3, queries like 00912 $keyRes = mysql_query('SHOW keys FROM '.$tableName, $this->link); takes a while to complete. More than 3-5 seconds. I'm using the mysqlnd driver in Mac OS X Tiger with Apache 1.3.41 Reproduce code: --------------- Use Typo3, and load an extension in the CMS Backend. While this does run smoothly with PHP < 5.3, there is clearly a problem with my PHP version. Even more: mtop show the related MySQL queries for a while (>1 second), even if it takes less than 0.1 seconds to complete in mysql client (or else). Expected result: ---------------- Queries completed in less than 0.1 seconds Actual result: -------------- More than 3 seconds to complete, with strange behaviors such as connection dropped or else. -- Edit bug report at http://bugs.php.net/?id=47998&edit=1 -- Try a CVS snapshot (PHP 5.2): http://bugs.php.net/fix.php?id=47998&r=trysnapshot52 Try a CVS snapshot (PHP 5.3): http://bugs.php.net/fix.php?id=47998&r=trysnapshot53 Try a CVS snapshot (PHP 6.0): http://bugs.php.net/fix.php?id=47998&r=trysnapshot60 Fixed in CVS: http://bugs.php.net/fix.php?id=47998&r=fixedcvs Fixed in CVS and need be documented: http://bugs.php.net/fix.php?id=47998&r=needdocs Fixed in release: http://bugs.php.net/fix.php?id=47998&r=alreadyfixed Need backtrace: http://bugs.php.net/fix.php?id=47998&r=needtrace Need Reproduce Script: http://bugs.php.net/fix.php?id=47998&r=needscript Try newer version: http://bugs.php.net/fix.php?id=47998&r=oldversion Not developer issue: http://bugs.php.net/fix.php?id=47998&r=support Expected behavior: http://bugs.php.net/fix.php?id=47998&r=notwrong Not enough info: http://bugs.php.net/fix.php?id=47998&r=notenoughinfo Submitted twice: http://bugs.php.net/fix.php?id=47998&r=submittedtwice register_globals: http://bugs.php.net/fix.php?id=47998&r=globals PHP 4 support discontinued: http://bugs.php.net/fix.php?id=47998&r=php4 Daylight Savings: http://bugs.php.net/fix.php?id=47998&r=dst IIS Stability: http://bugs.php.net/fix.php?id=47998&r=isapi Install GNU Sed: http://bugs.php.net/fix.php?id=47998&r=gnused Floating point limitations: http://bugs.php.net/fix.php?id=47998&r=float No Zend Extensions: http://bugs.php.net/fix.php?id=47998&r=nozend MySQL Configuration Error: http://bugs.php.net/fix.php?id=47998&r=mysqlcfg