MySQL Slow Query Log File
February 17, 2005
MySQL has a feature that allows you to log slow running queries to a file. To enable you just need to add some lines to your my.cnf file, and restart. Add the following:
log-slow-queries = /var/log/mysql/mysql-slow.log long_query_time = 1
The above will log queries taking longer than one second to the specified log file.
You can read more in the MySQL Reference Manual
add to del.icio.us
Trackbacks
Trackback Address: 233/AEB5F2A8AEF38EEEC2701EFE0F9EEFA6
Comments
On 10/02/2006 at 12:05:16 PM EDT Rolando wrote:
1
Regards..
I need catch all id and message avents (1064 You have a error in your SQL syntaxis) from MySQL database, because in the log, log-error the messages is not very good description..
Thanks, Rolando
Post a Comment
Recent Entries
- Cache Template in Request Setting Explained
- What Version of Java is ColdFusion Using?
- ColdFusion 9 Performance Brief from Adobe
- Request Filtering in IIS 7 Howto
- J2EE Session Cookies on ColdFusion / JRun
- Hands on ColdFusion Security Training
- ColdFusion 9 Solr Vulnerability - Are you at Risk?
- FCKEditor Year 2010 Bug for Firefox 3.6 with ColdFusion
I need catch all id and message avents (1064 You have a error in your SQL syntaxis) from MySQL database, because in the log, log-error the messages is not very good description..
Thanks, Rolando
