Your message dated Wed, 09 Mar 2016 22:02:05 +0000
with message-id <e1admbb-0003tc...@franck.debian.org>
and subject line Bug#811158: Removed package(s) from unstable
has caused the Debian Bug report #804214,
regarding mysql-server-core-5.5: Mysql 5.5.46 freezes under load
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 ow...@bugs.debian.org
immediately.)
--
804214: http://bugs.debian.org/cgi-bin/bugreport.cgi?bug=804214
Debian Bug Tracking System
Contact ow...@bugs.debian.org with problems
--- Begin Message ---
Package: mysql-server-core-5.5
Version: 5.5.44-0+deb7u1
Severity: important
Dear Maintainer,
Last week, we upgraded two of our database servers from version
5.5.44-0+deb7u1 to 5.5.46-0+deb7u1. After the upgrade, we started
experiencing unpredictable freezes, where the database became
unresponsive. In this state, it was not possible to connect to it,
list processes or even shut it down normally. The only way to get
out of this state was to kill -9 mysqld, start up again and let it
do crash recovery. This happened several times on both servers,
usually at least once per day, usually at heavy load. The longest
a server went without a crash was 40 hours.
We established a 24/7 schedule to babysit the system, so that it
was possible to detect outages early. We also worked with consultants
from Percona who suggested several options for tuning the system,
none of which were effective in preventing the freezing.
There were no performance problems before or during the outages.
Eventually we decided that a downgrade to 5.5.44 was necessary.
This was done on November 3rd and the databases have been stable
since.
Mysql configuration files:
ueriksson@gib-ca-db01:~$ more /etc/mysql/my.cnf
[client]
port = 3306
socket = /var/run/mysqld/mysqld.sock
[isamchk]
key_buffer_size = 16M
[mysql]
default-character-set = utf8
[mysqld]
basedir = /usr
bind-address = 0.0.0.0
character-set-server = utf8
datadir = /var/lib/mysql
default-storage-engine = INNODB
expire_logs_days = 14
innodb_file_per_table
key_buffer_size = 16M
log-error = /var/log/mysql/mysql.log
long_query_time = 1
max_allowed_packet = 16M
max_binlog_size = 100M
max_connections = 151
myisam_recover = BACKUP
table_open_cache = 4000
pid-file = /var/run/mysqld/mysqld.pid
port = 3306
query_cache_limit = 1M
#query_cache_size = 16M
skip-external-locking
slow_launch_time = 1
socket = /var/run/mysqld/mysqld.sock
#thread_cache_size = 8
thread_stack = 256K
tmpdir = /tmp
transaction-isolation = READ-COMMITTED
user = mysql
#thread_cache_size=64
####new_changes
innodb_buffer_pool_instances=8
innodb_stats_on_metadata=OFF
thread_cache_size=1000
query_cache_size=0
query_cache_type=0
innodb_flush_method=O_DIRECT
[mysqld_safe]
log-error = /var/log/mysql/mysql.log
nice = 0
socket = /var/run/mysqld/mysqld.sock
[mysqldump]
max_allowed_packet = 16M
quick
quote-names
!includedir /etc/mysql/conf.d/
ueriksson@gib-ca-db01:~$ more /etc/mysql/conf.d/common.cnf
[mysqld]
bind-address = 0.0.0.0
datadir = /data/mysql
tmpdir = /data/tmp
max_connections = 2000
expire_logs_days = 14
#thread_cache_size = 64
log-bin-trust-function-creators = 1
ueriksson@gib-ca-db01:~$ more /etc/mysql/conf.d/compress.cnf
[mysqld]
innodb_file_format = Barracuda
innodb_old_blocks_time = 1000
ueriksson@gib-ca-db01:~$ more /etc/mysql/conf.d/memory.cnf
[mysqld]
# innodb tweak params
innodb_buffer_pool_size = 51G
innodb_log_file_size = 1800M
innodb_log_buffer_size = 16M
ueriksson@gib-ca-db01:~$ more /etc/mysql/conf.d/replication.cnf
[mysqld]
server-id = 11
auto-increment-increment = 1
auto-increment-offset = 1
log-slave-updates = true
log_bin = /data/log/mysql-bin.log
binlog-format = row
replicate-wild-ignore-table = mysql.%
replicate-wild-ignore-table = performance_schema.%
# Skip some errors
# 1396 = user error
# 1133 = set password error
-- System Information:
Debian Release: 7.9
APT prefers oldstable-updates
APT policy: (500, 'oldstable-updates'), (500, 'oldstable')
Architecture: amd64 (x86_64)
Kernel: Linux 3.2.0-4-amd64 (SMP w/10 CPU cores)
Locale: LANG=en_US.UTF-8, LC_CTYPE=en_US.UTF-8 (charmap=UTF-8)
Shell: /bin/sh linked to /bin/dash
Versions of packages mysql-server-core-5.5 depends on:
ii libaio1 0.3.109-3
ii libc6 2.13-38+deb7u8
ii libgcc1 1:4.7.2-5
ii libstdc++6 4.7.2-5
ii libwrap0 7.6.q-24
ii zlib1g 1:1.2.7.dfsg-13
mysql-server-core-5.5 recommends no packages.
mysql-server-core-5.5 suggests no packages.
-- no debconf information
--- End Message ---
--- Begin Message ---
Version: 5.5.46-0+deb8u1+rm
Dear submitter,
as the package mysql-5.5 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 https://bugs.debian.org/811158
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
ftpmas...@ftp-master.debian.org.
Debian distribution maintenance software
pp.
Scott Kitterman (the ftpmaster behind the curtain)
--- End Message ---
