Search Results
https://dev.mysql.com/doc/refman/8.4/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/8.4/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/8.4/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/8.4/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/8.4/en/telemetry-system-variables.html
The following table lists the Telemetry variables. Table 35.1 Telemetry Variable Summary Name Cmd-Line Option File System Var Status Var Var Scope Dynamic telemetry.live_sessions Yes Global No telemetry.metrics_enabled Yes Global No ...
https://dev.mysql.com/doc/refman/8.4/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/8.4/en/trigger-metadata.html
To obtain metadata about triggers: Query the TRIGGERS table of the INFORMATION_SCHEMA database.
https://dev.mysql.com/doc/refman/8.4/en/unix-signal-response.html
SIGHUP causes the server to reload the grant tables and to flush tables, logs, the thread cache, and the host cache. On Unix and Unix-like systems, a process can be the recipient of signals sent to it by the root system account or the system ...
https://dev.mysql.com/doc/refman/8.4/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 ...
https://dev.mysql.com/doc/refman/8.4/en/validate-password-installation.html
INSTALL COMPONENT loads the component, and also registers it in the mysql.component system table to cause it to be loaded during subsequent server startups. To uninstall the validate_password component, use this statement: UNINSTALL COMPONENT ...