@dzysyakFeb 10.2009 — #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.
@chazzyFeb 10.2009 — #no, it's something controlled by the server. i'd be surprised that a shared host wouldn't enable this by default, as a way of yelling at its users that the queries are too long. what is it you're trying to get from the query log?