Search Results
https://dev.mysql.com/doc/refman/8.4/en/innodb-backup.html
In conjunction with the MySQL binary log, users can perform point-in-time recovery. The key to safe database management is making regular backups. Hot and cold backups are physical backups that copy actual data files, which can be used directly by ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-compression-tuning.html
On the other hand, tables containing mostly binary data (integers or floating point numbers) or data that is previously compressed (for example JPEG or PNG images) may not generally compress well, significantly or at all. Most often, the internal ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-configuring-io-capacity.html
Ignoring I/O Capacity at Checkpoints The innodb_flush_sync variable, which is enabled by default, causes the innodb_io_capacity setting to be ignored during bursts of I/O activity that occur at checkpoints. When configuring innodb_io_capacity_max, ... The InnoDB master thread and other threads perform various tasks in the background, most of which are I/O related, such as flushing dirty pages from the buffer pool and writing changes from the change buffer to the appropriate secondary ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-file-space.html
The 768-byte prefix is accompanied by a 20-byte value that stores the true length of the column and points into the overflow list where the rest of the value is stored. DYNAMIC and COMPRESSED Row Formats When a variable-length column is chosen for ... The data files that you define in the configuration file using the innodb_data_file_path configuration option form the InnoDB system ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-introduction.html
InnoDB is a general-purpose storage engine that balances high reliability and high performance. Unless you have configured a different default storage engine, issuing a CREATE TABLE statement without an ENGINE clause creates an InnoDB table. Key ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-performance-compression-oltp.html
innodb_compression_failure_threshold_pct specifies a cutoff point for compression failures during updates to a compressed table. Traditionally, the InnoDB compression feature was recommended primarily for read-only or read-mostly workloads, such as ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-row-format.html
In addition, there is a 6-byte transaction ID field and a 7-byte roll pointer field. A record contains a pointer to each field of the record. If the total length of the fields in a record is less than 128 bytes, the pointer is one byte; otherwise, ... The row format of a table determines how its rows are physically stored, which in turn can affect the performance of queries and DML ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-table-import.html
Also, you should export all foreign key related tables at the same logical point in time, as ALTER TABLE ... This section describes how to import tables using the Transportable Tablespaces feature, which permits importing tables, partitioned ...
https://dev.mysql.com/doc/refman/8.4/en/internal-temporary-tables.html
If the physical_disk instrument reports a value other than 0 and memory-mapped files are used as the TempTable overflow mechanism, a TempTable memory limit was reached at some point. In some cases, the server creates internal temporary tables while ...
https://dev.mysql.com/doc/refman/8.4/en/json-function-reference.html
Table 14.22 JSON Functions Name Description Deprecated -> Return value from JSON column after evaluating path; equivalent to JSON_EXTRACT(). ->> Return value from JSON column after evaluating path and unquoting the result; equivalent to ...