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/fulltext-fine-tuning.html
Do not alter the MySQL sources unless you know what you are doing. Add a new collation for the character set used by the indexed columns, and alter the columns to use that collation. To rebuild FULLTEXT indexes for an InnoDB table, use ALTER TABLE ...You can exert more control over full-text searching behavior if you have a MySQL source distribution because some changes require source code ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema-events-table.html
EXECUTE_AT For a one-time event, this is the DATETIME value specified in the AT clause of the CREATE EVENT statement used to create the event, or of the last ALTER EVENT statement that modified the event. SQL_MODE The SQL mode in effect when the ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-auto-increment-handling.html
In MySQL 5.7 and earlier, a server restart cancels the effect of the AUTO_INCREMENT = N table option, which may be used in a CREATE TABLE or ALTER TABLE statement to set an initial counter value or alter the existing counter value, respectively. If ... InnoDB provides a configurable locking mechanism that can significantly improve scalability and performance of SQL statements that add rows to tables with AUTO_INCREMENT ...
https://dev.mysql.com/doc/refman/8.0/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 ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-limitations-syntax.html
Trying either to create a temporary table that uses the NDB storage engine or to alter an existing temporary table to use NDB fails with the error Table storage engine 'ndbcluster' does not support the create option 'TEMPORARY'. CREATE TABLE and ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-option-tables.html
ndb-allow-copying-alter-table: Set to OFF to keep ALTER TABLE from using copying operations on NDB tables. ndb_read_backup: Enable read from any replica for all NDB tables; use NDB_TABLE=READ_BACKUP={0|1} with CREATE TABLE or ALTER TABLE to enable ... The following list includes command-line options, system variables, and status variables applicable within mysqld when it is running as an SQL node in an NDB ...
https://dev.mysql.com/doc/refman/8.0/en/mysqldump.html
mysqldump output can include ALTER DATABASE statements that change the database collation. To reload a dump file containing such statements, the ALTER privilege for the affected database is required. Alternatively, the client user can select a mode ... The mysqldump client utility performs logical backups, producing a set of SQL statements that can be executed to reproduce the original database object definitions and table ...
https://dev.mysql.com/doc/refman/8.0/en/resetting-permissions.html
If you know the root password and want to change it, see Section 15.7.1.1, “ALTER USER Statement”, and Section 15.7.1.10, “SET PASSWORD Statement”. Alternatively, you can log in as root, but in this case you must start mysqld with the ... If ...
https://dev.mysql.com/doc/refman/8.0/en/server-options.html
It is ignored and has no effect on the operation of ALTER INSTANCE RELOAD TLS at runtime. For example, you can use --admin-ssl=OFF to start the administrative interface with encrypted connections disabled, then reconfigure TLS and execute ALTER ...
https://dev.mysql.com/doc/refman/8.0/en/sql-mode.html
NO_ENGINE_SUBSTITUTION Control automatic substitution of the default storage engine when a statement such as CREATE TABLE or ALTER TABLE specifies a storage engine that is disabled or not compiled in. For ALTER TABLE, a warning occurs and the table ... The MySQL server can operate in different SQL modes, and can apply these modes differently for different clients, depending on the value of the sql_mode system ...