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/optimize-blob.html
When storing a large blob containing textual data, consider compressing it first. For example, to retrieve a BLOB might require a large sequential disk read that is better suited to a traditional hard drive than to an SSD device. Do not use this ...
https://dev.mysql.com/doc/refman/8.0/en/time.html
MySQL retrieves and displays TIME values in 'hh:mm:ss' format (or 'hhh:mm:ss' format for large hours values). The hours part may be so large because the TIME type can be used not only to represent a time of day (which must be less than 24 hours), ...MySQL recognizes TIME values in several formats, some of which can include a trailing fractional seconds part in up to microseconds (6 digits) ...
https://dev.mysql.com/doc/refman/8.0/en/upgrading-what-is-upgraded.html
Dropping and re-creating the index is necessary and might take some time if the system has a large number of users and privileges. Check and repair operations can be time-consuming, particularly for large tables. Installing a new version of MySQL ...
https://dev.mysql.com/doc/refman/8.0/en/json.html
It is important to keep in mind that the size of any JSON document stored in a JSON column is limited to the value of the max_allowed_packet system variable. The value being replaced must be at least as large as the replacement value. In other ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-tips.html
Setting max_join_size to 1,000,000 causes multiple-table SELECT statements to produce an error if the server estimates it must examine more than 1,000,000 row combinations. For example, the left-arrow and right-arrow keys move horizontally within ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-ndbinfo-transporters.html
Rows where the node_id is that of a data node which is not currently connected are not shown in this table. In this state, any new scan using this transporter has its batch size reduced to minimize the load on the transporter. In NDB 8.0.37 and ...
https://dev.mysql.com/doc/refman/8.0/en/insert-optimization.html
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 rows at once, and delay all index updates and consistency checking until the very end. The size ...When loading a table from a text file, use LOAD ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-information-schema-system-tables.html
row *************************** TABLE_ID: 71 NAME: test/t1 FLAG: 1 N_COLS: 6 SPACE: 57 ROW_FORMAT: Compact ZIP_PAGE_SIZE: 0 INSTANT_COLS: 0 Table t1 has a TABLE_ID of 71. Also provided are tablespace ROW_FORMAT, PAGE_SIZE, and several other ...There ... You can extract metadata about schema objects managed by InnoDB using InnoDB INFORMATION_SCHEMA ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema-innodb-buffer-page-lru-table.html
Querying this table can require MySQL to allocate a large block of contiguous memory, more than 64 bytes times the number of active pages in the buffer pool. When tables, table rows, partitions, or indexes are deleted, associated pages remain in the ... 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 ...
https://dev.mysql.com/doc/refman/8.0/en/compatibility.html
MySQL Server was originally designed to work with medium-sized databases (10-100 million rows, or about 100MB per table) on small computer systems. We are not afraid to add extensions to SQL or support for non-SQL features if this greatly increases ... This section describes how MySQL relates to the ANSI/ISO SQL ...