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/innodb-persistent-stats.html
In this case innodb_stats_persistent_sample_pages should be decreased until ANALYZE TABLE execution time is acceptable. To avoid this scenario, innodb_stats_include_delete_marked can be enabled to ensure that delete-marked records are included when ... The persistent optimizer statistics feature improves plan stability by storing statistics to disk and making them persistent across server restarts so that the optimizer is more likely to make consistent choices each time for a given ...
https://dev.mysql.com/doc/refman/8.0/en/linux-installation-rpm.html
Be aware that they may differ from those built by Oracle in features, capabilities, and conventions (including communication setup), and that the installation instructions in this manual do not necessarily apply to them. For example, to install ...
https://dev.mysql.com/doc/refman/8.0/en/linux-installation-yum-repo.html
This is a typical entry for a MySQL 8.0 subrepository: [mysql80-community] name=MySQL 8.0 Community Server baseurl=http://repo.mysql.com/yum/mysql-8.0-community/el/9/$basearch/ enabled=1 gpgcheck=1 ...MySQL 8.0 must be manually enabled via your ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-ndbd-definition.html
The only mandatory parameter is HostName; this must be defined in the local [ndbd] section. Information about configuration parameters specific to NDB Cluster Disk Data tables can be found later in this section (see Disk Data Configuration ... The ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-programs-ndb-restore.html
ndb_restore cannot be used to re-create the table with a different definition from the original; this means that you must either create the table manually, or alter the columns which you wish to promote using ALTER TABLE after restoring the table ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-replication-failover.html
This means that the ndb_apply_status table contains information for the replica on this host as well as for any other host which acts as a replica of the replication source server running on this host. You can retrieve this list as ... In the event ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-replication-issues.html
This message is available in the output of SHOW REPLICA STATUS (prior to NDB 8.0.22, use SHOW SLAVE STATUS), and indicates that the SQL thread has stopped due to an incident registered in the replication stream, and that manual intervention is ...A ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-upgrade.html
If the table cannot be repaired, see Section 3.14, “Rebuilding or Repairing Tables or Indexes” for manual table repair strategies. To correct this, reset the root password to unexpire it and run mysql_upgrade again. For details about what this ... Note As of MySQL 8.0.16, the MySQL server performs the upgrade tasks previously handled by mysql_upgrade (for details, see Section 3.4, “What the MySQL Upgrade Process ...
https://dev.mysql.com/doc/refman/8.0/en/replica-logs-status.html
The metadata in this repository includes the connection configuration, the replication user account details, the SSL settings for the connection, and the file name and position where the replication receiver thread is currently reading from the ...
https://dev.mysql.com/doc/refman/8.0/en/replication-binlog-encryption-key-rotation.html
When you rotate the binary log master key manually, MySQL Server takes the following actions in sequence: A new binary log encryption key is generated with the next available sequence number, stored on the keyring, and used as the new binary log ...