List:Internals« Previous MessageNext Message »
From:Antony T Curtis Date:April 13 2012 2:52pm
Subject:Re: MySQL Audit Function
View as plain text  
Oh cool! There is less missing now.


On Apr 12, 2012, at 3:30 PM, Paul DuBois wrote:

> 
> 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