Search Results
https://dev.mysql.com/doc/internals/en/x-protocol-lifecycle-lifecycle.html
Note Disabling TLS on a connection may not be supported by the server and should result in an error. Topics in this section: Connection Session Stages of Session Setup Authentication Pipelining Max Message Length Extensions The following list ...
https://dev.mysql.com/doc/mysql-em-plugin/en/myoem-config-metric-statementprocessing-category.html
Safe Updates Enabled If set to 1, MySQL aborts UPDATE or DELETE statements that do not use a key in the WHERE clause or a LIMIT clause. Lists the Statement Processing configuration metrics and provides a brief description of each. Big Selects ...
https://dev.mysql.com/doc/heatwave-aws/en/heatwave-aws-security.html
The following security features help keep your data safe and secure. Security 1.6 Security Oracle considers cloud security its highest priority. Database access control and account management MySQL provides security features to control access and ...
https://dev.mysql.com/doc/refman/8.4/en/converting-tables-to-innodb.html
With each COMMIT, MySQL makes sure each change is safely recorded to disk, which involves some I/O. From a safety perspective, this allows you to issue a ROLLBACK statement to recover lost or garbled data if you make a mistake on the mysql command ... If you have MyISAM tables that you want to convert to InnoDB for better reliability and scalability, review the following guidelines and tips before ...
https://dev.mysql.com/doc/refman/8.4/en/crashing.html
(This is not true if you are running with the delay_key_write system variable enabled, in which case data files are written but not index files.) This means that data file contents are safe even if mysqld crashes, because the operating system ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-configuring-instances.html
server_id=1 gtid_mode=ON enforce_gtid_consistency=ON These settings configure the server to use the unique identifier number 1, to enable Section 19.1.3, “Replication with Global Transaction Identifiers”, and to allow execution of only ...Set ...
https://dev.mysql.com/doc/refman/8.4/en/information-functions.html
It is multi-user safe because multiple clients can issue the UPDATE statement and get their own sequence value with the SELECT statement (or mysql_insert_id()), without affecting or being affected by other clients that generate their own sequence ...
https://dev.mysql.com/doc/refman/8.4/en/outer-join-optimization.html
However, STRAIGHT_JOIN may prevent indexes from being used because it disables semijoin transformations; see Optimizing IN and EXISTS Subquery Predicates with Semijoin Transformations. MySQL implements an A LEFT JOIN B join_specification as follows: ...
https://dev.mysql.com/doc/refman/8.4/en/reset-binary-logs-and-gtids.html
For a server where GTIDs are in use (gtid_mode is ON), issuing RESET BINARY LOGS AND GTIDS resets the GTID execution history. Note that RESET BINARY LOGS AND GTIDS is the method to reset the GTID execution history even if the GTID-enabled server is ... Note This statement takes the place of the old RESET MASTER statement, which is no longer ...
https://dev.mysql.com/doc/refman/8.4/en/reset-replica.html
(This is a condition likely to exist on a replica if you have issued a STOP REPLICA statement or if the replica is highly loaded.) For a server where GTIDs are in use (gtid_mode is ON), issuing RESET REPLICA has no effect on the GTID execution ...