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/monitor-innodb-mutex-waits-performance-schema.html
For example, to disable InnoDB mutex wait event instruments related to full-text search, add the following rule: performance-schema-instrument='wait/synch/mutex/innodb/fts%=OFF' Note Rules with a longer prefix such as wait/synch/mutex/innodb/fts% ...
https://dev.mysql.com/doc/refman/5.7/en/replication-options-binary-log.html
(In older versions of MySQL, manual intervention was required whenever relocating the binary log or relay log files.) (Bug #11745230, Bug #12133) Setting this option causes the log_bin system variable to be set to ON (or 1), and not to the base name. Startup Options Used with Binary Logging System Variables Used with Binary Logging You can use the mysqld options and system variables that are described in this section to affect the operation of the binary log as well as to control which statements are written to the binary ...
https://dev.mysql.com/doc/refman/5.7/en/faqs-replication.html
The implication of this is that, at any given time, the replica is not guaranteed to be in synchrony with the source unless you take some special measures. (This is why TIMESTAMP is well replicated.) In the Time column in the output of SHOW ... In ...
https://dev.mysql.com/doc/refman/5.7/en/disk-issues.html
This section describes ways to configure storage devices when you can devote more and faster storage hardware to the database server. This problem becomes more apparent when the amount of data starts to grow so large that effective caching becomes ...For information about optimizing an InnoDB configuration to improve I/O performance, see Section 8.5.8, “Optimizing InnoDB Disk ...
https://dev.mysql.com/doc/refman/5.7/en/group-replication-limitations.html
This is because foreign key constraints that result in cascading operations executed by a multi-primary mode group can result in undetected conflicts and lead to inconsistent data across the members of the group. In single-primary mode this is not a ...Note that the limitations and issues described for multi-primary mode groups can also apply in single-primary mode clusters during a failover event, while the newly elected primary flushes out its applier queue from the old ...
https://dev.mysql.com/doc/refman/5.7/en/index-extensions.html
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, i2). It also ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-innodb-sys-tablestats-table.html
This data is used by the MySQL optimizer to calculate which index to use when querying an InnoDB table. This information is derived from in-memory data structures rather than data stored on disk. InnoDB tables are represented in this view if they ...
https://dev.mysql.com/doc/refman/5.7/en/myisam-repair.html
The discussion in this section describes how to use myisamchk on MyISAM tables (extensions .MYI and .MYD). In this case, you must use ALTER TABLE to increase the MAX_ROWS and AVG_ROW_LENGTH table option values: ALTER TABLE tbl_name MAX_ROWS=xxx ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-online-add-node-basics.html
In this section, we list the basic steps required to add new data nodes to an NDB Cluster. This procedure applies whether you are using ndbd or ndbmtd binaries for the data node processes. In the event that you have API nodes using dynamically ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-params-other.html
The listings in this section provide information about parameters used in the [computer], [tcp], and [shm] sections of a config.ini file for configuring NDB Cluster. The following parameters apply to the config.ini file's [computer] section: ...For ...