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
The above query together with this config crashes the server.
# egrep -v "^($|#)" /etc/mysql/my.cnf mysqld/ mysqld. sock mysqld/ mysqld. sock mysqld/ mysqld. pid mysqld/ mysqld. sock mysql/english locking mysql/mysql- bin.log buffer_ pool_size = 64M
[client]
port = 3306
socket = /var/run/
[mysqld_safe]
socket = /var/run/
nice = 0
core-file-size = unlimited
[mysqld]
core-file
user = mysql
pid-file = /var/run/
socket = /var/run/
port = 3306
basedir = /usr
datadir = /export/mysql
tmpdir = /tmp
language = /usr/share/
skip-external-
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/
expire-logs-days = 20
max_binlog_size = 104857600
skip-bdb
innodb_
[mysqldump]
quick
quote-names
max_allowed_packet = 16M
[mysql]
[isamchk]
key_buffer = 16M