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/optimizing-innodb-queries.html
To tune queries for InnoDB tables, create an appropriate set of indexes on each table. Follow these guidelines for InnoDB indexes: Because each InnoDB table has a primary key (whether you request one or not), specify a set of primary key columns ...
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/group-replication-tuning-recovery.html
mysql> SET GLOBAL group_replication_recovery_retry_count= 10; Note that this accounts for the global number of attempts that the server joining the group makes connecting to each one of the suitable donors. The following section explains how ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-programs-ndb-error-reporter.html
Optionally, you can supply the name of a user that is able to access the cluster's data nodes using SSH, to copy the data node log files. ndb_error_reporter also accepts the options listed here: --connection-timeout=timeout Command-Line Format ...
https://dev.mysql.com/doc/refman/5.7/en/pluggable-storage.html
Plugging in a Storage Engine Before a storage engine can be used, the storage engine plugin shared library must be loaded into MySQL using the INSTALL PLUGIN statement. Ensure that there are no tables using a storage engine before you unplug the ...
https://dev.mysql.com/doc/refman/5.7/en/sys-schema-views.html
The sys schema contains many views that summarize Performance Schema tables in various ways. The view with the x$ prefix that displays the same values in raw form is intended more for use with other tools that perform their own processing on the ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-files-table.html
TABLESPACE is the file type for any system, general, or file-per-table tablespace file that holds tables, indexes, or other forms of user data. The FILES table provides information about the files in which MySQL tablespace data is stored. In NDB ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-optimizer-trace-table.html
INSUFFICIENT_PRIVILEGES If a traced query uses views or stored routines that have SQL SECURITY with a value of DEFINER, it may be that a user other than the definer is denied from seeing the trace of the query. The OPTIMIZER_TRACE table provides ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-deadlocks.html
To view the last deadlock in an InnoDB user transaction, use SHOW ENGINE INNODB STATUS. Because all transactions involved are waiting for the same resource to become available, none of them ever releases the lock it holds. For a deadlock example, ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-ndbinfo-cpustat-1sec.html
The cpustat-1sec table provides raw, per-thread CPU data obtained each second for each thread running in the NDB kernel. Like cpustat_50ms and cpustat_20sec, this table shows 20 measurement sets per thread, each referencing a period of the named ...