Search Results
https://dev.mysql.com/doc/refman/8.4/en/innodb-performance-schema.html
This type of tuning is primarily for expert users who evaluate optimization strategies to overcome performance bottlenecks. This section provides a brief introduction to InnoDB integration with Performance Schema. For comprehensive Performance ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-read-only-instance.html
See Section 10.5.3, “Optimizing InnoDB Read-Only Transactions” for ways to tune the performance of read-only queries, which do not require making the entire server read-only. You can query InnoDB tables where the MySQL data directory is on ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-redo-log-buffer.html
For related information, see Memory Configuration, and Section 10.5.4, “Optimizing InnoDB Redo Logging”. The log buffer is the memory area that holds data to be written to the log files on disk. The contents of the log buffer are periodically ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-redo-log.html
mysql> SHOW GLOBAL STATUS LIKE 'Innodb_redo_log_enabled'; +-------------------------+-------+ | Variable_name | Value | +-------------------------+-------+ | Innodb_redo_log_enabled | ON | +-------------------------+-------+ Related Topics Redo Log ... The redo log is a disk-based data structure used during crash recovery to correct data written by incomplete ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-restrictions-limitations.html
The row count is only a rough estimate used in SQL optimization. This section describes restrictions and limitations of the InnoDB storage engine. You cannot create a table with a column name that matches the name of an internal InnoDB column ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-row-format.html
The row format of a table determines how its rows are physically stored, which in turn can affect the performance of queries and DML operations. As more rows fit into a single disk page, queries and index lookups can work faster, less cache memory ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-table-import.html
After importing a table with a FULLTEXT index, run OPTIMIZE TABLE to rebuild the FULLTEXT indexes. This section describes how to import tables using the Transportable Tablespaces feature, which permits importing tables, partitioned tables, or ...
https://dev.mysql.com/doc/refman/8.4/en/json-utility-functions.html
This section documents utility functions that act on JSON values, or strings that can be parsed as JSON values. JSON_PRETTY() prints out a JSON value in a format that is easy to read. JSON_STORAGE_SIZE() and JSON_STORAGE_FREE() show, respectively, ...
https://dev.mysql.com/doc/refman/8.4/en/keywords.html
Certain keywords, such as SELECT, DELETE, or BIGINT, are reserved and require special treatment for use as identifiers such as table and column names. This may also be true for the names of built-in functions. Some keywords which are otherwise ...
https://dev.mysql.com/doc/refman/8.4/en/lock-instance-for-backup.html
REPAIR TABLE TRUNCATE TABLE, OPTIMIZE TABLE, and account management statements are blocked. LOCK INSTANCE FOR BACKUP UNLOCK INSTANCE LOCK INSTANCE FOR BACKUP acquires an instance-level backup lock that permits DML during an online backup while ...