PDF (US Ltr)
- 41.8Mb
PDF (A4)
- 41.9Mb
Man Pages (TGZ)
- 272.4Kb
Man Pages (Zip)
- 378.4Kb
Info (Gzip)
- 4.2Mb
Info (Zip)
- 4.2Mb
Search Results
https://dev.mysql.com/doc/refman/9.7/en/grant.html
This behavior is by design, and is intended to enable the database administrator to prepare user accounts and privileges for databases or tables that are to be created at a later time. [WITH GRANT OPTION] [AS user [WITH ROLE DEFAULT | NONE | ALL | ...
https://dev.mysql.com/doc/refman/9.7/en/group-replication-frequently-asked-questions.html
You can specify them in the START GROUP_REPLICATION statement each time Group Replication is started. Warning When the network round-trip time (RTT) between any group members is 5 seconds or more you could encounter problems as the built-in failure ...What is the maximum number of MySQL servers in a group? A group can consist of maximum 9 ...
https://dev.mysql.com/doc/refman/9.7/en/group-replication-requirements.html
Transactions are executed optimistically and then, at commit time, are checked for conflicts. Bi-directional communication must be maintained at all times between all group members. (In MySQL 9.7, this is the default.) Group members need to log ...
https://dev.mysql.com/doc/refman/9.7/en/group-replication-responses-failure.html
When a suspicion times out, the suspected member is assumed to have failed, and is expelled from the group. By default, the following behaviors happen if a member is suspected of having failed: In MySQL 9.7, when a suspicion is created, a waiting ...
https://dev.mysql.com/doc/refman/9.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. Group Replication is designed to ensure that the database service is continuously available, even if some of the servers ...
https://dev.mysql.com/doc/refman/9.7/en/group-replication-secure-user.html
Typically, this is set up at the time you are provisioning a server to join the group. Alternatively, you can specify them in the START GROUP_REPLICATION statement each time Group Replication is started. State transfer from the binary log requires ...
https://dev.mysql.com/doc/refman/9.7/en/information-schema-innodb-cmp-per-index-table.html
COMPRESS_TIME The total time in seconds used for compressing data in this index. Compressed InnoDB pages are uncompressed whenever compression fails, or the first time a compressed page is accessed in the buffer pool and the uncompressed page does ... The INNODB_CMP_PER_INDEX and INNODB_CMP_PER_INDEX_RESET tables provide status information on operations related to compressed InnoDB tables and indexes, with separate statistics for each combination of database, table, and index, to help you evaluate the performance and usefulness of compression for specific ...
https://dev.mysql.com/doc/refman/9.7/en/information-schema-innodb-tablestats-table.html
Statistics are collected again the next time the table is accessed. This column is reset each time table statistics are recalculated AUTOINC The next number to be issued for any auto-increment-based operation. The rate at which the AUTOINC value ...
https://dev.mysql.com/doc/refman/9.7/en/information-schema-libraries-table.html
LAST_ALTERED Most recent date and time that the library was altered. SQL_MODE SQL mode in effect at time of creation (see Section 7.1.11, “Server SQL Modes”). This is a set consisting of none or any one or more of the following: REAL_AS_FLOAT, ... The LIBRARIES table contains information about JavaScript and WebAssembly libraries known to the MLE JavaScript component (see Section 7.5.7, “Multilingual Engine Component ...
https://dev.mysql.com/doc/refman/9.7/en/information-schema-optimization.html
Some INFORMATION_SCHEMA tables contain columns that provide table statistics: STATISTICS.CARDINALITY TABLES.AUTO_INCREMENT TABLES.AVG_ROW_LENGTH TABLES.CHECKSUM TABLES.CHECK_TIME TABLES.CREATE_TIME TABLES.DATA_FREE TABLES.DATA_LENGTH ...