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-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 ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-ndb-innodb-workloads.html
Due to its distributed architecture and multi-node implementation, NDB Cluster also has specific constraints that may keep some workloads from performing well. A number of major differences in behavior between the NDB and InnoDB storage engines with ... NDB Cluster has a range of unique attributes that make it ideal to serve applications requiring high availability, fast failover, high throughput, and low ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-variable-table-migration.html
Before MySQL 5.7.9, selecting from the INFORMATION_SCHEMA tables produces an empty result set plus a deprecation warning. The INFORMATION_SCHEMA has tables that contain system and status variable information (see Section 24.3.11, “The ...
https://dev.mysql.com/doc/refman/5.7/en/replication-features-variables.html
In addition, the enabling this variable has different effects with regard to temporary tables, table locking, and the SET PASSWORD statement in different MySQL versions. To help reduce possible confusion, we recommend that you always use the same ...
https://dev.mysql.com/doc/refman/5.7/en/faqs-innodb-change-buffer.html
The innodb_io_capacity parameter sets an upper limit on the I/O activity performed by InnoDB background tasks such as merging data from the change buffer. How much space does InnoDB use for the change buffer? A.16.5. Where can I find additional ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-disk-io.html
Because the doublewrite buffer setting is global, doublewrite buffering is also disabled for data files residing on non-Fusion-io hardware. InnoDB uses asynchronous disk I/O where possible, by creating a number of threads to handle I/O operations, ...In random read-ahead, if InnoDB notices that some area in a tablespace seems to be in the process of being fully read into the buffer pool, it posts the remaining reads to the I/O ...
https://dev.mysql.com/doc/refman/5.7/en/group-replication-bootstrap.html
Therefore to safely bootstrap the group, connect to s1 and issue: mysql> SET GLOBAL group_replication_bootstrap_group=ON; mysql> START GROUP_REPLICATION; mysql> SET GLOBAL group_replication_bootstrap_group=OFF; Once the START GROUP_REPLICATION ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-stage-tables.html
Configuring Stage Event Collection Stage Event Progress Information Configuring Stage Event Collection To control whether to collect stage events, set the state of the relevant instruments and consumers: The setup_instruments table contains ... The ...Within the event hierarchy, wait events nest within stage events, which nest within statement events, which nest within transaction ...
https://dev.mysql.com/doc/refman/5.7/en/precision-math-expressions.html
To turn on all restrictions, you can simply use TRADITIONAL mode, which includes both strict mode values and ERROR_FOR_DIVISION_BY_ZERO: SET sql_mode='TRADITIONAL'; If a number is inserted into an exact type column (DECIMAL or integer), it is ...For ... With precision math, exact-value numbers are used as given whenever ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-innodb-sys-tablespaces-table.html
The INNODB_SYS_TABLESPACES table provides metadata about InnoDB file-per-table and general tablespaces, equivalent to the information in the SYS_TABLESPACES table in the InnoDB data dictionary. For related usage information and examples, see ...