Bug #71842 Add P_S file instrumentation to the audit log plugin

• Submitted: 26 Feb 2014 12:18
• Modified: 10 Mar 2014 5:11
• Reporter: Daniël van Eeden (OCA)
• Status: Verified
• Category: MySQL Server: Logging
• Severity: S3 (Non-critical)
• Version: 5.6.16
• OS: Any
• CPU Architecture: Any
• Tags: auditlog

[26 Feb 2014 12:18] Daniël van Eeden

Description:
The audit log plugin doesn't seem to have any P_S instrumentation.

Related to: Bug #71840

How to repeat:
select * from events_waits_summary_global_by_event_name where event_name like '%audit%'

select * from file_summary_by_instance where file_name like '%audit%'

Suggested fix:
Add P_S instrumentation

[27 Feb 2014 6:56] Daniël van Eeden

Add auditlog tag

[28 Feb 2014 10:33] Daniël van Eeden

There is some info, but it's not really obvious what they measure.

mysql> select * from events_waits_summary_global_by_event_name where event_name like '%/alog/%';
+-----------------------------------+------------+-----------------+----------------+----------------+----------------+
| EVENT_NAME                        | COUNT_STAR | SUM_TIMER_WAIT  | MIN_TIMER_WAIT | AVG_TIMER_WAIT | MAX_TIMER_WAIT |
+-----------------------------------+------------+-----------------+----------------+----------------+----------------+
| wait/synch/mutex/alog/LOCK_block  |       7074 |       759564542 |          22506 |         107074 |        1445840 |
| wait/synch/mutex/alog/LOCK_reopen |          0 |               0 |              0 |              0 |              0 |
| wait/synch/cond/alog/COND_data    |       2274 | 392049513716597 |              0 |   172405238951 |  1013510086281 |
| wait/synch/cond/alog/COND_space   |          0 |               0 |              0 |              0 |              0 |
| wait/synch/cond/alog/COND_idle    |          0 |               0 |              0 |              0 |              0 |
+-----------------------------------+------------+-----------------+----------------+----------------+----------------+
5 rows in set (0.00 sec)

Also I would expect something like 'wait/io/file/audit_log' for something that can be writing lots of data (and might do so synchronously)

[10 Mar 2014 5:11] MySQL Verification Team

Hello Daniel,

Thank you for the bug report.
Verified as described.

Thanks,
Umesh

[10 Mar 2014 8:39] Marc ALFF

Verified by code review that file io in the audit plugin is not instrumented.

Changing category to Logging.