maria-discuss team mailing list archive

[<Rhys.Campbell@xxxxxxxxxxxx>]

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