List:Internals« Previous MessageNext Message »
From:Paul DuBois Date:April 12 2012 10:30pm
Subject:Re: MySQL Audit Function
View as plain text  
On Feb 5, 2012, at 12:56 PM, Antony T Curtis wrote:

> MySQL 5.5 has some audit functionality.
> 
> http://dev.mysql.com/doc/refman/5.5/en/writing-audit-plugins.html
> 
> However, It's not "all there". If you look at the mysql bk-commits email list at
> around Jan-April 2008, there are additional patches which hook into many parts of MySQL,
> including all the phases of connection and authentication.

So if you compare the URL above to the corresponding one in the 5.6 manual:

http://dev.mysql.com/doc/refman/5.6/en/writing-audit-plugins.html

You'll see that the example audit plugin can track more kinds of events. Compare the two
versions beginning with this paragraph:

"The general descriptor also refers to simple_status, a structure that exposes several
status variables to the SHOW STATUS statement:"

> Regards,
> Antony.
> 
> On 5 Feb, 2012, at 1:28 am, Aruna Karunarathna wrote:
> 
>> I think that MySQL database is suffers from lacking a proper Audit
>> Functionality.
>> I would like to contribute in a way to enable a better audit trail.
>> 
>> Are there any suggestions or a particular group I should added to?

-- 
Paul DuBois
Oracle Corporation / MySQL Documentation Team
Madison, Wisconsin, USA
www.mysql.com

Thread
MySQL Audit FunctionAruna Karunarathna5 Feb
  • Re: MySQL Audit FunctionAntony T Curtis5 Feb
    • Re: MySQL Audit FunctionPaul DuBois12 Apr
      • Re: MySQL Audit FunctionAntony T Curtis13 Apr
        • Re: MySQL Audit FunctionPaul DuBois13 Apr
          • RE: MySQL Audit FunctionRick James18 Apr
            • Re: MySQL Audit FunctionSergei Golubchik18 Apr
  • re: MySQL Audit FunctionMichael Widenius21 Feb
    • Re: re: MySQL Audit FunctionSergei Golubchik22 Feb
      • memcache vs.query_cacheRevathi Rangachari23 Feb
        • re: memcache vs.query_cacheMichael Widenius24 Feb
          • re: memcache vs.query_cacheRevathi Rangachari25 Feb
          • Re: memcache vs.query_cacheRick James27 Feb
            • query_cache_type and Aborted ClientsRevathi Rangachari1 Mar
              • Re: query_cache_type and Aborted ClientsRick James1 Mar
                • Re: query_cache_type and Aborted ClientsRevathi Rangachari5 Mar
                  • Re: query_cache_type and Aborted ClientsRick James5 Mar
                    • have_query_cache and query_cache_typeRevathi Rangachari6 Mar
                      • Re: have_query_cache and query_cache_typeYves Trudeau7 Mar
                • Slow query log file not getting updatedRevathi Rangachari20 Mar
                  • Re: Slow query log file not getting updatedBaron Schwartz21 Mar