Search Results
https://dev.mysql.com/doc/refman/8.4/en/replication-rbr-usage.html
MySQL uses statement-based logging (SBL), row-based logging (RBL) or mixed-format logging. The type of binary log used impacts the size and efficiency of logging. Therefore the choice between row-based replication (RBR) or statement-based ...
https://dev.mysql.com/doc/refman/8.4/en/rewriter-query-rewrite-plugin-usage.html
You must invoke flush_rewrite_rules() to load the table contents into the plugin in-memory cache: mysql> CALL query_rewrite.flush_rewrite_rules(); Tip If your rewrite rules seem not to be working properly, make sure that you have reloaded the rules ... To enable or disable the plugin, enable or disable the rewriter_enabled system ...
https://dev.mysql.com/doc/refman/8.4/en/scalar-subqueries.html
A scalar subquery is a simple operand, and you can use it almost anywhere a single column value or literal is legal, and you can expect it to have those characteristics that all operands have: a data type, a length, an indication that it can be ...
https://dev.mysql.com/doc/refman/8.4/en/security.html
Ensure that you have adequate and appropriate backups of your database files, configuration and log files. Also be sure that you have a recovery solution in place and test that you are able to successfully recover the information from your backups.
https://dev.mysql.com/doc/refman/8.4/en/select-into.html
The file is created on the server host, so you must have the FILE privilege to use this syntax. (You should never run mysqld as root for this and other reasons.) The umask for file creation is 0640; you must have sufficient access privileges to ...
https://dev.mysql.com/doc/refman/8.4/en/select-optimization.html
Those statements have additional performance considerations because they combine write operations with the read-oriented query operations. Both InnoDB and MyISAM have sets of guidelines for enabling and sustaining high performance in queries.
https://dev.mysql.com/doc/refman/8.4/en/set-variable.html
A system variable can have a global value that affects server operation as a whole, a session value that affects the current session, or both. variable: { user_var_name | param_name | local_var_name | {GLOBAL | @@GLOBAL.} system_var_name | {PERSIST ...
https://dev.mysql.com/doc/refman/8.4/en/sha256-pluggable-authentication.html
The database administrator must set these variables at server startup if the key files to use have names that differ from the system variable default values. After the server has been configured with the RSA key files, accounts that authenticate ...
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/show-tables.html
These temporary tables have names beginning with #sql and can be dropped using DROP TABLE. If you have no privileges for a base table or view, it does not show up in the output from SHOW TABLES or mysqlshow db_name. SHOW [EXTENDED] [FULL] TABLES ...