Search Results
https://dev.mysql.com/doc/refman/8.4/en/innodb-performance-ro-txn.html
In this case, attempting to make changes to the database (for InnoDB, MyISAM, or other types of tables) causes an error, and the transaction continues in read-only state: ERROR 1792 (25006): Cannot execute statement in a READ ONLY transaction.
https://dev.mysql.com/doc/refman/8.4/en/innodb-recovery.html
Doing so may eliminate errors that appeared to be database page corruption. If a hardware failure or severe system error corrupted InnoDB data, MySQL might refuse to start. To achieve point-in-time recovery after restoring a backup, you can apply ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-undo-tablespaces.html
An error message is reported at startup if an undo tablespace known to the data dictionary is not found. Attempting to drop an undo tablespace that is not empty returns an error. Undo tablespaces contain undo logs, which are collections of records ...
https://dev.mysql.com/doc/refman/8.4/en/invisible-columns.html
For new or modified rows, violation of a CHECK constraint on an invisible column produces an error. An invisible column is normally hidden to queries, but can be accessed if explicitly referenced. As an illustration of when invisible columns may be ...
https://dev.mysql.com/doc/refman/8.4/en/invisible-indexes.html
If an index made invisible actually is needed or used by the optimizer, there are several ways to notice the effect of its absence on queries for the table: Errors occur for queries that include index hints that refer to the invisible index. MySQL ...
https://dev.mysql.com/doc/refman/8.4/en/keyring-functions-plugin-specific.html
Return value: Returns 1 for success, or NULL and an error for failure. Return value: Returns 1 for success, or NULL and an error for failure. For each keyring plugin-specific function, this section describes its purpose, calling sequence, and ...
https://dev.mysql.com/doc/refman/8.4/en/known-issues.html
For example, the following does not work: mysql> SELECT * FROM temp_table, temp_table AS t2; ERROR 1137: Can't reopen table: 'temp_table' The optimizer may handle DISTINCT differently when you are using “hidden” columns in a join than when you ... This section lists known issues in recent versions of ...
https://dev.mysql.com/doc/refman/8.4/en/large-page-support.html
In the event sysctl returns an error relating to the file name, check the name of the corresponding file in /proc/sys/vm and use that instead. If InnoDB cannot do this, it falls back to use of traditional memory and writes a warning to the error ...
https://dev.mysql.com/doc/refman/8.4/en/linux-installation-sles-repo.html
A password for the superuser is set and stored in the error log file. The MySQL SLES repository provides RPM packages for installing and managing the MySQL server, client, and other components on SUSE Enterprise Linux Server. Adding the MySQL SLES ...
https://dev.mysql.com/doc/refman/8.4/en/linux-installation-yum-repo.html
A password for the superuser is set and stored in the error log file. Before You Start As a popular, open-source software, MySQL, in its original or re-packaged form, is widely installed on many systems from various sources, including different ...