Neohapsis is currently accepting applications for employment. For more information, please visit our website www.neohapsis.com or email email@example.com
From: Andy Shellam (andy-listsnetworkmail.eu)
Date: Mon Dec 22 2008 - 17:03:04 CST
> 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.
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql