audit_log plugin contention on libc TZ conversion

Bug #1612650 reported by Laurynas Biveinis
8
This bug affects 1 person
Affects Status Importance Assigned to Milestone
Percona Server moved to https://jira.percona.com/projects/PS
Status tracked in 5.7
5.5
Won't Fix
Wishlist
Unassigned
5.6
Triaged
Wishlist
Unassigned
5.7
Triaged
Wishlist
Unassigned

Bug Description

PMP on a server with audit_log enabled shows the following aggregated stacktrace:

113 __lll_lock_wait_private(libc.so.6),__tz_convert(libc.so.6),audit_log_general_record(audit_log.so),audit_log_notify(audit_log.so),general_class_handler,mysql_audit_notify,dispatch_command,do_handle_one_connection,handle_one_connection,pfs_spawn_thread,start_thread(libpthread.so.0),clone(libc.so.6)

This is caused by UTC timestamp printing in make_timestamp function, the sequence of libc calls time(NULL) -> gmtime_r -> strftime.

tags: added: audit performance
Revision history for this message
Sergei Glushchenko (sergei.glushchenko) wrote :
Revision history for this message
Shahriyar Rzayev (rzayev-sehriyar) wrote :

Percona now uses JIRA for bug reports so this bug report is migrated to: https://jira.percona.com/browse/PS-2481

To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.