Search Results
https://dev.mysql.com/doc/refman/8.4/en/replication-solutions-switch.html
In a failover situation, all the servers in the group are typically executing the same events from the same binary log file, so changing the source of the events should not affect the structure or integrity of the database, provided that you ... You ...
https://dev.mysql.com/doc/refman/8.4/en/reproducible-test-case.html
If you want to find a statement that crashes mysqld, you should start the server with the general query log enabled as well. When you have gotten a crashed table, stop the mysqld server. For information about steps to take when encountering InnoDB ...
https://dev.mysql.com/doc/refman/8.4/en/show-binary-logs.html
SHOW BINARY LOGS Lists the binary log files on the server. Binary log encryption is active if binlog_encryption=ON is set for the server. Existing binary log files are not encrypted or decrypted if binary log encryption is activated or deactivated ...This statement is used as part of the procedure described in Section 15.4.1.1, “PURGE BINARY LOGS Statement”, that shows how to determine which logs can be ...
https://dev.mysql.com/doc/refman/8.4/en/sql-replication-statements.html
Statements are split into a group which controls source servers, a group which controls replica servers, and a group which can be applied to any replication servers. Replication can be controlled through the SQL interface using the statements ...
https://dev.mysql.com/doc/refman/8.4/en/stored-programs-defining.html
By default, mysql itself recognizes the semicolon as a statement delimiter, so you must redefine the delimiter temporarily to cause mysql to pass the entire stored program definition to the server. The delimiter is changed to // to enable the entire ... Each stored program contains a body that consists of an SQL ...
https://dev.mysql.com/doc/refman/8.4/en/symbolic-links-to-databases.html
On Unix, symlink a database using this procedure: Create the database using CREATE DATABASE: mysql> CREATE DATABASE mydb1; Using CREATE DATABASE creates the database in the MySQL data directory and permits the server to update the data dictionary ...Move the database directory to some disk where you have free ...
https://dev.mysql.com/doc/refman/8.4/en/sys-processlist.html
The MySQL process list indicates the operations currently being performed by the set of threads executing within the server. For MySQL Community Edition Server, MySQL Enterprise Edition Server (on-premise), and MySQL HeatWave Service without MySQL ...They provide more complete information than the SHOW PROCESSLIST statement and the INFORMATION_SCHEMA PROCESSLIST table, and are also ...
https://dev.mysql.com/doc/refman/8.4/en/sys-version.html
This view provides the current sys schema and MySQL server versions. For example, use the VERSION() function to retrieve the MySQL server version. Note This view is deprecated, and subject to removal in a future MySQL version. Applications that use ...
https://dev.mysql.com/doc/refman/8.4/en/tutorial.html
mysql (sometimes referred to as the “terminal monitor” or just “monitor”) is an interactive program that enables you to connect to a MySQL server, run queries, and view the results. To see a list of options provided by mysql, invoke it with ... This chapter provides a tutorial introduction to MySQL by showing how to use the mysql client program to create and use a simple ...
https://dev.mysql.com/doc/refman/8.4/en/uln-installation.html
Both Community and Commercial packages are supported, and each offers three MySQL channels: Server: MySQL Server Connectors: MySQL Connector/C++, MySQL Connector/J, MySQL Connector/ODBC, and MySQL Connector/Python. Once MySQL has been installed ...