List:Internals« Previous MessageNext Message »
From:Paul DuBois Date:April 13 2012 4:16pm
Subject:Re: MySQL Audit Function
View as plain text  
In Antony,

"less missing", heh. Faint praise! :-)


On Apr 13, 2012, at 9:52 AM, Antony T Curtis wrote:

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

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