Web Hosting Talk







View Full Version : mysql logs?


Lem0nHead
04-15-2004, 01:35 PM
does anyone know how to set mysql to save logs?
i guess i don't have them (no /var/log/my* )

also, is there some tool that logs (maybe analysing mysql logs) users that uses too much mysql resources?
at this time my load is around 3 and i don't know which user is causing this (mysql is the top process)

Lem0nHead
04-15-2004, 01:46 PM
just found mytop: http://jeremy.zawodny.com/mysql/mytop/
very useful

anyway, i still would like to enable logs

GameraFan
04-15-2004, 02:07 PM
http://dev.mysql.com/doc/mysql/en/Query_log.html