The above query together with this config crashes the server.

# egrep -v "^($|#)" /etc/mysql/my.cnf 
[client]
port            = 3306
socket          = /var/run/mysqld/mysqld.sock
[mysqld_safe]
socket          = /var/run/mysqld/mysqld.sock
nice            = 0
core-file-size  = unlimited
[mysqld]
core-file
user            = mysql
pid-file        = /var/run/mysqld/mysqld.pid
socket          = /var/run/mysqld/mysqld.sock
port            = 3306
basedir         = /usr
datadir         = /export/mysql
tmpdir          = /tmp
language        = /usr/share/mysql/english
skip-external-locking
old_passwords   = 1
bind-address            = 0.0.0.0
key_buffer              = 128M
max_allowed_packet      = 16M
thread_stack            = 265K
table_cache             = 16M
query_cache_limit       = 1048576
query_cache_size        = 128M
query_cache_type        = 1
log-bin                 = /var/log/mysql/mysql-bin.log
expire-logs-days        = 20
max_binlog_size         = 104857600
skip-bdb
innodb_buffer_pool_size = 64M
[mysqldump]
quick
quote-names
max_allowed_packet      = 16M
[mysql]
[isamchk]
key_buffer              = 16M

-- 
MySQL 5.0.22 Crash on Ubuntu 6.06.2 LTS (SELECT 0+0+0...)
https://bugs.launchpad.net/bugs/394036
You received this bug notification because you are a member of Ubuntu
Server Team, which is subscribed to mysql-dfsg-5.0 in ubuntu.

-- 
Ubuntu-server-bugs mailing list
Ubuntu-server-bugs@lists.ubuntu.com
Modify settings or unsubscribe at: 
https://lists.ubuntu.com/mailman/listinfo/ubuntu-server-bugs

Reply via email to