PDF (US Ltr)
- 43.2Mb
PDF (A4)
- 43.3Mb
Man Pages (TGZ)
- 295.2Kb
Man Pages (Zip)
- 400.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/innodb-file-space.html
In a newly created system tablespace, InnoDB allocates space starting from the first data file. To avoid the issues that come with storing all tables and indexes inside the system tablespace, you can enable the innodb_file_per_table configuration ...
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/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/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/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/stored-objects-security.html
If a definition omits the DEFINER attribute, the default object definer is the user who creates it. Creating a stored object with a nonexistent DEFINER account creates an orphan object, which may have negative consequences; see Orphan Stored Objects. This account must have the EXECUTE privilege for p1 as well as the UPDATE privilege for the table t1 referenced within the object ... Stored programs (procedures, functions, triggers, ...
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/index-hints.html
They also work with multi-table DELETE statements, but not with single-table DELETE, as shown later in this section. (For the general syntax for specifying tables in a SELECT statement, see Section 15.2.13.2, “JOIN Clause”.) The syntax for ...