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: -- To UNSUBSCRIBE, email to debian-bugs-dist-requ...@lists.debian.org with a subject of "unsubscribe". Trouble? Contact listmas...@lists.debian.org
