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/upgrade-prerequisites.html
There must be no obsolete SQL modes defined by sql_mode system variable. Attempting to use an obsolete SQL mode prevents MySQL 8.0 from starting. Applications that use obsolete SQL modes should be revised to avoid them. For information about SQL ...
https://dev.mysql.com/doc/refman/8.0/en/x-plugin-system-monitoring.html
We use MySQL Shell in Python mode, and the \sql command which enables you to issue SQL statements without changing to SQL mode. This is important, because if you instead try to switch to SQL mode, the procedure shows the result of this operation ...
https://dev.mysql.com/doc/refman/8.0/en/create-index.html
For a unique index, an error occurs regardless of SQL mode because reducing the index length might enable insertion of nonunique entries that do not meet the specified uniqueness requirement. CREATE [UNIQUE | FULLTEXT | SPATIAL] INDEX index_name ...
https://dev.mysql.com/doc/refman/8.0/en/create-table-generated-columns.html
STORED: Column values are evaluated and stored when rows are inserted or updated. Note Expression evaluation uses the SQL mode in effect at evaluation time. If any component of the expression depends on the SQL mode, different results may occur for ...Values of a generated column are computed from an expression included in the column ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-information-schema-examples.html
Note This section describes locking information as exposed by the Performance Schema data_locks and data_lock_waits tables, which supersede the INFORMATION_SCHEMA INNODB_LOCKS and INNODB_LOCK_WAITS tables in MySQL 8.0. For similar discussion ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-limitations-transactions.html
LOCK IN SHARE MODE causes shared row locks to be used; FOR UPDATE causes exclusive row locks to be used. When a row referenced by a unique index in the user-created NDB table is updated, the hidden index table is subject to an exclusive lock by the ... A number of limitations exist in NDB Cluster with regard to the handling of ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema-tables-table.html
Even with file-per-table mode with each InnoDB table in a separate .ibd file, change buffering can delay the write to the data file, so the file modification time is different from the time of the last insert, update, or delete. To update cached ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-locks-set.html
A locking read, an UPDATE, or a DELETE generally set record locks on every index record that is scanned in the processing of an SQL statement. For locking reads (SELECT with FOR UPDATE or FOR SHARE), UPDATE, and DELETE statements, the locks that ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-option-tables.html
ndb-log-apply-status: Cause MySQL server acting as replica to log mysql.ndb_apply_status updates received from its immediate source in its own binary log, using its own server ID. ndb-log-empty-epochs: When enabled, causes epochs in which there were ... 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/myisamchk-table-info.html
myisamchk -d tbl_name Runs myisamchk in “describe mode” to produce a description of your table. If you start the MySQL server with external locking disabled, myisamchk may report an error for a table that is updated while it runs. However, ...