Search Results
https://dev.mysql.com/doc/refman/9.7/en/data-dictionary-transactional-storage.html
Data dictionary tables are located in the mysql database together with non-data dictionary system tables. The data dictionary schema stores dictionary data in transactional (InnoDB) tables. Data dictionary tables are created in a single InnoDB ...
https://dev.mysql.com/doc/refman/9.7/en/data-masking-component-functions.html
Each country can have a different national routing or account numbering system, with a minimum of 13 and a maximum of 34 alphanumeric ASCII characters. mask_canada_sin(str [, mask_char]) Masks a Canada Social Insurance Number (SIN) and returns the ...
https://dev.mysql.com/doc/refman/9.7/en/derived-tables.html
row *************************** id: 1 select_type: PRIMARY table: <derived2> partitions: NULL type: system possible_keys: NULL key: NULL key_len: NULL ref: NULL rows: 1 filtered: 100.00 Extra: NULL *************************** 2. For information ...
https://dev.mysql.com/doc/refman/9.7/en/explain-extended.html
When some tables are of const or system type, expressions involving columns from these tables are evaluated early by the optimizer and are not part of the displayed statement. The EXPLAIN statement produces extra (“extended”) information that ...
https://dev.mysql.com/doc/refman/9.7/en/faqs-tablespace-encryption.html
Encryption support for the mysql system tablespace is available as of MySQL 8.0.16. Is data decrypted for users who are authorized to see it? A.17.2. What are the encryption algorithms used with InnoDB data-at-rest encryption? A.17.4. Is it possible ...
https://dev.mysql.com/doc/refman/9.7/en/fixed-point-types.html
(The precise behavior is operating system-specific, but generally the effect is truncation to the permissible number of digits.) . The DECIMAL and NUMERIC types store exact numeric data values. These types are used when it is important to preserve ...
https://dev.mysql.com/doc/refman/9.7/en/full-disk.html
All of these statements may create large temporary files that, if left to themselves, would cause big problems for the rest of the system. This section describes how MySQL responds to disk-full errors (such as “no space left on device”), and to ...
https://dev.mysql.com/doc/refman/9.7/en/full-table.html
The effective maximum table size for MySQL databases is usually determined by operating system constraints on file sizes, not by MySQL internal limits. If a table-full error occurs, it may be that the disk is full or that the table has reached its ...
https://dev.mysql.com/doc/refman/9.7/en/fulltext-boolean.html
The stopword list applies, controlled by innodb_ft_enable_stopword, innodb_ft_server_stopword_table, and innodb_ft_user_stopword_table for InnoDB search indexes, and ft_stopword_file for MyISAM ones. InnoDB uses a variation of the “term ... MySQL ...
https://dev.mysql.com/doc/refman/9.7/en/gis-class-multipolygon.html
MultiPolygon Examples On a region map, a MultiPolygon could represent a system of lakes. A MultiPolygon is a MultiSurface object composed of Polygon elements. MultiPolygon Assertions A MultiPolygon has no two Polygon elements with interiors that ...