mysqldb can't find slow log
Not sure if this should go in newbie or here.
I'm trying to get the slow queries to log, but the mysqldb process says it can't find it.
Here's an extract from mysqld.log:-
081010 15:05:33 mysqld started
/usr/libexec/mysqld: File '/var/log/mysql/mysql-slow.log' not found (Errcode: 13)
081010 15:05:33 [ERROR] Could not use /var/log/mysql/mysql-slow.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.
I can run the command "touch /var/log/mysql-slow.log" successfully, file attribute is 664
my.cnf contains the following:
[mysqld]
long_query_time = 2
set-variable = max_connections=60
log-slow-queries=/var/log/mysql/mysql-slow.log
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
Syetm is Fedora Core 4, MySQL 4.1.24
Thanks,
Kevin Jones
Subject
Written By
Posted
mysqldb can't find slow log
October 16, 2008 03:56AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.