Search Results
https://dev.mysql.com/doc/refman/8.4/en/ignoring-user.html
If you get the following error, it means that when mysqld was started or when it reloaded the grant tables, it found an account in the user table that had an invalid password. Found wrong password for user 'some_user'@'some_host'; ignoring user As ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-innodb-buffer-page-lru-table.html
This allocation could potentially cause an out-of-memory error, especially for systems with multi-gigabyte buffer pools. The INNODB_BUFFER_PAGE_LRU table provides information about the pages in the InnoDB buffer pool; in particular, how they are ...
https://dev.mysql.com/doc/refman/8.4/en/innochecksum.html
Attempting to run innochecksum on a tablespace that the server already has open results in an Unable to lock file error. This tool reads an InnoDB tablespace file, calculates the checksum for each page, compares the calculated checksum to the stored ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-backup.html
Use the following procedure: Perform a slow shutdown of the MySQL server and make sure that it stops without errors. The key to safe database management is making regular backups. Hot and cold backups are physical backups that copy actual data ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-consistent-read.html
In this case, the transaction returns an error: ER_TABLE_DEF_CHANGED, “Table definition has changed, please retry transaction”. A consistent read means that InnoDB uses multi-versioning to present to a query a snapshot of the database at a ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-create-table-external.html
Attempting to access a table when the associated data file is missing causes a serious error that requires a server restart. There are different reasons for creating InnoDB tables externally; that is, creating tables outside of the data directory.
https://dev.mysql.com/doc/refman/8.4/en/innodb-data-encryption.html
Failing to do so results in errors when starting the server and during InnoDB recovery. InnoDB supports data-at-rest encryption for file-per-table tablespaces, general tablespaces, the mysql system tablespace, redo logs, and undo logs. You can set ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-deadlock-detection.html
The same error may also occur if the locking thread must look at more than 1,000,000 locks owned by transactions on the wait-for list. When deadlock detection is enabled (the default), InnoDB automatically detects transaction deadlocks and rolls ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-locking.html
If a lock request conflicts with an existing lock and cannot be granted because it would cause deadlock, an error occurs. Shared and Exclusive Locks Intention Locks Record Locks Gap Locks Next-Key Locks Insert Intention Locks AUTO-INC Locks ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-monitor-types.html
There are two types of InnoDB monitor: The standard InnoDB Monitor displays the following types of information: Work done by the main background thread Semaphore waits Data about the most recent foreign key and deadlock errors Lock waits for ...