Re: MySQLd Crash

[Gerald Clark]

Try the -q option to mysqldump so it doesn't buffer up the whole thing.

Quentin Bennett wrote:

> Hi,
> 
> Doing a mysqldump of a large table to /tmp, I filled up /tmp, which  caused
> mysqld to reset.
> 
> This is while using 3.23.40 on Solaris 2.6
> 
> What additional information should I provide to help address this problem?
> 
> From: Quentin Bennett
> To: mysql@stripped
> Subject: [Mysql crash]
> 
>> Description:
> 
> 	Crash with full /tmp
> 
>> How-To-Repeat:
> 
> 	Fill up /tmp and allow mysqld to continue running
> 
>> Fix:
> 
> 	Don't fill up /tmp
> 
>> Submitter-Id:	<submitter ID>
>> Originator:	Mercury Admin
>> Organization:
> 
>  Infinity Solutions
> 
>> MySQL support: [none at the moment
>> Synopsis:	mysqld crash on full /tmp
>> Severity:	critical
>> Priority:	medium
>> Category:	mysql
>> Class:		sw-bug
>> Release:	mysql-3.23.40 (Source distribution)
>> Server: /usr/local/mysql/bin/mysqladmin  Ver 8.21 Distrib 3.23.40, for
> 
> pc-solaris2.6 on i386
> Copyright (C) 2000 MySQL AB & MySQL Finland AB & TCX DataKonsult AB
> This software comes with ABSOLUTELY NO WARRANTY. This is free software,
> and you are welcome to modify and redistribute it under the GPL license
> 
> Server version		3.23.40-log
> Protocol version	10
> Connection		Localhost via UNIX socket
> UNIX socket		/tmp/mysql.sock
> Uptime:			8 min 51 sec
> 
> Threads: 29  Questions: 5332  Slow queries: 1  Opens: 42  Flush tables: 1
> Open tables: 36 Queries per second avg: 10.041
> 
>> Environment:
> 
> 	<machine, os, target, libraries (multiple lines)>
> System: SunOS AKLDB 5.8 Generic_108529-03 i86pc i386 i86pc
> Architecture: i86pc
> 
> Some paths:  /usr/bin/perl
> 
> Compilation info: CC='gcc'  CFLAGS=''  CXX='gcc'  CXXFLAGS=''  LDFLAGS=''
> LIBC: 
> -rw-r--r--   1 root     bin      1574456 Jul 21  2000 /lib/libc.a
> lrwxrwxrwx   1 root     root          11 Sep 28 14:48 /lib/libc.so ->
> ../libc.so.1
> -rwxr-xr-x   1 root     bin       933380 Jul 21  2000 /lib/libc.so.1
> -rw-r--r--   1 root     bin      1574456 Jul 21  2000 /usr/lib/libc.a
> lrwxrwxrwx   1 root     root          11 Sep 28 14:48 /usr/lib/libc.so ->
> ../libc.so.1
> -rwxr-xr-x   1 root     bin       933380 Jul 21  2000 /usr/lib/libc.so.1
> Configure command: ./configure  --with-unix-socket-path=/var/tmp/mysql.sock
> --with-low-memory --with-mit-threads=yes --without-perl
> --enable-thread-safe-client --with-berkeley-db --with-innodb
> Perl: This is perl, version 5.005_03 built for i86pc-solaris
> 
> The information contained in this email is privileged and confidential
> and intended for the addressee only. If you are not the intended 
> recipient, you are asked to respect that confidentiality and not 
> disclose, copy or make use of its contents. If received in error 
> you are asked to destroy this email and contact the sender immediately. 
> Your assistance is appreciated.
> 
> ---------------------------------------------------------------------
> 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 <mysql-thread95620@stripped>
> To unsubscribe, e-mail
> <mysql-unsubscribe-gerald_clark=suppliersystems.com@stripped>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
> 
> 
>