temporaere Dateien.

2002-08-15 Thread samia_driss

Hallo,
Ich wuerde gern wissen, warum und wann MySQL temporaere Dateien erzeugt.
Ausserdem wie vermeide ich, dass meine Festplatte bei der Ausfuehrung meiner 
Applikation, nicht voll wird, wenn so viele temporaere Dateien reingelegt werden.
Vielen Danke.

-
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




Re: temporaere Dateien.

2002-08-15 Thread Daniel Kiss

Hi,

Please write in English to this mailing list, or go to a German one.

Vielen Danke, :-)
Bye
 Daniel

At 11:04 2002.08.15. +0200, you wrote:
Hallo,
Ich wuerde gern wissen, warum und wann MySQL temporaere Dateien erzeugt.
Ausserdem wie vermeide ich, dass meine Festplatte bei der Ausfuehrung 
meiner Applikation, nicht voll wird, wenn so viele temporaere Dateien 
reingelegt werden.
Vielen Danke.

-
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




Re: temporaere Dateien.

2002-08-15 Thread Thomas Spahni

On Thu, 15 Aug 2002 [EMAIL PROTECTED] wrote:

 Hallo,
 Ich wuerde gern wissen, warum und wann MySQL temporaere Dateien erzeugt.
 Ausserdem wie vermeide ich, dass meine Festplatte bei der Ausfuehrung meiner 
Applikation, nicht voll wird, wenn so viele temporaere Dateien reingelegt werden.
 Vielen Dank.

Samia,

there is something in the manual about temporary files. Look for
Where MySQL Stores Temporary Files to be found under Problems and
Common Errors / Administration Issues.

quote
MySQL creates all temporary files as hidden files. This ensures that
the temporary files will be removed if `mysqld' is terminated.  The
disadvantage of using hidden files is that you will not see a big
temporary file that fills up the filesystem in which the temporary file
directory is located.
unquote

I think temporary files should be removed as soon as they are no longer
needed and not be kept until mysqld is closed down (which may happen very
unfrequently). You may always have a cron job deleting old temporary files
automatically.

Thomas


-
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