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/group-replication-replication-group-members.html
The MEMBER_STATE column shows one of the Section 17.4.1, “Group Replication Server States”, in this case it shows that all three members in this group are ONLINE, and the MEMBER_ROLE column shows that there are two secondaries, and a single ...
https://dev.mysql.com/doc/refman/5.7/en/group-replication-secure-socket-layer-support-ssl.html
Typically, this is set up at the time one is provisioning a server to join the group. This option activates the SSL communication between members of the group, by configuring the SSL framework with the ssl_* parameters that are provided to the ...
https://dev.mysql.com/doc/refman/5.7/en/identifier-mapping.html
For the table format files (.FRM), the data is always stored in this structure and location. This occurs on all platforms for portability of the corresponding database object between platforms. You should not create databases or tables with names ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-innodb-buffer-pool-stats-table.html
This is an identifier to distinguish between multiple buffer pool instances. Use the INFORMATION_SCHEMA COLUMNS table or the SHOW COLUMNS statement to view additional information about the columns of this table, including data types and default ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-innodb-locks-table.html
Note This table is deprecated as of MySQL 5.7.14 and is removed in MySQL 8.0. To obtain details about the transaction, join this column with the TRX_ID column of the INNODB_TRX table. row *************************** lock_id: 3722:72:3:2 lock_trx_id: ... The INNODB_LOCKS table provides information about each lock that an InnoDB transaction has requested but not yet acquired, and each lock that a transaction holds that is blocking another ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-innodb-sys-indexes-table.html
For GEN_CLUST_INDEX indexes, this value is 0 because the index is created using an artificial value rather than a real table column. Because all indexes for a table reside in the same tablespace as the table, this value is not necessarily unique.
https://dev.mysql.com/doc/refman/5.7/en/information-schema-innodb-sys-tables-table.html
For file-per-table tablespaces, this identifier is unique for tables across all databases in the instance. row *************************** TABLE_ID: 214 NAME: test/t1 FLAG: 129 N_COLS: 4 SPACE: 233 FILE_FORMAT: Antelope ROW_FORMAT: Compact ... The ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-buffer-pool-flushing.html
The default low water mark is 0, which disables this early flushing behaviour. For table data stored on SSD, seek time is not a significant factor and you can disable this setting to spread out write operations. This is a background operation ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-consistent-read.html
The exception to this rule is that the query sees the changes made by earlier statements within the same transaction. This exception causes the following anomaly: If you update some rows in a table, a SELECT sees the latest version of the updated ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-memcached-troubleshoot.html
This section describes issues that you may encounter when using the InnoDB memcached plugin. This problem could also occur if you change an existing entry in the innodb_memcache.containers table without restarting the MySQL server afterward. If you ...