PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 297.2Kb
Man Pages (Zip)
- 402.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-consumer-configurations.html
Those consumers can be enabled separately or together to collect event history per thread, globally, or both. The consumer settings in the setup_consumers table form a hierarchy from higher levels to lower. The following discussion describes how ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-event-tables.html
Both tables contains the same data when an event is first seen. For wait, stage, statement, and transaction events, the Performance Schema can monitor and store current events. In addition, when events end, the Performance Schema can store them in ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-instrument-naming.html
An instrument name consists of a sequence of elements separated by '/' characters. Example names: wait/io/file/myisam/log wait/io/file/mysys/charset wait/lock/table/sql/handler wait/synch/cond/mysys/COND_alarm ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-mutex-instances-table.html
By performing queries on both of the following tables, a monitoring application or a DBA can detect bottlenecks or deadlocks between threads that involve mutexes: events_waits_current, to see what mutex a thread is waiting for mutex_instances, to ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-queries.html
If the event tables contain both file and nonfile information, post-filtering is another way to see information only for file events. Pre-filtering limits which event information is collected and is independent of any particular user. By contrast, ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-quick-start.html
This section briefly introduces the Performance Schema with examples that show how to use it. For additional examples, see Section 29.19, “Using the Performance Schema to Diagnose Problems”. To enable or disable it explicitly, start the server ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-rwlock-instances-table.html
The rwlock_instances table lists all the rwlock (read write lock) instances seen by the Performance Schema while the server executes. An rwlock is a synchronization mechanism used in the code to enforce that threads at a given time can have access ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-thread-filtering.html
By default, monitoring and historical event collection are enabled for all new foreground threads because the setup_actors table initially contains a row with '%' for both HOST and USER. The threads table contains a row for each server thread. Each ...
https://dev.mysql.com/doc/refman/8.0/en/perror.html
perror displays the error message for MySQL or operating system error codes. For example, for the ER_WRONG_VALUE_FOR_VAR error, perror understands any of these arguments: 1231, 001231, MY-1231, or MY-001231, or ER_WRONG_VALUE_FOR_VAR. The meaning ...
https://dev.mysql.com/doc/refman/8.0/en/persisted-system-variables.html
A system variable can have a global value that affects server operation as a whole, a session value that affects the current session, or both. The MySQL server maintains system variables that configure its operation. Many system variables are ...