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/source-thread-states.html
This enables monitoring tools that rely on the old names to continue working until they can be updated to use the new names. Master has sent all binlog to slave; waiting for more updates From MySQL 8.0.26: Source has sent all binlog to replica; ...
https://dev.mysql.com/doc/refman/8.0/en/myisamlog.html
Invoke myisamlog like this: myisamlog [options] [file_name [tbl_name] ...] The default operation is update (-u). If a recovery is done (-r), all writes and possibly updates and deletes are done and errors are only counted. If tables are named on the ...To create such a file, start the server with a --log-isam=log_file ...
https://dev.mysql.com/doc/refman/8.0/en/replica-logs-status.html
Important Do not attempt to update or insert rows in the mysql.slave_master_info or mysql.slave_relay_log_info tables manually. Use a restricted access mode to protect database backups that include this table. With the GTID_ONLY setting, the ... A ...
https://dev.mysql.com/doc/refman/8.0/en/myisampack.html
Please note the following: If the mysqld server was invoked with external locking disabled, it is not a good idea to invoke myisampack if the table might be updated by the server during the packing process. If the mysqld server was invoked with ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-events-transactions-current-table.html
END_EVENT_ID This column is set to NULL when the event starts and updated to the thread current event number when the event ends. If gtid_mode is either ON or ON_PERMISSIVE, the GTID column changes to the transaction's GTID. If gtid_mode is either ...The table stores one row per thread showing the current status of the thread's most recent monitored transaction event, so there is no system variable for configuring the table ...
https://dev.mysql.com/doc/refman/8.0/en/with.html
A common table expression (CTE) is a named temporary result set that exists within the scope of a single statement and that can be referred to later within that statement, possibly multiple times. The following discussion describes how to write ...
https://dev.mysql.com/doc/refman/8.0/en/binary-varbinary.html
If strict SQL mode is not enabled and you assign a value to a BINARY or VARBINARY column that exceeds the column's maximum length, the value is truncated to fit and a warning is generated. For cases of truncation, to cause an error to occur (rather ... The BINARY and VARBINARY types are similar to CHAR and VARCHAR, except that they store binary strings rather than nonbinary ...
https://dev.mysql.com/doc/refman/8.0/en/caching-sha2-pluggable-authentication.html
For example: $> mysql --ssl-mode=DISABLED -u sha2user -p Enter password: password For this connection attempt by sha2user, the server determines that caching_sha2_password is the appropriate authentication plugin and invokes it (because that was the ... MySQL provides two authentication plugins that implement SHA-256 hashing for user account passwords: caching_sha2_password: Implements SHA-256 authentication (like the deprecated sha256_password), but uses caching on the server side for better performance and has additional features for wider ...
https://dev.mysql.com/doc/refman/8.0/en/create-table-like.html
This means that if the current SQL mode is different from the mode in effect when the original table was created, the table definition might be considered invalid for the new mode and cause the statement to fail. LIKE to create an empty table based ...
https://dev.mysql.com/doc/refman/8.0/en/group-by-handling.html
If the ONLY_FULL_GROUP_BY SQL mode is enabled (which it is by default), MySQL rejects queries for which the select list, HAVING condition, or ORDER BY list refer to nonaggregated columns that are neither named in the GROUP BY clause nor are ...