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
