PDF (US Ltr)
- 35.0Mb
PDF (A4)
- 35.1Mb
Man Pages (TGZ)
- 254.9Kb
Man Pages (Zip)
- 359.9Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/group-replication-network-partitioning.html
Unblocking a Partition Group replication enables you to reset the group membership list by forcing a specific configuration. To do that on s1: mysql> SET GLOBAL group_replication_force_members="127.0.0.1:10000,127.0.0.1:10001"; This unblocks the ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-innodb-sys-tablestats-table.html
This column is reset each time table statistics are recalculated AUTOINC The next number to be issued for any auto-increment-based operation. The INNODB_SYS_TABLESTATS table provides a view of low-level status information about InnoDB tables. This ...This data is used by the MySQL optimizer to calculate which index to use when querying an InnoDB ...
https://dev.mysql.com/doc/refman/5.7/en/xa-statements.html
To perform XA transactions in MySQL, use the following statements: XA {START|BEGIN} xid [JOIN|RESUME] XA END xid [SUSPEND [FOR MIGRATE]] XA PREPARE xid XA COMMIT xid [ONE PHASE] XA ROLLBACK xid XA RECOVER [CONVERT XID] For XA START, the JOIN and ...
https://dev.mysql.com/doc/refman/5.7/en/backup-types.html
This type of backup is suitable for large, important databases that need to be recovered quickly when problems occur. Logical backups save information represented as logical database structure (CREATE DATABASE, CREATE TABLE statements) and content ...Physical (Raw) Versus Logical Backups Physical backups consist of raw copies of the directories and files that store database ...
https://dev.mysql.com/doc/refman/5.7/en/audit-log-restrictions.html
Prior to MySQL 5.7.21, MySQL Enterprise Audit uses MyISAM tables in the mysql system database. MySQL Enterprise Audit is subject to these general restrictions: Only SQL statements are logged. Changes made by no-SQL APIs, such as memcached, Node.JS, ...
https://dev.mysql.com/doc/refman/5.7/en/event-scheduler.html
You may also find the MySQL User Forums to be helpful. Section 23.4.3, “Event Syntax”, discusses the SQL statements for creating, altering, and dropping MySQL Events. Section 23.4.4, “Event Metadata”, shows how to obtain information about ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-schema-privileges-table.html
The SCHEMA_PRIVILEGES table has these columns: GRANTEE The name of the account to which the privilege is granted, in 'user_name'@'host_name' format. IS_GRANTABLE YES if the user has the GRANT OPTION privilege, NO otherwise. TABLE_CATALOG The name of ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-table-privileges-table.html
The TABLE_PRIVILEGES table has these columns: GRANTEE The name of the account to which the privilege is granted, in 'user_name'@'host_name' format. IS_GRANTABLE YES if the user has the GRANT OPTION privilege, NO otherwise. TABLE_SCHEMA The name of ...TABLE_CATALOG The name of the catalog to which the table ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-transaction-model.html
Typically, several users are permitted to lock every row in InnoDB tables, or any random subset of the rows, without causing InnoDB memory exhaustion. The InnoDB transaction model aims combine the best properties of a multi-versioning database with ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-config-file.html
In such cases we try to let NDB Cluster users know in advance if a change is not backward compatible. Configuring NDB Cluster requires working with two files: my.cnf: Specifies options for all NDB Cluster executables. config.ini: This file, ...This ...