Hi
If you don't mind keeping the general log, you can periodically parse it. I read that MySQL 5.1 (or some later version) will have an option to keep the general log in a table - that will be very handy.
Be careful if you use this option (logging to a table) - while it's an extremely attractive feature, I've read that performance while it's switched on is less than desirable. The 5.1 manual also supports this:
"Currently, logging to tables incurs significantly more server overhead than logging to files. If you enable the general log or slow query log and require highest performance, you should log to files and not to tables."
Hopefully this performance difference will be resolved in future releases of 5.1.
Andy -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org
