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

Thu, 21 Nov 2002 07:48:12 -0800

Hi Markus,

I just missed something in your original Mail,
I guess its not the mysql server growing to 1gig (check with ps -ely)
its simply the system memory showing no free mem.
If you have root access to the maschine its probably a good idea to install the prtmem command (ftp://playground.sun.com/pub/memtool/)
it shows output like
bash-2.05$ prtmem

Total memory: 492 Megabytes
Kernel Memory: 26 Megabytes
Application: 179 Megabytes
Executable & libs: 14 Megabytes
File Cache: 176 Megabytes
Free, file cache: 24 Megabytes
Free, free: 71 Megabytes

so you can see that a lot of the memory is used for file caching.
In Solaris Versions below 8 there will be no Free, file cache.
Most of the file cache can and probably will normaly be on the Free, file cache list on Solaris > 7
(not in this example is dirty file cache block will be on the File Cache list and they move to the Free, file cache after sync etc)
So there is nothing to worry about if the freemem drops because of an increasing filecache if you want to the system to scan more aggressively for file cache memory than for any memory if memory is tight it helps to activate priority_paging.
Search for Solaris and priority_paging.
I think the right syntax is to put a line in /etc/system like this:
set priority_paging = 1
this is usefull for pre Solaris 8 systems and never set this varibale fo Solaris versions > 7

Lars


On Donnerstag, November 21, 2002, at 03:30 Uhr, Markus Warg wrote:

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

Reply via email to