Search Results
https://dev.mysql.com/doc/refman/8.4/en/show-create-trigger.html
This statement requires the TRIGGER privilege for the table associated with the trigger. row *************************** Trigger: ins_sum sql_mode: ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES, NO_ZERO_IN_DATE,NO_ZERO_DATE, ERROR_FOR_DIVISION_BY_ZERO, ...
https://dev.mysql.com/doc/refman/8.4/en/show-databases.html
Caution Because any static global privilege is considered a privilege for all databases, any static global privilege enables a user to see all database names with SHOW DATABASES or by examining the SCHEMATA table of INFORMATION_SCHEMA, except ...
https://dev.mysql.com/doc/refman/8.4/en/show-plugins.html
For plugins installed with INSTALL PLUGIN, the Name and Library values are also registered in the mysql.plugin system table. row *************************** Name: binlog Status: ACTIVE Type: STORAGE ENGINE Library: NULL License: GPL ...
https://dev.mysql.com/doc/refman/8.4/en/show-status.html
Status variable information is also available from these sources: Performance Schema tables. Each invocation of the SHOW STATUS statement uses an internal temporary table and increments the global Created_tmp_tables value. mysql> SHOW STATUS; ...
https://dev.mysql.com/doc/refman/8.4/en/sorted-index-builds.html
Sorted Index Builds and Compressed Tables For compressed tables, the previous index creation method appended entries to both compressed and uncompressed pages. For more information about compression of B-Tree pages, see Section 17.9.1.5, “How ...
https://dev.mysql.com/doc/refman/8.4/en/sys-innodb-buffer-stats-by-schema.html
These views summarize the information in the INFORMATION_SCHEMA INNODB_BUFFER_PAGE table, grouped by schema. Warning Querying views that access the INNODB_BUFFER_PAGE table can affect performance. Do not query these views on a production system ...
https://dev.mysql.com/doc/refman/8.4/en/sys-ps-setup-show-disabled.html
Displays all currently disabled Performance Schema configuration. Parameters in_show_instruments BOOLEAN: Whether to display disabled instruments. This might be a long list. in_show_threads BOOLEAN: Whether to display disabled threads. Example ...
https://dev.mysql.com/doc/refman/8.4/en/sys-ps-trace-statement-digest.html
If you find a statement of interest within the Performance Schema events_statements_summary_by_digest table, specify its DIGEST column MD5 value to this procedure and indicate the polling duration and interval. in_start_fresh BOOLEAN: Whether to ...
https://dev.mysql.com/doc/refman/8.4/en/sys-statement-analysis.html
full_scan The total number of full table scans performed by occurrences of the statement. tmp_tables The total number of internal in-memory temporary tables created by occurrences of the statement. tmp_disk_tables The total number of internal ...The ...
https://dev.mysql.com/doc/refman/8.4/en/uninstall-component.html
It requires the DELETE privilege for the mysql.component system table because it removes the row from that table that registers the component. A loader service handles component unloading, which includes removing uninstalled components from the ...A ...