PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 296.5Kb
Man Pages (Zip)
- 401.8Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-programs-ndb-index-stat.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. --loops=# Command-Line Format --loops=# Type Numeric Default Value 0 ...
https://dev.mysql.com/doc/refman/8.0/en/mysqld-safe.html
mysqld_safe adds some safety features such as restarting the server when an error occurs and logging runtime information to an error log. --mysqld-safe-log-timestamps Command-Line Format --mysqld-safe-log-timestamps=type Type Enumeration Default ...
https://dev.mysql.com/doc/refman/8.0/en/nested-loop-joins.html
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 in a loop one at a time, passing each row to a nested loop that processes the next table ... MySQL executes joins between tables using a nested-loop algorithm or variations on ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-filtering.html
The setup_instruments table lists the instruments for which events can be collected, whether they are enabled, and (for enabled instruments) whether to collect timing information: mysql> SELECT NAME, ENABLED, TIMED FROM ... Events are processed in a ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-statement-tables.html
For additional information about configuring event collection, see Section 29.3, “Performance Schema Startup Configuration”, and Section 29.4, “Performance Schema Runtime Configuration”. Typically, this means from the time the server gets ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-wait-tables.html
The Performance Schema instruments waits, which are events that take time. For additional information about configuring event collection, see Section 29.3, “Performance Schema Startup Configuration”, and Section 29.4, “Performance Schema ...
https://dev.mysql.com/doc/refman/8.0/en/replication-features-functions.html
To avoid unexpected results when replicating between MySQL servers in different time zones, set the time zone on both source and replica. To explain the potential problems when replicating between servers which are in different time zones, suppose ... Certain functions do not replicate well under some conditions: The USER(), CURRENT_USER() (or CURRENT_USER), UUID(), VERSION(), and LOAD_FILE() functions are replicated without change and thus do not work reliably on the replica unless row-based replication is ...
https://dev.mysql.com/doc/refman/8.0/en/replication-features-triggers.html
It is sufficient to switch to statement-based replication only for those statements where you want this effect, and to use row-based replication the rest of the time. (Bug #45677) A trigger can have triggers for different combinations of trigger ...
https://dev.mysql.com/doc/refman/8.0/en/show-replica-status.html
The relay log file position (Relay_Log_Pos) is also updated at that time. This means that there is a small window of time during which SHOW REPLICA STATUS shows a nonzero value for Last_SQL_Errno even though Replica_SQL_Running still displays Yes.
https://dev.mysql.com/doc/refman/8.0/en/sys-host-summary-by-statement-latency.html
total_latency The total wait time of timed statements for the host. max_latency The maximum single wait time of timed statements for the host. lock_latency The total time waiting for locks by timed statements for the host. The ...