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/generated-column-index-optimizations.html
This occurs if the WHERE, ORDER BY, or GROUP BY clause refers to an expression that matches the definition of some indexed generated column. You can see this using EXPLAIN: mysql> EXPLAIN SELECT * FROM t1 WHERE f1 + 1 > 9\G ...For example: CREATE ...
https://dev.mysql.com/doc/refman/5.7/en/group-replication-message-compression.html
This limit is lower than the maximum possible value for the group_replication_compression_threshold system variable, which is matched to the maximum message size accepted by XCom. The LZ4 maximum input size is therefore a practical limit for message ... For messages sent between online group members, Group Replication enables message compression by ...
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 ...