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/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/option-modifiers.html
For example, --maximum-max_heap_table_size=32M prevents any client from making the heap table size limit larger than 32M. For example, the mysql client supports a --column-names option that determines whether or not to display a row of column names ... Some options are “boolean” and control behavior that can be turned on or ...
https://dev.mysql.com/doc/refman/8.0/en/alter-table.html
With the mysql_info() C API function, you can find out how many rows were copied by ALTER TABLE. To change the InnoDB table to use compressed row-storage format: ALTER TABLE t1 ROW_FORMAT = COMPRESSED; The ENCRYPTION clause enables or disables ...
https://dev.mysql.com/doc/refman/8.0/en/create-table-secondary-indexes.html
Even with additional write costs, secondary indexes on virtual columns may be preferable to generated stored columns, which are materialized in the clustered index, resulting in larger tables that require more disk space and memory. If a secondary ...A secondary index defined on a virtual column is sometimes referred to as a “virtual ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-online-operations.html
Reads rows from the original table, and writes them to the copy. Other NDB clients can modify row data during a copying ALTER TABLE, resulting in inconsistency. row *************************** Level: Warning Code: 1478 Message: DYNAMIC column c4 ...
https://dev.mysql.com/doc/refman/8.0/en/subquery-optimization-with-exists.html
WHERE subquery_where) MySQL evaluates queries “from outside to inside.” That is, it first obtains the value of the outer expression outer_expr, and then runs the subquery and captures the rows that it produces. A very useful optimization is to ... Certain optimizations are applicable to comparisons that use the IN (or =ANY) operator to test subquery ...
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/audit-log-file-formats.html
Only this format supports the optional query time and size statistics, which are available from MySQL 8.0.30. When the audit log plugin opens the audit log file, it initializes the sequence number to the size of the audit log file, then increments ... The MySQL server calls the audit log plugin to write an audit record to its log file whenever an auditable event ...
https://dev.mysql.com/doc/refman/8.0/en/encryption-functions.html
The size penalty for storing the hex string in a CHAR column is at least two times, up to eight times if the value is stored in a column that uses the utf8mb4 character set (where each character uses 4 bytes). Storing the string also results in ...