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: [EMAIL PROTECTED] > 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 <[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