Re: MySQL TMPDIR.

2004-10-19 Thread Egor Egorov
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 / /|_/ / // /\ \/

MySQL TMPDIR.

2004-10-18 Thread RV Tec
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 only

Re: MySQL TMPDIR.

2004-10-18 Thread gerald_clark
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 a MFS

Re: MySQL TMPDIR.

2004-10-18 Thread 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

Re: MySQL TMPDIR.

2004-10-18 Thread gerald_clark
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