https://dev.mysql.com/create-table-generated-columns.html
Note Expression evaluation uses the SQL mode in effect at evaluation time. Values of a generated column are computed from an expression included in the column definition. Generated column definitions have this syntax: col_name data_type [GENERATED ...
https://dev.mysql.com/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/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/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/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. For some distribution types, such as RPM packages, ...
https://dev.mysql.com/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/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/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/data-lock-waits-table.html
Use the data_lock_waits table to help diagnose performance problems that occur during times of heavy concurrent load. The data_lock_waits table implements a many-to-many relationship showing which data lock requests in the data_locks table are ...
https://dev.mysql.com/date-calculations.html
To determine how many years old each of your pets is, use the TIMESTAMPDIFF() function. DATE_ADD() enables you to add a time interval to a given date. MySQL provides several functions that you can use to perform calculations on dates, for example, ...
