Lars, the amount used increases until all free memory is used plus a fair amount of swap. On a machine with 2GB memory this can well grow up to 1GB.
Any chance to get the current size of the malloc pool to check if this causes the effect? thx so far, Markus On Don, 21 Nov 2002, Lars Heidieker wrote: > Does the memory amount used increases any further if repeating the dump > import. > If so there is a leak if not you just got fooled by the standard malloc > of solaris which wont return memory free(d) to the system but instead > the memory will be kept in a pool for the next malloc. > > Lars > > > On Donnerstag, November 21, 2002, at 02:50 Uhr, [EMAIL PROTECTED] > wrote: > > >> 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 > > -- this space is for rent --------------------------------------------------------------------- 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
