php.net |  support |  documentation |  report a bug |  advanced search |  search howto |  statistics |  random bug |  login

go to bug id or search bugs for

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
View Developer Edit
Welcome back! If you're the original bug submitter, here's where you can edit the bug or add additional notes.
If you forgot your password, you can retrieve your password here.
Password:
Status:
Package:
Bug Type:
Summary:
From: valderama at gmail dot com
New email:
PHP Version: OS:

 

 [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

Pull Requests

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-2025 The PHP Group
All rights reserved. 		Last updated: Fri Feb 14 22:01:29 2025 UTC