PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 256.4Kb
Man Pages (Zip)
- 361.3Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/converting-tables-to-innodb.html
For most operations on InnoDB tables, you should use the setting autocommit=0. SET unique_checks=1; For big tables, this saves disk I/O because InnoDB can use its change buffer to write secondary index records as a batch. In the case of a runaway ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-profiling-table.html
Its contents correspond to the information produced by the SHOW PROFILE and SHOW PROFILES statements (see Section 13.7.5.30, “SHOW PROFILE Statement”). The table is empty unless the profiling session variable is set to 1. Use the Performance ...
https://dev.mysql.com/doc/refman/5.7/en/operator-precedence.html
Section 13.7.4.1, “SET Syntax for Variable Assignment”, and Section 9.4, “User-Defined Variables”, explain how MySQL determines which interpretation of = should apply. For operators that occur at the same precedence level within an ...
https://dev.mysql.com/doc/refman/5.7/en/sys-schema.html
MySQL 5.7 includes the sys schema, a set of objects that helps DBAs and developers interpret data collected by the Performance Schema. mysql_upgrade returns an error if a sys schema exists but has no version view, on the assumption that absence of ...sys schema objects can be used for typical tuning and diagnosis use ...
https://dev.mysql.com/doc/refman/5.7/en/full-disk.html
This section describes how MySQL responds to disk-full errors (such as “no space left on device”), and to quota-exceeded errors (such as “write failed” or “user block limit reached”). Other threads might be waiting for the table that ...
https://dev.mysql.com/doc/refman/5.7/en/group-replication-replication-group-members.html
For more information about the Member_host value and its impact on the distributed recovery process, see Section 17.2.1.3, “User Credentials”. The performance_schema.replication_group_members table is used for monitoring the status of the ...At ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-file-summary-tables.html
In this way, aggregations at higher levels are available directly without the need for user-defined views that sum lower-level columns. The Performance Schema maintains file I/O summary tables that aggregate information about I/O operations. row ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-mutex-instances-table.html
The mutex_instances table lists all the mutexes seen by the Performance Schema while the server executes. A mutex is a synchronization mechanism used in the code to enforce that only one thread at a given time can have access to some common ...The ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-pre-filtering.html
Pre-filtering is done by the Performance Schema and has a global effect that applies to all users. setup_objects controls whether the Performance Schema monitors particular table and stored program objects. Modifications to the setup_actors table ...Pre-filtering can be applied to either the producer or consumer stage of event processing: To configure pre-filtering at the producer stage, several tables can be used: setup_instruments indicates which instruments are ...
https://dev.mysql.com/doc/refman/5.7/en/replication-solutions-switch.html
To use CHANGE MASTER TO, add all information about how to connect to Replica 1 from Replica 2 or Replica 3 (user, password, port). When this is true for all replicas, they can be reconfigured to the new setup. During this procedure, do not forget to ...The replica does not check whether the databases on the source are compatible with those on the replica; it simply begins reading and executing events from the specified coordinates in the new source's binary ...