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/mysql-cluster-replication-schema.html
ndb_apply_status Table ndb_binlog_index Table ndb_replication Table Replication in NDB Cluster makes use of a number of dedicated tables in the mysql database on each MySQL Server instance acting as an SQL node in both the cluster being replicated ...
https://dev.mysql.com/doc/refman/5.7/en/order-by-optimization.html
Assuming that there is an index on (key_part1, key_part2), the following queries may use the index to resolve the ORDER BY part. In this query, the index on (key_part1, key_part2) enables the optimizer to avoid sorting: SELECT * FROM t1 ORDER BY ...
https://dev.mysql.com/doc/refman/5.7/en/partitioning-hash.html
Note For simplicity, the tables in the examples that follow do not use any keys. You should be aware that, if a table has any unique keys, every column used in the partitioning expression for this table must be part of every unique key, including ...
https://dev.mysql.com/doc/refman/5.7/en/partitioning-info.html
row *************************** id: 1 select_type: SIMPLE table: trb1 partitions: p0,p1,p2,p3 type: ALL possible_keys: NULL key: NULL key_len: NULL ref: NULL rows: 10 Extra: Using filesort In this case, all four partitions are searched. However, ...
https://dev.mysql.com/doc/refman/5.7/en/partitioning-range.html
While the examples work as shown for purposes of the present discussion, you should keep in mind that tables are extremely likely in practice to have primary keys, unique keys, or both, and that allowable choices for partitioning columns depend on ... A table that is partitioned by range is partitioned in such a way that each partition contains rows for which the partitioning expression value lies within a given ...
https://dev.mysql.com/doc/refman/5.7/en/partitioning-types.html
When partitioning by KEY or LINEAR KEY, you can use a DATE, TIME, or DATETIME column as the partitioning column without performing any modification of the column value. For KEY partitioning, this issue is taken care of automatically by the hashing ... This section discusses the types of partitioning which are available in MySQL ...
https://dev.mysql.com/doc/refman/5.7/en/alter-instance.html
ALTER INSTANCE ROTATE INNODB MASTER KEY ALTER INSTANCE, introduced in MySQL 5.7.11, defines actions applicable to a MySQL server instance. The statement supports these actions: ALTER INSTANCE ROTATE INNODB MASTER KEY This action rotates the master ...ENCRYPTION operations, and locks are taken to prevent conflicts that could arise from concurrent execution of these ...
https://dev.mysql.com/doc/refman/5.7/en/alter-user.html
Encrypted connections can be used, at the client's option, if the client has the proper certificate and key files. ALTER USER 'jeffrey'@'localhost' REQUIRE X509; For accounts with REQUIRE X509, clients must specify the --ssl-key and --ssl-cert ...
https://dev.mysql.com/doc/refman/5.7/en/blackhole-storage-engine.html
This should be borne in mind when considering the behavior of primary key columns that auto increment. Consider the following replication scenario where all three of the following conditions apply: On a source server there is a blackhole table with ... The BLACKHOLE storage engine acts as a “black hole” that accepts data but throws it away and does not store ...
https://dev.mysql.com/doc/refman/5.7/en/create-table-select.html
For example: mysql> CREATE TABLE test (a INT NOT NULL AUTO_INCREMENT, -> PRIMARY KEY (a), KEY(b)) -> ENGINE=InnoDB SELECT b,c FROM test2; This creates an InnoDB table with three columns, a, b, and c. You can precede the SELECT by IGNORE or REPLACE ... You can create one table from another by adding a SELECT statement at the end of the CREATE TABLE statement: CREATE TABLE new_tbl [AS] SELECT * FROM orig_tbl; MySQL creates new columns for all elements in the ...