php.net |  support |  documentation |  report a bug |  advanced search |  search howto |  statistics |  random bug |  login
Bug #47998 Queries like 'show keys from *' take a while to complete with mysqlnd
Submitted: 2009-04-17 01:30 UTC Modified: 2009-04-25 01:00 UTC
From: valderama at gmail dot com Assigned:
Status: No Feedback Package: MySQL related
PHP Version: 5.3.0RC1 OS: Mac OS X Tiger
Private report: No CVE-ID: None
Have you experienced this issue?
Rate the importance of this bug to you:

 [2009-04-17 01:30 UTC] valderama at gmail dot com
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.

Patches

Add a Patch

Pull Requests

Add a Pull Request

History

AllCommentsChangesGit/SVN commitsRelated reports
 [2009-04-17 10:47 UTC] jani@php.net
And your configure line was..?
 [2009-04-25 01:00 UTC] php-bugs at lists dot php dot net
No feedback was provided for this bug for over a week, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".
 
PHP Copyright © 2001-2024 The PHP Group
All rights reserved.
Last updated: Fri Mar 29 09:01:28 2024 UTC