Search Results
https://dev.mysql.com/doc/refman/8.4/en/faqs-general.html
The InnoDB storage engine offers full ACID transactions with row-level locking, multi-versioning, nonlocking repeatable reads, and all four SQL standard isolation levels. Why did MySQL version numbering skip versions 6 and 7 and go straight to 8.0? ...
https://dev.mysql.com/doc/refman/8.4/en/firewall-elements.html
This is useful, for example, for any database administrator who configures the firewall, to avoid the possibility of a misconfiguration causing even the administrator to be locked out and unable to execute statements. MySQL Enterprise Firewall is ...
https://dev.mysql.com/doc/refman/8.4/en/firewall-usage.html
This is useful, for example, for a database administrator who configures the firewall, to avoid the possibility of a misconfiguration causing even the administrator to be locked out and unable to execute statements. DETECTING: This mode detects but ... Before using MySQL Enterprise Firewall, install it according to the instructions provided in Section 8.4.7.2, “Installing or Uninstalling MySQL Enterprise ...
https://dev.mysql.com/doc/refman/8.4/en/full-disk.html
This section describes how MySQL responds to disk-full errors (such as “no space left on device”), and to quota-exceeded errors (such as “write failed” or “user block limit reached”). If you have several “locked” threads, killing ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-summary.html
Note that if two transactions are bound to conflict more often than not, then it is a good practice to start them on the same server, where they have a chance to synchronize on the local lock manager instead of being rolled back as a result of ...
https://dev.mysql.com/doc/refman/8.4/en/help.html
HELP 'search_string' The HELP statement returns online information from the MySQL Reference Manual. Its proper operation requires that the help tables in the mysql database be initialized with help topic information (see Section 7.1.17, ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-innodb-buffer-page-lru-table.html
It has LRU_POSITION and COMPRESSED columns instead of BLOCK_ID and PAGE_STATE columns, and it does not include and IS_STALE column. FIX_COUNT The number of threads using this block within the buffer pool. IS_OLD Whether the block is in the sublist ... The INNODB_BUFFER_PAGE_LRU table provides information about the pages in the InnoDB buffer pool; in particular, how they are ordered in the LRU list that determines which pages to evict from the buffer pool when it becomes ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-autocommit-commit-rollback.html
Both COMMIT and ROLLBACK release all InnoDB locks that were set during the current transaction. 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 ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-backup.html
mysqldump also has a --single-transaction option for making a consistent snapshot without locking out other clients. 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-buffer-pool-resize.html
Status codes include: 0: No Resize operation in progress 1: Starting Resize 2: Disabling AHI (Adaptive Hash Index) 3: Withdrawing Blocks 4: Acquiring Global Lock 5: Resizing Pool 6: Resizing Hash 7: Resizing Failed The ... You can configure InnoDB ...