PDF (US Ltr)
- 41.9Mb
PDF (A4)
- 42.0Mb
Man Pages (TGZ)
- 272.3Kb
Man Pages (Zip)
- 378.3Kb
Info (Gzip)
- 4.2Mb
Info (Zip)
- 4.2Mb
Search Results
https://dev.mysql.com/doc/refman/9.7/en/create-table-gipks.html
MySQL 9.7 supports generated invisible primary keys for any InnoDB table that is created without an explicit primary key. When the sql_generate_invisible_primary_key server system variable is set to ON, the MySQL server automatically adds a ...
https://dev.mysql.com/doc/refman/9.7/en/create-table-secondary-indexes.html
A secondary index defined on a virtual column is sometimes referred to as a “virtual index”. A secondary index may be created on one or more virtual columns or on a combination of virtual columns and regular columns or stored generated columns.
https://dev.mysql.com/doc/refman/9.7/en/create-table.html
| {FULLTEXT | SPATIAL} [INDEX | KEY] [index_name] (key_part,...) [index_option] ... | [CONSTRAINT [symbol]] UNIQUE [INDEX | KEY] [index_name] [index_type] (key_part,...) [index_option] ... (Some valid select or union statement) CREATE TABLE creates ...
https://dev.mysql.com/doc/refman/9.7/en/creating-ssl-rsa-files-using-mysql.html
MySQL provides these ways to create the SSL certificate and key files and RSA key-pair files required to support encrypted connections using SSL and secure password exchange using RSA over unencrypted connections, if those files are missing: The ...
https://dev.mysql.com/doc/refman/9.7/en/custom-benchmarks.html
Benchmark your application and database to find out where the bottlenecks are. After fixing one bottleneck (or by replacing it with a “dummy” module), you can proceed to identify the next bottleneck. Even if the overall performance for your ...
https://dev.mysql.com/doc/refman/9.7/en/data-dictionary-object-cache.html
The dictionary object cache is a shared global cache that stores previously accessed data dictionary objects in memory to enable object reuse and minimize disk I/O. Similar to other cache mechanisms used by MySQL, the dictionary object cache uses ...
https://dev.mysql.com/doc/refman/9.7/en/data-dictionary-schema.html
Data dictionary tables are protected and may only be accessed in debug builds of MySQL. However, MySQL supports access to data stored in data dictionary tables through INFORMATION_SCHEMA tables and SHOW statements. For an overview of the tables ...
https://dev.mysql.com/doc/refman/9.7/en/data-masking-component-functions.html
mask_canada_sin(str [, mask_char]) Masks a Canada Social Insurance Number (SIN) and returns the number with all meaningful digits replaced by 'X' characters. Nine digits grouped in pattern: xxx-xxx-xxx ('-' is any separator character). Return value: ...
https://dev.mysql.com/doc/refman/9.7/en/data-masking-components-vs-plugin.html
Previously, MySQL enabled masking and de-identification capabilities using a server-side plugin, but transitioned to use the component infrastructure as an alternative implementation. The following table briefly compares MySQL Enterprise Data ...
https://dev.mysql.com/doc/refman/9.7/en/data-masking-policy-usage.html
Dynamic data masking enables you to conditionally mask column data for specific users or roles. A masking policy is a rule, or set of rules, which determines how a column's data is transformed for access control. A masking policy consists of the ...