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/flush.html
FLUSH TABLES WITH READ LOCK does not prevent the server from inserting rows into the log tables (see Section 7.4.1, “Selecting General Query Log and Slow Query Log Output Destinations”). | tables_option } flush_option: { BINARY LOGS | ENGINE ...
https://dev.mysql.com/doc/refman/8.0/en/foreign-key-optimization.html
(To maximize performance, queries try to read as few data blocks as possible from disk; tables with only a few columns can fit more rows in each data block.) . If a table has many columns, and you query many different combinations of columns, it ...
https://dev.mysql.com/doc/refman/8.0/en/fulltext-restrictions.html
This rules out, for example, a table column because that can differ for each row. Full-text searches are supported for InnoDB and MyISAM tables only. The exception is that for Unicode, the utf8mb3 or utf8mb4 character set can be used, but not the ...
https://dev.mysql.com/doc/refman/8.0/en/functions.html
Rather than showing examples in this format: mysql> SELECT MOD(29,9); +-----------+ | mod(29,9) | +-----------+ | 2 | +-----------+ 1 rows in set (0.00 sec) This format is used instead: mysql> SELECT MOD(29,9); -> 2 . Expressions can be used at ...
https://dev.mysql.com/doc/refman/8.0/en/group-by-optimization.html
The most general way to satisfy a GROUP BY clause is to scan the whole table and create a new temporary table where all rows from each group are consecutive, and then use this temporary table to discover groups and apply aggregate functions (if ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-bootstrap.html
The process of starting a group for the first time is called bootstrapping. The bootstrap should only be done by a single server, the one that starts the group and only once. This is why the value of the group_replication_bootstrap_group option was ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-configuring-instances.html
log_bin=binlog log_slave_updates=ON binlog_format=ROW master_info_repository=TABLE relay_log_info_repository=TABLE transaction_write_set_extraction=XXHASH64 Group Replication Settings At this point the option file ensures that the server is ... This ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-enterprise-backup.html
Note that tables without PK can cause performance problems in row-based replication, so please consult your DBA before changing this setting. The exact way to copy the backup depends on the operating system and tools available to you. The exact way ... MySQL Enterprise Backup is a commercially-licensed backup utility for MySQL Server, available with MySQL Enterprise ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-plugin-architecture.html
MySQL Group Replication is a MySQL plugin and it builds on the existing MySQL replication infrastructure, taking advantage of features such as the binary log, row-based logging, and global transaction identifiers. It integrates with current MySQL ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-primary-secondary-replication.html
The source applies transactions, commits them and then they are later (thus asynchronously) sent to the replicas to be either re-executed (in statement-based replication) or applied (in row-based replication). The arrows between the different ...