| 1 |
INSTALL PLUGIN null_audit SONAME 'adt_null.so'; |
| 2 |
INSTALL COMPONENT "file://component_test_audit_api_message"; |
| 3 |
SET @@null_audit_event_order_check = 'MYSQL_AUDIT_COMMAND_START;command_id="3";;' |
| 4 |
'MYSQL_AUDIT_PARSE_PREPARSE;;;' |
| 5 |
'MYSQL_AUDIT_PARSE_POSTPARSE;;;' |
| 6 |
'MYSQL_AUDIT_GENERAL_LOG;;;' |
| 7 |
'MYSQL_AUDIT_QUERY_START;sql_command_id="0";;' |
| 8 |
'MYSQL_AUDIT_MESSAGE_USER;component="test_audit_api_message" producer="test_audit_api_message" message="test_audit_api_message_user" key[0]="my_string_key" value[0]="my_string_value";;' |
| 9 |
'MYSQL_AUDIT_QUERY_STATUS_END;sql_command_id="0";;' |
| 10 |
'MYSQL_AUDIT_GENERAL_RESULT;;;' |
| 11 |
'MYSQL_AUDIT_GENERAL_STATUS;;;' |
| 12 |
'MYSQL_AUDIT_COMMAND_END;command_id="3";;'; |
| 13 |
SELECT test_audit_api_message_user(); |
| 14 |
test_audit_api_message_user() |
| 15 |
0 |
| 16 |
SELECT @@null_audit_event_order_check; |
| 17 |
@@null_audit_event_order_check |
| 18 |
EVENT-ORDER-OK |
| 19 |
UNINSTALL COMPONENT "file://component_test_audit_api_message"; |
| 20 |
UNINSTALL PLUGIN null_audit; |
| 21 |
Warnings: |
| 22 |
Warning 1620 Plugin is busy and will be uninstalled on shutdown |