Search Results
https://dev.mysql.com/doc/refman/8.4/en/grant-tables.html
For any operation that modifies a grant table, the server checks whether the table has the expected structure and produces an error if not. Each statement either succeeds for all named users or rolls back and has no effect if any error occurs. For ... The mysql system database includes several grant tables that contain information about user accounts and the privileges held by ...
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. [WITH GRANT OPTION] [AS user [WITH ROLE DEFAULT | NONE | ALL | ALL EXCEPT role [, role ] ... ] ] } GRANT PROXY ON user_or_role TO user_or_role ...
https://dev.mysql.com/doc/refman/8.4/en/group-by-handling.html
The following discussion demonstrates functional dependence, the error message MySQL produces when functional dependence is absent, and ways of causing MySQL to accept a query in the absence of functional dependence. SQL-92 and earlier does not ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-configuring-consistency-guarantees.html
You can only use the consistency levels BEFORE, AFTER and BEFORE_AND_AFTER on ONLINE members, attempting to use them on members in other states causes a session error. A transaction cannot be on-hold forever, and if the time held exceeds ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-autocommit-commit-rollback.html
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 return an error. If a statement returns an error, the commit or rollback behavior depends ...If autocommit mode is enabled, each SQL statement forms a single transaction on its ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-deadlock-example.html
The following example illustrates how an error can occur when a lock request causes a deadlock. If client A attempts to update a row in Birds at the same time, this will lead to a deadlock: mysql> UPDATE Birds SET value=40 WHERE name='Buzzard'; ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-locking-reads.html
The query executes immediately, failing with an error if a requested row is locked. Because the requested row is locked by Session 1, the locking read returns immediately with an error. If you query data and then insert or update related data ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-locks-set.html
If a duplicate-key error occurs, a shared lock on the duplicate index record is set. The operations by sessions 2 and 3 both result in a duplicate-key error and they both request a shared lock for the row. The operations by sessions 2 and 3 both ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-online-ddl-limitations.html
When the DML operations are applied, it is possible to encounter a duplicate key entry error (ERROR 1062 (23000): Duplicate entry), even if the duplicate entry is only temporary and would be reverted by a later entry in the online log. The ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-system-tablespace.html
If you encounter this error, restore the previous innodb_data_file_path setting, and refer to the system tablespace resizing instructions. The system tablespace is the storage area for the change buffer. It may also contain table and index data if ...