PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 296.5Kb
Man Pages (Zip)
- 401.9Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/innodb-parameters.html
The slow shutdown can take minutes, or even hours in extreme cases where substantial amounts of data are still buffered. Generally, the combined size of the log files should be large enough that the server can smooth out peaks and troughs in ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-nutshell.html
This offset uses the same format as that employed when setting the time_zone system variable, except that a leading zero is required when the hours portion of the offset is less than 10, and '-00:00' is not allowed. This section summarizes what has ...
https://dev.mysql.com/doc/refman/8.0/en/thread-pool-tuning.html
In the worst case, this could take hours or even days. Suppose a server executes a workload where 99.9% of the statements complete within 100ms even when the server is loaded, and the remaining statements take between 100ms and 2 hours fairly evenly ... This section provides guidelines on determining the best configuration for thread pool performance, as measured using a metric such as transactions per ...
https://dev.mysql.com/doc/refman/8.0/en/mysqladmin.html
You can use it to check the server's configuration and current status, to create and drop databases, and more. Invoke mysqladmin like this: mysqladmin [options] command [command-arg] [command [command-arg]] ... Some of the commands take an argument ...
https://dev.mysql.com/doc/refman/8.0/en/flush.html
Resetting resource indicators enables clients that have reached their hourly connection, query, or update limits to resume activity immediately. | tables_option } flush_option: { BINARY LOGS | ENGINE LOGS | ERROR LOGS | GENERAL LOGS | HOSTS | LOGS | ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-system-variables.html
You can specify a timeout value up to a maximum of 3600 seconds (1 hour). The group_replication_member_expel_timeout system variable determines the waiting period (up to an hour) that is allowed in addition to the initial 5-second detection period ... This section lists the system variables that are specific to the Group Replication ...
https://dev.mysql.com/doc/refman/8.0/en/alter-user.html
ALTER USER permits these resource_option values: MAX_QUERIES_PER_HOUR count, MAX_UPDATES_PER_HOUR count, MAX_CONNECTIONS_PER_HOUR count For all accounts named by the statement, these options restrict how many queries, updates, and connections to the ... ALTER USER [IF EXISTS] user [auth_option] [, user [auth_option]] ...
https://dev.mysql.com/doc/refman/8.0/en/error-log-rule-based-filtering.html
This rule throttles errors and warnings to 1000 occurrences per hour and information messages to 100 occurrences per hour: IF prio <= INFORMATION THEN throttle 1000/3600 ELSE throttle 100/3600. The log_filter_dragnet log filter component enables ...
https://dev.mysql.com/doc/refman/8.0/en/time-zone-support.html
A leading zero can optionally be used for hours values less than 10; MySQL prepends a leading zero when storing and retrieving the value in such cases. The example uses values that are appropriate for the 2007 DST 1-hour change that occurs in the ...
https://dev.mysql.com/doc/refman/8.0/en/create-user.html
CREATE USER permits these resource_option values: MAX_QUERIES_PER_HOUR count, MAX_UPDATES_PER_HOUR count, MAX_CONNECTIONS_PER_HOUR count For all accounts named by the statement, these options restrict how many queries, updates, and connections to ...