> I'm new to MySQL, and I hope somebody can help me.
> I have a 3.7G database and a 10G tmpdir.
> Sometimes the tmpdir runs out of space, and I get the following message on
> the logs:
> [ERROR] /usr/libexec/mysqld: Incorrect key file for table
> '/tmp/tmpdir/#sql_2
Hello, everybody!
I'm new to MySQL, and I hope somebody can help me.
I have a 3.7G database and a 10G tmpdir.
Sometimes the tmpdir runs out of space, and I get the following message on
the logs:
[ERROR] /usr/libexec/mysqld: Incorrect key file for table
'/tmp/tmpdir/#sql_22f_33.MYI'
>
> And I have written to quite some lengh about the symptoms here, if you
> are curious.
>
> http://forum.slicehost.com/comments.php?DiscussionID=3373&page=1
> http://news.ycombinator.com/item?id=543614
>
> But the final conclusion is to use memory rather than disk for mysql
/comments.php?DiscussionID=3373&page=1
http://news.ycombinator.com/item?id=543614
But the final conclusion is to use memory rather than disk for mysql's
tmpdir setting. So my question is, how does one do this in
debian/unix? Are there any recipes you can share? Should I use tmpfs
vs ramfs
Hello.
It'll say that the disk is full, and will not make any attemt
to ignore it and use the second partition.
Eamon Daly wrote:
> This is wishful thinking, but I figured I'd ask anyway: the
> manual states:
>
> "Starting from MySQL 4.1, the --tmpdir option
Kirchhoff" <[EMAIL PROTECTED]>
To: "Eamon Daly" <[EMAIL PROTECTED]>
Cc:
Sent: Wednesday, February 01, 2006 11:40 AM
Subject: Re: "tmpdir" option
Eamon Daly schrieb:
We've been considering the
purchase of a flash drive as a temporary disk for so
This is wishful thinking, but I figured I'd ask anyway: the
manual states:
"Starting from MySQL 4.1, the --tmpdir option can be set
to a list of several paths that are used in round-robin
fashion."
Are these directories promotable at all? In other words, if
I specify an 8G
You can be sure that MySQL won't loose any data in this case.
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.net http://www.ensita.net/
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ /Egor Egorov
/ /|_/ / // /\ \/ /_
Yes.
RV Tec wrote:
Clark,
MySQL will stop processing the current query until space becomes
available. It will then continue.
Stop processing the current query means locking it all, and everything
else has to wait for this query to be completed?!
Thanks for your reply!
Best regards,
RV Tec
Clark,
> MySQL will stop processing the current query until space becomes
> available. It will then continue.
Stop processing the current query means locking it all, and everything
else has to wait for this query to be completed?!
Thanks for your reply!
Best regards,
RV Tec
--
MySQL General
RV Tec wrote:
Folks,
A couple of months ago I asked this question, and there was no answer,
since then I couldn't find a reasonable answer or a way to find it myself.
What happens if MySQL runs out of space at TMPDIR? I guess I could use the
performance improvement of redirecting that to
Folks,
A couple of months ago I asked this question, and there was no answer,
since then I couldn't find a reasonable answer or a way to find it myself.
What happens if MySQL runs out of space at TMPDIR? I guess I could use the
performance improvement of redirecting that to a MFS DIR. The
reports and manage our
system. In order to gain performance, I thought that I could map the
tmpdir to a MFS directory (512MB). I really think that this would speed
things up.
Although, I have come to a couple of questions that I was not able to find
the answer at MySQL documentation... maybe you
Hi!
On Feb 17, Jeremy Zawodny wrote:
> On Tue, Feb 17, 2004 at 01:18:45PM -0800, lee wrote:
> > We are trying to do some capacity planning, and we need to know how MySQL
> > allocates the the filespace in the directories set by the tmpdir
> > configuration parameter.
>
On Tue, Feb 17, 2004 at 01:18:45PM -0800, lee wrote:
> We are trying to do some capacity planning, and we need to know how MySQL
> allocates the the filespace in the directories set by the tmpdir
> configuration parameter.
>
> The manual simply states:
> "...It may be usef
We are trying to do some capacity planning, and we need to know how MySQL
allocates the the filespace in the directories set by the tmpdir
configuration parameter.
The manual simply states:
"...It may be useful if your default /tmp directory resides on a partition
that is too small to
At 13:20 -0500 10/3/03, dan orlic wrote:
Hello all,
My query is about changing the tmpdir on mysql. As stated in on the
mysql.com site it states that if it is not set it uses the default, in
my case, the default was /tmp. It also states that to change it you can
do so in the mysqld_safe
In my.cnf its called tmpdir change that location
tmpdir=
- Dathan Vance Pattishall
- Sr. Programmer and mySQL DBA for FriendFinder Inc.
- http://friendfinder.com/go/p40688
-->-Original Message-
-->From: dan orlic [mailto:[EMAIL PROTECTED]
-->Sent: Friday, October 03, 2003
-Original Message-
From: dan orlic [mailto:[EMAIL PROTECTED]
Sent: Friday, October 03, 2003 1:20 PM
To: '[EMAIL PROTECTED]'
Subject: changing TMPDIR for tempory file location
Hello all,
My query is about changing the tmpdir on mysql. As stated in on the
mysql.c
Hello all,
My query is about changing the tmpdir on mysql. As stated in on the
mysql.com site it states that if it is not set it uses the default, in
my case, the default was /tmp. It also states that to change it you can
do so in the mysqld_safe startup file. It makes no mention of
I am running MySQL database 4.0.4 on a RedHat Linux 7.3 with the
database path being on raid disks and /tmp/ on a non raid disk.
Should the tmpdir be on a raid disk? If so they will be at the same disk
as the database. Is that the best option?
Regards, Jacob
21 matches
Mail list logo
