PDF (US Ltr)
- 35.0Mb
PDF (A4)
- 35.1Mb
Man Pages (TGZ)
- 254.9Kb
Man Pages (Zip)
- 359.9Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/sys-schema-index-statistics.html
The schema_index_statistics and x$schema_index_statistics views have these columns: table_schema The schema that contains the table. select_latency The total wait time of timed reads using the index. insert_latency The total wait time of timed ...
https://dev.mysql.com/doc/refman/5.7/en/sys-schema-unused-indexes.html
These views display indexes for which there are no events, which indicates that they are not being used. This view is most useful when the server has been up and processing long enough that its workload is representative. Otherwise, presence of an ...
https://dev.mysql.com/doc/refman/5.7/en/sys-user-summary-by-statement-latency.html
Rows for which the USER 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. full_scans The total number of full table scans by statements for the user.
https://dev.mysql.com/doc/refman/5.7/en/sys-user-summary-by-statement-type.html
Rows for which the USER 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. full_scans The total number of full table scans by occurrences of the ...
https://dev.mysql.com/doc/refman/5.7/en/sys-user-summary.html
Rows for which the USER 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. These views summarize statement activity, file I/O, and connections, grouped ...
https://dev.mysql.com/doc/refman/5.7/en/thread-commands.html
Refresh The thread is flushing table, logs, or caches, or resetting status variable or replication server information. A thread can have any of the following Command values: Binlog Dump This is a thread on a replication source for sending binary ...
https://dev.mysql.com/doc/refman/5.7/en/trigger-metadata.html
To obtain metadata about triggers: Query the TRIGGERS table of the INFORMATION_SCHEMA database.
https://dev.mysql.com/doc/refman/5.7/en/union.html
This kind of ORDER BY cannot use column references that include a table name (that is, names in tbl_name.col_name format). (Alternatively, refer to the column in the ORDER BY using its column position. Extra columns can provide other identifying ...
https://dev.mysql.com/doc/refman/5.7/en/updating-direct-rpms.html
mysql_upgrade also performs other functions; see Section 4.4.7, “mysql_upgrade — Check and Upgrade MySQL Tables” for details. It is preferable to use the MySQL Yum repository or MySQL SLES Repository to upgrade MySQL on RPM-based platforms.
https://dev.mysql.com/doc/refman/5.7/en/using-spatial-indexes.html
The optimizer investigates whether available spatial indexes can be involved in the search for queries that use a function such as MBRContains() or MBRWithin() in the WHERE clause. The following query finds all objects that are in the given ...