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/optimizing-innodb.html
InnoDB is the storage engine that MySQL customers typically use in production databases where reliability and concurrency are important. This section explains how to optimize database operations for InnoDB tables.
https://dev.mysql.com/doc/refman/8.0/en/password-security-admin.html
MySQL stores passwords for user accounts in the mysql.user system table. Database administrators should use the following guidelines to keep passwords secure. Access to this table should never be granted to any nonadministrative accounts. Account ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-clone-progress-table.html
Note The Performance Schema table described here is available as of MySQL 8.0.17. The clone_progress table has these columns: ID A unique cloning operation identifier in the current MySQL server instance. BEGIN_TIME A timestamp in 'YYYY-MM-DD ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-clone-tables.html
Note The Performance Schema tables described here are available as of MySQL 8.0.17. The Performance Schema clone plugin tables are used only on the recipient MySQL server instance. The following sections describe the Performance Schema tables ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-ndb-sync-pending-objects-table.html
This table provides information about NDB database objects for which mismatches have been detected and which are waiting to be synchronized between the NDB dictionary and the MySQL data dictionary.
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-objects-summary-global-by-type-table.html
row *************************** OBJECT_TYPE: TABLE OBJECT_SCHEMA: mysql OBJECT_NAME: user COUNT_STAR: 14 SUM_TIMER_WAIT: 365567592 MIN_TIMER_WAIT: 1141704 AVG_TIMER_WAIT: 26111769 MAX_TIMER_WAIT: 334783032 ... Example object wait event summary ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-replication-applier-configuration-table.html
Parameters stored in the table can be changed at runtime with the CHANGE REPLICATION SOURCE TO statement (from MySQL 8.0.23) or CHANGE MASTER TO statement (before MySQL 8.0.23). This table shows the configuration parameters that affect transactions ...
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-tls-channel-status-table.html
Connection interface TLS properties are set at server startup, and can be updated at runtime using the ALTER INSTANCE RELOAD TLS statement. The tls_channel_status table (available as of MySQL 8.0.21) provides information about connection interface ...The tls_channel_status table has these columns: CHANNEL The name of the connection interface to which the TLS property row ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-tp-thread-group-state-table.html
Note The Performance Schema table described here is available as of MySQL 8.0.14. Prior to MySQL 8.0.14, use the corresponding INFORMATION_SCHEMA table instead; see Section 28.5.2, “The INFORMATION_SCHEMA TP_THREAD_GROUP_STATE Table”. The ...