Search Results
https://dev.mysql.com/doc/refman/8.4/en/partitioning-limitations.html
No InnoDB table definition may contain a foreign key reference to a user-partitioned table; no InnoDB table with user-defined partitioning may contain columns referenced by foreign keys. ORDER BY column statement run against a partitioned table ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-replication-schema.html
0 in the epoch column of this table indicates a transaction originating from a storage engine other than NDB. The number of epochs per binary log file normally depends on the amount of binary log generated per epoch and the size of the binary log ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-persistent-stats.html
If innodb_stats_auto_recalc is disabled, you can ensure the accuracy of optimizer statistics by executing the ANALYZE TABLE statement after making substantial changes to indexed columns. When an index is added to an existing table, or when a column ... The persistent optimizer statistics feature improves plan stability by storing statistics to disk and making them persistent across server restarts so that the optimizer is more likely to make consistent choices each time for a given ...
https://dev.mysql.com/doc/refman/8.4/en/set-operations.html
Result Set Column Names and Data Types Set Operations with TABLE and VALUES Statements Set Operations using DISTINCT and ALL Set Operations with ORDER BY and LIMIT Limitations of Set Operations SQL set operations combine the results of multiple ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-row-format.html
The B-tree index that represents an entire table is known as the clustered index, which is organized according to the primary key columns. The nodes of a clustered index data structure contain the values of all columns in the row. The nodes of a ...
https://dev.mysql.com/doc/refman/8.4/en/grant-tables.html
Each grant table contains scope columns and privilege columns: Scope columns determine the scope of each row in the tables; that is, the context in which the row applies. Similarly, a db table row with Host, User, and Db column values of ... The ...
https://dev.mysql.com/doc/refman/8.4/en/replication-features-differing-tables.html
A table on the source can have more or fewer columns than the replica's copy of the table. In addition, corresponding table columns on the source and the replica can use different data types, subject to certain conditions. (This is true even if both ... Source and target tables for replication do not have to be ...
https://dev.mysql.com/doc/connectors/en/connector-odbc-usagenotes-apptips-microsoft.html
Include a TIMESTAMP column in all tables that you want to be able to update. For maximum portability, do not use a length specification in the column declaration (which is unsupported within MySQL in versions earlier than 4.1). If you are using ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-compression-internals.html
Each row in the index node contains the values of the (user-specified or system-generated) primary key and all the other columns of the table. The pointer is in fact the value of the primary key of the table, which is used to access the clustered ...
https://dev.mysql.com/doc/refman/8.4/en/converting-tables-to-innodb.html
autocommit=1 is suitable for InnoDB tables when running a sequence of queries for generating reports or analyzing statistics. File-per-table tablespaces also support DYNAMIC and COMPRESSED row formats and associated features such as table ... If you ...