Your message dated Sat, 12 May 2012 22:19:07 +0100
with message-id <[email protected]>
and subject line done
has caused the Debian Bug report #477668,
regarding mysql-server-5.0: slow information_schema on all versions of mysql
5.0 and 5.1
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.)
--
477668: http://bugs.debian.org/cgi-bin/bugreport.cgi?bug=477668
Debian Bug Tracking System
Contact [email protected] with problems
--- Begin Message ---
Package: mysql-server-5.0
Version: 5.0.51a-3
Severity: critical
Justification: breaks unrelated software
the whole issue is described and discussed here:
http://bugs.mysql.com/bug.php?id=19588
it is confirmed, it is serious (it could be easly used as DoS)
it also makes bigger servers unusable.
it breaks phpmyadmin and many other software scripts, including mysql itself.
the problem is that information_schema is very slow on system with many
databases, so slow that it's becoming unusable
this is of course mysql bug, but why debian doesn't recognize it, and allows
installation of this mysel server in it's stable branch ?
versions affacted are: 5.0.x and 5.1.x , althoigh some early 5.0 might not get
affected
please read the whole thing in a link given above, it is described and
commented there.
since mysql doesn't bother to fix this, maybe debian will, or at least debian
could not put affected mysql servers into stable
-- System Information:
Debian Release: lenny/sid
APT prefers testing
APT policy: (500, 'testing')
Architecture: i386 (i686)
Kernel: Linux 2.6.24.4 (SMP w/2 CPU cores)
Locale: LANG=pl_PL.UTF-8, LC_CTYPE=pl_PL.UTF-8 (charmap=UTF-8)
Shell: /bin/sh linked to /bin/bash
Versions of packages mysql-server-5.0 depends on:
ii adduser 3.107 add and remove users and groups
ii debconf [debconf-2.0] 1.5.20 Debian configuration management sy
ii libc6 2.7-10 GNU C Library: Shared libraries
ii libdbi-perl 1.604-1 Perl5 database interface by Tim Bu
ii libgcc1 1:4.3.0-3 GCC support library
ii libmysqlclient15off 5.0.51a-3 MySQL database client library
ii libncurses5 5.6+20080308-1 Shared libraries for terminal hand
ii libreadline5 5.2-3 GNU readline and history libraries
ii libstdc++6 4.3.0-3 The GNU Standard C++ Library v3
ii libwrap0 7.6.q-15 Wietse Venema's TCP wrappers libra
ii lsb-base 3.1-24 Linux Standard Base 3.1 init scrip
ii mysql-client-5.0 5.0.51a-3 MySQL database client binaries
ii mysql-common 5.0.51a-3 MySQL database common files
ii passwd 1:4.1.1-1 change and administer password and
ii perl 5.8.8-12 Larry Wall's Practical Extraction
ii psmisc 22.6-1 Utilities that use the proc filesy
ii zlib1g 1:1.2.3.3.dfsg-12 compression library - runtime
Versions of packages mysql-server-5.0 recommends:
ii bsd-mailx [mailx] 8.1.2-0.20071201cvs-2 A simple mail user agent
ii libhtml-template-p 2.9-1 HTML::Template : A module for usin
ii mailx 1:20071201-2 Transitional package for mailx ren
-- debconf-show failed
--- End Message ---
--- Begin Message ---
Version: 5.1.21-1
This is marked closed upstream. It is important to read the upstream
page carefully. A lot of people are complaining that it is not fixed.
But then you have to read what was said when it was closed upstream.
Some changes have been made to the information schema code to optimize
queries. However those queries have to be carefully constructed
according to guidelines laid down in
http://dev.mysql.com/doc/refman/5.1/en/information-schema-optimization.html.
In other words oracle are not claiming to applied a silver bullet at
this issue.
--- End Message ---
