新手求救数据库问题

efeikiss

按照军哥的优化后。数据库出问题了。提示日志如下：

[mysqld]
port            = 3306
socket          = /tmp/mysql.sock
skip-external-locking
key_buffer_size = 16M
max_allowed_packet = 1M
table_open_cache = 64
sort_buffer_size = 512K
net_buffer_length = 8K
read_buffer_size = 256K
read_rnd_buffer_size = 512K
myisam_sort_buffer_size = 8M
table_cache = 4096
query_cache _size = 32M
query_cache_type = 1

130108 12:36:49 mysqld_safe mysqld from pid file /usr/local/mysql/var/li531-9.pid ended
130108 12:57:26 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/var
130108 12:57:26  InnoDB: Initializing buffer pool, size = 16.0M
130108 12:57:26  InnoDB: Completed initialization of buffer pool
130108 12:57:26  InnoDB: Started; log sequence number 0 44233
130108 12:57:26 [ERROR] /usr/local/mysql/libexec/mysqld: unknown variable 'query_cache _size=32M'
130108 12:57:26 [ERROR] Aborting

130108 12:57:26  InnoDB: Starting shutdown...
130108 12:57:31  InnoDB: Shutdown completed; log sequence number 0 44233
130108 12:57:31 [Note] /usr/local/mysql/libexec/mysqld: Shutdown complete

130108 12:57:31 mysqld_safe mysqld from pid file /usr/local/mysql/var/li531-9.pid ended
130108 13:00:48 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/var
130108 13:00:48  InnoDB: Initializing buffer pool, size = 16.0M
130108 13:00:48  InnoDB: Completed initialization of buffer pool
130108 13:00:48  InnoDB: Started; log sequence number 0 44233
130108 13:00:48 [ERROR] /usr/local/mysql/libexec/mysqld: unknown variable 'query_cache _size=32M'
130108 13:00:48 [ERROR] Aborting

130108 13:00:48  InnoDB: Starting shutdown...
130108 13:00:53  InnoDB: Shutdown completed; log sequence number 0 44233
130108 13:00:53 [Note] /usr/local/mysql/libexec/mysqld: Shutdown complete

130108 13:00:53 mysqld_safe mysqld from pid file /usr/local/mysql/var/li301-9.pid ended


请问下军哥。这个是怎么回事情。非常感谢

[ 本帖最后由 efeikiss 于 2013-1-8 13:22 编辑 ]

licess

按日志是query_cache _size = 32M 这个里cache后面多加了一个空格

如果修正后还是2002 论坛里搜索按原来提供的方法排查

efeikiss

谢谢军哥。我看看。