[debian-mysql] Bug#499574: mysql-server-5.0: Cannot change innodb_log_file_size

[Peter Lieverdink]

Package: mysql-server-5.0
Version: 5.0.32-7etch6
Severity: important

I am unable to change the value of innodb_log_file_size from 5Mb to a more useful 
(ie: any other) number.

I logged into the server as root and ran 'set global innodb_fast_shutdown=0'. I 
then shut down the server via the init script and verified it was no longer 
running.

in the [mysqld] section of my.cnf I set innodb_log_file_size=128M and I moved the 
ib_logfile0 and ib_logfile1 out of /var/lib/mysql.

When the server is restarted, ib_logfile0 and ib_logfile1 are re-created (as 
they should) but still with a size of 5Mb, which is not the expected behaviour.

I've tried setting it to 67108864 as well, but the new logfiles that are created 
are still only 5Mb.

Note, this is a Xen domU and the kernel it uses is not a Debian one.

-- System Information:
Debian Release: 4.0
  APT prefers stable
  APT policy: (500, 'stable')
Architecture: amd64 (x86_64)
Shell:  /bin/sh linked to /bin/bash
Kernel: Linux 2.6.19-4-generic-amd64
Locale: LANG=en_AU.UTF-8, LC_CTYPE=en_AU.UTF-8 (charmap=UTF-8)

Versions of packages mysql-server-5.0 depends on:
ii  adduser                3.102             Add and remove users and groups
ii  debconf [debconf-2.0]  1.5.11etch2       Debian configuration management sy
ii  libc6                  2.3.6.ds1-13etch7 GNU C Library: Shared libraries
ii  libdbi-perl            1.53-1etch1       Perl5 database interface by Tim Bu
ii  libgcc1                1:4.1.1-21        GCC support library
ii  libmysqlclient15off    5.0.32-7etch6     mysql database client library
ii  libncurses5            5.5-5             Shared libraries for terminal hand
ii  libreadline5           5.2-2             GNU readline and history libraries
ii  libstdc++6             4.1.1-21          The GNU Standard C++ Library v3
ii  libwrap0               7.6.dbs-13        Wietse Venema's TCP wrappers libra
ii  lsb-base               3.1-23.2etch1     Linux Standard Base 3.1 init scrip
ii  mysql-client-5.0       5.0.32-7etch6     mysql database client binaries
ii  mysql-common           5.0.32-7etch6     mysql database common files (e.g. 
ii  passwd                 1:4.0.18.1-7      change and administer password and
ii  perl                   5.8.8-7etch3      Larry Wall's Practical Extraction 
ii  psmisc                 22.3-1            Utilities that use the proc filesy
ii  zlib1g                 1:1.2.3-13        compression library - runtime

Versions of packages mysql-server-5.0 recommends:
ii  mailx            1:8.1.2-0.20050715cvs-1 A simple mail user agent

-- debconf information excluded