PDF (US Ltr)
- 43.2Mb
PDF (A4)
- 43.3Mb
Man Pages (TGZ)
- 295.2Kb
Man Pages (Zip)
- 400.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/group-replication-probes-and-statistics.html
The monitoring mechanism works by having each member deploying a set of probes to collect information about its work queues and throughput. Such probes are scattered throughout the plugin stack and allow one to establish metrics, such as: the ...It ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-prepared-statements-instances-table.html
Prepared statement execution Execution of a COM_STMT_EXECUTE or SQLCOM_PREPARE command for an instrumented prepared statement instance updates the corresponding prepared_statements_instances table row. COUNT_REPREPARE The number of times the ...This ... The Performance Schema provides instrumentation for prepared statements, for which there are two protocols: The binary ...
https://dev.mysql.com/doc/refman/8.0/en/checksum-table.html
For example, the storage format for temporal types such as TIME, DATETIME, and TIMESTAMP changed in MySQL 5.6 prior to MySQL 5.6.5, so if a 5.5 table is upgraded to MySQL 5.6, the checksum value may change. You can use this statement to verify that ...[QUICK | EXTENDED] CHECKSUM TABLE reports a checksum for the contents of a ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-performance-schema.html
DBAs can also use this feature for capacity planning, to see whether their typical workload encounters any performance bottlenecks with a particular combination of CPU, RAM, and disk storage; and if so, to judge whether performance can be improved ... This section provides a brief introduction to InnoDB integration with Performance ...
https://dev.mysql.com/doc/refman/8.0/en/precision-math-examples.html
These examples demonstrate the principles described in Section 14.24.3, “Expression Handling”, and Section 14.24.4, “Rounding Behavior”. Consider the following stored procedure, which adds .0001 to a variable 1,000 times. That is, for two ...
https://dev.mysql.com/doc/refman/8.0/en/charset-mysql.html
For more complete information, see Section 12.10, “Supported Character Sets and Collations”. For example, the default collations for utf8mb4 and latin1 are utf8mb4_0900_ai_ci and latin1_swedish_ci, respectively. The INFORMATION_SCHEMA ... MySQL ...
https://dev.mysql.com/doc/refman/8.0/en/constraint-primary-key.html
MySQL supports an IGNORE keyword for INSERT, UPDATE, and so forth. See the section for the statement that you are using (Section 15.2.7, “INSERT Statement”, Section 15.2.17, “UPDATE Statement”, and so forth). Normally, errors occur for ...
https://dev.mysql.com/doc/refman/8.0/en/geometry-well-formedness-validity.html
It is permitted to insert, select, and update geometrically invalid geometries, but they must be syntactically well-formed. For geometry values, MySQL distinguishes between the concepts of syntactically well-formed and geometrically valid. Spatial ...Spatial import functions that parse WKT or WKB values raise an error for attempts to create a geometry that is not syntactically ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-deploying-in-multi-primary-or-single-primary-mode.html
ON means single-primary mode, which is the default mode, and OFF means multi-primary mode. In MySQL 8.0.13 and later, you can use the group_replication_switch_to_single_primary_mode() and group_replication_switch_to_multi_primary_mode() functions to ... Group Replication operates either in single-primary mode or in multi-primary ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-index-types.html
To get the best performance from queries, inserts, and other database operations, it is important to understand how InnoDB uses the clustered index to optimize the common lookup and DML operations. If there is no logical unique and non-null column ... Each InnoDB table has a special index called the clustered index that stores row ...