PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 256.4Kb
Man Pages (Zip)
- 361.2Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-wait-summary-tables.html
row *************************** EVENT_NAME: wait/synch/mutex/sql/BINARY_LOG::LOCK_index COUNT_STAR: 8 SUM_TIMER_WAIT: 2119302 MIN_TIMER_WAIT: 196092 AVG_TIMER_WAIT: 264912 MAX_TIMER_WAIT: 569421 ... row *************************** EVENT_NAME: ...
https://dev.mysql.com/doc/refman/5.7/en/group-replication-restarting-group.html
In that situation, to re-create the group, it must be started by bootstrapping as if it was being started for the first time. For Group Replication, this includes both transactions that have been committed and applied, which are in the gtid_executed ... Group Replication is designed to ensure that the database service is continuously available, even if some of the servers that form the group are currently unable to participate in it due to planned maintenance or unplanned ...
https://dev.mysql.com/doc/refman/5.7/en/group-replication-ip-address-permissions.html
A host name that cannot be resolved is not considered for allowlist validation, and a warning message is written to the error log. The Group Replication plugin has a configuration option to determine from which hosts an incoming Group Communication ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-innodb-cmp-table.html
COMPRESS_TIME The total time in seconds used for attempts to compress B-tree pages of size PAGE_SIZE. UNCOMPRESS_TIME The total time in seconds used for uncompressing B-tree pages of the size PAGE_SIZE. COMPRESS_OPS The number of times a B-tree page ... The INNODB_CMP and INNODB_CMP_RESET tables provide status information on operations related to compressed InnoDB ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-table-wait-summary-tables.html
COUNT_STAR, SUM_TIMER_WAIT, MIN_TIMER_WAIT, AVG_TIMER_WAIT, MAX_TIMER_WAIT These columns aggregate all I/O operations. COUNT_READ, SUM_TIMER_READ, MIN_TIMER_READ, AVG_TIMER_READ, MAX_TIMER_READ These columns aggregate all read operations. The ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-socket-instances-table.html
The socket_instances table provides a real-time snapshot of the active connections to the MySQL server. Information available in this table provides a real-time snapshot of the active connections to the server. Wait times for active sockets are ...
https://dev.mysql.com/doc/refman/5.7/en/replication-features-max-allowed-packet.html
If you are replicating large column values (such as might be found in TEXT or BLOB columns) and max_allowed_packet is too small on the source, the source fails with an error, and the replica shuts down the replication I/O thread. max_allowed_packet ... max_allowed_packet sets an upper limit on the size of any single message between the MySQL server and clients, including ...
https://dev.mysql.com/doc/refman/5.7/en/audit-log-file-reading.html
The plugin opens each remaining candidate file, verifies that the file actually contains JSON audit events, and sorts the files using the timestamps from the first event of each file. For example: [ { "timestamp": "2020-05-18 13:39:33", "id": 0, ...
https://dev.mysql.com/doc/refman/5.7/en/environment-variables.html
The AND operation may remove read and write permissions from the directory mode, but not execute permissions. This section lists environment variables that are used directly or indirectly by MySQL. Most of these can also be found in other places in ...
https://dev.mysql.com/doc/refman/5.7/en/table-cache.html
When you execute a mysqladmin status command, you should see something like this: Uptime: 426 Running threads: 1 Questions: 11082 Reloads: 1 Open tables: 12 The Open tables value of 12 can be somewhat puzzling if you have fewer than 12 tables. For ...(By contrast, the index file descriptor is shared between all sessions.) The table_open_cache and max_connections system variables affect the maximum number of files the server keeps ...