Search Results
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/reset-persist.html
Removing a persisted system variable causes the variable no longer to be initialized from mysqld-auto.cnf at server startup. On the other hand, because RESET PERSIST does not change variable values, it has no effect on the contents of the ... RESET ...
https://dev.mysql.com/doc/refman/8.4/en/set-statement.html
Descriptions for those forms that are not associated with a specific server capability appear in subsections of this section: SET var_name = value enables you to assign values to variables that affect the operation of the server or clients. SET ...
https://dev.mysql.com/doc/refman/8.4/en/show-binary-log-status.html
SHOW BINARY LOG STATUS This statement provides status information about binary log files on the source server, and requires the REPLICATION CLIENT privilege (or the deprecated SUPER privilege). This is the same as the value for the gtid_executed ...
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/show-create-view.html
MySQL lets you use different sql_mode settings to tell the server the type of SQL syntax to support. However an additional consequence is that comments prior to SELECT are stripped from the definition by the server. SHOW CREATE VIEW view_name This ...
https://dev.mysql.com/doc/refman/8.4/en/show-profile.html
Enable profiling by setting profiling to 1 or ON: mysql> SET profiling = 1; SHOW PROFILES displays a list of the most recent statements sent to the server. The Status values are like the State values displayed by SHOW PROCESSLIST, although there ...
https://dev.mysql.com/doc/refman/8.4/en/show-relaylog-events.html
Note Issuing a SHOW RELAYLOG EVENTS with no LIMIT clause could start a very time- and resource-consuming process because the server returns to the client the complete contents of the relay log (including all statements modifying data that have been ... SHOW RELAYLOG EVENTS [IN 'log_name'] [FROM pos] [LIMIT [offset,] row_count] [channel_option] channel_option: FOR CHANNEL channel Shows the events in the relay log of a ...
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/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 ...