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-api-definition.html
The timeout is applied with approximately 100 ms resolution, starting with a 100 ms delay; for each subsequent attempt, the length of this period is doubled until it reaches ConnectBackoffMaxTime milliseconds, up to a maximum of 100000 ms (100s).
https://dev.mysql.com/doc/refman/5.7/en/sys-waits-by-host-by-latency.html
max_latency The maximum single wait time of timed occurrences of the event for the host. total_latency The total wait time of timed occurrences of the event for the host. avg_latency The average wait time per timed occurrence of the event for the ...
https://dev.mysql.com/doc/refman/5.7/en/sys-waits-by-user-by-latency.html
max_latency The maximum single wait time of timed occurrences of the event for the user. total_latency The total wait time of timed occurrences of the event for the user. avg_latency The average wait time per timed occurrence of the event for the ...
https://dev.mysql.com/doc/refman/5.7/en/sys-waits-global-by-latency.html
max_latency The maximum single wait time of timed occurrences of the event. total_latency The total wait time of timed occurrences of the event. avg_latency The average wait time per timed occurrence of the event. The waits_global_by_latency and ...
https://dev.mysql.com/doc/refman/5.7/en/replication-solutions-scaleout.html
Start by creating a wrapper library or module that implements the following functions: safe_writer_connect() safe_reader_connect() safe_reader_statement() safe_writer_statement() safe_ in each function name means that the function takes care of ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-ndb-innodb-workloads.html
NDB Cluster has a range of unique attributes that make it ideal to serve applications requiring high availability, fast failover, high throughput, and low latency. Due to its distributed architecture and multi-node implementation, NDB Cluster also ...
https://dev.mysql.com/doc/refman/5.7/en/comparisons-using-subqueries.html
WHERE 'a' = (SELECT column1 FROM t1) MySQL also permits this construct: non_subquery_operand LIKE (subquery) At one time the only legal place for a subquery was on the right side of a comparison, and you might still find some old DBMSs that insist ... The most common use of a subquery is in the form: non_subquery_operand comparison_operator (subquery) Where comparison_operator is one of these operators: = > < >= <= <> != <=> For example: ...
https://dev.mysql.com/doc/refman/5.7/en/downgrading-to-previous-series.html
However, if there are multiple triggers with the same trigger event and action time, the server executes only one of them when the trigger event occurs. Logging Changes Support for sending the server error log to syslog in MySQL 5.7.5 and up differs ... Before downgrading from MySQL 5.7, review the information in this ...
https://dev.mysql.com/doc/refman/5.7/en/replication-features-temptables.html
Temporary tables are replicated except in the case where you stop the replica server (not just the replication threads) and you have replicated temporary tables that are open for use in updates that have not yet been executed on the replica. The ...
https://dev.mysql.com/doc/refman/5.7/en/index-extensions.html
The following example shows how execution plans are affected by whether the optimizer uses extended secondary indexes. InnoDB automatically extends each secondary index by appending the primary key columns to it. It also defines a secondary index ...Consider this table definition: CREATE TABLE t1 ( i1 INT NOT NULL DEFAULT 0, i2 INT NOT NULL DEFAULT 0, d DATE DEFAULT NULL, PRIMARY KEY (i1, i2), INDEX k_d (d) ) ENGINE = InnoDB; This table defines the primary key on columns (i1, ...