RE: Enabling Logging of Slow Queries
i think the server does not run with privileges to write to /root regards Sven Huster Senior IT Systems Engineer Sven Huster Senior IT Systems Engineer -Original Message- From: Ryan Shrout [mailto:[EMAIL PROTECTED]] Sent: 30 August, 2001 20:51 To: [EMAIL PROTECTED] Subject: Enabling Logging of Slow Queries I have tried to enable slow query logging for a couple days now, with no success. I have tried adding the line to the my.cnf file as well as stoppign the service then starting it with the command line version. Both ways, the server refuses to restart. I have checked the syntax over and over and I think I have it correct! [mysqld] log-slow-queries=/root/slow-queries.log and /etc/usr/bin/safe_mysqld --log-slow-queries=/root/slow-queries.log Either way, the server will not start. I take the line out and it works again. What am I doing wrong? Ryan Shrout Owner - Amdmb.com http://www.amdmb.com/ [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Enabling Logging of Slow Queries
Hi Ryan, Did you look in you hostname.err file for the error at the end of the file? Are you running the mysql daemon as root? Could it be the user you are running mysqld as does not have permission to write to /root? The .err file by default is in the directory with your other logs (on my system /usr/local/var/picard.icarz.com.err ). Either tail or cat the file and look at the error on the end. Best of luck Ken - Original Message - From: Ryan Shrout [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, August 30, 2001 2:50 PM Subject: Enabling Logging of Slow Queries I have tried to enable slow query logging for a couple days now, with no success. I have tried adding the line to the my.cnf file as well as stoppign the service then starting it with the command line version. Both ways, the server refuses to restart. I have checked the syntax over and over and I think I have it correct! [mysqld] log-slow-queries=/root/slow-queries.log and /etc/usr/bin/safe_mysqld --log-slow-queries=/root/slow-queries.log Either way, the server will not start. I take the line out and it works again. What am I doing wrong? Ryan Shrout Owner - Amdmb.com http://www.amdmb.com/ [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Enabling Logging of Slow Queries
On Thu, Aug 30, 2001 at 02:50:47PM -0400, Ryan Shrout wrote: I have tried to enable slow query logging for a couple days now, with no success. I have tried adding the line to the my.cnf file as well as stoppign the service then starting it with the command line version. Both ways, the server refuses to restart. I have checked the syntax over and over and I think I have it correct! [mysqld] log-slow-queries=/root/slow-queries.log Is mysqld running owned by root? No? Then mysql will have no right to write to /root. Mine runs as mysql. -- Any technology distinguishable from magic is insufficiently advanced. [EMAIL PROTECTED] TopQuark Software Serv. Contract programmer, server bum. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php