Search Results
https://dev.mysql.com/doc/refman/8.4/en/show-create-view.html
row *************************** View: v Create View: CREATE ALGORITHM=UNDEFINED DEFINER=`bob`@`localhost` SQL SECURITY DEFINER VIEW `v` AS select 1 AS `a`,2 AS `b` character_set_client: utf8mb4 collation_connection: utf8mb4_0900_ai_ci ... SHOW ...
https://dev.mysql.com/doc/refman/8.4/en/show-privileges.html
row *************************** Privilege: Alter Context: Tables Comment: To alter the table *************************** 2. row *************************** Privilege: Alter routine Context: Functions,Procedures Comment: To alter or drop stored ...
https://dev.mysql.com/doc/refman/8.4/en/show-triggers.html
The WHERE clause can be given to select rows using more general conditions, as discussed in Section 28.8, “Extensions to SHOW Statements”. row *************************** Trigger: ins_sum Event: INSERT Table: account Statement: SET @sum = @sum + ... SHOW TRIGGERS [{FROM | IN} db_name] [LIKE 'pattern' | WHERE expr] SHOW TRIGGERS lists the triggers currently defined for tables in a database (the default database unless a FROM clause is ...
https://dev.mysql.com/doc/refman/8.4/en/stored-programs-defining.html
Each stored program contains a body that consists of an SQL statement. This statement may be a compound statement made up of several statements separated by semicolon (;) characters. For example, the following stored procedure has a body made up of ...
https://dev.mysql.com/doc/refman/8.4/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. rows_sent The total number of rows returned by statements for the host. The ...
https://dev.mysql.com/doc/refman/8.4/en/sys-host-summary-by-statement-type.html
By default, rows are sorted by host and descending total latency. 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. rows_sent ... These views summarize information about statements executed, grouped by host and statement ...
https://dev.mysql.com/doc/refman/8.4/en/sys-innodb-lock-waits.html
These views summarize the InnoDB locks that transactions are waiting for. The innodb_lock_waits and x$innodb_lock_waits views have these columns: wait_started The time at which the lock wait started. wait_age How long the lock has been waited for, ...
https://dev.mysql.com/doc/refman/8.4/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/8.4/en/sys-schema-table-statistics.html
By default, rows are sorted by descending total wait time (tables with most contention first). The schema_table_statistics and x$schema_table_statistics views have these columns: table_schema The schema that contains the table. total_latency The ...
https://dev.mysql.com/doc/refman/8.4/en/sys-statements-with-full-table-scans.html
By default, rows are sorted by descending percentage of time a full scan was done and descending total latency. rows_examined The total number of rows read from the storage engine for the table. rows_examined_avg The average number of rows read from ... These views display normalized statements that have done full table ...