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-status-variable-tables.html
The MySQL server maintains many status variables that provide information about its operation (see Section 7.1.10, “Server Status Variables”). Status variable information is available in these Performance Schema tables: global_status: Global ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-system-variable-tables.html
The MySQL server maintains many system variables that indicate how it is configured (see Section 7.1.8, “Server System Variables”). persisted_variables: Provides a SQL interface to the mysqld-auto.cnf file that stores persisted global system ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-thread-filtering.html
The threads table contains a row for each server thread. Each row contains information about a thread and indicates whether monitoring is enabled for it. For the Performance Schema to monitor a thread, these things must be true: The ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-transaction-summary-tables.html
Example transaction event summary information: mysql> SELECT * FROM performance_schema.events_transactions_summary_global_by_event_name LIMIT 1\G *************************** 1. row *************************** EVENT_NAME: transaction COUNT_STAR: 5 ...
https://dev.mysql.com/doc/refman/8.0/en/permission-optimization.html
Simplifying the privileges established by GRANT statements enables MySQL to reduce permission-checking overhead when clients execute statements. The more complex your privilege setup, the more overhead applies to all SQL statements. For example, if ...
https://dev.mysql.com/doc/refman/8.0/en/programs-client.html
This section describes client programs that connect to the MySQL server.
https://dev.mysql.com/doc/refman/8.0/en/programs-installation.html
The programs in this section are used when installing or upgrading MySQL.
https://dev.mysql.com/doc/refman/8.0/en/programs-server.html
This section describes mysqld, the MySQL server, and several programs that are used to start the server.
https://dev.mysql.com/doc/refman/8.0/en/replication-configuration.html
This section describes how to configure the different types of replication available in MySQL and includes the setup and configuration required for a replication environment, including step-by-step instructions for creating a new replication ...For ...
https://dev.mysql.com/doc/refman/8.0/en/replication-features-charset.html
The following applies to replication between MySQL servers that use different character sets: If the source has databases with a character set different from the global character_set_server value, you should design your CREATE TABLE statements so ...A good workaround is to state the character set and collation explicitly in CREATE TABLE ...