[debian-mysql] Bug#567498: mysql-server-5.1: Default my.cnf

Olaf van der Spek olafvdspek at gmail.com
Fri Jan 29 13:50:44 UTC 2010


Package: mysql-server-5.1
Version: 5.1.41-3
Severity: normal

Hi,

> #table_cache            = 64

This should be table_open_cache, see http://dev.mysql.com/doc/refman/5.1-maria/en/server-system-variables.html#sysvar_table_open_cache
Could you also increase the default to 400, as is standard in 5.5? See http://dev.mysql.com/doc/refman/5.5/en/server-system-variables.html#sysvar_table_open_cache

> key_buffer              = 16M

Could this be increased to 64M? 16M is kinda low on today's systems.

Greetings,

Olaf

-- System Information:
Debian Release: squeeze/sid
  APT prefers testing
  APT policy: (500, 'testing')
Architecture: amd64 (x86_64)

Kernel: Linux 2.6.32-trunk-amd64 (SMP w/2 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-5.1 depends on:
ii  adduser                 3.112            add and remove users and groups
ii  debconf [debconf-2.0]   1.5.28           Debian configuration management sy
ii  libc6                   2.10.2-2         GNU C Library: Shared libraries
ii  libdbi-perl             1.609-1          Perl Database Interface (DBI)
ii  libgcc1                 1:4.4.2-9        GCC support library
ii  libmysqlclient16        5.1.41-3         MySQL database client library
ii  libstdc++6              4.4.2-9          The GNU Standard C++ Library v3
ii  libwrap0                7.6.q-18         Wietse Venema's TCP wrappers libra
ii  lsb-base                3.2-23           Linux Standard Base 3.2 init scrip
ii  mysql-client-5.1        5.1.41-3         MySQL database client binaries
ii  mysql-common            5.1.41-3         MySQL database common files (e.g. 
ii  passwd                  1:4.1.4.2-1      change and administer password and
ii  perl                    5.10.1-9         Larry Wall's Practical Extraction 
ii  psmisc                  22.10-1          utilities that use the proc file s
ii  zlib1g                  1:1.2.3.4.dfsg-3 compression library - runtime

Versions of packages mysql-server-5.1 recommends:
ii  bsd-mailx [mailx]  8.1.2-0.20090911cvs-2 simple mail user agent
ii  heirloom-mailx [ma 12.4-1.1+b1           feature-rich BSD mail(1)
ii  libhtml-template-p 2.9-1                 HTML::Template : A module for usin

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

-- debconf information:
  mysql-server/error_setting_password:
  mysql-server-5.1/nis_warning:
  mysql-server-5.1/really_downgrade: false
  mysql-server-5.1/start_on_boot: true
  mysql-server-5.1/postrm_remove_databases: false
  mysql-server/password_mismatch:
  mysql-server/no_upgrade_when_using_ndb:





More information about the pkg-mysql-maint mailing list