Rechercher dans le manuel MySQL
Search Results
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 ...
Document created the 26/06/2006, last modified the 26/10/2018
Source of the printed document:https://www.gaudry.be/en/mysql-rf-fct-time-p-35.html
The infobrol is a personal site whose content is my sole responsibility. The text is available under CreativeCommons license (BY-NC-SA). More info on the terms of use and the author.
References
These references and links indicate documents consulted during the writing of this page, or which may provide additional information, but the authors of these sources can not be held responsible for the content of this page.
The author This site is solely responsible for the way in which the various concepts, and the freedoms that are taken with the reference works, are presented here. Remember that you must cross multiple source information to reduce the risk of errors.
