https://dev.mysql.com/innodb-online-ddl.html
Benefits of this feature include: Improved responsiveness and availability in busy production environments, where making a table unavailable for minutes or hours is not practical. The online DDL feature provides support for instant and in-place ...
https://dev.mysql.com/innodb-parameters.html
The slow shutdown can take minutes, or even hours in extreme cases where substantial amounts of data are still buffered. System variables that are true or false can be enabled at server startup by naming them, or disabled by using a --skip- prefix.
https://dev.mysql.com/sys-format-time.html
Depending on the size of the value, the units part is ps (nanoseconds), ns (nanoseconds), us (microseconds), ms (milliseconds), s (seconds), m (minutes), h (hours), d (days), or w (weeks). Note As of MySQL 8.0.16, format_time() is deprecated and ...
https://dev.mysql.com/partitioning-limitations-functions.html
This section discusses limitations in MySQL Partitioning relating specifically to functions used in partitioning expressions. Each of these functions returns an integer only if it is passed an argument of an exact numeric type, such as one of the ...
https://dev.mysql.com/controlling-query-plan-evaluation.html
At the same time, if compiled with optimizer_search_depth equal to 3 or 4, the optimizer may compile in less than a minute for the same query. The task of the query optimizer is to find an optimal plan for executing an SQL query. Because the ...
https://dev.mysql.com/mysql-options.html
You can set the value so that a lost connection can be detected earlier than the TCP/IP Close_Wait_Timeout value of 10 minutes. int mysql_options(MYSQL *mysql, enum mysql_option option, const void *arg) Can be used to set extra connect options and ...
https://dev.mysql.com/mysql-cluster-options-variables.html
Time values can be optionally suffixed with h (hours), m (minutes), or s (seconds). This section provides information about MySQL server options, server and status variables that are specific to NDB Cluster. For general information on using these, ...
https://dev.mysql.com/performance-schema-statement-digests.html
The MySQL server is capable of maintaining statement digest information. The digesting process converts each SQL statement to normalized form (the statement digest) and computes a SHA-256 hash value (the digest hash value) from the normalized ...
https://dev.mysql.com/server-system-variables.html
log_throttle_queries_not_using_indexes Property Value Command-Line Format --log-throttle-queries-not-using-indexes=# System Variable log_throttle_queries_not_using_indexes Scope Global Dynamic Yes SET_VAR Hint Applies No Type Integer Default Value 0 ... The MySQL server maintains many system variables that configure its ...
https://dev.mysql.com/mysql-cluster-programs-ndb-waiter.html
ndb_waiter repeatedly (each 100 milliseconds) prints out the status of all cluster data nodes until either the cluster reaches a given status or the --timeout limit is exceeded, then exits. By default, it waits for the cluster to achieve STARTED ...
