Search Results
https://dev.mysql.com/doc/refman/8.4/en/server-status-variables.html
| Connections | 30023 | | Created_tmp_disk_tables | 0 | | Created_tmp_files | 3 | | Created_tmp_tables | 2 | ... | Threads_created | 217 | | Threads_running | 88 | | Uptime | 1389872 | +-----------------------------------+------------+ Many status ... The MySQL server maintains many status variables that provide information about its ...
https://dev.mysql.com/doc/refman/8.4/en/telemetry-metrics-meter-metrics.html
The following server metrics are registered by default: mysql.stats Metrics mysql.stats.com Metrics mysql.stats.connection Metrics mysql.perf_schema Metrics mysql.stats.handler Metrics mysql.stats.myisam Metrics mysql.stats.ssl Metrics mysql.inno ...binlog_stmt_cache_disk_use Binlog_stmt_cache_disk_use ASYNC COUNTER The number of nontransaction statements that used the binary log statement cache but that exceeded the value of binlog_stmt_cache_size and used a temporary file to store those ...
https://dev.mysql.com/doc/mysql-enterprise-backup/8.4/en/mysqlbackup.privileges.html
You can either create a new user with a limited set of privileges, or use an administrative account such as root. CREATE, INSERT, DROP, and UPDATE on the tables mysql.backup_progress and mysql.backup_history, and also SELECT and ALTER on ... The ...
https://dev.mysql.com/doc/mysql-monitor/8.0/en/mem-creating-advisors-overview.html
To create a new Advisor, click the Create Advisor button on the Advisors page. To create an Advisor based on an existing one, select Copy Advisor menu item from the Advisor menu. For a complete list of the built-in variables used to create ...You ...
https://dev.mysql.com/doc/mysql-enterprise-backup/8.4/en/restore-use-tts.html
Requirements for restoring backups created with transportable tablespaces (TTS) (that is, created with the --use-tts option) are similar to those listed in Section 5.1.4, “Table-Level Recovery (TLR)”, with some differences noted in the section.
https://dev.mysql.com/doc/refman/8.4/en/group-replication-adding-instances.html
20.2.1.6.1 Adding a Second Instance In order to add a second instance, server s2, first create the configuration file for it. If you did not have binary logging enabled when you configured the user credentials on s1, and a remote cloning operation ... At this point, the group has one member in it, server s1, which has some data in ...
https://dev.mysql.com/doc/refman/8.4/en/import-table.html
IMPORT TABLE requires the FILE privilege to read the .sdi and table content files, and the CREATE privilege for the table to be created. If necessary, execute this statement to create it: mysql> CREATE SCHEMA hr; At the file system level, copy the ...The IMPORT TABLE statement imports MyISAM tables based on information contained in .sdi (serialized dictionary information) metadata ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-limitations-syntax.html
Trying either to create a temporary table that uses the NDB storage engine or to alter an existing temporary table to use NDB fails with the error Table storage engine 'ndbcluster' does not support the create option 'TEMPORARY'. Attempting to create ... Some SQL statements relating to certain MySQL features produce errors when used with NDB tables, as described in the following list: Temporary ...
https://dev.mysql.com/doc/refman/8.4/en/mysqlslap.html
Invoke mysqlslap like this: mysqlslap [options] Some options such as --create or --query enable you to specify a string containing an SQL statement or a file containing statements. mysqlslap runs in three stages: Create schema, table, and optionally ... mysqlslap is a diagnostic program designed to emulate client load for a MySQL server and to report the timing of each ...
https://dev.mysql.com/doc/internals/en/logging-transactions-rules-for-non-committing-statements.html
Let S be a logged statement that does not have an implicit commit, except CREATE TEMPORARY TABLE...SELECT (This includes all "pure DML": INSERT, UPDATE, DELETE, REPLACE, TRUNCATE, SELECT, DO, CALL, EXECUTE, LOAD DATA INFILE, and BINLOG. It also ...