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-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 ...
https://dev.mysql.com/doc/refman/8.0/en/converting-tables-to-innodb.html
Make sure that any error handlers in your application also ROLLBACK incomplete changes or COMMIT completed changes. Handling Deadlocks You might see warning messages referring to “deadlocks” in the MySQL error log, or the output of SHOW ENGINE ... If you have MyISAM tables that you want to convert to InnoDB for better reliability and scalability, review the following guidelines and tips before ...
https://dev.mysql.com/doc/refman/8.0/en/enum.html
The strings you specify as input values are automatically encoded as numbers. The index value of the empty string error value is 0. If strict SQL mode is enabled, attempts to insert invalid ENUM values result in an error. Duplicate values in the ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-locking-reads.html
Your application code can ensure referential integrity throughout this sequence of operations. For another example, consider an integer counter field in a table CHILD_CODES, used to assign a unique identifier to each child added to table CHILD. For ... If you query data and then insert or update related data within the same transaction, the regular SELECT statement does not give enough ...
https://dev.mysql.com/doc/refman/8.0/en/keywords.html
Reserved words are permitted as identifiers if you quote them as described in Section 11.2, “Schema Object Names”: mysql> CREATE TABLE interval (begin INT, end INT); ERROR 1064 (42000): You have an error in your SQL syntax ... Certain keywords, ...