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/mysql-cluster-replication-conflict-resolution.html
Some types of conflict resolution supported by NDB Cluster (NDB$OLD(), NDB$MAX(), and NDB$MAX_DELETE_WIN(); additionally, in NDB 8.0.30 and later, NDB$MAX_INS() and NDB$MAX_DEL_WIN_INS()) implement this user-defined column as a “timestamp” ...
https://dev.mysql.com/doc/refman/8.0/en/mysqldumpslow.html
The MySQL slow query log contains information about queries that take a long time to execute (see Section 7.4.5, “The Slow Query Log”). mysqldumpslow parses MySQL slow query log files and summarizes their contents. Normally, mysqldumpslow ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-object-filtering.html
The ENABLED column indicates whether matching objects are monitored, and TIMED indicates whether to collect timing information. Setting the TIMED column affects Performance Schema table contents as described in Section 29.4.1, “Performance Schema ... The setup_objects table controls whether the Performance Schema monitors particular table and stored program ...
https://dev.mysql.com/doc/refman/8.0/en/slow-query-log.html
The slow query log consists of SQL statements that take more than long_query_time seconds to execute and require at least min_examined_row_limit rows to be examined. The slow query log can be used to find queries that take a long time to execute ...
https://dev.mysql.com/doc/refman/8.0/en/sys-io-global-by-wait-by-latency.html
These views summarize global I/O consumers to display amount of I/O and time waiting for I/O, grouped by event. total_latency The total wait time of timed occurrences of the I/O event. avg_latency The average wait time per timed occurrence of the ...The io_global_by_wait_by_latency and x$io_global_by_wait_by_latency views have these columns: event_name The I/O event name, with the wait/io/file/ prefix ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-responses-failure-expel.html
You can use the group_replication_member_expel_timeout system variable, which is available from MySQL 8.0.13, to allow additional time between the creation of a suspicion and the expulsion of the suspect member. A group member is then expelled when ...A suspicion is created when one server does not receive messages from another server, as explained in Section 20.1.4.2, “Failure ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-quick-start.html
The number of Performance Schema tables increases over time as implementation of additional instrumentation proceeds. row *************************** THREAD_ID: 0 EVENT_ID: 5523 END_EVENT_ID: 5523 EVENT_NAME: wait/synch/mutex/mysys/THR_LOCK::mutex ... This section briefly introduces the Performance Schema with examples that show how to use ...
https://dev.mysql.com/doc/refman/8.0/en/sys-schema-table-statistics-with-buffer.html
By default, rows are sorted by descending total wait time (tables with most contention first). fetch_latency The total wait time of timed read I/O events for the table. insert_latency The total wait time of timed insert I/O events for the table.
https://dev.mysql.com/doc/refman/8.0/en/sys-statement-analysis.html
total_latency The total wait time of timed occurrences of the statement. max_latency The maximum single wait time of timed occurrences of the statement. avg_latency The average wait time per timed occurrence of the statement. lock_latency The total ...The statement_analysis and x$statement_analysis views have these columns: query The normalized statement ...
https://dev.mysql.com/doc/refman/8.0/en/backup-types.html
These provide logical copies of the file system at a given point in time, without requiring a physical copy of the entire file system. (For example, the implementation may use copy-on-write techniques so that only parts of the file system modified ... This section describes the characteristics of different types of ...