Search Results
https://dev.mysql.com/doc/refman/8.4/en/index-hints.html
row *************************** id: 1 select_type: DELETE table: t1 partitions: NULL type: range possible_keys: col2 key: col2 key_len: 5 ref: NULL rows: 72 filtered: 11.11 Extra: Using where 1 row in set, 1 warning (0.00 sec) . Index hints give ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-innodb-buffer-page-lru-table.html
When tables, table rows, partitions, or indexes are deleted, associated pages remain in the buffer pool until space is required for other data. The INNODB_BUFFER_PAGE_LRU table provides information about the pages in the InnoDB buffer pool; in ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-innodb-buffer-page-table.html
When tables, table rows, partitions, or indexes are deleted, associated pages remain in the buffer pool until space is required for other data. The INNODB_BUFFER_PAGE table provides information about each page in the InnoDB buffer pool. For related ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-create-table-external.html
Tables and table partitions created outside of the data directory using the DATA DIRECTORY clause are restricted to directories known to InnoDB. There are different reasons for creating InnoDB tables externally; that is, creating tables outside of ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-online-ddl-limitations.html
OPTIMIZE TABLE is supported with the addition of online DDL support for rebuilding regular and partitioned InnoDB tables. The following limitations apply to online DDL operations: The table is copied when creating an index on a TEMPORARY TABLE. The ...
https://dev.mysql.com/doc/refman/8.4/en/log-destinations.html
MySQL Server provides flexible control over the destination of output written to the general query log and the slow query log, if those logs are enabled. Possible destinations for log entries are log files or the general_log and slow_log tables in ...
https://dev.mysql.com/doc/refman/8.4/en/monitor-mysql-memory-use.html
Depending on your MySQL installation, code areas may include performance_schema, sql, client, innodb, myisam, csv, memory, blackhole, archive, partition, and others. The following example demonstrates how to use Performance Schema and sys schema to ...
https://dev.mysql.com/doc/refman/8.4/en/myisamchk.html
The myisamchk utility gets information about your database tables or checks, repairs, or optimizes them. myisamchk works with MyISAM tables (tables that have .MYD and .MYI files for storing data and indexes). You can also use the CHECK TABLE and ...
https://dev.mysql.com/doc/refman/8.4/en/myisampack.html
When the table is used later, the server reads into memory the information needed to decompress columns. This results in much better performance when accessing individual rows, because you only have to uncompress exactly one row. MySQL uses mmap() ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-backup-troubleshooting.html
You should also make sure that there is sufficient space on the hard drive partition of the backup target. If an error code is returned when issuing a backup request, the most likely cause is insufficient memory or disk space. You should check that ...