maria-discuss team mailing list archive
-
maria-discuss team
-
Mailing list archive
-
Message #03646
Re: Event types in performance schema
Hi, Rhys.Campbell!
On Jun 07, Rhys.Campbell@xxxxxxxxxxxx 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@xxxxxxxxxxx
References