Search Results
https://dev.mysql.com/doc/refman/8.4/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.4/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.4/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.4/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.4/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.4/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.4/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.4/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.4/en/innodb-performance-schema.html
You should be familiar with performance_schema tables that store InnoDB event data. Tables relevant to InnoDB-related events include: The Wait Event tables, which store wait events. Stage Event tables, which store event data for InnoDB ALTER TABLE ... This section provides a brief introduction to InnoDB integration with Performance ...
https://dev.mysql.com/doc/refman/8.4/en/keyring-component-installation.html
MySQL provides these keyring component choices: component_keyring_file: Stores keyring data in a file local to the server host. component_keyring_encrypted_file: Stores keyring data in an encrypted, password-protected file local to the server host.