PDF (US Ltr)
- 43.2Mb
PDF (A4)
- 43.3Mb
Man Pages (TGZ)
- 295.2Kb
Man Pages (Zip)
- 400.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/option-defaults-equals.html
Assume that you are running MySQL on a computer whose host name is “tonfisk”, and consider the following invocation of mysqld_safe: $> mysqld_safe & [1] 11699 $> 080112 12:53:40 mysqld_safe Logging to '/usr/local/mysql/var/tonfisk.err'. 080112 ...Due to this behavior, problems can occasionally arise when no value is provided for an option that expects ...
https://dev.mysql.com/doc/refman/8.0/en/replication-features-partitioning.html
Replication is supported between partitioned tables as long as they use the same partitioning scheme and otherwise have the same structure, except where an exception is specifically allowed (see Section 19.5.1.9, “Replication with Differing Table ...Replication between tables that have different partitioning is generally not ...
https://dev.mysql.com/doc/refman/8.0/en/replication-features-truncate.html
TRUNCATE TABLE is normally regarded as a DML statement, and so would be expected to be logged and replicated using row-based format when the binary logging mode is ROW or MIXED. TRUNCATE TABLE is treated for purposes of logging and replication as ...However this caused issues when logging or replicating, in STATEMENT or MIXED mode, tables that used transactional storage engines such as InnoDB when the transaction isolation level was READ COMMITTED or READ UNCOMMITTED, which precludes statement-based ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-ndbinfo-locks-per-fragment.html
This table also shows the total time spent waiting for locks successfully and unsuccessfully since fragment or table creation, or since the most recent restart. This is also true for the time values shown in the wait_ok_millis and wait_fail_millis ... The locks_per_fragment table provides information about counts of lock claim requests, and the outcomes of these requests on a per-fragment basis, serving as a companion table to operations_per_fragment and ...
https://dev.mysql.com/doc/refman/8.0/en/events-metadata.html
This becomes the event time zone (ETZ); that is, the time zone that is used for event scheduling and is in effect within the event as it executes. For representation of event information in the data dictionary, the execute_at, starts, and ends times ...Event Scheduler Time Representation Each session in MySQL has a session time zone ... To ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-probes-and-statistics.html
The monitoring mechanism works by having each member deploying a set of probes to collect information about its work queues and throughput. Such probes are scattered throughout the plugin stack and allow one to establish metrics, such as: the ...It ...
https://dev.mysql.com/doc/refman/8.0/en/sys-host-summary-by-file-io-type.html
These views summarize file I/O, grouped by host and event type. By default, rows are sorted by host and descending total I/O latency. The host_summary_by_file_io_type and x$host_summary_by_file_io_type views have these columns: host The host from ...total The total number of occurrences of the file I/O event for the ...
https://dev.mysql.com/doc/refman/8.0/en/sys-user-summary-by-file-io-type.html
These views summarize file I/O, grouped by user and event type. By default, rows are sorted by user and descending total latency. The user_summary_by_file_io_type and x$user_summary_by_file_io_type views have these columns: user The client user ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-performance-xcom-cache.html
The group communication engine for Group Replication (XCom, a Paxos variant) includes a cache for messages (and their metadata) exchanged between the group members as a part of the consensus protocol. If the cache size limit is reached, XCom ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-log-status-table.html
When the log_status table is queried, the server blocks logging and related administrative changes for just long enough to populate the table, then releases the resources. The log_status table informs the online backup which point it should copy up ... The log_status table provides information that enables an online backup tool to copy the required log files without locking those resources for the duration of the copy ...