audit_record_cmds Type

[schochang]

Dear All
Are there have any documents to indicate what other command can be audit beside update, delete , insert. I know I can find out a lot in the audit files, but I like to have a formal documents instead of look from a huge audit file.

Thanks
Paul

[glicht]

Hi Paul,

We are getting the command names from MySQL. In general the best place to get the full list of commands is from the MySQL source code as it is may be different between versions.

We get the commands from the array command_name defined at: sql_parse.cc. If the command is a Query then we get the exact sql command from the array com_status_vars defined at: mysqld.cc.

Hope this clarifies things for you.

Guy

[schochang]

Hi Guy,
This is exactly source I am looking for, Thank you for your help. I had been looking for it a long time.

Thank again.
Paul