新手求救数据库问题
按照军哥的优化后。数据库出问题了。提示日志如下：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:26InnoDB: Initializing buffer pool, size = 16.0M
130108 12:57:26InnoDB: Completed initialization of buffer pool
130108 12:57:26InnoDB: Started; log sequence number 0 44233
130108 12:57:26 /usr/local/mysql/libexec/mysqld: unknown variable 'query_cache _size=32M'
130108 12:57:26 Aborting
130108 12:57:26InnoDB: Starting shutdown...
130108 12:57:31InnoDB: Shutdown completed; log sequence number 0 44233
130108 12:57:31 /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:48InnoDB: Initializing buffer pool, size = 16.0M
130108 13:00:48InnoDB: Completed initialization of buffer pool
130108 13:00:48InnoDB: Started; log sequence number 0 44233
130108 13:00:48 /usr/local/mysql/libexec/mysqld: unknown variable 'query_cache _size=32M'
130108 13:00:48 Aborting
130108 13:00:48InnoDB: Starting shutdown...
130108 13:00:53InnoDB: Shutdown completed; log sequence number 0 44233
130108 13:00:53 /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 编辑 ] 按日志是query_cache _size = 32M 这个里cache后面多加了一个空格
如果修正后还是2002 论坛里搜索按原来提供的方法排查 谢谢军哥。我看看。:victory:
页:
[1]