- 论坛徽章:
- 0
|
这是我的mysql log
070831 23:56:29 mysqld started
/usr/libexec/mysqld: File '/var/log/mysqld-slow-query.log' not found (Errcode: 13)
070831 23:56:29 [ERROR] Could not use /var/log/mysqld-slow-query.log for logging (error 13). Turning logging off for the whole duration of the MySQL server process. To turn it on again: fix the cause, shutdown the MySQL server and restart it.
070831 23:56:29 InnoDB: Started; log sequence number 0 766160961
/usr/libexec/mysqld: ready for connections.
Version: '4.1.20-log' socket: '/var/lib/mysql/mysql.sock' port: 3306 Source distribution
mysql是centos 4自带的
my.cnf设置
[client]
#password = your_password
port = 3306
socket = /var/lib/mysql/mysql.sock
[mysqld]
port = 3306
socket = /var/lib/mysql/mysql.sock
set-variable = ft_min_word_len=2
skip-locking
key_buffer = 400M
max_allowed_packet = 1M
max_connections = 2048
table_cache = 1024
sort_buffer_size = 64M
read_buffer_size = 16M
read_rnd_buffer_size = 8M
myisam_sort_buffer_size = 64M
thread_cache = 8
query_cache_size = 32M
log-slow-queries = /var/log/mysqld-slow-query.log
long-query-time = 5
log-long-format
log-queries-not-using-indexes
# Try number of CPU's*2 for thread_concurrency
thread_concurrency = 8
back_log=500
interactive_timeout=7200
thread_cache_size=80
wait_timeout=7200
#key_buffer_size
请大侠帮忙看看为啥产生不了log |
|