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/mysql-cluster-programs-ndb-delete-all.html
--connect-retries Command-Line Format --connect-retries=# Type Integer Default Value 12 Minimum Value 0 Maximum Value 12 Number of times to retry connection before giving up. --connect-retry-delay Command-Line Format --connect-retry-delay=# Type ...
https://dev.mysql.com/doc/refman/5.7/en/mysqlslap.html
Run all the load statements, then run all the queries in the query file with five clients (five times each): mysqlslap --concurrency=5 --iterations=5 --query=query.sql --create=create.sql --delimiter=";" mysqlslap supports the following options, ...
https://dev.mysql.com/doc/refman/5.7/en/replication-threads-monitor-worker.html
The message lists the following statistics for the relevant replication channel, or the default replication channel (which is not named): Seconds elapsed The difference in seconds between the current time and the last time this information was ...A ... On a multithreaded replica, the Performance Schema tables replication_applier_status_by_coordinator and replication_applier_status_by_worker show status information for the replica's coordinator thread and applier worker threads ...
https://dev.mysql.com/doc/refman/5.7/en/version-tokens-reference.html
Timeout values are nonnegative integers representing the time in seconds to wait to acquire locks before timing out with an error. mysql> SELECT version_tokens_lock_exclusive('lock1', 'lock2', 10); ...(It is not an error to delete nonexisting ...
https://dev.mysql.com/doc/refman/5.7/en/thread-pool-tuning.html
When a statement arrives, what is the maximum time it can be delayed before it actually starts executing? Suppose that the following conditions apply: There are 200 statements queued in the low-priority queue. In the worst case, the 10 high-priority ... This section provides guidelines on setting thread pool system variables for best performance, measured using a metric such as transactions per ...Our experience in testing the thread pool indicates the following: If the primary storage ...
https://dev.mysql.com/doc/refman/5.7/en/create-trigger.html
CREATE [DEFINER = user] TRIGGER trigger_name trigger_time trigger_event ON tbl_name FOR EACH ROW [trigger_order] trigger_body trigger_time: { BEFORE | AFTER } trigger_event: { INSERT | UPDATE | DELETE } trigger_order: { FOLLOWS | PRECEDES } ...A ...
https://dev.mysql.com/doc/refman/5.7/en/load-data.html
Unless REPLACE is also specified, LOCAL has the same effect as the IGNORE modifier on the interpretation of input file contents and error handling; see Duplicate-Key and Error Handling, and Column Value Assignment. For example, if mysqld was started ...The file can be read from the server host or the client host, depending on whether the LOCAL modifier is ...
https://dev.mysql.com/doc/refman/5.7/en/nested-loop-joins.html
MySQL executes joins between tables using a nested-loop algorithm or variations on it. Nested-Loop Join Algorithm Block Nested-Loop Join Algorithm Nested-Loop Join Algorithm A simple nested-loop join (NLJ) algorithm reads rows from the first table ...For example, if 10 rows are read into a buffer and the buffer is passed to the next inner loop, each row read in the inner loop can be compared against all 10 rows in the ...
https://dev.mysql.com/doc/refman/5.7/en/option-files.html
Most MySQL programs can read startup options from option files (sometimes called configuration files). Option files provide a convenient way to specify commonly used options so that they need not be entered on the command line each time you run a ...To determine whether a program reads option files, invoke it with the --help ...
https://dev.mysql.com/doc/refman/5.7/en/get-diagnostics.html
(You can also use SHOW WARNINGS or SHOW ERRORS to see conditions or errors.) No special privileges are required to execute GET DIAGNOSTICS. The keyword STACKED means to retrieve information from the second diagnostics area, which is available only ... GET [CURRENT | STACKED] DIAGNOSTICS { statement_information_item [, statement_information_item] ...