Re: Changing tmpdir causes InnoDB to break

[Emma Griffiths]

... my My.cnf contains

[client]
port = 3306
socket = /var/run/mysqld/mysqld.sock

[mysqld_safe]
socket = /var/run/mysqld/mysqld.sock
nice = 0

[mysqld]
user = mysql
pid_file = /var/run/mysqld/mysqld.pid
socket = /var/run/mysqld/mysqld.sock
port = 3306
basedir = /usr
datadir = /databases/mysql
tmpdir = /tmp
language = /usr/share/mysql/english
skip-external-locking

key_buffer = 256M
max_allowed_packet = 1M
thread_stack = 128K
thread_cache_size = 8
tmp_table_size = 1000000000 (1GB - is this too small for my huge tables?)

myisam-recover =BACKUP
table_cach = 256
query_cache_limit = 1M
query_cache_size = 16M

expire_logs_days = 10
max_binlog_size = 100M

skip-bdb

innodb_buffer_pool_size = 512M

skip_federated

[mysqldump]
quick
quote-names
max_allowed_packet =16M

[mysql]

[isamchk]
key_buffer =16M