PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 297.2Kb
Man Pages (Zip)
- 402.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-option-tables.html
ndb-log-exclusive-reads: Log primary key reads with exclusive locks; allow conflict resolution based on read conflicts. Ndb_api_wait_exec_complete_count: Number of times thread has been blocked while waiting for operation execution to complete by ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-replication-conflict-resolution.html
This requires exclusive read locks obtained by setting ndb_log_exclusive_reads equal to 1 on the replica. READ_ROW operations are user-initiated read tracking operations defined with exclusive row locks. Acquiring exclusive read locks in this way ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-thread-states.html
Waiting for allowed to take ndbcluster global schema lock The thread is waiting for permission to take a global schema lock. Waiting for first event from ndbcluster Waiting for ndbcluster binlog update to reach current position Waiting for ...
https://dev.mysql.com/doc/refman/8.0/en/optimizing-queries-myisam.html
Try to avoid complex SELECT queries on MyISAM tables that are updated frequently, to avoid problems with table locking that occur due to contention between readers and writers. MyISAM supports concurrent inserts: If a table has no free blocks in the ... Some general tips for speeding up queries on MyISAM tables: To help MySQL better optimize queries, use ANALYZE TABLE or run myisamchk --analyze on a table after it has been loaded with ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-setup-instruments-table.html
row *************************** NAME: wait/synch/mutex/pfs/LOCK_pfs_share_list ENABLED: NO TIMED: NO PROPERTIES: singleton FLAGS: NULL VOLATILITY: 1 DOCUMENTATION: Components can provide their own performance_schema tables. When an instrument is ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-tp-thread-group-stats-table.html
ROW_LOCK_WAITS The number of THD_WAIT_ROW_LOCK waits for release of a row lock by another transaction. GLOBAL_LOCK_WAITS The number of THD_WAIT_GLOBAL_LOCK waits for a global lock to be released. META_DATA_LOCK_WAITS The number of ... Note The ...
https://dev.mysql.com/doc/refman/8.0/en/replication-semisync-interface.html
From MySQL 8.0.23, you can improve the performance of semisynchronous replication by enabling the system variables replication_sender_observe_commit_only, which limits callbacks, and replication_optimize_for_static_plugin_config, which adds shared ... When you install the source and replica plugins for semisynchronous replication (see Section 19.4.10.1, “Installing Semisynchronous Replication”), system variables become available to control plugin ...
https://dev.mysql.com/doc/refman/8.0/en/replication-semisync.html
If semisynchronous replication is enabled on the source side and there is at least one semisynchronous replica, a thread that performs a transaction commit on the source blocks and waits until at least one semisynchronous replica acknowledges that ... In addition to the built-in asynchronous replication, MySQL 8.0 supports an interface to semisynchronous replication that is implemented by ...
https://dev.mysql.com/doc/refman/8.0/en/replication-solutions-backups-read-only.html
Note The instructions in this section place the server to be backed up in a state that is safe for backup methods that get the data from the server, such as mysqldump (see Section 6.5.4, “mysqldump — A Database Backup Program”). You should not ...
https://dev.mysql.com/doc/refman/8.0/en/savepoint.html
Modifications that the current transaction made to rows after the savepoint was set are undone in the rollback, but InnoDB does not release the row locks that were stored in memory after the savepoint. (For a new inserted row, the lock information ... SAVEPOINT identifier ROLLBACK [WORK] TO [SAVEPOINT] identifier RELEASE SAVEPOINT identifier InnoDB supports the SQL statements SAVEPOINT, ROLLBACK TO SAVEPOINT, RELEASE SAVEPOINT and the optional WORK keyword for ...