Search Results
https://dev.mysql.com/doc/refman/8.4/en/sys-host-summary-by-statement-type.html
These views summarize information about statements executed, grouped by host and statement type. The host_summary_by_statement_type and x$host_summary_by_statement_type views have these columns: host The host from which the client connected. total ...By default, rows are sorted by host and descending total ...
https://dev.mysql.com/doc/refman/8.4/en/sys-user-summary-by-statement-type.html
These views summarize information about statements executed, grouped by user and statement type. The user_summary_by_statement_type and x$user_summary_by_statement_type views have these columns: user The client user name. total The total number of ...By default, rows are sorted by user and descending total ...
https://dev.mysql.com/doc/refman/8.4/en/table.html
TABLE is a DML statement which returns rows and columns of the named table. Given the existence of a table named t, the following two statements produce identical output: TABLE t; SELECT * FROM t; You can order and limit the number of rows produced ...TABLE does not allow for any arbitrary filtering of rows; that is, TABLE does not support any WHERE ...
https://dev.mysql.com/doc/refman/8.4/en/server-system-variables.html
disabled_storage_engines does not restrict other DDL statements for existing tables, such as CREATE INDEX, TRUNCATE TABLE, ANALYZE TABLE, DROP TABLE, or DROP TABLESPACE. (These are used for spatial indexes in MyISAM tables.) have_statement_timeout ...Most of them can be changed dynamically at runtime using the SET statement, which enables you to modify operation of the server without having to stop and restart ...
https://dev.mysql.com/doc/refman/8.4/en/show-grants.html
} This statement displays the privileges and roles that are assigned to a MySQL user account or role, in the form of GRANT statements that must be executed to duplicate the privilege and role assignments. Note To display nonprivilege information for ... SHOW GRANTS [FOR user_or_role [USING role [, role] ...]] user_or_role: { user (see Section 8.2.4, “Specifying Account Names”) | role (see Section 8.2.5, “Specifying Role ...
https://dev.mysql.com/doc/refman/8.4/en/begin-end.html
END syntax is used for writing compound statements, which can appear within stored programs (stored procedures and functions, triggers, and events). A compound statement can contain multiple statements, enclosed by the BEGIN and END keywords. In the ...
https://dev.mysql.com/doc/refman/8.4/en/kill.html
KILL permits an optional CONNECTION or QUERY modifier: KILL CONNECTION is the same as KILL with no modifier: It terminates the connection associated with the given processlist_id, after terminating any statement the connection is executing. KILL ...
https://dev.mysql.com/doc/refman/8.4/en/sys-statements-with-errors-or-warnings.html
These views display normalized statements that have produced errors or warnings. The statements_with_errors_or_warnings and x$statements_with_errors_or_warnings views have these columns: query The normalized statement string. db The default ...By ...
https://dev.mysql.com/doc/refman/8.4/en/sys-statements-with-temp-tables.html
These views list normalized statements that have used temporary tables. The statements_with_temp_tables and x$statements_with_temp_tables views have these columns: query The normalized statement string. db The default database for the statement, or ...By default, rows are sorted by descending number of on-disk temporary tables used and descending number of in-memory temporary tables ...
https://dev.mysql.com/doc/refman/8.4/en/extended-show.html
Some extensions to SHOW statements accompany the implementation of INFORMATION_SCHEMA: SHOW can be used to get information about the structure of INFORMATION_SCHEMA itself. Several SHOW statements accept a WHERE clause that provides more ...