Rechercher dans le manuel MySQL
Search Results
https://dev.mysql.com/replication-features-timeout.html
The global system variable slave_transaction_retries sets the maximum number of times for applier threads on a single-threaded or multithreaded replication slave to automatically retry failed transactions before stopping. Transactions are ...If a ...
https://dev.mysql.com/replication-mode-change-online-verify-transactions.html
Or wait for a day, or whatever time period you consider safe for your deployment. This section explains how to monitor a replication topology and verify that all anonymous transactions have been replicated. This is helpful when changing the ...
https://dev.mysql.com/replication-sbr-rbr.html
If there is an error in evaluation on the slave, particularly when executing complex statements, statement-based replication may slowly increase the margin of error across the affected rows over time. This also means that making and restoring a ...
https://dev.mysql.com/rwlock-instances-table.html
An rwlock is a synchronization mechanism used in the code to enforce that threads at a given time can have access to some common resource following certain rules. The access is either shared (many threads can have a read lock at the same time), ...
https://dev.mysql.com/show-triggers.html
This is a TIMESTAMP(2) value (with a fractional part in hundredths of seconds) for triggers. SHOW TRIGGERS [{FROM | IN} db_name] [LIKE 'pattern' | WHERE expr] SHOW TRIGGERS lists the triggers currently defined for tables in a database (the default ...
https://dev.mysql.com/socket-pluggable-authentication.html
With this plugin-loading method, the option must be given each time the server starts. Alternatively, to load the plugin at runtime, use this statement: INSTALL PLUGIN auth_socket SONAME 'auth_socket.so'; INSTALL PLUGIN loads the plugin immediately, ... The server-side auth_socket authentication plugin authenticates clients that connect from the local host through the Unix socket ...
https://dev.mysql.com/statement-caching.html
For certain statements that a client might execute multiple times during a session, the server converts the statement to an internal structure and caches that structure to be used during execution. If the server does not detect this change the next ...Caching enables the server to perform more efficiently because it avoids the overhead of reconverting the statement should it be needed again during the ...
https://dev.mysql.com/stored-programs-logging.html
Because MySQL does not check if a function really is deterministic at creation time, the invocation of a stored function with the DETERMINISTIC keyword might carry out an action that is unsafe for statement-based logging, or invoke a function or ...
https://dev.mysql.com/string-functions.html
Permissible locale values are the same as the legal values for the lc_time_names system variable (see Section 10.16, “MySQL Server Locale Support”). REPEAT(str,count) Returns a string consisting of the string str repeated count times. For ...
https://dev.mysql.com/sys-ps-setup-show-disabled-instruments.html
Displays all currently disabled Performance Schema instruments. This might be a long list. None. mysql> CALL sys.ps_setup_show_disabled_instruments()\G *************************** 1. row *************************** disabled_instruments: ...
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-34.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.
