On Sat, 2004-08-07 at 14:07 +0100, Hubertus Haniel wrote:
Had sam problem but so far I have tracked it back to a corrupted table from a crash last week - I am currently restoring the table from a previous dump. Do a mysqlcheck -A to check the tables to make sure all your tables are ok.
thanks for the idea! But according to mysqlcheck, all tables were ok. So there are still many many little zombies (even after another reboot): 7310 pts/8 Z 0:00 \_ [mysqld] <defunct> 7316 pts/8 Z 0:00 \_ [mysqld] <defunct> 7317 pts/8 Z 0:00 \_ [mysqld] <defunct> 7320 pts/8 Z 0:00 \_ [mysqld] <defunct> 7321 pts/8 Z 0:00 \_ [mysqld] <defunct> [...] regards, Olivier PS: it's a suse 9.0-based system, mysql 4.0.18. currently installing 4.0.20 to see if it may help