Search Results
https://dev.mysql.com/doc/refman/8.4/en/partitioning-handling-nulls.html
DROP PARTITION, see Section 15.1.9, “ALTER TABLE Statement”.) NULL is also treated in this way for partitioning expressions that use SQL functions. Partitioning in MySQL does nothing to disallow NULL as the value of a partitioning expression, ...
https://dev.mysql.com/doc/refman/8.4/en/partitioning-info.html
Methods of obtaining such information include the following: Using the SHOW CREATE TABLE statement to view the partitioning clauses used in creating a partitioned table. Using the SHOW TABLE STATUS statement to determine whether a table is ... This ...
https://dev.mysql.com/doc/refman/8.4/en/processlist-access.html
Info indicates the statement the thread is executing, or NULL if it is executing no statement. For SHOW PROCESSLIST, this value contains only the first 100 characters of the statement. To see complete statements, use SHOW FULL PROCESSLIST (or query ... The following discussion enumerates the sources of process information, the privileges required to see process information, and describes the content of process list ...
https://dev.mysql.com/doc/refman/8.4/en/replication-features-memory.html
To replicate this effect to replicas, the first time that the source uses a given MEMORY table after startup, it logs an event that notifies replicas that the table must be emptied by writing a DELETE or TRUNCATE TABLE statement for that table to ...
https://dev.mysql.com/doc/refman/8.4/en/replication-features-truncate.html
TRUNCATE TABLE is normally regarded as a DML statement, and so would be expected to be logged and replicated using row-based format when the binary logging mode is ROW or MIXED. However this caused issues when logging or replicating, in STATEMENT ...
https://dev.mysql.com/doc/refman/8.4/en/replication-gtids-assign-anon.html
You can enable GTID assignment on a replication channel using the ASSIGN_GTIDS_TO_ANONYMOUS_TRANSACTIONS option of the CHANGE REPLICATION SOURCE TO statement. The SOURCE_LOG_FILE and SOURCE_LOG_POS options of the CHANGE REPLICATION SOURCE TO ... You ...
https://dev.mysql.com/doc/refman/8.4/en/replication-howto.html
When you are using MyISAM, you must stop processing statements on the source to obtain a read-lock, then obtain its current binary log coordinates and dump its data, before permitting the source to continue executing statements. If you do not stop ... This section describes how to set up a MySQL server to use binary log file position based ...
https://dev.mysql.com/doc/refman/8.4/en/replication-mode-change-online-disable-gtids.html
The file and channel names are strings; both of these must be quoted when used in the STOP REPLICA, CHANGE REPLICATION SOURCE TO, and START REPLICA statements. On each server, execute the following statement: SET @@global.gtid_mode = ON_PERMISSIVE; ... This section describes how to disable GTID transactions on servers that are already ...
https://dev.mysql.com/doc/refman/8.4/en/replication-solutions-unexpected-replica-halt.html
In all other cases, including DDL statements that are not fully atomic, and exempted storage engines that do not support atomic DDL, the mysql.slave_relay_log_info table might be missing updates associated with replicated data if the server halts ...
https://dev.mysql.com/doc/refman/8.4/en/resetting-permissions.html
If you know the root password and want to change it, see Section 15.7.1.1, “ALTER USER Statement”, and Section 15.7.1.10, “SET PASSWORD Statement”. Create a text file containing the password-assignment statement on a single line. Create a ...