PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 297.2Kb
Man Pages (Zip)
- 402.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/partitioning-info.html
This section discusses obtaining information about existing partitions, which can be done in a number of ways. Methods of obtaining such information include the following: Using the SHOW CREATE TABLE statement to view the partitioning clauses used ...
https://dev.mysql.com/doc/refman/8.0/en/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/doc/refman/8.0/en/replace.html
REPLACE [LOW_PRIORITY | DELAYED] [INTO] tbl_name [PARTITION (partition_name [, partition_name] ...)] [(col_name [, col_name] ...)] { {VALUES | VALUE} (value_list) [, (value_list)] ... | VALUES row_constructor_list } REPLACE [LOW_PRIORITY | DELAYED] ...
https://dev.mysql.com/doc/refman/8.0/en/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/doc/refman/8.0/en/string-comparison-functions.html
This differs from comparisons performed with the = operator, for which the significance of trailing spaces in nonbinary strings (CHAR, VARCHAR, and TEXT values) depends on the pad attribute of the collation used for the comparison. For example, ...
https://dev.mysql.com/doc/refman/8.0/en/sys-create-synonym-db.html
Parameters 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 ...
https://dev.mysql.com/doc/refman/8.0/en/sys-extract-schema-from-file-name.html
Parameters 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 ...
https://dev.mysql.com/doc/refman/8.0/en/sys-extract-table-from-file-name.html
Parameters 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 ...
https://dev.mysql.com/doc/refman/8.0/en/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 or replica_load_tmpdir innodb_data_home_dir innodb_log_group_home_dir ...
https://dev.mysql.com/doc/refman/8.0/en/sys-ps-is-account-enabled.html
Parameters in_host VARCHAR(60): The host name of the account to check. Returns YES or NO to indicate whether Performance Schema instrumentation for a given account is enabled. Example mysql> SELECT sys.ps_is_account_enabled('localhost', 'root'); ...