Re: Lost connection to MySQL server during query

2009-09-09 Thread Claudio Nanni
Can you provide more details? network layout, type of client/app used, connectors,etc,etc? Thanks Claudio 2009/9/9 stutiredboy stutired...@gmail.com hi,all: we met a problem that: * Lost connection to MySQL server during query SHOW TABLE STATUS WHERE ENGINE='MyISAM' *sometimes it works

Re: Lost connection to MySQL server during query

2009-09-09 Thread Claudio Nanni
Since it is very unlikely that you lose connection on the socket file, I guess you are using a PHP app, that uses the mysql driver and the problem must be in the driver. I would not look at mysql but at the PHP and PHP2MYSQL layer, mainly at the later one. Try different PHP (and driver) versions.

Re: Lost connection to MySQL server during query

2009-09-09 Thread stutiredboy
the application program and mysql server are in the same host and i have add skip-name-resolv to the my.cnf and extend the max_allowed_packet from 16M to 32M our application connected to mysql server from mysql.sock before the query which cause lost connection to MySQLserver.. we only ran some

Upgrading from 5.0.32 via a replication chain and bug 24432

2009-09-09 Thread David Harrison
Hi all, I've got a quite large database (23G) that is running on a 5.0.32 version of MySQL. I really want to upgrade out of 5.0.32 to the latest version of 5.1 (or even 5.4) but a straight mysql_upgrade of the database takes long enough that I'd have serious down-time issues (last time I

Re: Upgrading from 5.0.32 via a replication chain and bug 24432

2009-09-09 Thread Per Jessen
David Harrison wrote: Hi all, I've got a quite large database (23G) that is running on a 5.0.32 version of MySQL. I really want to upgrade out of 5.0.32 to the latest version of 5.1 (or even 5.4) but a straight mysql_upgrade of the database takes long enough that I'd have serious

ANN: AnySQL Maestro 9.8 released

2009-09-09 Thread SQL Maestro Team
Hi! SQL Maestro Group announces the release of AnySQL Maestro 9.8, a powerful tool for managing any database engine accessible via ODBC driver or OLE DB provider (MySQL, SQL Server, Oracle, Access, etc). The new version is immediately available at