Search Results
https://dev.mysql.com/doc/mysql-em-plugin/en/myoem-config-metric-tableconfiguration-category.html
Old Alter Table Enabled Whether to revert to using a temporary table, copying over the data, and then renaming the temporary table to the original, as used by MySQL 5.0 and earlier. Lists the Table Configuration configuration metrics and provides a ...Explicit Defaults For Timestamp Enabled Sets whether TIMESTAMP columns has an explicit DEFAULT ...
https://dev.mysql.com/doc/refman/8.4/en/partitioning-key.html
Important For a key-partitioned table, you cannot execute an ALTER TABLE DROP PRIMARY KEY, as doing so generates the error ERROR 1466 (HY000): Field in list of fields for partition function not found in table. NDB Cluster uses MD5() for this ...
https://dev.mysql.com/doc/refman/8.4/en/partitioning-management.html
There are a number of ways using SQL statements to modify partitioned tables; it is possible to add, drop, redefine, merge, or split existing partitions using the partitioning extensions to the ALTER TABLE statement. To change a table's ...There ...
https://dev.mysql.com/doc/refman/8.4/en/myisam-storage-engine.html
(When an AUTO_INCREMENT column is defined as the last column of a multiple-column index, reuse of values deleted from the top of a sequence does occur.) The AUTO_INCREMENT value can be reset with ALTER TABLE or myisamchk. Table 18.2 MyISAM Storage ... MyISAM is based on the older (and no longer available) ISAM storage engine but has many useful ...
https://dev.mysql.com/doc/refman/8.4/en/table-locking.html
InnoDB tables use row-level locking so that multiple sessions and applications can read from and write to the same table simultaneously, without making each other wait or producing inconsistent results. For this storage engine, avoid using the LOCK ...See Chapter 17, The InnoDB Storage Engine for more details about this storage ...
https://dev.mysql.com/doc/refman/8.4/en/myisam-repair.html
In this case, you must use ALTER TABLE to increase the MAX_ROWS and AVG_ROW_LENGTH table option values: ALTER TABLE tbl_name MAX_ROWS=xxx AVG_ROW_LENGTH=yyy; If you do not know the current table option values, use SHOW CREATE TABLE. The discussion ...On Unix, make sure that they are readable by the user that mysqld runs as (and to you, because you need to access the files you are ...
https://dev.mysql.com/doc/refman/8.4/en/optimizing-queries-myisam.html
Some general tips for speeding up queries on MyISAM tables: To help MySQL better optimize queries, use ANALYZE TABLE or run myisamchk --analyze on a table after it has been loaded with data. (For unique indexes, this is always 1.) MySQL uses this ...This updates a value for each index part that indicates the average number of rows that have the same ...
https://dev.mysql.com/doc/refman/8.4/en/fulltext-fine-tuning.html
To rebuild FULLTEXT indexes for an InnoDB table, use ALTER TABLE with the DROP INDEX and ADD INDEX options to drop and re-create each index. To rebuild the FULLTEXT indexes for a MyISAM table, it is sufficient to do a QUICK repair operation: mysql> ...Do not alter the MySQL sources unless you know what you are ...You can exert more control over full-text searching behavior if you have a MySQL source ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-migration.html
Issue this ALTER TABLE statement to delete the current .ibd file: ALTER TABLE tbl_name DISCARD TABLESPACE; Copy the backup .ibd file to the proper database directory. Issue this ALTER TABLE statement to tell InnoDB to use the new .ibd file for the ... This section describes techniques for moving or copying some or all InnoDB tables to a different server or ...MySQL Enterprise Backup The MySQL Enterprise Backup product lets you back up a ...
https://dev.mysql.com/doc/relnotes/mysql/8.4/en/news-8-4-4.html
Alternatively, you can drop and re-create such indexes immediately following the upgrade, but before making use of any of the tables in which they occur. (Bug #37271715) InnoDB: It was possible for an ALTER TABLE operation using the INPLACE ...(Bug ... Account Management Notes C API Notes Character Set Support Compilation Notes Component Notes Firewall Notes Installation Notes Optimizer Notes Performance Schema Notes Functionality Added or Changed Bugs Fixed Account Management Notes The database cache was not flushed properly following execution of DROP ...