https://dev.mysql.com/sys-ps-setup-show-enabled-instruments.html
Displays all currently enabled Performance Schema instruments. This might be a long list. None. mysql> CALL sys.ps_setup_show_enabled_instruments()\G *************************** 1. row *************************** enabled_instruments: ...
https://dev.mysql.com/sys-statements-with-errors-or-warnings.html
last_seen The time at which the statement was most recently seen. These views display normalized statements that have produced errors or warnings. By default, rows are sorted by descending error and warning counts. The ...
https://dev.mysql.com/thread-pool-i_s-tables.html
They provide information about thread pool operation: TP_THREAD_GROUP_STATE: Information about thread pool thread group states TP_THREAD_GROUP_STATS: Thread group statistics TP_THREAD_STATE: Information about thread pool thread states Rows in these ... Note As of MySQL 8.0.14, the thread pool INFORMATION_SCHEMA tables are also available as Performance Schema ...
https://dev.mysql.com/type-conversion.html
If one of the arguments is a TIMESTAMP or DATETIME column and the other argument is a constant, the constant is converted to a timestamp before the comparison is performed. To be safe, always use complete datetime, date, or time strings when doing ... When an operator is used with operands of different types, type conversion occurs to make the operands ...
https://dev.mysql.com/upgrade-prerequisites.html
In-place upgrade to MySQL 8.0 is not supported if tables contain old temporal columns in pre-5.6.4 format (TIME, DATETIME, and TIMESTAMP columns without support for fractional seconds precision). (Alternatively, let the 8.0 server add those ...
https://dev.mysql.com/upgrading-from-previous-series.html
For example, use these lines in the server option file: [mysqld] default_authentication_plugin=mysql_native_password That setting enables pre-8.0 clients to connect to 8.0 servers until such time as the clients and connectors in use at your ...
https://dev.mysql.com/writing-audit-plugins.html
These variables can be used to communicate with the plugin at runtime. The first time the server calls event_notify for a thread, it creates a binding of the plugin to the thread. To register the plugin at runtime, use this statement (adjust the .so ... This section describes how to write a server-side audit plugin, using the example plugin found in the plugin/audit_null directory of MySQL source ...
https://dev.mysql.com/archive-storage-engine.html
A bulk insert is visible only after it completes, unless other inserts occur at the same time, in which case it can be seen partially. The ARCHIVE storage engine produces special-purpose tables that store large amounts of unindexed data in a very ...
https://dev.mysql.com/audit-log-reference.html
The following items are significant in the arg value (other items are ignored): timestamp, id: The location within the audit log of the first event to read. Example: mysql> SELECT audit_log_read(audit_log_read_bookmark()); ...Unless those components ...
https://dev.mysql.com/binary-log-setting.html
The logging format also can be switched at runtime, although note that there are a number of situations in which you cannot do this, as discussed later in this section. Some statements require a lot of execution time on the master, but result in ...
