https://dev.mysql.com/partitioning-key.html
Partitioning by key is similar to partitioning by hash, except that where hash partitioning employs a user-defined expression, the hashing function for key partitioning is supplied by the MySQL server. NDB Cluster uses MD5() for this purpose; for ...
https://dev.mysql.com/partitioning-linear-hash.html
MySQL also supports linear hashing, which differs from regular hashing in that linear hashing utilizes a linear powers-of-two algorithm whereas regular hashing employs the modulus of the hashing function's value. We call this value V; it can be ...
https://dev.mysql.com/replace.html
REPLACE [LOW_PRIORITY | DELAYED] [INTO] tbl_name [PARTITION (partition_name [, partition_name] ...)] [(col_name [, col_name] ...)] {VALUES | VALUE} (value_list) [, (value_list)] ... REPLACE [LOW_PRIORITY | DELAYED] [INTO] tbl_name [PARTITION ...
https://dev.mysql.com/static-format.html
It is used when the table contains no variable-length columns (VARCHAR, VARBINARY, BLOB, or TEXT). Static-format tables have these characteristics: CHAR and VARCHAR columns are space-padded to the specified column width, although the column type is ...Of the three MyISAM storage formats, static format is the simplest and most secure (least subject to ...
https://dev.mysql.com/string-comparison-functions.html
For example, consider the following table and data: CREATE TABLE foo (bar VARCHAR(10)); INSERT INTO foo VALUES (NULL), (NULL); The query SELECT COUNT(*) FROM foo WHERE bar LIKE '%baz%'; returns 0. Table 12.8 String Comparison Functions and ...
https://dev.mysql.com/sys-create-synonym-db.html
in_db_name VARCHAR(64): The name of the schema for which to create the synonym. Given a schema name, this procedure creates a synonym schema containing views that refer to all the tables and views in the original schema. This can be used, for ...
https://dev.mysql.com/sys-extract-schema-from-file-name.html
path VARCHAR(512): The full path to a data file from which to extract the schema name. Given a file path name, returns the path component that represents the schema name. This function assumes that the file name lies within the schema directory.
https://dev.mysql.com/sys-extract-table-from-file-name.html
path VARCHAR(512): The full path to a data file from which to extract the table name. Given a file path name, returns the path component that represents the table name. This function is useful when extracting file I/O information from the ...
https://dev.mysql.com/sys-format-path.html
Given a path name, returns the modified path name after replacing subpaths that match the values of the following system variables, in order: datadir tmpdir slave_load_tmpdir innodb_data_home_dir innodb_log_group_home_dir innodb_undo_directory ...
https://dev.mysql.com/sys-ps-is-account-enabled.html
Returns YES or NO to indicate whether Performance Schema instrumentation for a given account is enabled. mysql> SELECT sys.ps_is_account_enabled('localhost', 'root'); +------------------------------------------------+ | ...
