Re: [Phplib-users] MySql losing connection

[Chris J. <ch...@ch...>]

This does not appear to be a PHPLIB / DB class problem.  It's far more
likely to be a network, MySQL server host machine or MySQL problem.

I run PHPLIB and MySQL in a production environment (and have for 3 years)
and never see this error unless I do something like unplug the Ethernet
connection.

..chris


----- Original Message -----
From: "Leandro Nery" <lea...@ho...>

I am using Db_Sql class of Phplib-7.4-pre1 with MySQL 3.23.34a for an
application in php and "very often" when I am executing a query like this:

$db->query("SELECT id,subject FROM A.table ORDER BY mdate DESC LIMIT 10");

Then I get this error:

MySQL Error: 2013 (Lost connection to MySQL server during query)

The table has about 4000 rows and field sizes not so big too.

I don't have the exactly idea if this is a problem with the DB class or
MySql. I had used this DB for other applications without phplib classes
before and I never had this problem, maybe just coincidence, I HOPE SO, ..
Someone here have any idea of what it can be. I am almost praying :)

... [snip] ...