List:General Discussion« Previous MessageNext Message »
From:Lars Andersson Date:October 31 2002 7:05pm
Subject:RE: mysql fills the disk with temporary files?
View as plain text  
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@stripped]
> Sent: Thursday, October 31, 2002 9:56 AM
> To: mysql@stripped
> 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 <mysql-thread123680@stripped>
> To unsubscribe, e-mail
> <mysql-unsubscribe-kblack05=sprintspectrum.com@stripped>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>

Thread
: A simple one that gets me!scott31 Oct
  • Re: A simple one that gets me!Roger Baklund31 Oct
    • mysql fills the disk with temporary files?Lars Andersson31 Oct
      • Re: mysql fills the disk with temporary files?gerald_clark31 Oct
        • Re: mysql fills the disk with temporary files?Lars Andersson31 Oct
RE: mysql fills the disk with temporary files?Kelly W [PCS] Black31 Oct
  • RE: mysql fills the disk with temporary files?Lars Andersson31 Oct
RE: mysql fills the disk with temporary files?Kelly W [PCS] Black31 Oct
  • RE: mysql fills the disk with temporary files?Lars Andersson31 Oct
RE: mysql fills the disk with temporary files?Jan Steinman1 Nov
  • RE: mysql fills the disk with temporary files?Lars Andersson1 Nov
RE: mysql fills the disk with temporary files?Kelly W [PCS] Black1 Nov