PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 297.2Kb
Man Pages (Zip)
- 402.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/replication-upgrade.html
Upgrade Procedure With Table Repair Or Rebuild Some upgrades may require that you drop and re-create database objects when you move from one MySQL series to the next. Perform any table repair or rebuilding operations needed to re-create database ...
https://dev.mysql.com/doc/refman/8.0/en/show-open-tables.html
The FROM clause, if present, restricts the tables shown to those present in the db_name database. SHOW OPEN TABLES output has these columns: Database The database containing the table. Name locking is used for operations such as dropping or renaming ... SHOW OPEN TABLES [{FROM | IN} db_name] [LIKE 'pattern' | WHERE expr] SHOW OPEN TABLES lists the non-TEMPORARY tables that are currently open in the table ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-memcached-intro.html
The default settings represent a combination of high reliability and the fewest surprises for database applications. For example, default settings avoid uncommitted data on the database side, or stale data returned for memcached get requests. The ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-importing-data.html
If a data import operation does not complete successfully, for whatever reason, you should be prepared to perform any necessary cleanup including possibly one or more DROP TABLE statements, DROP DATABASE statements, or both. Failing to do so may ...
https://dev.mysql.com/doc/refman/8.0/en/show-tables.html
SHOW [EXTENDED] [FULL] TABLES [{FROM | IN} db_name] [LIKE 'pattern' | WHERE expr] SHOW TABLES lists the non-TEMPORARY tables in a given database. These temporary tables have names beginning with #sql and can be dropped using DROP TABLE. You can ...
https://dev.mysql.com/doc/refman/8.0/en/events-syntax.html
An event can be dropped by any user having the EVENT privilege for the database on which the event is defined. When a scheduled event is no longer wanted or needed, it can be deleted from the server by its definer using the DROP EVENT statement.
https://dev.mysql.com/doc/refman/8.0/en/merge-storage-engine.html
The underlying tables do not have to be in the same database as the MERGE table. Use of DROP TABLE with a MERGE table drops only the MERGE specification. The MERGE storage engine, also known as the MRG_MyISAM engine, is a collection of identical ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-limitations-limits.html
A DROP TABLE or TRUNCATE TABLE operation on an NDB table frees the memory that was used by this table for re-use by any NDB table, either by the same table or by another NDB table. These hard limits include: Database memory size and index memory ...
https://dev.mysql.com/doc/refman/8.0/en/account-categories.html
Without the system user concept, a user who has the CREATE USER privilege can modify or drop any existing account, including the root account. Regular users with the CREATE USER privilege can still modify or drop existing accounts, but only regular ... As of MySQL 8.0.16, MySQL incorporates the concept of user account categories, based on the SYSTEM_USER ...
https://dev.mysql.com/doc/refman/8.0/en/alter-table-examples.html
If you drop an AUTO_INCREMENT column and then add another AUTO_INCREMENT column, the numbers are resequenced beginning with 1. Regardless of the method used to create and populate the copy having the AUTO_INCREMENT column, the final step is to drop ...For NDB tables, it is also possible to change the storage type used for a table or ...