https://dev.mysql.com/create-function-udf.html
All active functions are reloaded each time the server starts, unless you start mysqld with the --skip-grant-tables option. CREATE [AGGREGATE] FUNCTION function_name RETURNS {STRING|INTEGER|REAL|DECIMAL} SONAME shared_library_name A user-defined ...
https://dev.mysql.com/create-index.html
CREATE [UNIQUE | FULLTEXT | SPATIAL] INDEX index_name [index_type] ON tbl_name (key_part,...) [index_option] [algorithm_option | lock_option] ... This guideline is especially important for InnoDB tables, where the primary key determines the ...
https://dev.mysql.com/create-logfile-group.html
There can be only one log file group per NDB Cluster instance at any given time. CREATE LOGFILE GROUP logfile_group ADD UNDOFILE 'undo_file' [INITIAL_SIZE [=] initial_size] [UNDO_BUFFER_SIZE [=] undo_buffer_size] [REDO_BUFFER_SIZE [=] ...
https://dev.mysql.com/create-table-check-constraints.html
Note Constraint expression evaluation uses the SQL mode in effect at evaluation time. Prior to MySQL 8.0.16, CREATE TABLE permits only the following limited version of table CHECK constraint syntax, which is parsed and ignored: CHECK (expr) As of ...
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 ...
