> What will happen on Error code 28: No space left on device? Will mysql > crash down?... Will there be posibility of reading data from tables?
I saw this error on one of my servers not too long ago. MySQL keeps running but seemingly refuses to do SELECTs on any tables. Upon freeing some space those same SELECTs went through fine without a restart of mysqld. I believe the default my.cnf uses /tmp for its temporary files. If this partition is full you may either free some space within it or alternatively specify a different location for MySQL's temporary files. See the "tmpdir" setting in my.cnf. e.g.: tmpdir = /usr/tmp/ Ron Jamison --------------------------------------------------------------------- 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
