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-bootstrap.html
For the purpose of demonstrating that the server is indeed in a group and that it is able to handle load, create a table and add some content to it. mysql> CREATE DATABASE test; mysql> USE test; mysql> CREATE TABLE t1 (c1 INT PRIMARY KEY, c2 TEXT ...
https://dev.mysql.com/doc/refman/5.7/en/group-replication-network-partitioning.html
Detecting Partitions The replication_group_members performance schema table presents the status of each server in the current view from the perspective of this server. The majority of the time the system does not run into partitioning, and therefore ... The group needs to achieve consensus whenever a change that needs to be replicated ...
https://dev.mysql.com/doc/refman/5.7/en/ignoring-user.html
If you get the following error, it means that when mysqld was started or when it reloaded the grant tables, it found an account in the user table that had an invalid password. The following list indicates possible causes of and fixes for this ...
https://dev.mysql.com/doc/refman/5.7/en/index-merge-optimization.html
This access method merges index scans from a single table only, not scans across multiple tables. AND key_partN = constN Any range condition over the primary key of an InnoDB table. If all columns used in the query are covered by the used indexes, ... The Index Merge access method retrieves rows with multiple range scans and merges their results into ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-introduction.html
Unless you have configured a different default storage engine, issuing a CREATE TABLE statement without an ENGINE clause creates an InnoDB table. InnoDB tables arrange your data on disk to optimize queries based on primary keys. Each InnoDB table ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-memcached-benefits.html
The combination of InnoDB tables and memcached offers advantages over using either by themselves. Data written using the memcached protocol is transparently written to an InnoDB table, without going through the MySQL SQL layer. Data requested ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-memcached-dml.html
These operations are guaranteed to only affect one row when issued through the memcached interface, because the key is unique within the table. In the following SQL examples, t1 refers to the table used for memcached operations, based on the ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-next-key-locking.html
Let the table contain rows having id values of 90 and 102. If the locks set on the index records in the scanned range do not lock out inserts made in the gaps (in this case, the gap between 90 and 102), another session can insert a new row into the ... The so-called phantom problem occurs within a transaction when the same query produces different sets of rows at different ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-troubleshooting.html
Issues relating to the InnoDB data dictionary include failed CREATE TABLE statements (orphan table files), inability to open InnoDB files, and system cannot find the path specified errors. If the problem is with table creation, tablespaces, or data ... The following general guidelines apply to troubleshooting InnoDB problems: When an operation fails or you suspect a bug, look at the MySQL server error log (see Section 5.4.2, “The Error ...
https://dev.mysql.com/doc/refman/5.7/en/ldap-pluggable-authentication.html
LDAP pluggable authentication provides these capabilities: External authentication: LDAP authentication enables MySQL Server to accept connections from users defined outside the MySQL grant tables in LDAP directories. The following tables show the ... Note LDAP pluggable authentication is an extension included in MySQL Enterprise Edition, a commercial ...