Re: slow mysql queries via php5-mysql

Marcin Debowski wrote:

On 2009-07-30, Chris <dmagick@gmail.com> wrote:

Marcin Debowski wrote:

Yes, but I daubt phpmyadmin is the culprit - a dedicated web interface I have written for the database has exactly the same problem. This interface works fast under the old version of php-/mysql and slow under the new one. The php code is the same.

Can you run it on the same server as a test? That will rule out whether it's network related at least.

Mysql and apache are on the same physical server but it connects via 127.0.0.1.

So it's not network related, I thought they may have been different physical machines.

Or do you have a cli script you can run to do the same thing?

I just tried to connect via the socket and I am not sure if this helped - seems slightly better but this could be sheer effect of the different connection route. I will try to run some more quantitative tests.

That suggestion was to see if cutting phpmyadmin out of the picture made a difference rather than testing the network theory. Plus, mysql_query buffers the results before sending them back to the client - which means mysql loads 50,000 records in to memory, then sends it to php. Are there any differences in (say) memory_limit settings for the two php setups, or any of the mysql specific settings in php.ini ? If you use an unbuffered query, does it make a difference (http://www.php.net/manual/en/function.mysql-unbuffered-query.php) ? -- Postgresql & php tutorials http://www.designmagick.com/