Search Results
https://dev.mysql.com/doc/refman/8.4/en/drop-database.html
Important When a database is dropped, privileges granted specifically for the database are not automatically dropped. DROP {DATABASE | SCHEMA} [IF EXISTS] db_name DROP DATABASE drops all tables in the database and deletes the database. Be very ...
https://dev.mysql.com/doc/refman/8.4/en/drop-table.html
Important When a table is dropped, privileges granted specifically for the table are not automatically dropped. Be careful with this statement! For each table, it removes the table definition and all table data. If the table is partitioned, the ...
https://dev.mysql.com/doc/refman/8.4/en/faqs-replication.html
How do I prevent GRANT and REVOKE statements from replicating to replica machines? A.14.13. How do I prevent GRANT and REVOKE statements from replicating to replica machines? Start the server with the --replicate-wild-ignore-table=mysql.% option to ... In the following section, we provide answers to questions that are most frequently asked about MySQL ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-cloning.html
As a minimum, you must install the clone plugin on the donor and joining member, grant the BACKUP_ADMIN permission to the replication user for distributed recovery, and set the group_replication_clone_threshold system variable to an appropriate ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-enabled-roles-table.html
The ENABLED_ROLES table has these columns: ROLE_NAME The user name part of the granted role. The ENABLED_ROLES table provides information about the roles that are enabled within the current session. IS_DEFAULT YES or NO, depending on whether the ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-locking-reads.html
FOR SHARE statements do not acquire read locks on MySQL grant tables. If you query data and then insert or update related data within the same transaction, the regular SELECT statement does not give enough protection. Other transactions can update ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-locks-set.html
When session 1 rolls back, it releases its exclusive lock on the row and the queued shared lock requests for sessions 2 and 3 are granted. When session 1 commits, it releases its exclusive lock on the row and the queued shared lock requests for ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-online-ddl-performance.html
Once granted, the duration of the exclusive metadata lock is brief. Session 3: mysql> SELECT * FROM t1; The SELECT statement issued in session 3 is blocked waiting for the exclusive metadata lock requested by the ALTER TABLE operation in session 2 ... Online DDL improves several aspects of MySQL operation: Applications that access the table are more responsive because queries and DML operations on the table can proceed while the DDL operation is in ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-redo-log.html
On the new MySQL instance, grant the INNODB_REDO_LOG_ENABLE privilege to the user account responsible for disabling redo logging. mysql> GRANT INNODB_REDO_LOG_ENABLE ON *.* to 'data_load_admin'; As the data_load_admin user, disable redo logging: ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-transaction-scheduling.html
A single attempt may result in zero or more record locks being granted. InnoDB uses the Contention-Aware Transaction Scheduling (CATS) algorithm to prioritize transactions that are waiting for locks. When multiple transactions are waiting for a ...