Search Results
https://dev.mysql.com/doc/refman/8.4/en/grant-tables.html
Note Direct modification of grant tables using statements such as INSERT, UPDATE, or DELETE is discouraged and done at your own risk. The mysql system database includes several grant tables that contain information about user accounts and the ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-enterprise-backup.html
MySQL Enterprise Backup is a commercially-licensed backup utility for MySQL Server, available with MySQL Enterprise Edition. This section explains how to back up and subsequently restore a Group Replication member using MySQL Enterprise Backup. The ...
https://dev.mysql.com/doc/refman/8.4/en/index-statistics.html
(This may occur for bulk inserts or deletes, or some ALTER TABLE statements, for example.) If this happens, the statistics are collected using whatever value innodb_stats_method or myisam_stats_method has at the time. Storage engines collect ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-events-table.html
The EVENTS table provides information about Event Manager events, which are discussed in Section 27.4, “Using the Event Scheduler”. The EVENTS table has these columns: EVENT_CATALOG The name of the catalog to which the event belongs.
https://dev.mysql.com/doc/refman/8.4/en/information-schema-plugins-table.html
PLUGIN_STATUS The plugin status, one of ACTIVE, INACTIVE, DISABLED, DELETING, or DELETED. The PLUGINS table has these columns: PLUGIN_NAME The name used to refer to the plugin in statements such as INSTALL PLUGIN and UNINSTALL PLUGIN. PLUGIN_TYPE ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-tables-table.html
Even with file-per-table mode with each InnoDB table in a separate .ibd file, change buffering can delay the write to the data file, so the file modification time is different from the time of the last insert, update, or delete. UPDATE_TIME displays ...The information_schema_stats_expiry system variable defines the period of time before cached table statistics ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-triggers-table.html
The value is INSERT (a row was inserted), DELETE (a row was deleted), or UPDATE (a row was modified). To see information about a table's triggers, you must have the TRIGGER privilege for the table. The TRIGGERS table has these columns: ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-views-table.html
The flag is set to YES (true) if UPDATE and DELETE (and similar operations) are legal for the view. If a view is not updatable, statements such UPDATE, DELETE, and INSERT are illegal and are rejected. You must have the SHOW VIEW privilege to access ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-autocommit-commit-rollback.html
If autocommit mode is enabled, each SQL statement forms a single transaction on its own. By default, MySQL starts the session for each new connection with autocommit enabled, so MySQL does a commit after each SQL statement if that statement did not ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-best-practices.html
Foreign keys also propagate deletes and updates to all affected tables, and prevent insertion of data in a child table if the corresponding IDs are not present in the parent table. While you don't want to commit too often, you also don't want to ...