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/replication-threads-monitor-main.html
The State information indicates that all outstanding updates have been sent to the replica and that the source is waiting for more updates to occur. The SHOW PROCESSLIST statement provides information that tells you what is happening on the source ...
https://dev.mysql.com/doc/refman/8.0/en/replication-threads-monitor-worker.html
If an unusually large event exceeds this size, the transaction is held until all the applier worker threads have empty queues, and then processed. On a multithreaded replica, the Performance Schema tables replication_applier_status_by_coordinator ...
https://dev.mysql.com/doc/refman/8.0/en/replication.html
Replication using GTIDs guarantees consistency between source and replica as long as all transactions committed on the source have also been applied on the replica. Replication enables data from one MySQL database server (known as a source) to be ...
https://dev.mysql.com/doc/refman/8.0/en/reset-persist.html
RESET PERSIST [[IF EXISTS] system_var_name] RESET PERSIST removes persisted global system variable settings from the mysqld-auto.cnf option file in the data directory. Removing a persisted system variable causes the variable no longer to be ...
https://dev.mysql.com/doc/refman/8.0/en/reset.html
reset_option: { MASTER | REPLICA | SLAVE } The RESET statement is used to clear the state of various server operations. For information about the RESET PERSIST statement that removes persisted global system variables, see Section 15.7.8.7, “RESET ...
https://dev.mysql.com/doc/refman/8.0/en/row-constructor-optimization.html
Under certain conditions, the optimizer can apply the range access method to IN() expressions that have row constructor arguments. For example, these two statements are semantically equivalent: SELECT * FROM t1 WHERE (column1,column2) = (1,1); ...
https://dev.mysql.com/doc/refman/8.0/en/se-csv-limitations.html
All tables that you create using the CSV storage engine must have the NOT NULL attribute on all columns.
https://dev.mysql.com/doc/refman/8.0/en/selinux-context-mysql-feature-ports.html
If ports used by MySQL features do not have the correct SELinux context, the features might not function correctly. If you enable certain MySQL features, you might need to set the SELinux TCP port context for additional ports used by those features. The following sections describe how to set port contexts for MySQL ...
https://dev.mysql.com/doc/refman/8.0/en/selinux-troubleshooting.html
For example, if you configure MySQL to use a non-default data directory, the directory may not have the expected SELinux context. Troubleshooting SELinux typically involves placing SELinux into permissive mode, rerunning problematic operations, ...
https://dev.mysql.com/doc/refman/8.0/en/server-shutdown.html
For threads that have an open transaction, the transaction is rolled back. The server shutdown process takes place as follows: The shutdown process is initiated. For example, a user with the SHUTDOWN privilege can execute a mysqladmin shutdown ...