PDF (US Ltr)
- 43.2Mb
PDF (A4)
- 43.3Mb
Man Pages (TGZ)
- 296.3Kb
Man Pages (Zip)
- 401.7Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/floating-point-types.html
Here, (M,D) means than values can be stored with up to M digits in total, of which D digits may be after the decimal point. Because floating-point values are approximate and not stored as exact values, attempts to treat them as exact in comparisons ... The FLOAT and DOUBLE types represent approximate numeric data ...
https://dev.mysql.com/doc/refman/8.0/en/flow-control-functions.html
Note The syntax of the CASE operator described here differs slightly from that of the SQL CASE statement described in Section 15.6.5.1, “CASE Statement”, for use inside stored programs. The default return type of IF() (which may matter when it ...The second syntax returns the result for the first condition that is ...
https://dev.mysql.com/doc/refman/8.0/en/general-tablespaces.html
Similar to the system tablespace, truncating or dropping tables stored in a general tablespace creates free space internally in the general tablespace .ibd data file which can only be used for new InnoDB data. Similar to the system tablespace, ... A ...
https://dev.mysql.com/doc/refman/8.0/en/identifier-mapping.html
These files may be stored in the database directory, or the information may be stored in a separate file. There is a correspondence between database and table identifiers and names in the file system. For the basic structure, MySQL represents each ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema-innodb-tablestats-table.html
This information is derived from in-memory data structures rather than data stored on disk. CLUST_INDEX_SIZE The number of pages on disk that store the clustered index, which holds the InnoDB table data in primary key order. OTHER_INDEX_SIZE The ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema-tables-table.html
This is the total number of bytes of data that can be stored in the table, given the data pointer size used. For NDB tables, DATA_LENGTH includes data stored in main memory only; the MAX_DATA_LENGTH and DATA_FREE columns apply to Disk Data. The ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-buffer-pool-flushing.html
When table data is stored on a traditional HDD storage device, flushing neighbor pages in one operation reduces I/O overhead (primarily for disk seek operations) compared to flushing individual pages at different times. For table data stored on SSD, ... InnoDB performs certain tasks in the background, including flushing of dirty pages from the buffer ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-file-per-table-tablespaces.html
A file-per-table tablespace contains data and indexes for a single InnoDB table, and is stored on the file system in a single data file. Truncating or dropping a table stored in a shared tablespace creates free space within the shared tablespace ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-memcached-benefits.html
For example, you can store the string value 2|4|6|8 in the memcached cache, and have InnoDB split the value based on a separator character, then store the result in four numeric columns. Data is stored in a MySQL database to protect against crashes, ...The combination of InnoDB tables and memcached offers advantages over using either by ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-memcached-porting-memcached.html
If you store several different classes of information using memcached, consider setting up a separate InnoDB table for each type of data. Define additional table identifiers in the innodb_memcache.containers table, and use the @@table_id.key ...This ...