Folks, I'm experiencing some strange behavior with our mysql server and I'm curious to see if anybody else has had this problem. Over about a 3 month period, I noticed that the /var partition of our linux server claims to fill up. The server is well into it's 3 month cycle now and I have a short window to play with before the machine will just die. The output from df shows:
machine:/var# df -k . Filesystem 1k-blocks Used Available Use% Mounted on /dev/hda3 497861 345390 126767 74% /var whereas the output from du returns: machine:/var# du -sk /var 145841 /var obviously there is a discrepency here. I ran lsof on the /var directory and noticed: machine:/var# lsof +D /var COMMAND PID USER FD TYPE DEVICE SIZE NODE NAME mysqld 10917 root 3u unix 0xc2367cc0 144707 /var/run/mysqld/mysqld.sock mysqld 10917 root 7u unix 0xc600f660 4464830 /var/run/mysqld/mysqld.sock mysqld 10917 root 24u unix 0xc56f2c80 4465358 /var/run/mysqld/mysqld.sock mysqld 10917 root 62u unix 0xc1bd7c80 4468136 /var/run/mysqld/mysqld.sock mysqld 10917 root 82u unix 0xc2484980 4465577 /var/run/mysqld/mysqld.sock mysqld 10931 root 3u unix 0xc2367cc0 144707 /var/run/mysqld/mysqld.sock mysqld 10931 root 7u unix 0xc600f660 4464830 /var/run/mysqld/mysqld.sock mysqld 10931 root 24u unix 0xc56f2c80 4465358 /var/run/mysqld/mysqld.sock mysqld 10931 root 62u unix 0xc1bd7c80 4468136 /var/run/mysqld/mysqld.sock mysqld 10931 root 82u unix 0xc2484980 4465577 /var/run/mysqld/mysqld.sock mysqld 10932 root 3u unix 0xc2367cc0 144707 /var/run/mysqld/mysqld.sock mysqld 10932 root 7u unix 0xc600f660 4464830 /var/run/mysqld/mysqld.sock mysqld 10932 root 24u unix 0xc56f2c80 4465358 /var/run/mysqld/mysqld.sock mysqld 10932 root 62u unix 0xc1bd7c80 4468136 /var/run/mysqld/mysqld.sock mysqld 10932 root 82u unix 0xc2484980 4465577 /var/run/mysqld/mysqld.sock mysqld 10933 root 3u unix 0xc2367cc0 144707 /var/run/mysqld/mysqld.sock mysqld 10933 root 7u unix 0xc600f660 4464830 /var/run/mysqld/mysqld.sock mysqld 10933 root 24u unix 0xc56f2c80 4465358 /var/run/mysqld/mysqld.sock mysqld 10933 root 62u unix 0xc1bd7c80 4468136 /var/run/mysqld/mysqld.sock mysqld 10933 root 82u unix 0xc2484980 4465577 /var/run/mysqld/mysqld.sock mysqld 30032 root 3u unix 0xc2367cc0 144707 /var/run/mysqld/mysqld.sock mysqld 30032 root 7u unix 0xc600f660 4464830 /var/run/mysqld/mysqld.sock mysqld 30032 root 24u unix 0xc56f2c80 4465358 /var/run/mysqld/mysqld.sock mysqld 30032 root 62u unix 0xc1bd7c80 4468136 /var/run/mysqld/mysqld.sock mysqld 30032 root 82u unix 0xc2484980 4465577 /var/run/mysqld/mysqld.sock mysqld 30146 root 3u unix 0xc2367cc0 144707 /var/run/mysqld/mysqld.sock mysqld 30146 root 7u unix 0xc600f660 4464830 /var/run/mysqld/mysqld.sock mysqld 30146 root 24u unix 0xc56f2c80 4465358 /var/run/mysqld/mysqld.sock mysqld 30146 root 62u unix 0xc1bd7c80 4468136 /var/run/mysqld/mysqld.sock mysqld 30146 root 82u unix 0xc2484980 4465577 /var/run/mysqld/mysqld.sock mysqld 30193 root 3u unix 0xc2367cc0 144707 /var/run/mysqld/mysqld.sock mysqld 30193 root 7u unix 0xc600f660 4464830 /var/run/mysqld/mysqld.sock mysqld 30193 root 24u unix 0xc56f2c80 4465358 /var/run/mysqld/mysqld.sock mysqld 30193 root 62u unix 0xc1bd7c80 4468136 /var/run/mysqld/mysqld.sock mysqld 30193 root 82u unix 0xc2484980 4465577 /var/run/mysqld/mysqld.sock mysqld 30767 root 3u unix 0xc2367cc0 144707 /var/run/mysqld/mysqld.sock mysqld 30767 root 7u unix 0xc600f660 4464830 /var/run/mysqld/mysqld.sock mysqld 30767 root 24u unix 0xc56f2c80 4465358 /var/run/mysqld/mysqld.sock mysqld 30767 root 62u unix 0xc1bd7c80 4468136 /var/run/mysqld/mysqld.sock mysqld 30767 root 82u unix 0xc2484980 4465577 /var/run/mysqld/mysqld.sock Is this some sort of unlinking bug? Naturally, a reboot fixes our problems for a couple of months. As I said in the beginning of the email, I've got a few days/a week before I REALLY need to reboot this machine. So I'd love to get some help on chasing this down, in case it is a bug and we need to get some data from it. Mark --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
