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: | |
| 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
[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.