[Maria-discuss] Event types in performance schema
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
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
participants (2)
-
Rhys.Campbell@swisscom.com
-
Sergei Golubchik