pico /etc/services ulimit 20000 # size in k
BTW It cannot remove files in use. It would simply generate cron errors -----Original Message----- From: Lars Andersson [mailto:lars@;rockar.nu] Sent: Thursday, October 31, 2002 11:05 AM To: Black, Kelly W [PCS] Cc: [EMAIL PROTECTED] Subject: RE: mysql fills the disk with temporary files? Thanks, Unfortunatley I think things will break if I remove the temporary files while they still are in use =) I want a solution that keeps the files limited in size. There must be some settings that controll this kind of stuff. /Lars On Thu, 31 Oct 2002, Black, Kelly W [PCS] wrote: > #!/usr/local/bin/perl > use strict; > my @files=(`/bin/ls /tmp/sql*.M*`); > for (@files) { > unlink; > } > exit 0; > > > shell> crontab -e > > 0 2 * * * /usr/local/bin/perl /path/to/delete/program > > :wq > > :) > -----Original Message----- > From: Lars Andersson [mailto:lars@;rockar.nu] > Sent: Thursday, October 31, 2002 9:56 AM > To: [EMAIL PROTECTED] > Subject: mysql fills the disk with temporary files? > > > Hi, > > I manage a mysql server with a few hundred users. All of a sudden mysql > has started to put large files in /tmp > > I've never noticed this behavior before. The files looks like this > > -rw-rw---- 1 mysql mysql 3788431360 Oct 31 17:49 > #sql420e_36b82b_1.MYD > -rw-rw---- 1 mysql mysql 1024 Oct 31 17:39 > #sql420e_36b82b_1.MYI > -rw-rw---- 1 mysql mysql 1094713344 Oct 31 17:49 > #sql420e_36b8c6_1.MYD > -rw-rw---- 1 mysql mysql 1024 Oct 31 17:45 > #sql420e_36b8c6_1.MYI > > I wonder if this is the result of someone making a heap table to big to > fit into the servers memory? > > How do I stop these files from filling my diskspace. The server filled > 10GB of space in notime and forced me to halt the server and put in some > extra disks and symlink some directories to the new disks. > > I'm running > MySQL-Max-3.23.53a > 2x1.3Ghz PIII with 2GB of ram > RedHat 7.3 > glibc-2.2.5-40. > > Could this file-thing be related to the glibc-mysql problems? > > regards > /Lars > > > query,sql > > > --------------------------------------------------------------------- > 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 > --------------------------------------------------------------------- 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