PDF (US Ltr)
- 41.8Mb
PDF (A4)
- 41.9Mb
Man Pages (TGZ)
- 272.3Kb
Man Pages (Zip)
- 378.3Kb
Info (Gzip)
- 4.2Mb
Info (Zip)
- 4.2Mb
Search Results
https://dev.mysql.com/doc/refman/9.7/en/faqs-replication.html
The replica can go down or stay disconnected for hours or even days, and then reconnect and catch up on updates. Note that if your replica has been disconnected from the source for one hour, and then reconnects, you may immediately see large Time ...
https://dev.mysql.com/doc/refman/9.7/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/9.7/en/mysql-commands.html
mysql sends each SQL statement that you issue to the server to be executed. There is also a set of commands that mysql itself interprets. For a list of these commands, type help or \h at the mysql> prompt: mysql> help List of all MySQL commands: ...
https://dev.mysql.com/doc/refman/9.7/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/9.7/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/9.7/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 | LOGS | ...
https://dev.mysql.com/doc/refman/9.7/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/9.7/en/controlling-query-plan-evaluation.html
Because the difference in performance between “good” and “bad” plans can be orders of magnitude (that is, seconds versus hours or even days), most query optimizers, including that of MySQL, perform a more or less exhaustive search for an ...
https://dev.mysql.com/doc/refman/9.7/en/converting-tables-to-innodb.html
When loading large volumes of data with a sequence of INSERT statements, periodically COMMIT the results to avoid having transactions that last for hours. If an ALTER TABLE operation runs out of space, it starts a rollback, and that can take hours ... If you have MyISAM tables that you want to convert to InnoDB for better reliability and scalability, review the following guidelines and tips before ...
https://dev.mysql.com/doc/refman/9.7/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 ...