PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 256.4Kb
Man Pages (Zip)
- 361.2Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/flow-control-functions.html
The second syntax returns the result for the first condition that is true. If no comparison or condition is true, the result after ELSE is returned, or NULL if there is no ELSE part. Note The syntax of the CASE operator described here differs ...
https://dev.mysql.com/doc/refman/5.7/en/replication-rules.html
If the server does log the statement, the statement is sent to all replicas and each replica determines whether to execute it or ignore it. Instead, use filtering on the replica to control the events that are executed on the replica. On the replica ... If a replication source server does not write a statement to its binary log, the statement is not ...
https://dev.mysql.com/doc/refman/5.7/en/sys-ps-trace-thread.html
in_max_runtime DECIMAL(20,2): The maximum number of seconds (which can be fractional) to collect data. This procedure disables binary logging during its execution by manipulating the session value of the sql_log_bin system variable. Use NULL to ...
https://dev.mysql.com/doc/refman/5.7/en/date-calculations.html
To determine how many years old each of your pets is, use the TIMESTAMPDIFF() function. DATE_ADD() enables you to add a time interval to a given date. MySQL provides several functions that you can use to perform calculations on dates, for example, ...
https://dev.mysql.com/doc/refman/5.7/en/locking-service.html
Timeout values must be integers indicating how many seconds to wait to acquire locks before giving up with an error. Lock acquisition calls take an integer timeout value that indicates how many seconds to wait to acquire locks before giving up. If ...Namespace and lock names must be non-NULL, nonempty, and have a maximum length of 64 ... MySQL distributions provide a locking interface that is accessible at two levels: At the ...
https://dev.mysql.com/doc/refman/5.7/en/sys-host-summary-by-file-io-type.html
max_latency The maximum single wait time of timed occurrences of the file I/O event for the host. total_latency The total wait time of timed occurrences of the file I/O event for the host. These views summarize file I/O, grouped by host and event ...
https://dev.mysql.com/doc/refman/5.7/en/sys-user-summary-by-file-io-type.html
max_latency The maximum single wait time of timed occurrences of the file I/O event for the user. latency The total wait time of timed occurrences of the file I/O event for the user. These views summarize file I/O, grouped by user and event type.
https://dev.mysql.com/doc/refman/5.7/en/general-thread-states.html
deleting from reference tables The server is executing the second part of a multiple-table delete and deleting the matched rows from the other tables. updating reference tables The server is executing the second part of a multiple-table update and ...This state is used even if the table could not be created due to some ... The following list describes thread State values that are associated with ...
https://dev.mysql.com/doc/refman/5.7/en/thread-pool.html
The default thread-handling model in MySQL Server executes statements using one thread per client connection. As more clients connect to the server and execute statements, overall performance degrades. The plugin implements a thread pool that ...
https://dev.mysql.com/doc/refman/5.7/en/group-replication-view-changes.html
Figure 17.10 Stable Group View Change: a Member Joins Whenever a new member joins the group and therefore a view change is performed, every online server queues a view change log event for execution. Figure 17.12 State Transfer: Catching Up As view ... This section explains the process which controls how the view change identifier is incorporated into a binary log event and written to the log, The following steps are taken: Begin: Stable Group All servers are online and processing incoming transactions from the ...