PDF (US Ltr)
- 43.2Mb
PDF (A4)
- 43.3Mb
Man Pages (TGZ)
- 295.2Kb
Man Pages (Zip)
- 400.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-examples.html
Tune a query by writing it differently, Tune the database schema (tables, indexes, and so forth). The Performance Schema is a tool to help a DBA do performance tuning by taking real measurements instead of “wild guesses.” This section ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-instrument-naming.html
For example, the statement/sql/create_db and statement/sql/select instruments are used for CREATE DATABASE and SELECT statements. An instrument name consists of a sequence of elements separated by '/' characters. Example names: ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-metadata-locks-table.html
MySQL uses metadata locking to manage concurrent access to database objects and to ensure data consistency; see Section 10.11.4, “Metadata Locking”. Metadata locking applies not just to tables, but also to schemas, stored programs (procedures, ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-processlist-table.html
DB The default database for the thread, or NULL if none has been selected. The MySQL process list indicates the operations currently being performed by the set of threads executing within the server. For a comparison of this table with other ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-replication-group-member-stats-table.html
Can be thought of as the current size of the conflict detection database against which each transaction is certified. The replication_group_member_stats table has these columns: CHANNEL_NAME Name of the Group Replication channel VIEW_ID Current view ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-statement-digests.html
The MySQL server is capable of maintaining statement digest information. The digesting process converts each SQL statement to normalized form (the statement digest) and computes a SHA-256 hash value (the digest hash value) from the normalized ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-status-variable-summary-tables.html
The Performance Schema makes status variable information available in the tables described in Section 29.12.15, “Performance Schema Status Variable Tables”. It also makes aggregated status variable information available in summary tables, ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-table-descriptions.html
Tables in the performance_schema database can be grouped as follows: Setup tables. The events_waits_current table contains the most recent event for each thread. Other similar tables contain current events at different levels of the event ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-threads-table.html
PROCESSLIST_DB The default database for the thread, or NULL if none has been selected. The threads table contains a row for each server thread. Each row contains information about a thread and indicates whether monitoring and historical event ...
https://dev.mysql.com/doc/refman/8.0/en/platform-support.html
MySQL platform support evolves over time; please refer to https://www.mysql.com/support/supportedplatforms/database.html for the latest updates.