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/grant.html
CREATE TABLESPACE Enable tablespaces and log file groups to be created, altered, or dropped. To create or drop a trigger, you must have the TRIGGER privilege for the table, not the trigger. (GRANT does not create such rows when ...(Alternatively, if ...[WITH GRANT OPTION] [AS user [WITH ROLE DEFAULT | NONE | ALL | ALL EXCEPT role [, role ] ...
https://dev.mysql.com/doc/refman/8.0/en/memory-storage-engine.html
The MEMORY storage engine (formerly known as HEAP) creates special-purpose tables with contents that are stored in memory. Characteristics of MEMORY Tables The MEMORY storage engine does not create any files on disk. DDL Operations for MEMORY ...A ...
https://dev.mysql.com/doc/refman/8.0/en/partitioning-limitations.html
Tables employing user-defined partitioning do not preserve the SQL mode in effect at the time that they were created. Therefore, a change in the SQL mode at any time after the creation of partitioned tables may lead to major changes in the behavior ...Partitioning and repartitioning operations (such as ALTER TABLE with PARTITION BY ..., REORGANIZE PARTITION, or REMOVE PARTITIONING) depend on file system operations for their ...
https://dev.mysql.com/doc/refman/8.0/en/system-schema.html
Previously, these tables were created in individual tablespace files in the mysql database directory. The change of grant-table storage engine underlies an accompanying change in MySQL 8.0 to the behavior of account-management statements such as ...
https://dev.mysql.com/doc/refman/8.0/en/alter-table-partition-operations.html
This clause always begins with PARTITION BY, and follows the same syntax and other rules as apply to the partition_options clause for CREATE TABLE (for more detailed information, see Section 15.1.20, “CREATE TABLE Statement”), and can also be ...
https://dev.mysql.com/doc/refman/8.0/en/merge-table-problems.html
The following are known problems with MERGE tables: MERGE child tables are locked through the parent table. If the parent is a temporary table, it is not locked, and thus the child tables are also not locked; this means that parallel use of the ...
https://dev.mysql.com/doc/refman/8.0/en/partitioning-management-range-list.html
If you now execute a SHOW CREATE TABLE statement, you can see how the partitioning makeup of the table has been changed: mysql> SHOW CREATE TABLE tr\G *************************** 1. Another solution might appear to be to make a copy of the table ...
https://dev.mysql.com/doc/refman/8.0/en/atomic-ddl.html
Supported table DDL statements include CREATE, ALTER, and DROP statements for databases, tablespaces, tables, and indexes, and the TRUNCATE TABLE statement. Supported non-table DDL statements include: CREATE and DROP statements, and, if applicable, ...In earlier MySQL versions, metadata was stored in metadata files, nontransactional tables, and storage engine-specific dictionaries, which necessitated intermediate ...An ...
https://dev.mysql.com/doc/refman/8.0/en/converting-tables-to-innodb.html
Note Partitioned MyISAM tables created in previous versions of MySQL are not compatible with MySQL 8.0. When you convert MyISAM tables that are large, frequently accessed, and hold vital data, investigate and consider the innodb_file_per_table and ... If you have MyISAM tables that you want to convert to InnoDB for better reliability and scalability, review the following guidelines and tips before ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema-tables-table.html
Prior to MySQL 8.0.16, CREATE_OPTIONS shows the ENCRYPTION clause specified for tables created in file-per-table tablespaces. The encryption clause is not shown for tables created in general tablespaces. When creating a table with strict mode ...The ...To always retrieve the latest statistics directly from storage engines, set information_schema_stats_expiry ...