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/check-table.html
With FOR UPGRADE, the server checks each table to determine whether there have been any incompatible changes in any of the table's data types or indexes since the table was created. option: { FOR UPGRADE | QUICK | FAST | MEDIUM | EXTENDED | CHANGED ...The last row has a Msg_type value of status and the Msg_text normally should be ...
https://dev.mysql.com/doc/refman/8.0/en/privileges-provided.html
Renaming a table requires ALTER and DROP on the old table, CREATE, and INSERT on the new table. CREATE Enables use of statements that create new databases and tables. CREATE TABLESPACE Enables use of statements that create, alter, or drop ... The ...
https://dev.mysql.com/doc/refman/8.0/en/general-thread-states.html
After create This occurs when the thread creates a table (including internal temporary tables), at the end of the function that creates the table. This state is used even if the table could not be created due to some error. This state occurs after ...altering table The server is in the process of executing an in-place ALTER ... The following list describes thread State values that are associated with ...
https://dev.mysql.com/doc/refman/8.0/en/explain-output.html
Using temporary (JSON property: using_temporary_table) To resolve the query, MySQL needs to create a temporary table to hold the result. EXPLAIN returns a row of information for each table used in the SELECT statement. It lists the tables in the ...
https://dev.mysql.com/doc/refman/8.0/en/flush.html
InnoDB supports FOR EXPORT for tables that have their own .ibd file file (that is, tables created with the innodb_file_per_table setting enabled). | tables_option } flush_option: { BINARY LOGS | ENGINE LOGS | ERROR LOGS | GENERAL LOGS | HOSTS | LOGS ...Note It is not possible to issue FLUSH statements within stored functions or ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-ndbd-definition.html
(NDB 8.0.13) This parameter specifies the directory where all files created for metadata, REDO logs, UNDO logs (for Disk Data tables), and data files are placed. Consider this table definition: CREATE TABLE example ( a INT NOT NULL, b INT NOT NULL, ...Information about configuration parameters specific to NDB Cluster Disk Data tables can be found later in this section (see Disk Data Configuration ...
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/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/mysql-cluster-replication-schema.html
The ndb_binlog_index and ndb_apply_status tables are created in the mysql database. User intervention is normally not required to create or maintain either of these tables, since both are maintained by the NDB binary log (binlog) injector thread.
https://dev.mysql.com/doc/refman/8.0/en/optimizer-hints.html
For example, you can enable an optimization for one table in a statement and disable the optimization for a different table. References to table and index names follow the usual identifier case-sensitivity rules (see Section 11.2.3, “Identifier ...