Search Results
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 ...
https://dev.mysql.com/doc/refman/8.4/en/stored-routines-metadata.html
Use the SHOW CREATE PROCEDURE and SHOW CREATE FUNCTION statements to see routine definitions. Use the SHOW PROCEDURE STATUS and SHOW FUNCTION STATUS statements to see routine characteristics. Use the SHOW PROCEDURE CODE and SHOW FUNCTION CODE ... To ...
https://dev.mysql.com/doc/refman/8.4/en/time-zone-support.html
Initially, the session variable takes its value from the global time_zone variable, but the client can change its own time zone with this statement: SET time_zone = timezone; The session time zone setting affects display and storage of time values ... This section describes the time zone settings maintained by MySQL, how to load the system tables required for named time support, how to stay current with time zone changes, and how to enable leap-second ...
https://dev.mysql.com/doc/refman/8.4/en/x-plugin-system-monitoring.html
Monitoring SQL Generated by X Plugin This section describes how to monitor the SQL statements which X Plugin generates when you run X DevAPI operations. When you execute a CRUD statement, it is translated into SQL and executed against the server.
https://dev.mysql.com/doc/mysql-enterprise-backup/8.4/en/mysqlbackup.privileges.html
PROCESS, to process DDL statements with the ALGORITHM = INPLACE clause. The mysqlbackup command connects to the MySQL server using the credentials supplied with the --user and --password options. You can either create a new user with a limited set ...
https://dev.mysql.com/doc/c-api/8.4/en/mysql-real-connect.html
CLIENT_MULTI_RESULTS: Tell the server that the client can handle multiple result sets from multiple-statement executions or stored procedures. CLIENT_MULTI_STATEMENTS: Tell the server that the client may send multiple statements in a single string ... MYSQL * mysql_real_connect(MYSQL *mysql, const char *host, const char *user, const char *passwd, const char *db, unsigned int port, const char *unix_socket, unsigned long client_flag) Description Note mysql_real_connect() is a synchronous ...
https://dev.mysql.com/doc/c-api/8.4/en/mysql-set-server-option.html
Option Description MYSQL_OPTION_MULTI_STATEMENTS_ON Enable multiple-statement support MYSQL_OPTION_MULTI_STATEMENTS_OFF Disable multiple-statement support If you enable multiple-statement support, you should retrieve results from calls to ... int ...