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/performance-schema-socket-summary-tables.html
Except for events_statements_summary_by_digest, tt resets the summary columns to zero rather than removing rows. These socket summary tables aggregate timer and byte count information for socket operations: socket_summary_by_event_name: Aggregate ...When a connection terminates, the row in socket_summary_by_instance corresponding to it is ...
https://dev.mysql.com/doc/refman/5.7/en/show-status.html
SHOW [GLOBAL | SESSION] STATUS [LIKE 'pattern' | WHERE expr] Note The value of the show_compatibility_56 system variable affects the information available from and privileges required for the statement described here. For details, see the ...A ...
https://dev.mysql.com/doc/refman/5.7/en/sys-host-summary-by-statement-latency.html
Rows for which the HOST column in the underlying Performance Schema table is NULL are assumed to be for background threads and are reported with a host name of background. total_latency The total wait time of timed statements for the host. The ...
https://dev.mysql.com/doc/refman/5.7/en/sys-host-summary-by-statement-type.html
These views summarize informaion about statements executed, grouped by host and statement type. Rows for which the HOST column in the underlying Performance Schema table is NULL are assumed to be for background threads and are reported with a host ...By default, rows are sorted by host and descending total ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-limitations-multiple-nodes.html
(See next item for an example.) Implementing table locks in NDBCLUSTER can be done in an API application, and ensuring that all applications start by setting LockMode to LM_Read or LM_Exclusive. A LOCK TABLES statement or GET_LOCK() call works only ...The following are issues relating to the use of multiple MySQL servers as NDB Cluster SQL nodes, and are specific to the NDBCLUSTER storage engine: Stored programs not ...
https://dev.mysql.com/doc/refman/5.7/en/show-index.html
Take this into account when specifying a prefix length for a nonbinary string column that uses a multibyte character set. SHOW {INDEX | INDEXES | KEYS} {FROM | IN} tbl_name [{FROM | IN} db_name] [WHERE expr] SHOW INDEX returns table index ...row ...
https://dev.mysql.com/doc/refman/5.7/en/creating-spatial-indexes.html
For InnoDB and MyISAM tables, MySQL can create spatial indexes using syntax similar to that for creating regular indexes, but using the SPATIAL keyword. For storage engines that support nonspatial indexing of spatial columns, the engine creates a ...To drop spatial indexes, use ALTER TABLE or DROP INDEX: With ALTER TABLE: ALTER TABLE geom DROP INDEX g; With DROP INDEX: DROP INDEX g ON geom; Example: Suppose that a table geom contains more than 32,000 geometries, which are stored in the column g of type ...
https://dev.mysql.com/doc/refman/5.7/en/engine-condition-pushdown-optimization.html
For example, in a my.cnf file, use these lines: [mysqld] optimizer_switch=engine_condition_pushdown=off At runtime, disable condition pushdown like this: SET optimizer_switch='engine_condition_pushdown=off'; Limitations. In such cases, the condition ... This optimization improves the efficiency of direct comparisons between a nonindexed column and a ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-runtime-configuration.html
If you have the UPDATE privilege, you can change Performance Schema operation by modifying setup tables to affect how monitoring occurs. For additional details about these tables, see Section 25.12.2, “Performance Schema Setup Tables”. The ...
https://dev.mysql.com/doc/refman/5.7/en/error-log.html
For information about selecting the error message character set and language, see Section 10.6, “Error Message Character Set”, and Section 10.12, “Setting the Error Message Language”. This section discusses how to configure the MySQL server ...The error log contains a record of mysqld startup and shutdown ...