PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 296.5Kb
Man Pages (Zip)
- 401.9Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/create-table-secondary-indexes.html
A secondary index defined on a virtual column is sometimes referred to as a “virtual index”. If a secondary index is not defined on a virtual column, there are additional costs for reads, as virtual column values must be computed each time the ...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 ...
https://dev.mysql.com/doc/refman/8.0/en/create-table.html
The column_list used in the COLUMNS clause may contain only names of columns; each column in the list must be one of the following MySQL data types: the integer types; the string types; and time or date column types. | {FULLTEXT | SPATIAL} [INDEX | ...
https://dev.mysql.com/doc/refman/8.0/en/creating-ssl-files-using-openssl.html
This section describes how to use the openssl command to set up SSL certificate and key files for use by MySQL servers and clients. The first example shows a simplified procedure such as you might use from the command line. The first two examples ...
https://dev.mysql.com/doc/refman/8.0/en/creating-ssl-rsa-files-using-mysql.html
They can be enabled at startup and inspected but not set at runtime. SSL files created by the server or by mysql_ssl_rsa_setup are valid for ten years from the time of generation. MySQL provides these ways to create the SSL certificate and key ...
https://dev.mysql.com/doc/refman/8.0/en/custom-benchmarks.html
Most of the time, these problems would be much easier to fix if the systems were not already in production. Benchmark your application and database to find out where the bottlenecks are. After fixing one bottleneck (or by replacing it with a ...
https://dev.mysql.com/doc/refman/8.0/en/data-dictionary-object-cache.html
The stored_program_cache option sets a soft upper limit for the number of cached stored procedures or functions per connection, and the limit is checked each time a connection executes a stored procedure or function. The dictionary object cache is ...
https://dev.mysql.com/doc/refman/8.0/en/data-dictionary-schema.html
Generally, the difference between MySQL data dictionary tables and system tables is that data dictionary tables contain metadata required to execute SQL queries, whereas system tables contain auxiliary data such as time zone and help information.
https://dev.mysql.com/doc/refman/8.0/en/data-masking-component-functions.html
masking_dictionary_term_add() permits you to add one dictionary term at a time. 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 ...
https://dev.mysql.com/doc/refman/8.0/en/data-masking-components-vs-plugin.html
Note Only the data-masking components or the plugin should be enabled at a time. Prior to 8.0.33, MySQL enabled masking and de-identification capabilities using a server-side plugin, but transitioned to use the component infrastructure in MySQL ...
https://dev.mysql.com/doc/refman/8.0/en/data-masking.html
If you are using MySQL Enterprise Data Masking and De-Identification for the first time, consider installing the components for access to the ongoing enhancements only available with component infrastructure. Note MySQL Enterprise Data Masking and ...