Search Results
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/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-save.html
It is intended you call ps_setup_reload_saved() later within the same session as ps_setup_save() because the configuration is saved in TEMPORARY tables. If you end your session without invoking ps_setup_save(), the tables and lock disappear ...This ...
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 ...
https://dev.mysql.com/doc/refman/8.4/en/use.html
The named database remains the default until the end of the session or another USE statement is issued: USE db1; SELECT COUNT(*) FROM mytable; # selects from db1.mytable USE db2; SELECT COUNT(*) FROM mytable; # selects from db2.mytable The database ... USE db_name The USE statement tells MySQL to use the named database as the default (current) database for subsequent ...
https://dev.mysql.com/doc/refman/8.4/en/windows-symbolic-links.html
After this, all tables created in the database mydb are created in D:\data\mydb. After this, all tables created in the database mydb are created in D:\data\mydb. On Windows, symbolic links can be used for database directories. This enables you to ...
https://dev.mysql.com/doc/mysql-enterprise-backup/8.4/en/backup-metadata-options.html
Some metadata is stored in the backup directory, other metadata is stored in tables within the mysql database of the backed-up instance. --no-history-logging Turns off the recording of backup progress and history in logging tables inside the ...