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-table-characteristics.html
Many tables in the performance_schema database are read only and cannot be modified: mysql> TRUNCATE TABLE performance_schema.setup_instruments; ERROR 1683 (HY000): Invalid performance_schema usage. That might be useful, for example, after you have ... The name of the performance_schema database is lowercase, as are the names of tables within ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-tp-thread-state-table.html
The value shown in this column is one of CONNECTION_HANDLER_WORKER_THREAD, LISTENER_WORKER_THREAD, QUERY_WORKER_THREAD, or TIMER_WORKER_THREAD. The tp_thread_state table has one row per thread created by the thread pool to handle connections. Note ...
https://dev.mysql.com/doc/refman/8.0/en/pluggable-storage.html
MySQL Server uses a pluggable storage engine architecture that enables storage engines to be loaded into and unloaded from a running MySQL server. Plugging in a Storage Engine Before a storage engine can be used, the storage engine plugin shared ...
https://dev.mysql.com/doc/refman/8.0/en/precision-math-rounding.html
This section discusses precision math rounding for the ROUND() function and for inserts into columns with exact-value types (DECIMAL and integer). Such truncation is not an error, even in strict SQL mode (see Section 14.24.3, “Expression ...The ...
https://dev.mysql.com/doc/refman/8.0/en/replication-features-drop-if-exists.html
The DROP DATABASE IF EXISTS, DROP TABLE IF EXISTS, and DROP VIEW IF EXISTS statements are always replicated, even if the database, table, or view to be dropped does not exist on the source. IF EXISTS statements for stored programs (stored ...This ...
https://dev.mysql.com/doc/refman/8.0/en/replication-functions.html
MASTER_POS_WAIT() Block until the replica has read and applied all updates up to the specified position 8.0.26 SOURCE_POS_WAIT() Block until the replica has read and applied all updates up to the specified position 8.0.26 ... The functions described ...
https://dev.mysql.com/doc/refman/8.0/en/replication-howto-repuser.html
Each replica connects to the source using a MySQL user name and password, so there must be a user account on the source that the replica can use to connect. Although you do not have to create an account specifically for replication, you should be ...The user name is specified by the SOURCE_USER | MASTER_USER option of the CHANGE REPLICATION SOURCE TO statement (from MySQL 8.0.23) or CHANGE MASTER TO statement (before MySQL 8.0.23) when you set up a ...
https://dev.mysql.com/doc/refman/8.0/en/replication-multi-source-monitoring.html
The error codes and messages that are issued when multi-source replication is enabled specify the channel that generated the error. row *************************** CHANNEL_NAME: source_1 GROUP_NAME: SOURCE_UUID: 046e41f8-a223-11e4-a975-0811960cc264 ... To monitor the status of replication channels the following options exist: Using the replication Performance Schema ...
https://dev.mysql.com/doc/refman/8.0/en/reproducible-test-case.html
If you encounter corrupted MyISAM tables or if mysqld always fails after some update statements, you can test whether the issue is reproducible by doing the following: Stop the MySQL daemon with mysqladmin shutdown. See Section 7.4.3, “The General ...For information about steps to take when encountering InnoDB table corruption, see Section 1.5, “How to Report Bugs or ...
https://dev.mysql.com/doc/refman/8.0/en/selinux-context-mysql-feature-ports.html
mysqld must be able to bind to the Group Replication communication port and listen there. mysqld must be able to bind to the X Plugin communication port and listen there. If you enable certain MySQL features, you might need to set the SELinux TCP ...