PDF (US Ltr)
- 43.2Mb
PDF (A4)
- 43.3Mb
Man Pages (TGZ)
- 295.2Kb
Man Pages (Zip)
- 400.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/check-table.html
Column Value Table The table name Op Always check Msg_type status, error, info, note, or warning Msg_text An informational message The statement might produce many rows of information for each checked table. The last row has a Msg_type value of ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-index-types.html
If a table is large, the clustered index architecture often saves a disk I/O operation when compared to storage organizations that store row data using a different page from the index record. Each InnoDB table has a special index called the ...To ...
https://dev.mysql.com/doc/refman/8.0/en/fulltext-fine-tuning.html
For example, to make two-character words searchable, you could put the following lines in an option file: [mysqld] innodb_ft_min_token_size=2 ft_min_word_len=2 Then restart the server and rebuild your FULLTEXT indexes. Rebuilding InnoDB Full-Text ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-preload-buffer-pool.html
The ability to restore the buffer pool at startup shortens the warmup period by reloading disk pages that were in the buffer pool before the restart rather than waiting for DML operations to access corresponding rows. Also, I/O requests can be ...
https://dev.mysql.com/doc/refman/8.0/en/replication-gtids-failover.html
Executing the entire transaction history can be time-consuming when the source server has processed a large number of transactions previously, and this can represent a major bottleneck when setting up a new replica. However, it may not always be ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-indexes.html
Indexes are used to find rows with specific column values quickly. Without an index, MySQL must begin with the first row and then read through the entire table to find the relevant rows. MySQL uses indexes for these operations: To find the rows ...
https://dev.mysql.com/doc/refman/8.0/en/option-modifiers.html
For example, --maximum-max_heap_table_size=32M prevents any client from making the heap table size limit larger than 32M. For example, the mysql client supports a --column-names option that determines whether or not to display a row of column names ... Some options are “boolean” and control behavior that can be turned on or ...
https://dev.mysql.com/doc/refman/8.0/en/full-table.html
If a table-full error occurs, it may be that the disk is full or that the table has reached its maximum size. The effective maximum table size for MySQL databases is usually determined by operating system constraints on file sizes, not by MySQL ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-information-schema-examples-compression-sect.html
The only compressed page size that the buffer pool contains is 8K. The smallest PAGE_SIZE in INNODB_CMPMEM is used for block descriptors of those compressed pages for which no uncompressed page exists in the buffer pool. Some memory is unusable due ... Example 17.1 Using the Compression Information Schema Tables The following is sample output from a database that contains compressed tables (see Section 17.9, “InnoDB Table and Page Compression”, INNODB_CMP, INNODB_CMP_PER_INDEX, and ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-memcached-troubleshoot.html
As the length of the memcached key and values increase, you might encounter size and length limits. InnoDB table limits may be encountered if values exceed 768 bytes in size, 3072 bytes in size, or half of the innodb_page_size value. This section ...