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

_______________________________________________
Mailing list: https://launchpad.net/~maria-discuss
Post to     : [email protected]
Unsubscribe : https://launchpad.net/~maria-discuss
More help   : https://help.launchpad.net/ListHelp

Reply via email to