MySQL gurus:
I'm a big fan of the general query log for taking the occasional audit
of activity against our database server, as well as a tool for checking
on the efficiency of new (mostly PHP) projects that interact with MySQL.
What I don't like is that I have to stop and restart the server process
twice (once to turn the log on and once to turn it back off) in order to
get the output.
I've read through the documentation at mysql.com and would have searched
through the list archives if I wasn't getting "document contains no
data" messages from lists.mysql.com at the moment.
We use mytop (http://jeremy.zawodny.com/mysql/mytop/) to keep some track
of the queries that are being run, but the output pales in comparison
(for this use) to that from the general query log.
(1) Is there a way to turn logging on for brief periods (no more than
15 minutes) without having to stop and restart?
(2) Is there some way to get similar output with a different tool?
[mysql query]
TIA,
Andy
Andy Ingham
Systems Librarian
Academic Affairs Library
UNC-Chapel Hill
919-962-1288
[EMAIL PROTECTED]
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
