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/show-index.html
SHOW {INDEX | INDEXES | KEYS} {FROM | IN} tbl_name [{FROM | IN} db_name] [WHERE expr] SHOW INDEX returns table index information. This statement requires some privilege for any column in the table. row *************************** Table: city ...
https://dev.mysql.com/doc/refman/5.7/en/purge-binary-logs.html
PURGE { BINARY | MASTER } LOGS { TO 'log_name' | BEFORE datetime_expr } The binary log is a set of files that contain information about data modifications made by the MySQL server. Examples: PURGE BINARY LOGS TO 'mysql-bin.010'; PURGE BINARY LOGS ...The log consists of a set of binary log files, plus an index file (see Section 5.4.4, “The Binary ...
https://dev.mysql.com/doc/refman/5.7/en/connection-control-plugin-installation.html
If connection_control_min_connection_delay and connection_control_max_connection_delay are 1500 and 20000, the adjusted delays for the fourth and subsequent failed connections are 1500 milliseconds, 2000 milliseconds, 3000 milliseconds, and so ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-replication-general.html
A replication channel requires two MySQL servers acting as replication servers (one each for the source and replica). For example, this means that in the case of a replication setup with two replication channels (to provide an extra channel for ...
https://dev.mysql.com/doc/refman/5.7/en/replication-rules-examples.html
If you use a combination of database-level and table-level replication filtering options, the replica first accepts or ignores events using the database options, then it evaluates all events permitted by those options according to the table options. It is also important to note that the results vary depending on whether the operation is logged using statement-based or row-based binary logging ...
https://dev.mysql.com/doc/refman/5.7/en/group-replication-plugin-architecture.html
These interfaces isolate the MySQL Server core from the Group Replication plugin, and are mostly hooks placed in the transaction execution pipeline. The capture component is responsible for keeping track of context related to transactions that are ... MySQL Group Replication is a MySQL plugin and it builds on the existing MySQL replication infrastructure, taking advantage of features such as the binary log, row-based logging, and global transaction ...
https://dev.mysql.com/doc/refman/5.7/en/creating-accounts.html
As of MySQL 5.7.18, for any operation that modifies a grant table, the server checks whether the table has the expected structure and produces an error if not. These privileges enable the admin user to execute the mysqladmin reload, mysqladmin ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-innodb-sys-tablespaces-table.html
FILE_SIZE The apparent size of the file, which represents the maximum size of the file, uncompressed. The INNODB_SYS_TABLESPACES table provides metadata about InnoDB file-per-table and general tablespaces, equivalent to the information in the ...
https://dev.mysql.com/doc/refman/5.7/en/replication-solutions-performance.html
This prevents “dumb” replicas from also logging events they have executed into their own binary log. As the number of replicas connecting to a source increases, the load, although minimal, also increases, as each replica uses a client ...
https://dev.mysql.com/doc/refman/5.7/en/privileges-provided.html
EXECUTE Enables use of statements that execute stored routines (stored procedures and functions). PROCESS The PROCESS privilege controls access to information about threads executing within the server (that is, information about statements being ...