Search Results
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 ...
https://dev.mysql.com/doc/mysql-enterprise-backup/8.4/en/meb-group-replication.html
When working with a Group Replication setup, mysqlbackup makes the backup information available to all members of the server group by making sure that the backup_history, backup_sbt_history (when using the SBT API), and backup_progress tables are ...
https://dev.mysql.com/doc/mysql-enterprise-backup/8.4/en/meb-troubleshooting.html
As mysqlbackup proceeds, it writes progress information into the mysql.backup_progress table. When the command finishes the backup operation, it records status information in the mysql.backup_history table. You can query those tables to monitor ...
https://dev.mysql.com/doc/mysql-enterprise-backup/8.4/en/mysqlbackup.backup.html
The unique ID for this backup job is recorded in special tables that mysqlbackup creates inside the MySQL instance, allowing you to monitor long-running backups and view information on previous backups. In the following illustration, we back up an ...
https://dev.mysql.com/doc/mysql-enterprise-backup/8.4/en/restore.html
The restored data includes the backup_history table, where MySQL Enterprise Backup records details of each backup. The table allows you to perform future incremental backups using the --incremental-base=history:{last_backup | last_full_backup} ...