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/keyring-system-variables.html
(It is permissible to rename or move the file, as long as you change the value of keyring_file_data to match.) It is recommended that you create a separate backup of the keyring data file immediately after you create the first encrypted table and ...
https://dev.mysql.com/doc/refman/8.0/en/type-conversion.html
mysql> SELECT 38.8, CAST(38.8 AS CHAR); -> 38.8, '38.8' mysql> SELECT 38.8, CONCAT(38.8); -> 38.8, '38.8' See later in this section for information about the character set of implicit number-to-string conversions, and for modified rules that apply ...A single-row subquery from a table or tables is not considered a ... When an operator is used with operands of ...
https://dev.mysql.com/doc/refman/8.0/en/partitioning-subpartitions.html
Consider the following CREATE TABLE statement: CREATE TABLE ts (id INT, purchased DATE) PARTITION BY RANGE( YEAR(purchased) ) SUBPARTITION BY HASH( TO_DAYS(purchased) ) SUBPARTITIONS 2 ( PARTITION p0 VALUES LESS THAN (1990), PARTITION p1 VALUES LESS ... Subpartitioning—also known as composite partitioning—is the further division of each partition in a partitioned ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-troubleshooting-datadict.html
See Section 17.6.1.4, “Moving or Copying InnoDB Tables” for information about creating clean backups. On the new MySQL instance, recreate the table in a database of the same name. Information about table definitions is stored in the InnoDB data ...If you move data files around, dictionary data can become ...
https://dev.mysql.com/doc/refman/8.0/en/audit-log-installation.html
Create the database first; its name should not exceed 64 characters. For example: mysql> CREATE DATABASE IF NOT EXISTS database-name; Next, run the script using the alternative database name. $> mysql -u root -p -D database-name < ... This section ...
https://dev.mysql.com/doc/refman/8.0/en/charset-unicode-conversion.html
Tables created with these row formats enable you to index a maximum of 1024 or 768 characters for utf8mb3 or utf8mb4 columns, respectively. In terms of table content, conversion from utf8mb3 to utf8mb4 presents no problems: For a BMP character, ...
https://dev.mysql.com/doc/refman/8.0/en/charset-conversion.html
If you specified attributes when creating a column initially, you should also specify them when altering the table with ALTER TABLE. To convert a binary or nonbinary string column to use a particular character set, use ALTER TABLE. Suppose that a ...For successful conversion to occur, one of the following conditions must apply: If the column has a binary data type (BINARY, VARBINARY, BLOB), all the values that it contains must be encoded using a single character set (the character set you're converting the column ...
https://dev.mysql.com/doc/refman/8.0/en/replication-options-reference.html
gtid_executed_compression_period: Compress gtid_executed table each time this many transactions have occurred. log_bin_trust_function_creators: If equal to 0 (default), then when --log-bin is used, stored function creation is allowed only to users ... The following two sections provide basic information about the MySQL command-line options and system variables applicable to replication and the binary ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema.html
INFORMATION_SCHEMA provides access to database metadata, information about the MySQL server such as the name of a database or table, the data type of a column, or access privileges. Other terms that are sometimes used for this information are data ...
https://dev.mysql.com/doc/refman/8.0/en/optimizing-innodb.html
This section explains how to optimize database operations for InnoDB tables. InnoDB is the storage engine that MySQL customers typically use in production databases where reliability and concurrency are important.