Re: [Maria-discuss] Event types in performance schema

Hi, Rhys.Campbell! On Jun 07, Rhys.Campbell@swisscom.com wrote:

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.

No, these are _sql statements_. So, statement/sql/commit event happens when you issue an SQL statement "COMMIT", it does not include any other SQL statements. Regards, Sergei Chief Architect MariaDB and security@mariadb.org