← Back to team overview

maria-discuss team mailing list archive

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.

Chief Architect MariaDB
and security@xxxxxxxxxxx