Hello, After upgrating mysql 4.0.7 to 4.0.18/FreeBSD 4.6.2, the mysqld restarts each time it receives a remote connect from another client machine. Here is what is written into the log:
040415 08:51:00 mysqld started 040415 8:51:00 Warning: setrlimit returned ok, but didn't change limits. Max open files is 22154 (request: 25010) 040415 8:51:00 Warning: Changed limits: max_connections: 5000 table_cache: 8572 040415 8:51:01 InnoDB: Started /usr/local/mysql40/libexec/mysqld: ready for connections. Version: '4.0.18-log' socket: '/tmp/mysql4.sock' port: 3310 Number of processes running now: 0 040415 08:51:15 mysqld restarted 040415 8:51:15 Warning: setrlimit returned ok, but didn't change limits. Max open files is 22154 (request: 25010) What the client gets is the error ERROR 2013: Lost connection to MySQL server during query Connections from the same server, both using unix socket or tcp port, get through without any problems. The mysql 4.0.18 was compiled from ports with the linuxthreads option. 4.0.7 is working fine on the same machine. Any help will be greatly apprecialted. Thanks ---- Alexander Varshavchick, Metrocom Joint Stock Company Phone: (812)118-3322, 118-3115(fax) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]