PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 297.2Kb
Man Pages (Zip)
- 402.5Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/replication-gtids-concepts.html
GTIDs are stored in the mysql.gtid_executed table only when gtid_mode is ON or ON_PERMISSIVE. If binary logging is enabled (log_bin is ON), from MySQL 8.0.17 for the InnoDB storage engine only, the server updates the mysql.gtid_executed table in the ... A global transaction identifier (GTID) is a unique identifier created and associated with each transaction committed on the server of origin (the ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-change-buffer.html
The buffered changes, which may result from INSERT, UPDATE, or DELETE operations (DML), are merged later when the pages are loaded into the buffer pool by other read operations. Similarly, deletes and updates may affect secondary index pages that ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-replication-starting.html
It is also necessary in NDB 8.0 to enable logging of updates to NDB tables explicitly, using the --ndb-log-bin option; this is a change from previous versions of NDB Cluster, in which this option was enabled by default. It is also possible to ...
https://dev.mysql.com/doc/refman/8.0/en/optimizing-queries-myisam.html
This updates a value for each index part that indicates the average number of rows that have the same value. Try to avoid complex SELECT queries on MyISAM tables that are updated frequently, to avoid problems with table locking that occur due to ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-metadata-locks-table.html
When a metadata lock previously requested is granted, its row status is updated to GRANTED. When a pending lock request is canceled by the deadlock detector to break a deadlock (ER_LOCK_DEADLOCK), its row status is updated from PENDING to VICTIM.
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-stage-tables.html
To enable the instrument and the relevant consumers, execute these statements: UPDATE performance_schema.setup_instruments SET ENABLED='YES' WHERE NAME='stage/sql/copy to tmp table'; UPDATE performance_schema.setup_consumers SET ENABLED='YES' WHERE ... The Performance Schema instruments stages, which are steps during the statement-execution process, such as parsing a statement, opening a table, or performing a filesort ...
https://dev.mysql.com/doc/refman/8.0/en/constraint-enum.html
Errors for invalid values can be suppressed in strict mode if you use INSERT IGNORE or UPDATE IGNORE. Unless strict mode is disabled (not recommended, but see Section 7.1.11, “Server SQL Modes”), the definition of a ENUM or SET column acts as a ... ENUM and SET columns provide an efficient way to define columns that can contain only a given set of ...
https://dev.mysql.com/doc/refman/8.0/en/example-auto-increment.html
You can also explicitly assign 0 to the column to generate sequence numbers, unless the NO_AUTO_VALUE_ON_ZERO SQL mode is enabled. How AUTO_INCREMENT behaves depending on the NO_AUTO_VALUE_ON_ZERO SQL mode: Section 7.1.11, “Server SQL Modes”.
https://dev.mysql.com/doc/refman/8.0/en/fulltext-restrictions.html
Although FULLTEXT indexes on ucs2 columns cannot be used, you can perform IN BOOLEAN MODE searches on a ucs2 column that has no such index. The MATCH() column list must match exactly the column list in some FULLTEXT index definition for the table, ... Full-text searches are supported for InnoDB and MyISAM tables ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-configuring-consistency-guarantees.html
This mode ensures that when a transaction is committed on the local member, any subsequent transaction reads the written value or a more recent value on any group member. Use this mode with a group that is used for predominantly read-only operations ... Although the Transaction Synchronization Points section explains that conceptually there are two synchronization points from which you can choose: on read or on write, these terms were a simplification and the terms used in Group Replication are: before and after transaction ...