[debian-mysql] Bug#661529: mysql-server-5.1: memory leak
aspel
aspel at ukr.net
Mon Feb 27 20:34:11 UTC 2012
Package: mysql-server-5.1
Version: 5.1.49-3
Severity: important
I have a small script that will record in the database, some data.
http://pastebin.com/jcqfRnja
The file sparefile1.txt is stored such data at 14 MB
--- start file ---
insert into uc_spareshop_spare value('127628','xxx','xxx','1988','1995','xxxxx','','xxxxx','xxxx','','0','0','480','');insert into uc_spareshop_spare value('127630','xxx','xxx','1988','1995','xxxxx','','xxxxx','xxxx','','0','0','480','');insert into uc_spareshop_spare value('127629','xxx','xxx','1988','1995','xxxxx','','xxxxx','xxxx','','0','0','480','');
--- end file ---
My vps has 8G RAM
If I run a php script that all memory is taken mysqld
12661 mysql 20 0 7g 6g 6364 S 2 1.3 5:18.81 7g mysqld
-mysqld.log-
120225 19:15:49 [ERROR] /usr/sbin/mysqld: Out of memory (Needed 14634160 bytes)
120225 19:15:49 [ERROR] Out of memory; check if mysqld or some other process uses all available memory; if not, you may have to use 'ulimit' to allow mysqld to use more memory or you can add more swap space
I tested that script on the mysql-server-5.0 and everything works without problems.
-/etc/mysql/my.cnf-
[client]
port = 3306
socket = /var/run/mysqld/mysqld.sock
[mysql]
character-sets-dir=/usr/share/mysql/charsets
default-character-set=utf8
[mysqladmin]
character-sets-dir=/usr/share/mysql/charsets
default-character-set=utf8
[mysqlcheck]
character-sets-dir=/usr/share/mysql/charsets
default-character-set=utf8
[mysqldump]
character-sets-dir=/usr/share/mysql/charsets
default-character-set=utf8
[mysqlimport]
character-sets-dir=/usr/share/mysql/charsets
default-character-set=utf8
[mysqlshow]
character-sets-dir=/usr/share/mysql/charsets
default-character-set=utf8
[myisamchk]
character-sets-dir=/usr/share/mysql/charsets
[myisampack]
character-sets-dir=/usr/share/mysql/charsets
[mysqld_safe]
err-log = /var/log/mysql/mysql.err
[mysqld]
character-set-server = utf8
default-character-set = utf8
init-connect="SET NAMES utf8"
user = mysql
port = 3306
socket = /var/run/mysqld/mysqld.sock
pid-file = /var/run/mysqld/mysqld.pid
log-error = /var/log/mysql/mysqld.err
basedir = /usr
datadir = /var/lib/mysql
#log = /tmp/query.log
log-slow-queries = /var/log/mysql/queryslow.log
skip-locking
tmp_table_size = 32M
key_buffer = 6M
max_allowed_packet = 16M
table_cache = 256
sort_buffer_size = 512K
net_buffer_length = 8K
read_buffer_size = 256K
read_rnd_buffer_size = 512K
myisam_sort_buffer_size = 8M
ft_min_word_len = 1
thread_cache = 2
query_cache_size = 16M
connect_timeout = 40
flush_time = 600
wait_timeout = 300
interactive-timeout = 300
# Try number of CPU's*2 for thread_concurrency
thread_concurrency = 2
language = /usr/share/mysql/english
bind-address = 0.0.0.0
tmpdir = /tmp/
innodb_buffer_pool_size = 16M
innodb_additional_mem_pool_size = 2M
innodb_data_file_path = ibdata1:10M:autoextend:max:1024M
innodb_log_file_size = 5M
innodb_log_buffer_size = 8M
set-variable = innodb_log_files_in_group=2
innodb_flush_log_at_trx_commit = 1
innodb_lock_wait_timeout = 50
[mysqldump]
quick
max_allowed_packet = 16M
[mysql]
[isamchk]
key_buffer = 20M
sort_buffer_size = 20M
read_buffer = 2M
write_buffer = 2M
[myisamchk]
key_buffer = 20M
sort_buffer_size = 20M
read_buffer = 2M
write_buffer = 2M
[mysqlhotcopy]
interactive-timeout
-- System Information:
Debian Release: 6.0.4
APT prefers stable
APT policy: (600, 'stable'), (500, 'oldstable')
Architecture: amd64 (x86_64)
Kernel: Linux 2.6.32-5-openvz-amd64 (SMP w/24 CPU cores)
Locale: LANG=en_US.UTF-8, LC_CTYPE=en_US.UTF-8 (charmap=UTF-8) (ignored: LC_ALL set to en_US.UTF-8)
Shell: /bin/sh linked to /bin/dash
Versions of packages mysql-server-5.1 depends on:
ii adduser 3.112+nmu2 add and remove users and groups
ii debconf [de 1.5.36.1 Debian configuration management sy
ii libc6 2.11.3-2 Embedded GNU C Library: Shared lib
ii libdbi-perl 1.612-1 Perl Database Interface (DBI)
ii libgcc1 1:4.4.5-8 GCC support library
ii libmysqlcli 5.1.49-3 MySQL database client library
ii libstdc++6 4.4.5-8 The GNU Standard C++ Library v3
ii lsb-base 3.2-23.2squeeze1 Linux Standard Base 3.2 init scrip
ii mysql-clien 5.1.49-3 MySQL database client binaries
ii mysql-commo 5.1.49-3 MySQL database common files, e.g.
ii mysql-serve 5.1.49-3 MySQL database server binaries
ii passwd 1:4.1.4.2+svn3283-2+squeeze1 change and administer password and
ii perl 5.10.1-17squeeze3 Larry Wall's Practical Extraction
ii psmisc 22.11-1 utilities that use the proc file s
ii zlib1g 1:1.2.3.4.dfsg-3 compression library - runtime
Versions of packages mysql-server-5.1 recommends:
ii bsd-mailx [mailx] 8.1.2-0.20100314cvs-1 simple mail user agent
ii libhtml-template-p 2.9-2 module for using HTML Templates wi
ii mailx 1:20071201-3 Transitional package for mailx ren
Versions of packages mysql-server-5.1 suggests:
pn tinyca <none> (no description available)
-- debconf information:
mysql-server/root_password_again: (password omitted)
mysql-server/root_password: (password omitted)
mysql-server/error_setting_password:
mysql-server-5.1/nis_warning:
mysql-server-5.1/really_downgrade: false
mysql-server-5.1/start_on_boot: true
mysql-server-5.1/postrm_remove_databases: false
mysql-server/password_mismatch:
mysql-server/no_upgrade_when_using_ndb:
More information about the pkg-mysql-maint
mailing list