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-persistent-stats.html
You can also configure automatic statistics recalculation for individual tables by specifying the STATS_AUTO_RECALC clause when creating or altering a table. To override these system-wide settings and configure optimizer statistics parameters for ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-troubleshooting-datadict.html
mysql> ALTER TABLE sakila.actor DISCARD TABLESPACE; Copy the orphan .ibd file from your backup directory to the new database directory. Information about table definitions is stored in the InnoDB data dictionary. If you move data files around, ...
https://dev.mysql.com/doc/refman/8.0/en/known-issues.html
Alternatively, rename the old files to reflect your host name change. If you use ALTER TABLE to add a UNIQUE index to a table used in a MERGE table and then add a normal index on the MERGE table, the key order is different for the tables if there ...
https://dev.mysql.com/doc/refman/8.0/en/load-data.html
In some extreme cases, you can create the indexes even faster by turning them off with ALTER TABLE ... DISABLE KEYS before loading the file into the table and re-creating the indexes with ALTER TABLE ... The file can be read from the server host or ...
https://dev.mysql.com/doc/refman/8.0/en/macos-installation-pkg.html
From the Installation Type page you can either click Install to execute the installation wizard using all defaults, click Customize to alter which components to install (MySQL server, MySQL Test, Preference Pane, Launchd Support -- all but MySQL ...
https://dev.mysql.com/doc/refman/8.0/en/memory-storage-engine.html
The value in effect for CREATE TABLE, or a subsequent ALTER TABLE or TRUNCATE TABLE, is the value used for the life of the table. To free up the memory used by deleted rows, use ALTER TABLE ENGINE=MEMORY to force a table rebuild. The MEMORY storage ...
https://dev.mysql.com/doc/refman/8.0/en/merge-storage-engine.html
An alternative to a MERGE table is a partitioned table, which stores partitions of a single table in separate files and enables some operations to be performed more efficiently. Use ALTER TABLE tbl_name UNION=(...) to change the list of underlying ... The MERGE storage engine, also known as the MRG_MyISAM engine, is a collection of identical MyISAM tables that can be used as ...
https://dev.mysql.com/doc/refman/8.0/en/metadata-locking.html
For example, a second session blocks if it attempts any of these operations: DROP TABLE t; ALTER TABLE t ...; DROP TABLE nt; ALTER TABLE nt ...; LOCK TABLE t ... MySQL uses metadata locking to manage concurrent access to database objects and to ...
https://dev.mysql.com/doc/refman/8.0/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 ...
https://dev.mysql.com/doc/refman/8.0/en/myisamchk.html
The myisamchk utility gets information about your database tables or checks, repairs, or optimizes them. myisamchk works with MyISAM tables (tables that have .MYD and .MYI files for storing data and indexes). You can also use the CHECK TABLE and ...