From: Andy Shellam (andy-listsnetworkmail.eu)
Date: Mon Dec 22 2008 - 17:03:04 CST

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

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

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]