Search Results
https://dev.mysql.com/doc/refman/8.4/en/cursors.html
Cursors have these properties: Asensitive: The server may or may not make a copy of its result table Read only: Not updatable Nonscrollable: Can be traversed only in one direction and cannot skip rows Cursor declarations must appear before handler ...
https://dev.mysql.com/doc/refman/8.4/en/docker-mysql-more-topics.html
Warning Setting this variable to true is insecure, because it is going to leave your MySQL instance completely unprotected, allowing anyone to gain complete superuser access. A MySQL Docker installation is different from a common, non-Docker ...
https://dev.mysql.com/doc/refman/8.4/en/encrypted-connection-protocols-ciphers.html
Permitted protocols should be chosen such as not to leave “holes” in the list. MySQL supports multiple TLS protocols and ciphers, and enables configuring which protocols and ciphers to permit for encrypted connections. It is also possible to ...
https://dev.mysql.com/doc/refman/8.4/en/faqs-sql-modes.html
While the performance impact is not that great, if you do not require such validation (perhaps your application already handles all of this), then MySQL gives you the option of leaving strict mode disabled. What is the default server SQL mode when ...
https://dev.mysql.com/doc/refman/8.4/en/flow-control-statements.html
MySQL supports the IF, CASE, ITERATE, LEAVE LOOP, WHILE, and REPEAT constructs for flow control within stored programs. Many of these constructs contain other statements, as indicated by the grammar specifications in the following sections. For ...
https://dev.mysql.com/doc/refman/8.4/en/flush.html
Note The descriptions here that indicate tables are flushed by closing them apply differently for InnoDB, which flushes table contents to disk but leaves them open. | tables_option } flush_option: { BINARY LOGS | ENGINE LOGS | ERROR LOGS | GENERAL ...
https://dev.mysql.com/doc/refman/8.4/en/forcing-innodb-recovery.html
Leaves database pages in an obsolete state, which in turn may introduce more corruption into B-trees and other database structures. To investigate database page corruption, you might dump your tables from the database with SELECT ... Usually, most ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-configuring-consistency-guarantees.html
You only need to SET @@SESSION.group_replication_consistency= ‘AFTER’, on those instructions and leave the other instructions to run with EVENTUAL set at the global scope. Although the Transaction Synchronization Points section explains that ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-configuring-online-group.html
Any member that attempts to join the group during a coordinated configuration change leaves the group and cancels its join process. You can configure an online group while Group Replication is running by using a set of functions, which rely on a ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-ip-address-permissions.html
When a replication group is reconfigured (for example, when a new primary is elected or a member joins or leaves), the group members re-establish connections between themselves. When and only when the XCom communication stack is used for ...