PDF (US Ltr)
- 41.8Mb
PDF (A4)
- 41.9Mb
Man Pages (TGZ)
- 272.4Kb
Man Pages (Zip)
- 378.4Kb
Info (Gzip)
- 4.2Mb
Info (Zip)
- 4.2Mb
Search Results
https://dev.mysql.com/doc/refman/9.7/en/performance-schema-events-stages-current-table.html
The table stores one row per thread showing the current status of the thread's most recent monitored stage event, so there is no system variable for configuring the table size. Of the tables that contain stage event rows, events_stages_current is ...
https://dev.mysql.com/doc/refman/9.7/en/performance-schema-mutex-instances-table.html
The mutex_instances table lists all the mutexes seen by the Performance Schema while the server executes. A mutex is a synchronization mechanism used in the code to enforce that only one thread at a given time can have access to some common ...
https://dev.mysql.com/doc/refman/9.7/en/performance-schema-obtaining-parent-events.html
Rows of this table have a THREAD_ID column indicating the thread ID of the session that owns the lock, and an EVENT_ID column indicating the Performance Schema event that caused the lock. The relation is based on a nested set data model, so the join ...
https://dev.mysql.com/doc/refman/9.7/en/performance-schema-replication-applier-metrics-table.html
This table provides replication applier statistics such as wait times, wait counts, transaction counts, event counts, and byte counts for the applier coordinator. If the applier is stopped and restarted, then all active periods are summed together.
https://dev.mysql.com/doc/refman/9.7/en/performance-schema-stage-tables.html
The Performance Schema instruments stages, which are steps during the statement-execution process, such as parsing a statement, opening a table, or performing a filesort operation. Stages correspond to the thread states displayed by SHOW ...
https://dev.mysql.com/doc/refman/9.7/en/performance-schema-table-wait-summary-tables.html
The following sections describe the table I/O and lock wait summary tables: table_io_waits_summary_by_index_usage: Table I/O waits per index table_io_waits_summary_by_table: Table I/O waits per table table_lock_waits_summary_by_table: Table lock ...
https://dev.mysql.com/doc/refman/9.7/en/performance-schema-temporary-account-locks-table.html
The temporary_account_locks table lists the users with temporarily locked accounts. The temporary_account_locks table has these columns: USER The user name of the account used. FAILED_LOGIN_ATTEMPTS The number of login attempts, as defined in the ...
https://dev.mysql.com/doc/refman/9.7/en/performance-schema-tp-connections-table.html
The tp_connections table contains one row per connection managed by the Thread Pool plugin. Each row provides information about the current state of a thread pool connection. The tp_connections table contains the following rows: CONNECTION_ID The ...
https://dev.mysql.com/doc/refman/9.7/en/performance-schema-tp-thread-state-table.html
The tp_thread_state table has one row per thread created by the thread pool to handle connections. The tp_thread_state table has these columns: TP_GROUP_ID The thread group ID. TP_GROUP_ID and TP_THREAD_NUMBER together provide a unique key within ...
https://dev.mysql.com/doc/refman/9.7/en/performance-schema-user-defined-functions-table.html
The user_defined_functions table contains a row for each loadable function registered automatically by a component or plugin, or manually by a CREATE FUNCTION statement. For information about operations that add or remove table rows, see Section ...