Re: mysql memory leak on SUN Solaris 5.7 when importing dump files

[Lars Heidieker]

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

---------------------------------------------------------------------
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