Search Results
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. Reserved words are permitted as ...
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 ...
https://dev.mysql.com/doc/refman/8.4/en/locking-functions.html
Also, if it is important that locks are granted in a certain order, be aware that result set order may differ depending on which execution plan the optimizer chooses. While held by one session, other sessions cannot obtain a lock of the same name.
https://dev.mysql.com/doc/refman/8.4/en/locking-service.html
Also, if it is important that locks are granted in a certain order, be aware that result set order may differ depending on which execution plan the optimizer chooses. MySQL distributions provide a locking interface that is accessible at two levels: ...
https://dev.mysql.com/doc/refman/8.4/en/merge-table-problems.html
You should not use ANALYZE TABLE, REPAIR TABLE, OPTIMIZE TABLE, ALTER TABLE, DROP TABLE, DELETE without a WHERE clause, or TRUNCATE TABLE on any of the tables that are mapped into an open MERGE table. The following are known problems with MERGE ...