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 Email Updates:
Status: Verified Impact on me:
None 
Category:MySQL Server: Logging Severity:S3 (Non-critical)
Version:5.6.16 OS:Any
Assigned to: 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.

Portions of this website are copyright © 2001, 2002 The PHP Group

Page generated in 0.053 sec. using MySQL 8.4.7-u6-cloud

Timestamp references displayed by the system are UTC.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.