7 Jun
2016
7 Jun
'16
2:53 p.m.
Hi All, I'm doing some stuff with the performance_Schema and have a quick question about event types. These appear in the events_statements_summary_by_account_by_event_name table (and others) and look like... statement/com/Ping statement/sql/select statement/sql/insert statement/sql/commit statement/sql/update Am I correct in thinking the COMMIT type would be a total of all the events of a transaction. So if we did something like... START TRANSACTION SELECT EVENT UPDATE EVENT INSERT EVENT DELETE EVENT COMMIT The performance_schema would log this as EVENTS for SELECT, UPDATE, INSERT and DELETE individual times. While the COMMIT would be a sum of these times? Cheers, Rhys