Though I understand very well that it has been discussed lots of time
before but I don't have time to browse through the previous archives
and dig out the stuff I need. So, guys, I would be thankful if you
could give me your valuable advice that I need right now.
I just need to know
1) What parameters I need to set in my.cnf to
log slow queries so that they stick out conspicuously and get noticed,
and
2) How I can find out from the log that MySQL
creates as a result of 1) as to
which queries are running slow.
mysqlsla is kind of handy...
http://hackmysql.com/mysqlsla
mysqlsla analyzes general, slow, and raw MySQL statement logs. Formerly
called mysqlprofile, the new name reflects what the script really does:
combined MySQL Statement Log Analysis. mysqlsla can read multiple MySQL
general and slow logs (and logs containing raw SQL statements), combine
them, then run various analyses on all the queries.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]