#!/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
