MySQL Activity Loggin

Home

Help

	Welcome, Guest. Please login or register.	February 12, 2012, 07:20:29 AM
		Login with username, password and session length

Home (Index)

Level 1 Cache: General Discussion

All Things Database

MySQL Activity Loggin

Pages: [1]

« previous next »

Author

Topic: MySQL Activity Loggin (Read 835 times)

DangerMouse

Expert

Offline

Posts: 238

MySQL Activity Loggin

« on: October 01, 2009, 08:01:55 AM »

Hey all,

I'm looking for a very quick and dirty way of monitoring what queries are run against a MySQL database, and who runs those queries - is there anything available by default that can help me out with this?

Cheers,

DM


	Logged

vsloathe

vim ftw!
Global Moderator
Lifer

Offline

Posts: 1669

Re: MySQL Activity Loggin

« Reply #1 on: October 01, 2009, 08:22:50 AM »

http://dev.mysql.com/doc/refman/5.0/en/query-log.html


	Logged

hai

DangerMouse

Expert

Offline

Posts: 238

Re: MySQL Activity Logging

« Reply #2 on: October 01, 2009, 09:05:02 AM »

Great thanks VS

DM


	Logged

perkiset

Olde World Hacker
Administrator
Lifer

Offline

Posts: 9792

Re: MySQL Activity Loggin

« Reply #3 on: October 01, 2009, 02:21:43 PM »

Yikes. I don't even like the sound of why you'd want to know that.

Good luck, hope I'm completely wrong.


	Logged

It is now believed, that after having lived in one compound with 3 wives and never leaving the house for 5 years, Bin Laden called the U.S. Navy Seals himself.

qweqwe

Rookie

Offline

Posts: 14

Re: MySQL Activity Loggin

« Reply #4 on: January 12, 2010, 07:24:02 PM »