Search Results
https://dev.mysql.com/doc/refman/8.4/en/gone-away.html
If a specific query kills mysqld and the tables involved were checked with CHECK TABLE before you ran the query, can you provide a reproducible test case? See Section 7.9, “Debugging MySQL”. This section also covers the related Lost connection ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-change-primary.html
You can identify the current primary using the MEMBER_ROLE column in the Performance Schema replication_group_members table. This section explains how to change which member of a single-primary group is the primary, using the ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-observability.html
The entire state of the system (including the view, conflict statistics and service states) can be queried through Performance Schema tables. For example, you can connect to a single server in the group and obtain both local and global information ... There is a lot of automation built into the Group Replication ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-responses-failure-exit.html
The group_replication_exit_state_action system variable specifies what Group Replication does when the member leaves the group unintentionally due to an error or problem, and either fails to auto-rejoin or does not try. Note that in the case of an ...
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/innodb-buffer-pool-flushing.html
When table data is stored on a traditional HDD storage device, flushing neighbor pages in one operation reduces I/O overhead (primarily for disk seek operations) compared to flushing individual pages at different times. For table data stored on SSD, ... InnoDB performs certain tasks in the background, including flushing of dirty pages from the buffer ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-configuration.html
For information about optimizing database operations for InnoDB tables, see Section 10.5, “Optimizing for InnoDB Tables”. This section provides configuration information and procedures for InnoDB initialization, startup, and various components ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-multi-versioning.html
This information is stored in undo tablespaces in a data structure called a rollback segment. Otherwise, InnoDB cannot discard data from the update undo logs, and the rollback segment may grow too big, filling up the undo tablespace in which it ...
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. You ... InnoDB can avoid the overhead associated with setting up the transaction ID (TRX_ID field) for transactions that are known to be ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-transaction-scheduling.html
You can view transaction scheduling weights by querying the TRX_SCHEDULE_WEIGHT column in the Information Schema INNODB_TRX table. For information about using INNODB_METRICS counters, see Section 17.15.6, “InnoDB INFORMATION_SCHEMA Metrics ...