>Description:
Dump several big tables or entire databases with mysqldump, then
import to same or another database with mysql -f db <dumpfile or
on mysql console by typeing source dumpfile.
You can then see that the amount of free memory decreases quite
fast, stopping the client or mysqld server does not free the mem.
Can be reproduced with both V3.23.40 and V3.23.53.
V3.23.40 was compiled with GCC 3.2, V3.23.53 installed as binary
package.
>How-To-Repeat:
Dump a database with around 250.000 to 3.000.000 records, record size
is around 200 bytes.
Import dump file and see memory eaten up.
>Fix:
unknown
>Submitter-Id: <submitter ID>
>Originator: Markus Warg
>Organization:
no organization
>MySQL support: none
>Synopsis: memory leak
>Severity: non-critical
>Priority: low
>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 sun-solaris2.7
>on sparc
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: 6 hours 40 min 52 sec
Threads: 3 Questions: 415761 Slow queries: 101 Opens: 885 Flush tables: 2 Open
tables: 128 Queries per second avg: 17.286
>Environment:
SUN Solaris 5.7 with quite actual patch cluster installed
System: SunOS hostname 5.7 Generic_106541-20 sun4u sparc SUNW,Ultra-4
Architecture: sun4
Some paths: /local/bin/perl /local/bin/make /local/bin/gcc /usr/ucb/cc
GCC: Reading specs from /local/bin/../lib/gcc-lib/sparc-sun-solaris2.7/3.2/specs
Configured with: ../gcc-3.2/configure --enable-languages=c,c++ --disable-nls
Thread model: posix
gcc version 3.2
Compilation info: CC='gcc' CFLAGS='' CXX='c++' CXXFLAGS='' LDFLAGS=''
LIBC:
-rw-r--r-- 1 bin 1711920 Jun 14 00:12 /lib/libc.a
lrwxrwxrwx 1 root 11 Mar 10 1999 /lib/libc.so -> ./libc.so.1
-rwxr-xr-x 1 bin 1125872 Jun 14 00:12 /lib/libc.so.1
-rw-r--r-- 1 bin 1711920 Jun 14 00:12 /usr/lib/libc.a
lrwxrwxrwx 1 root 11 Mar 10 1999 /usr/lib/libc.so -> ./libc.so.1
-rwxr-xr-x 1 bin 1125872 Jun 14 00:12 /usr/lib/libc.so.1
Configure command: ./configure --prefix=/usr/local/mysql
Perl: This is perl, version 5.005_02 built for sun4-solaris
---------------------------------------------------------------------
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
