Your message dated Thu, 05 Jul 2012 15:53:12 +0000
with message-id <[email protected]>
and subject line Bug#680362: Removed package(s) from unstable
has caused the Debian Bug report #661529,
regarding mysql-server-5.1: memory leak
to be marked as done.
This means that you claim that the problem has been dealt with.
If this is not the case it is now your responsibility to reopen the
Bug report if necessary, and/or fix the problem forthwith.
(NB: If you are a system administrator and have no idea what this
message is talking about, this may indicate a serious mail system
misconfiguration somewhere. Please contact [email protected]
immediately.)
--
661529: http://bugs.debian.org/cgi-bin/bugreport.cgi?bug=661529
Debian Bug Tracking System
Contact [email protected] with problems
--- Begin Message ---
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:
--- End Message ---
--- Begin Message ---
Version: 5.1.62-1+rm
Dear submitter,
as the package mysql-5.1 has just been removed from the Debian archive
unstable we hereby close the associated bug reports. We are sorry
that we couldn't deal with your issue properly.
For details on the removal, please see http://bugs.debian.org/680362
The version of this package that was in Debian prior to this removal
can still be found using http://snapshot.debian.org/.
This message was generated automatically; if you believe that there is
a problem with it please contact the archive administrators by mailing
[email protected].
Debian distribution maintenance software
pp.
Alexander Reichle-Schmehl (the ftpmaster behind the curtain)
--- End Message ---
