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/myisamchk-check-options.html
myisamchk supports the following options for table checking operations: --check, -c Command-Line Format --check Check the table for errors. --check-only-changed, -C Command-Line Format --check-only-changed Check only tables that have changed since ...This is the default operation if you specify no option that selects an operation type ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-error-log-table.html
LOGGED corresponds to the time field of error events, although with certain potential differences: time values in the error log are displayed according to the log_timestamps system variable setting; see Early-Startup Logging Output Format. This is ... Of the logs the MySQL server maintains, one is the error log to which it writes diagnostic messages (see Section 7.4.2, “The Error ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-replication-applier-status-by-worker-table.html
When the Performance Schema is disabled, local timing information is not collected, so the fields showing the start and end timestamps for applied transactions are zero. LAST_ERROR_TIMESTAMP A timestamp in 'YYYY-MM-DD hh:mm:ss[.fraction]' format ...
https://dev.mysql.com/doc/refman/8.0/en/replication-rbr-safe-unsafe.html
The “safeness” of a statement in MySQL replication refers to whether the statement and its effects can be replicated correctly using statement-based format. A statement is treated differently depending on whether the statement is considered ...
https://dev.mysql.com/doc/refman/8.0/en/using-innodb-tables.html
Row Formats The row format of an InnoDB table determines how its rows are physically stored on disk. For information about row format characteristics, see Section 17.10, “InnoDB Row Formats”. The row format of a table can also be defined ...
https://dev.mysql.com/doc/refman/8.0/en/hash-joins.html
In MySQL 8.0.20 and later, the hash join is used in such cases, as shown here: mysql> EXPLAIN FORMAT=TREE -> SELECT * FROM t1 -> JOIN t2 ON (t1.c1 = t2.c1) -> JOIN t3 ON (t2.c1 < t3.c1)\G *************************** 1. This means that the types of ... By default, MySQL (8.0.18 and later) employs hash joins whenever ...
https://dev.mysql.com/doc/refman/8.0/en/myisamchk-table-info.html
myisamchk -dv tbl_name Adding -v runs myisamchk in verbose mode so that it produces more information about the table. myisamchk -eis tbl_name Shows only the most important information from a table. uint24 NULL 0 1024 Field Start Length Nullpos ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-replication-connection-status-table.html
This table shows the current status of the I/O thread that handles the replica's connection to the source, information on the last transaction queued in the relay log, and information on the transaction currently being queued in the relay log. It ...
https://dev.mysql.com/doc/refman/8.0/en/string-functions.html
For more information about that option, see Section 6.5.1, “mysql — The MySQL Command-Line Client”. For more information about that option, see Section 6.5.1, “mysql — The MySQL Command-Line Client”. mysql> SELECT ...For functions that ...
https://dev.mysql.com/doc/refman/8.0/en/using-explain.html
The EXPLAIN statement provides information about how MySQL executes statements: EXPLAIN works with SELECT, DELETE, INSERT, REPLACE, and UPDATE statements. When EXPLAIN is used with an explainable statement, MySQL displays information from the ...