The Cache: Technology Expert's Forum
 
*
Welcome, Guest. Please login or register. September 19, 2019, 02:48:18 PM

Login with username, password and session length


Pages: [1]
  Print  
Author Topic: MySQL Activity Loggin  (Read 2978 times)
DangerMouse
Expert
****
Offline Offline

Posts: 244



View Profile
« 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 Offline

Posts: 1669



View Profile
« 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 Offline

Posts: 244



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

Great thanks VS

DM
Logged
perkiset
Olde World Hacker
Administrator
Lifer
*****
Offline Offline

Posts: 10096



View Profile
« 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 Offline

Posts: 14


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

<spammer dick go boom>
« Last Edit: January 12, 2010, 08:33:20 PM by nutballs » Logged

No links in signatures please
carlonsame
n00b
*
Offline Offline

Posts: 1


View Profile
« Reply #5 on: November 02, 2011, 05:51:22 PM »

I there there are many ways to monitor queries in MySQL database, Juts do a quick google search !
Logged

Posted By Carlon Same,
african mango scam | zquiet
Pages: [1]
  Print  
 
Jump to:  

Perkiset's Place Home   Best of The Cache   phpMyIDE: MySQL Stored Procedures, Functions & Triggers
Politics @ Perkiset's   Pinkhat's Perspective   
cache
mart
coder
programmers
ajax
php
javascript
Powered by MySQL Powered by PHP Powered by SMF 1.1.2 | SMF © 2006-2007, Simple Machines LLC
Seo4Smf v0.2 © Webmaster's Talks


Valid XHTML 1.0! Valid CSS!