If you have a new account but are having problems posting or verifying your account, please email us on hello@boards.ie for help. Thanks :)

Hello all! Please ensure that you are posting a new thread or question in the appropriate forum. The Feedback forum is overwhelmed with questions that are having to be moved elsewhere. If you need help to verify your account contact hello@boards.ie

Anyway to see the log of MySQL queries?

AARRRGH · 2008-01-21 13:59:42

Hello If I run the command - watch -n 1 "uptime; free -m; mysqladmin processlist " - I'm able to see the SQL queries which are currently running on my server, but the end of the queries are getting truncated. Is there any log where I can see which queries have been/are being executed? I've Googled for this but there isn't…

Options

21-01-2008 2:59pm

#1

AARRRGH

Closed Accounts Posts: 12,382 ✭✭✭✭

Join Date: July 2004

Posts: 11798

Hello

If I run the command -

watch -n 1 "uptime; free -m; mysqladmin processlist "

- I'm able to see the SQL queries which are currently running on my server, but the end of the queries are getting truncated.

Is there any log where I can see which queries have been/are being executed?

I've Googled for this but there isn't really any information for viewing MySQL logs.

Thanks!

0

Comments

Options
#2 21-01-2008 3:34pm
wheres me jumpa

Registered Users Posts: 4,478 ✭✭✭

Join Date: July 2004

Posts: 4094

Im not sure but I thought when I installed MySQL locally, it stored logs in a temp folder on the C drive.

0
Options
#3 21-01-2008 4:18pm
cgarvey

Registered Users Posts: 3,886 ✭✭✭

Join Date: April 2002

Posts: 3749

http://dev.mysql.com/doc/refman/5.0/en/query-log.html
It can get big though!

0