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/replication-options-binary-log.html
binlog_expire_logs_seconds Command-Line Format --binlog-expire-logs-seconds=# System Variable binlog_expire_logs_seconds Scope Global Dynamic Yes SET_VAR Hint Applies No Type Integer Default Value 2592000 Minimum Value 0 Maximum Value 4294967295 ...
https://dev.mysql.com/doc/refman/8.0/en/thread-pool-tuning.html
This section provides guidelines on determining the best configuration for thread pool performance, as measured using a metric such as transactions per second. The value of thread_pool_stall_limit represents a number of 10-millisecond intervals, so ...Of chief importance is the number of thread groups in the thread pool, which can be set on server startup using the --thread-pool-size option; this cannot be changed at ...
https://dev.mysql.com/doc/refman/8.0/en/date-and-time-type-syntax.html
MySQL permits fractional seconds for TIME, DATETIME, and TIMESTAMP values, with up to microseconds (6 digits) precision. To define a column that includes a fractional seconds part, use the syntax type_name(fsp), where type_name is TIME, DATETIME, or ... The date and time data types for representing temporal values are DATE, TIME, DATETIME, TIMESTAMP, and ...
https://dev.mysql.com/doc/refman/8.0/en/explain-output.html
This means that MySQL reads a row from the first table, then finds a matching row in the second table, and then in the third table, and so on. Column names are shown in the table's first column; the second column provides the equivalent property ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-event-tables.html
After 5 seconds of execution: A and B have generated 5 and 500 events, respectively. After 5 minutes (300 seconds) of execution: A and B have generated 300 and 30,000 events, respectively. Rows for A include data up to 10 seconds old, whereas rows ... For wait, stage, statement, and transaction events, the Performance Schema can monitor and store current ...
https://dev.mysql.com/doc/refman/8.0/en/replication-delayed.html
Use a CHANGE REPLICATION SOURCE TO SOURCE_DELAY=N statement (from MySQL 8.0.23) or a CHANGE MASTER TO MASTER_DELAY=N statement (before MySQL 8.0.23) to set the delay to N seconds. A transaction received from the source is not executed until at least ... MySQL supports delayed replication such that a replica server deliberately executes transactions later than the source by at least a specified amount of ...
https://dev.mysql.com/doc/refman/8.0/en/source-configuration-options.html
Note Do not enable the WITH_TEST_TRACE_PLUGIN option if you want to use your own protocol trace plugins because only one such plugin can be loaded at a time and an error occurs for attempts to load a second one. The CMake program provides a great ...
https://dev.mysql.com/doc/refman/8.0/en/bnl-bka-optimization.html
An incremental join buffer contains only columns from rows of the table produced by the second join operand. This provides a savings in buffer space because in the general case a row produced by the first join operand can be matched by several rows ... In MySQL, a Batched Key Access (BKA) Join algorithm is available that uses both index access to the joined table and a join ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema-innodb-buffer-pool-stats-table.html
PAGES_MADE_YOUNG_RATE The number of pages made young per second (pages made young since the last printout / time elapsed). PAGES_MADE_NOT_YOUNG_RATE The number of pages not made per second (pages not made young since the last printout / time ... The ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-programs-ndb-waiter.html
ndb_waiter repeatedly (each 100 milliseconds) prints out the status of all cluster data nodes until either the cluster reaches a given status or the --timeout limit is exceeded, then exits. --connect-retry-delay Command-Line Format ...By default, ...