PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 297.2Kb
Man Pages (Zip)
- 402.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/faqs-replication.html
How do I tell whether a replication source server is using statement-based or row-based binary logging format? A.14.11. How do I tell a replica to use row-based replication? A.14.12. Note that if your replica has been disconnected from the source ...
https://dev.mysql.com/doc/refman/8.0/en/fulltext-search.html
For large data sets, it is much faster to load your data into a table that has no FULLTEXT index and then create the index after that, than to load data into a table that has an existing FULLTEXT index. This rules out, for example, a table column ...
https://dev.mysql.com/doc/refman/8.0/en/partitioning-maintenance.html
If you have deleted a large number of rows from a partition or if you have made many changes to a partitioned table with variable-length rows (that is, having VARCHAR, BLOB, or TEXT columns), you can use ALTER TABLE ... You can use ALTER IGNORE ...
https://dev.mysql.com/doc/refman/8.0/en/replication-gtids-lifecycle.html
Tables that use the MEMORY storage engine are deleted automatically the first time they are accessed after the server is started, because rows might have been lost during the shutdown. This also includes no-op transactions when row-based replication ... The life cycle of a GTID consists of the following steps: A transaction is executed and committed on the ...
https://dev.mysql.com/doc/refman/8.0/en/federated-usagenotes.html
This means that, for a query that cannot use any indexes and so requires a full table scan, the server fetches all rows from the remote table and filters them locally. This occurs regardless of any WHERE or LIMIT used with this SELECT statement; ...
https://dev.mysql.com/doc/refman/8.0/en/myisamchk-repair-options.html
--max-record-length=len Command-Line Format --max-record-length=len Type Numeric Skip rows larger than the given length if myisamchk cannot allocate memory to hold them. --extend-check, -e Command-Line Format --extend-check Do a repair that tries to ...--correct-checksum Command-Line Format --correct-checksum Correct the checksum information for the ...
https://dev.mysql.com/doc/refman/8.0/en/partitioning-overview.html
The SQL language itself is intended to work independently of any data structures or media underlying the schemas, tables, rows, or columns with which it works. Partitioning takes this notion a step further, by enabling you to distribute portions of ... This section provides a conceptual overview of partitioning in MySQL ...
https://dev.mysql.com/doc/refman/8.0/en/insert-on-duplicate.html
If you specify an ON DUPLICATE KEY UPDATE clause and a row to be inserted would cause a duplicate value in a UNIQUE index or PRIMARY KEY, an UPDATE of the old row occurs. If column b is also unique, the INSERT is equivalent to this UPDATE statement ...In general, you should try to avoid using an ON DUPLICATE KEY UPDATE clause on tables with multiple unique ...
https://dev.mysql.com/doc/refman/8.0/en/partitioning-selection.html
Explicit selection of partitions and subpartitions for rows matching a given WHERE condition is supported. When the PARTITION option is used, only the partitions and subpartitions listed are checked for matching rows. This option can be used in a ...Partition selection is similar to partition pruning, in that only specific partitions are checked for matches, but differs in two key respects: The partitions to be checked are specified by the issuer of the statement, unlike partition pruning, which is ...
https://dev.mysql.com/doc/refman/8.0/en/create-logfile-group.html
CREATE LOGFILE GROUP logfile_group ADD UNDOFILE 'undo_file' [INITIAL_SIZE [=] initial_size] [UNDO_BUFFER_SIZE [=] undo_buffer_size] [REDO_BUFFER_SIZE [=] redo_buffer_size] [NODEGROUP [=] nodegroup_id] [WAIT] [COMMENT [=] 'string'] ENGINE [=] ...A ...