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/index-extensions.html
The following example shows how execution plans are affected by whether the optimizer uses extended secondary indexes. InnoDB automatically extends each secondary index by appending the primary key columns to it. It also defines a secondary index ...Consider this table definition: CREATE TABLE t1 ( i1 INT NOT NULL DEFAULT 0, i2 INT NOT NULL DEFAULT 0, d DATE DEFAULT NULL, PRIMARY KEY (i1, i2), INDEX k_d (d) ) ENGINE = InnoDB; This table defines the primary key on columns (i1, ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-install-windows-service.html
Important When installing an NDB Cluster program as a Windows service, you should always specify the complete path; otherwise the service installation may fail with the error The system cannot find the file specified. Once you are satisfied that ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-ndb-innodb-workloads.html
NDB Cluster has a range of unique attributes that make it ideal to serve applications requiring high availability, fast failover, high throughput, and low latency. Due to its distributed architecture and multi-node implementation, NDB Cluster also ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-programs-ndbinfo-select-all.html
--delay=seconds Command-Line Format --delay=# Type Numeric Default Value 5 Minimum Value 0 Maximum Value MAX_INT This option sets the number of seconds to wait between executing loops. --loops=number, -l number Command-Line Format --loops=# Type ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-compression-background.html
Because processors and cache memories have increased in speed more than disk storage devices, many workloads are disk-bound. Data compression enables smaller database size, reduced I/O, and improved throughput, at the small cost of increased CPU ...
https://dev.mysql.com/doc/refman/5.7/en/sys-metrics.html
This view summarizes MySQL server metrics to show variable names, values, types, and whether they are enabled. The metric type determines the source from which the name is taken: For global status variables: The VARIABLE_NAME column of the ...
https://dev.mysql.com/doc/refman/5.7/en/group-replication-secure-socket-layer-support-ssl.html
Typically, this is set up at the time one is provisioning a server to join the group. Group communication connections as well as recovery connections, are secured using SSL. Configuring SSL for Group Replication Recovery Recovery is performed ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-information-schema-fulltext_index-tables.html
Because the contents of INNODB_FT_BEING_DELETED typically have a short lifetime, this table has limited utility for monitoring or debugging. To avoid expensive index reorganization during DML operations, data for newly inserted rows remains in the ...INNODB_FT_BEING_DELETED: Provides a snapshot of the INNODB_FT_DELETED table; it is used only during an OPTIMIZE TABLE maintenance ...
https://dev.mysql.com/doc/refman/5.7/en/replication-options-gtids.html
gtid_executed_compression_period Command-Line Format --gtid-executed-compression-period=# System Variable gtid_executed_compression_period Scope Global Dynamic Yes Type Integer Default Value 1000 Minimum Value 0 Maximum Value 4294967295 Compress the ...The set of transactions that can be found in the binary logs at any given time is equal to GTID_SUBTRACT(@@GLOBAL.gtid_executed, @@GLOBAL.gtid_purged); that is, to all transactions in the binary log that have not yet been ...
https://dev.mysql.com/doc/refman/5.7/en/replica-io-thread-states.html
This can last for a long time if the source is idle. Waiting for the slave SQL thread to free enough relay log space You are using a nonzero relay_log_space_limit value, and the relay logs have grown large enough that their combined size exceeds ...