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