to env from the
shell,
limit=figure
export limit
restart mysqld
-Original Message-
From: Lars Andersson [mailto:lars@;rockar.nu]
Sent: Thursday, October 31, 2002 11:36 AM
To: gerald_clark
Cc: [EMAIL PROTECTED]
Subject: Re: mysql fills the disk with temporary files?
Is there any way to
Mysql is installed properly with user mysql and group mysql.
What happens if I limit the maximum filesize for the mysql user? When it
reches that size it will send what kind of errors to the user doing the
query?
Another problem is that I have quite big innodb data-files, owned by
mysql, the limi
>From: Lars Andersson <[EMAIL PROTECTED]>
>
>Thanks for your advices, but I don't want to solve this problem on the
>OS/shell level.
Assuming MySQL is installed properly, with its own user and group, I don't see why you
should not want to solve the problem this way.
--
SQL SQL SQL SQL SQL
Is there any way to put a limit on the size of temporary tables? Or is
it possible for my users to put the server down just by creating some
kind of big cartesian product as a result of a big join?
The server is used in an production environment and it would be a great
releaf if there is some way
: 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
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/l
#!/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 A
