I am having problems with mysql loggin slow queries. I have set up mysql.sh like this
log_dir=/home/admin/slow_slog.log $bindir/safe_mysqld --datadir=$datadir --pid-file=$pid_file --log-slow-queri es=$log_dir & That is all I have changed and re started mysql. but no slow_slog.log file has been created. What have I done wrong? And as you can see from the output from status I have 41 slow querys and not a long uptime Uptime: 8963 Threads: 22 Questions: 258529 Slow queries: 41 Opens: 572 Flush tables: 1 Open tables: 562 Queries per second avg: 28.844 Any clues John --------------------------------------------------------------------- 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
