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/MySQLInstallerConsole.html
Options: --continue Continues processing the next product when an error is caught while processing the action blocks containing arguments for each product. If not specified the whole operation is aborted in case of an error. --continue Continues ...
https://dev.mysql.com/doc/refman/8.0/en/partitioning-limitations-partitioning-keys-unique-keys.html
This section discusses the relationship of partitioning keys with primary keys and unique keys. The rule governing this relationship can be expressed as follows: All columns used in the partitioning expression for a partitioned table must be part ...
https://dev.mysql.com/doc/refman/8.0/en/replication-features-differing-tables.html
Attempting the latter conversion in this case would cause replication to stop with an error on the replica. If only ALL_NON_LOSSY is set, but not ALL_LOSSY, then attempting a conversion that would result in the loss of data (such as INT to TINYINT, ... Source and target tables for replication do not have to be ...
https://dev.mysql.com/doc/refman/8.0/en/replication-howto-additionalslaves.html
If an event runs on the new replica that has already run on the source, the duplicated operation causes an error. Alternatively, if you have already tried to start the new replica after following the remaining steps in this section and have ... You ...
https://dev.mysql.com/doc/refman/8.0/en/replication-rbr-safe-unsafe.html
If a large number of such statements were executed on the source, this could lead to excessively large error log files. When activated, this causes such warnings not to be written to the error log; instead, for each 50 warnings of this type, a note ... The “safeness” of a statement in MySQL replication refers to whether the statement and its effects can be replicated correctly using statement-based ...
https://dev.mysql.com/doc/refman/8.0/en/select.html
Use of an unqualified * with other items in the select list may produce a parse error. (If you attempt to do so, the statement is rejected with the error Can't update table 'old_table' while 'new_table' is being created.) FOR SHARE and LOCK IN SHARE ... SELECT [ALL | DISTINCT | DISTINCTROW ] [HIGH_PRIORITY] [STRAIGHT_JOIN] [SQL_SMALL_RESULT] [SQL_BIG_RESULT] [SQL_BUFFER_RESULT] [SQL_NO_CACHE] [SQL_CALC_FOUND_ROWS] select_expr [, select_expr] ...
https://dev.mysql.com/doc/refman/8.0/en/slow-query-log.html
Note If you specify the TABLE log destination, see Log Tables and “Too many open files” Errors. The log_timestamps system variable controls the time zone of timestamps in messages written to the slow query log file (as well as to the general ...
https://dev.mysql.com/doc/refman/8.0/en/upgrade-prerequisites.html
To check for these issues, execute this command: mysqlcheck -u root -p --all-databases --check-upgrade If mysqlcheck reports any errors, correct the issues. To avoid upgrade errors, such views should be altered before upgrading. Failing to do so ...
https://dev.mysql.com/doc/refman/8.0/en/upgrading-what-is-upgraded.html
If the data dictionary is out of date but the server is prevented from upgrading it, the server does not run, and exits with an error instead. For example: [ERROR] [MY-013381] [Server] Server shutting down because upgrade is required, yet prohibited ... Installing a new version of MySQL may require upgrading these parts of the existing installation: The mysql system schema, which contains tables that store information required by the MySQL server as it runs (see Section 7.3, “The mysql System ...
https://dev.mysql.com/doc/refman/8.0/en/x-plugin-status-variables.html
Mysqlx_aborted_clients The number of clients that were disconnected because of an input or output error. Mysqlx_cursor_close The number of cursor-close messages received Mysqlx_cursor_fetch The number of cursor-fetch messages received ...