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/group-replication-responses-failure-expel.html
There is an initial 5-second detection period before a Group Replication group member creates a suspicion of another member (or of itself). group_replication_member_expel_timeout specifies the period of time in seconds, called the expel timeout, ...
https://dev.mysql.com/doc/refman/9.7/en/telemetry-metrics-configuration.html
telemetry.metrics_reader_frequency_1 System Variable telemetry.metrics_reader_frequency_1 Scope Global Dynamic No SET_VAR Hint Applies No Type Integer Default Value 10 Unit seconds Mandatory. Defines the interval in seconds (f1) between meter ...
https://dev.mysql.com/doc/refman/9.7/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/9.7/en/create-event.html
The interval portion consists of two parts, a quantity and a unit of time, and follows the syntax rules described in Temporal Intervals, except that you cannot use any units keywords that involving microseconds when defining an event. For example, ... CREATE [DEFINER = user] EVENT [IF NOT EXISTS] event_name ON SCHEDULE schedule [ON COMPLETION [NOT] PRESERVE] [ENABLE | DISABLE | DISABLE ON {REPLICA | SLAVE}] [COMMENT 'string'] DO event_body schedule: { AT timestamp [+ INTERVAL interval] ...
https://dev.mysql.com/doc/refman/9.7/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/9.7/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/9.7/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/9.7/en/replication-delayed.html
Use a CHANGE REPLICATION SOURCE TO SOURCE_DELAY=N statement to set the delay to N seconds. A transaction received from the source is not executed until at least N seconds later than its commit on the immediate source. The replication_applier_status ... 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/9.7/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/9.7/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 ...