Search Results
https://dev.mysql.com/doc/refman/8.4/en/replication-semisync.html
If your goal is to implement a fault-tolerant replication topology where all the servers receive the same transactions in the same order, and a server that crashes can rejoin the group and be brought up to date automatically, you can use Group ...
https://dev.mysql.com/doc/refman/8.4/en/replication-solutions-switch.html
If you are not using GTIDs for replication, then the replicas should also be run with --log-replica-updates=OFF (logging replica updates is the default). Each MySQL replica (Replica 1, Replica 2, and Replica 3) is a replica running with binary ...
https://dev.mysql.com/doc/refman/8.4/en/select-optimization.html
Keep table statistics up to date by using the ANALYZE TABLE statement periodically, so the optimizer has the information needed to construct an efficient execution plan. Queries, in the form of SELECT statements, perform all the lookup operations ...
https://dev.mysql.com/doc/refman/8.4/en/selecting-all.html
For example, you may happen to think that the birth date for Bowser doesn't seem quite right. Fix only the erroneous record with an UPDATE statement: mysql> UPDATE pet SET birth = '1989-08-31' WHERE name = 'Bowser'; The UPDATE changes only the ...
https://dev.mysql.com/doc/refman/8.4/en/selecting-columns.html
If you do not want to see entire rows from your table, just name the columns in which you are interested, separated by commas.
https://dev.mysql.com/doc/refman/8.4/en/selecting-rows.html
As shown in the preceding section, it is easy to retrieve an entire table. But typically you don't want to see the entire table, particularly when it becomes large. Instead, you're usually more interested in answering a particular question, in ...
https://dev.mysql.com/doc/refman/8.4/en/server-loadable-functions.html
See Section 7.6.4, “The Rewriter Query Rewrite Plugin” Version Tokens enables creation of and synchronization around server tokens that applications can use to prevent accessing incorrect or out-of-date data. MySQL supports loadable functions, ...
https://dev.mysql.com/doc/refman/8.4/en/server-plugins.html
Version Tokens enables creation of and synchronization around server tokens that applications can use to prevent accessing incorrect or out-of-date data. MySQL supports an plugin API that enables creation of server plugins. Plugins can be loaded at ...
https://dev.mysql.com/doc/refman/8.4/en/show-create-trigger.html
row *************************** Trigger: ins_sum sql_mode: ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES, NO_ZERO_IN_DATE,NO_ZERO_DATE, ERROR_FOR_DIVISION_BY_ZERO, NO_ENGINE_SUBSTITUTION SQL Original Statement: CREATE DEFINER=`me`@`localhost` TRIGGER ...
https://dev.mysql.com/doc/refman/8.4/en/show-procedure-status.html
It returns characteristics of a stored procedure, such as the database, name, type, creator, creation and modification dates, and character set information. SHOW PROCEDURE STATUS [LIKE 'pattern' | WHERE expr] This statement is a MySQL extension. A ...