[debian-mysql] Bug#590921: mysql-server-5.0: README.Debian should mention example my.cnf files which are more suitable for modern systems

[Lazeme Admin]

Package: mysql-server-5.0
Version: 5.0.51a-24+lenny4
Severity: normal

Obviously, shipping the default Debian MySQL to run on a low resource system is the best/safest option.  However, when 
running a Cubecart installation the default MySQL was running up to 99.9% percent processor usage and the server load 
was crippling the system to the extent that the website was unusable.

I spent hours looking through optimisation options and found it extremely difficult to improve performence.  If you 
don't work with running MySQL every day this can be daunting.

However, eventually I found out about the default my.cnf files which are in /usr/share/doc/mysql-server-5.0/examples.  
One of these was ideal for the server which has 1.5GB RAM.  After simply copying my-huge.cnf to /etc/mysql/my.cnf the 
system was able to handle the load easily.

As most modern systems have decent amounts of RAM I'd recommend at least mentioning these alternative default 
configuration files in the README.Debian.  (Obviously, most of us know that after installing a package reading the 
README.Debian file is the next thing to).

It could even be possible to measure the RAM and maybe change the my.cnf used during the intall process - or maybe make 
it an option the user can pick during install.


-- System Information:
Debian Release: 5.0.5
  APT prefers stable
  APT policy: (500, 'stable')
Architecture: i386 (i686)

Kernel: Linux 2.6.32.15-kvm-i386-20100622 (SMP w/1 CPU core)
Locale: LANG=en_GB, LC_CTYPE=en_GB (charmap=ISO-8859-1)
Shell: /bin/sh linked to /bin/bash

Versions of packages mysql-server-5.0 depends on:
ii  adduser                3.110             add and remove users and groups
ii  debconf [debconf-2.0]  1.5.24            Debian configuration management sy
ii  libc6                  2.7-18lenny4      GNU C Library: Shared libraries
ii  libdbi-perl            1.605-1           Perl5 database interface by Tim Bu
ii  libgcc1                1:4.3.2-1.1       GCC support library
ii  libmysqlclient15off    5.0.51a-24+lenny4 MySQL database client library
ii  libncurses5            5.7+20081213-1    shared libraries for terminal hand
ii  libreadline5           5.2-3.1           GNU readline and history libraries
ii  libstdc++6             4.3.2-1.1         The GNU Standard C++ Library v3
ii  libwrap0               7.6.q-16          Wietse Venema's TCP wrappers libra
ii  lsb-base               3.2-20            Linux Standard Base 3.2 init scrip
ii  mysql-client-5.0       5.0.51a-24+lenny4 MySQL database client binaries
ii  mysql-common           5.0.51a-24+lenny4 MySQL database common files
ii  passwd                 1:4.1.1-6+lenny1  change and administer password and
ii  perl                   5.10.0-19lenny2   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-3 A simple mail user agent
ii  libhtml-template-p 2.9-1                 HTML::Template : A module for usin
ii  mailx              1:20071201-3          Transitional package for mailx ren

Versions of packages mysql-server-5.0 suggests:
pn  tinyca                        <none>     (no description available)

-- debconf information:
  mysql-server-5.0/really_downgrade: false
  mysql-server-5.0/need_sarge_compat: false
  mysql-server-5.0/start_on_boot: true
  mysql-server/error_setting_password:
  mysql-server-5.0/nis_warning:
  mysql-server-5.0/postrm_remove_databases: false
  mysql-server-5.0/need_sarge_compat_done: true
  mysql-server/password_mismatch: