MySQL :: MySQL 8.0 Reference Manual

Search Results

Displaying 31 to 39 of 39 total results

« Previous
1
2
3
4
Next »

https://dev.mysql.com/doc/refman/8.0/en/insert-optimization.html

The size of the table slows down the insertion of indexes by log N, assuming B-tree indexes. To optimize insert speed, combine many small operations into a single large operation. Ideally, you make a single connection, send the data for many new ...

17.1 Introduction to InnoDB

https://dev.mysql.com/doc/refman/8.0/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 ...

17.15.3 InnoDB INFORMATION_SCHEMA Schema Object Tables

https://dev.mysql.com/doc/refman/8.0/en/innodb-information-schema-system-tables.html

PAGE_NO is the root page number of the index B-tree, and SPACE is the ID of the tablespace where the index resides. You can extract metadata about schema objects managed by InnoDB using InnoDB INFORMATION_SCHEMA tables. Traditionally, you would get ...

17.11.4 Defragmenting a Table

https://dev.mysql.com/doc/refman/8.0/en/innodb-file-defragmenting.html

All InnoDB data and indexes are stored in B-trees, and their fill factor may vary from 50% to 100%. Random insertions into or deletions from a secondary index can cause the index to become fragmented. Fragmentation means that the physical ordering ...

28.4.2 The INFORMATION_SCHEMA INNODB_BUFFER_PAGE Table

https://dev.mysql.com/doc/refman/8.0/en/information-schema-innodb-buffer-page-table.html

The INNODB_BUFFER_PAGE table provides information about each page in the InnoDB buffer pool. For related usage information and examples, see Section 17.15.5, “InnoDB INFORMATION_SCHEMA Buffer Pool Tables”. Do not query this table on a ...

28.4.3 The INFORMATION_SCHEMA INNODB_BUFFER_PAGE_LRU Table

https://dev.mysql.com/doc/refman/8.0/en/information-schema-innodb-buffer-page-lru-table.html

The INNODB_BUFFER_PAGE_LRU table provides information about the pages in the InnoDB buffer pool; in particular, how they are ordered in the LRU list that determines which pages to evict from the buffer pool when it becomes full. The ...

1.2.2 The Main Features of MySQL

https://dev.mysql.com/doc/refman/8.0/en/features.html

This section describes some of the important characteristics of the MySQL Database Software. In most respects, the roadmap applies to all versions of MySQL. Tested with Purify (a commercial memory leakage detector) as well as with Valgrind, a GPL ...

10.8.5 Estimating Query Performance

https://dev.mysql.com/doc/refman/8.0/en/estimating-performance.html

For bigger tables, you can estimate that, using B-tree indexes, you need this many seeks to find a row: log(row_count) / log(index_block_length / 3 * 2 / (index_length + data_pointer_length)) + 1. In most cases, you can estimate query performance ...

15.1.15 CREATE INDEX Statement

https://dev.mysql.com/doc/refman/8.0/en/create-index.html

CREATE [UNIQUE | FULLTEXT | SPATIAL] INDEX index_name [index_type] ON tbl_name (key_part,...) [index_option] [algorithm_option | lock_option] ... This guideline is especially important for InnoDB tables, where the primary key determines the ...