Package: mysql-server
Version: 4.0.24-10sarge2
Severity: important
Hello,
I have a sarge server (no backports or manualy installed software except
ruby on rails) using mysql-server. Since the last security update (to
4.0.24-10sarge2) mysql server has started to behave strangely.
When starting, everything seems ok as usual (step 1), but after
something like an hour the systme load climbs to ~3 (normal load is
~0.6), stays at 3 for a few hours(step 2) and then in a few minute climbs to
more than 30 and the system becomes completely unresponsive(step 3). I
then restart mysqld, and things go back step 1.
I collect stats on this system (with munin) and noticed the following
facts that might help tracing the problem:
- during step 1 (~1 hour) everything looks normal (as usual):
* mysql througput: 12kb/s received 40 kb/s sent
* mysql cache hits: 4/s
* vmstat running processes: 0.5
* cpu usage: 4% sys/26% user/61% idle/1% nice/iowait 7%/irq 0.1%/softirq 0.3%
* context switches: 600/s
* load avg: 0.6
- during step 2 (a few hours):
* mysql througput: 200kb/s received 550 kb/s sent
* mysql cache hits: 4000/s
* vmstat running processes: 2.5
* cpu usage: 25% sys/70% user/0% idle/3% nice/iowait <1%/irq 0.1%/softirq 0.6%
* context switches: 16000/s
* nothing else changes noticeably (memory usage, network, num
processes...)
- during step 3 (15-30 minutes) everything looks like step 2 except the
load climbing over 30 (but munin graphs are hardly readable on a such
a short timespan)
Apps accessing the server are php4 and ruby on rails.
The server is a production system hosting ~100 (mostly small) DBs for
websites. It would be very hard to test or debug on it if I must bring
mysql down for more than a few minutes (clients and boss would complain
fast).
Joel Kociolek.
-- System Information:
Debian Release: 3.1
Architecture: i386 (i686)
Kernel: Linux 2.6.8-1-386
Locale: LANG=C, LC_CTYPE=C (charmap=ANSI_X3.4-1968)
Versions of packages mysql-server depends on:
ii adduser 3.63 Add and remove users and groups
ii debconf 1.4.30.13 Debian configuration management sy
ii libc6 2.3.2.ds1-22sarge3 GNU C Library: Shared libraries an
ii libdbi-perl 1.46-6 Perl5 database interface by Tim Bu
ii libgcc1 1:3.4.3-13 GCC support library
ii libmysqlclient12 4.0.24-10sarge2 mysql database client library
ii libstdc++5 1:3.3.5-13 The GNU Standard C++ Library v3
ii libwrap0 7.6.dbs-8 Wietse Venema's TCP wrappers libra
ii mailx 1:8.1.2-0.20040524cvs-4 A simple mail user agent
ii mysql-client 4.0.24-10sarge2 mysql database client binaries
ii mysql-common 4.0.24-10sarge2 mysql database common files (e.g.
ii passwd 1:4.0.3-31sarge5 change and administer password and
ii perl 5.8.4-8sarge4 Larry Wall's Practical Extraction
ii psmisc 21.5-1 Utilities that use the proc filesy
ii zlib1g 1:1.2.2-4.sarge.2 compression library - runtime
-- debconf information:
mysql-server/nis_warning:
mysql-server/really_downgrade_from_41: false
mysql-server/mysql_update_hints1:
* mysql-server/start_on_boot: true
mysql-server/postrm_remove_databases: false
* mysql-server/mysql_install_db_notes:
--
To UNSUBSCRIBE, email to [EMAIL PROTECTED]
with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED]
