Search Results
https://dev.mysql.com/doc/refman/8.4/en/replication-features-row-searches.html
The algorithm used to carry out this process uses one of the table's indexes to carry out the search as the first choice, and a hash table if there are no suitable indexes. The algorithm first assesses the available indexes in the table definition ... When a replica using row-based replication format applies an UPDATE or DELETE operation, it must search the relevant table for the matching ...
https://dev.mysql.com/doc/connectors/en/connector-j-usagenotes-last-insert-id.html
On the other hand, the getGeneratedKeys() method is scoped by the Statement instance, so it can be used even if other queries happen on the same connection, but not on the same Statement instance. getGeneratedKeys() is the preferred method to use ...
https://dev.mysql.com/doc/internals/en/variation-of-protocol-option.html
Effect of the "--ps-protocol" option: mysqltest will run as many SQL statements as possible as prepared statements. Effect of the "--sp-protocol"/"--cursor-protocol"/"--view-protocol" options: As far as I know, mysqltest takes many statements and ...
https://dev.mysql.com/doc/mysql-monitor/8.0/en/mem-agent-rights.html
The SUPER privilege is required to run certain statements such as SHOW MASTER LOGS or SHOW ENGINE INNODB STATUS, depending on the version that is being monitored. The agent requires this privilege to use the SHOW BINARY LOGS statement on the ...
https://dev.mysql.com/doc/connector-j/en/connector-j-usagenotes-last-insert-id.html
On the other hand, the getGeneratedKeys() method is scoped by the Statement instance, so it can be used even if other queries happen on the same connection, but not on the same Statement instance. getGeneratedKeys() is the preferred method to use ...
https://dev.mysql.com/doc/refman/8.4/en/creating-accounts.html
To manage MySQL accounts, use the SQL statements intended for that purpose: CREATE USER and DROP USER create and remove accounts. Account-management statements cause the server to make appropriate modifications to the underlying grant tables, which ...GRANT and REVOKE assign privileges to and revoke privileges from ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-secure-user.html
20.6.3.1.3 Providing Replication User Credentials Securely To supply the user credentials for the replication user, you can set them permanently as the credentials for the group_replication_recovery channel, using a CHANGE REPLICATION SOURCE TO ...
https://dev.mysql.com/doc/refman/8.4/en/identifier-qualifiers.html
For example, this statement creates a table using the unqualified name t1: CREATE TABLE t1 (i INT); Because t1 includes no qualifier to specify a database, the statement creates the table in the default database. This statement creates a table using ...An unqualified name is permitted in contexts where interpretation of the name is ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-events-table.html
EVENT_BODY The language used for the statements in the event's DO clause. EVENT_DEFINITION The text of the SQL statement making up the event's DO clause; in other words, the statement executed by this event. EXECUTE_AT For a one-time event, this is ... The EVENTS table provides information about Event Manager events, which are discussed in Section 27.4, “Using the Event ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-error-handling.html
InnoDB sometimes rolls back only the statement that failed, other times it rolls back the entire transaction. If you run out of file space in a tablespace, a MySQL Table is full error occurs and InnoDB rolls back the SQL statement. A lock wait ...A ...