Search Results
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-filtering.html
The setup_instruments table lists the instruments for which events can be collected, whether they are enabled, and (for enabled instruments) whether to collect timing information: mysql> SELECT NAME, ENABLED, TIMED FROM ... Events are processed in a ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-wait-tables.html
The Performance Schema instruments waits, which are events that take time. For additional information about configuring event collection, see Section 29.3, “Performance Schema Startup Configuration”, and Section 29.4, “Performance Schema ...
https://dev.mysql.com/doc/mysql-enterprise-backup/8.4/en/backup-performance.html
In an emergency, the time needed to uncompress the backup data before restoring it might be unacceptable. For best backup performance and minimal impact on database processing: Do not run long INSERT, UPDATE, or DELETE queries at the time of the ...
https://dev.mysql.com/doc/mysql-enterprise-backup/8.4/en/restore-performance.html
The restore operation is often performed during an emergency, where it is critical to minimize the downtime of the application or web site. Restoring Different Classes of Backup Data Restoring a partial backup takes less time than restoring a full ... This section describes the performance considerations for restoring a database server with MySQL Enterprise ...
https://dev.mysql.com/doc/refman/8.4/en/grant.html
GRANT either succeeds for all named users and roles or rolls back and has no effect if any error occurs. For example: CREATE USER 'jeffrey'@'localhost' IDENTIFIED BY 'password'; GRANT ALL ON db1.* TO 'jeffrey'@'localhost'; GRANT SELECT ON ...[WITH ...
https://dev.mysql.com/doc/extending-mysql/8.4/en/writing-audit-plugins.html
Audit Plugin General Descriptor Audit Plugin Type-Specific Descriptor Audit Plugin Notification Function Audit Plugin Error Handling Audit Plugin Usage Audit Plugin General Descriptor An audit plugin, like any MySQL server plugin, has a general ...
https://dev.mysql.com/doc/refman/8.4/en/processlist-access.html
For a replica SQL thread, the value is the number of seconds between the timestamp of the last replicated event and the real time of the replica host. If a thread stays in a given state for many seconds, there might be a problem that needs to be ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-tp-thread-group-state-table.html
OLDEST_QUEUED How long in milliseconds the oldest queued statement has been waiting for execution. There is at most one thread ready to start executing if the active threads become stalled or blocked. There can be a maximum of four connection ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-programs-ndb-drop-table.html
--connect-retries Command-Line Format --connect-retries=# Type Integer Default Value 12 Minimum Value 0 Maximum Value 12 Number of times to retry connection before giving up. --connect-retry-delay Command-Line Format --connect-retry-delay=# Type ...
https://dev.mysql.com/doc/refman/8.4/en/stored-objects-security.html
For an event, an error occurs at event execution time if the account does not exist. Stored programs (procedures, functions, triggers, and events) and views are defined prior to use and, when referenced, execute within a security context that ...