[debian-mysql] Bug#431825: mysql-server-5.0: tmp dir not correct for replication slaves

Rudy Gevaert rudy.gevaert at ugent.be
Thu Jul 5 08:33:56 UTC 2007

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

The default my.cnf file has for tmp dir /tmp.  However the mysql manual says:

B.1.4.4. Where MySQL Stores Temporary Files

If the MySQL server is acting as a replication slave, you should not set --tmpdir to point to a directory on a memory-based filesystem or to a directory that is cleared when the server host restarts. A replication slave needs some of its temporary files to survive a machine restart so that it can replicate temporary tables or LOAD DATA INFILE operations. If files in the temporary file directory are lost when the server restarts, replication fails.

-- 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
Locale: LANG=C, LC_CTYPE=C (charmap=ANSI_X3.4-1968)

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.11        Debian configuration management sy
ii  libc6                      2.3.6.ds1-13  GNU C Library: Shared libraries
ii  libdbi-perl                1.53-1        Perl5 database interface by Tim Bu
ii  libgcc1                    1:4.1.1-21    GCC support library
ii  libmysqlclient15off        5.0.32-7etch1 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.1      Linux Standard Base 3.1 init scrip
ii  mysql-client-5.0           5.0.32-7etch1 mysql database client binaries
ii  mysql-common               5.0.32-7etch1 mysql database common files (e.g. 
ii  passwd                     1:  change and administer password and
ii  perl                       5.8.8-7       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

More information about the pkg-mysql-maint mailing list