473,320 Members | 1,865 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

MySQL Slow Log ERROR

In my.cnf

i add these lines

#######
log-bin
log-slow-queries = /var/log/mysqld-slow.log
long_query_time=1
#######

But I can't use slow-log
cause i see mysqld.log
i found

########
070211 20:04:25 mysqld started
^G/usr/libexec/mysqld: File '/var/log/mysqld-slow.log' not found
(Errcode: 13)
070211 20:04:25 [ERROR] Could not use /var/log/mysqld-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.
/usr/libexec/mysqld: ready for connections.
Version: '4.1.20-log' socket: '/var/lib/mysql/mysql.sock' port: 0
Source distribution
########
but in the directory /var/log i have "mysqld-slow.log" file
Anyone can help me ?
Thank you very much
Prat.
PS. /var/log/

[root@ict log]# ls -l
total 1192
-rw-r----- 1 root root 1037 Feb 9 22:52 acpid
-rw------- 1 root root 15041 Feb 9 18:50 anaconda.log
-rw------- 1 root root 23671 Feb 9 18:50 anaconda.syslog
-rw------- 1 root root 41403 Feb 9 18:50 anaconda.xlog
drwxr-x--- 2 root root 4096 Apr 20 2006 audit
-rw------- 1 root root 1144 Feb 11 20:04 boot.log
-rw------- 1 root root 32335 Feb 11 04:03 boot.log.1
drwxr-xr-x 2 clamav clamav 4096 Feb 11 18:23 clamav
-rw------- 1 root root 49761 Feb 11 21:55 cron
-rw------- 1 root root 90791 Feb 11 04:03 cron.1
drwxr-xr-x 2 lp sys 4096 Feb 11 04:03 cups
-rw-r--r-- 1 root root 17238 Feb 9 22:51 dmesg
drwxr-xr-x 2 root root 4096 Feb 9 18:54 gdm
drwx------ 2 root root 4096 Feb 11 16:11 httpd
-r-------- 1 root root 146584 Feb 11 21:39 lastlog
drwx------ 2 root root 16384 Feb 10 01:34 lost+found
drwxr-xr-x 2 root root 4096 Feb 9 18:38 mail
-rw------- 1 root root 7898 Feb 11 21:30 maillog
-rw------- 1 root root 13381 Feb 11 04:03 maillog.1
-rw------- 1 root root 9139 Feb 11 21:39 messages
-rw------- 1 root root 213732 Feb 11 04:03 messages.1
-rw-r--r-- 1 root root 20448 Feb 11 21:50 mrtg.log
-rw-r----- 1 mysql mysql 7970 Feb 11 20:04 mysqld.log
-rw-r--r-- 1 mysql mysql 0 Feb 11 19:44 mysqld-slow.log
drwx------ 2 root root 4096 Nov 2 2004 ppp
-rw-r--r-- 1 root root 34155 Feb 10 04:02 prelink.log
-rw-r--r-- 1 root root 22816 Feb 11 04:03 rpmpkgs
-rw-r--r-- 1 root root 22816 Feb 10 04:02 rpmpkgs.1
drwx------ 2 root root 4096 Jul 11 2006 samba
-rw-r--r-- 1 root root 63050 Feb 9 18:43 scrollkeeper.log
-rw------- 1 root root 3352 Feb 11 21:39 secure
-rw------- 1 root root 4746 Feb 10 18:04 secure.1
-rw-r--r-- 1 root root 160 Feb 11 04:10 snmpd.log
-rw-r--r-- 1 root root 210 Feb 11 04:03 snmpd.log.1
-rw------- 1 root root 0 Feb 11 04:03 spooler
-rw------- 1 root root 0 Feb 9 18:36 spooler.1
drwxr-x--- 2 squid squid 4096 Nov 23 2005 squid
drwxr-xr-x 2 root root 4096 Oct 5 2004 vbox
-rw------- 1 root root 5067 Feb 11 18:04 vsftpd.log
-rw-rw-r-- 1 root utmp 90240 Feb 11 21:39 wtmp
-rw-r--r-- 1 root root 42734 Feb 9 19:23 Xorg.0.log
-rw-r--r-- 1 root root 34730 Feb 9 19:18 Xorg.0.log.old

Feb 11 '07 #1
0 4422

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

5
by: Stuart Mueller | last post by:
I have a mySQL database, called clients it has a single table called client with 2325 records in it. It was originally an Access database but I have exported it to mySQL. I have created a system...
0
by: Mike Chirico | last post by:
Interesting Things to Know about MySQL Mike Chirico (mchirico@users.sourceforge.net) Copyright (GPU Free Documentation License) 2004 Last Updated: Mon Jun 7 10:37:28 EDT 2004 The latest...
0
by: Plymouth Acclaim | last post by:
Hi guys, We have a problem with Dual AMD64 Opteron/MySQL 4.0.18/Mandrake 10 for a very high volume site. We are evaluating the performance on our new server AMD64 and it seems it's slow compared...
11
by: DJJ | last post by:
I am using the MySQL ODBC 3.51 driver to link three relatively small MySQL tables to a Microsoft Access 2003 database. I am finding that the data from the MySQL tables takes a hell of a long time...
1
by: jlee | last post by:
I'm pretty much a newbie on mysql, and I need some help. I am running mysql Ver 12.22 Distrib 4.0.24, for portbld-freebsd5.4 (i386) on a server hosting an active website. The site's developer...
1
by: Ike | last post by:
Recently, I began using a different MySQL verver (i.e. different machine as well as different version#, going from 4.12a to 4.1.9 max). The following query used to work: select firstname,...
1
by: PowerLifter1450 | last post by:
I've been having a very rough time installinig mySQL on Linux. I have been following the instructions form here: http://www.hostlibrary.com/installing_apache_mysql_php_on_linux Everytime I get to...
0
by: Chrom_ | last post by:
Mysql is filling my /var partition because the log limit doesn't seem to be respected. I've tried many different settings in /etc/mysql/my.cnf but nothing works. Logrotate is not...
2
by: mezise | last post by:
Posted by Pratchaya: ------------------------------------------------------ MySQL Slow Log ERROR In my.cnf i add these lines ####### log-bin log-slow-queries = /var/log/mysqld-slow.log
0
by: DolphinDB | last post by:
The formulas of 101 quantitative trading alphas used by WorldQuant were presented in the paper 101 Formulaic Alphas. However, some formulas are complex, leading to challenges in calculation. Take...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
0
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.