Search Results
https://dev.mysql.com/doc/refman/8.4/en/myisam-table-close.html
In other words, the counter can become incorrect only under these conditions: A MyISAM table is copied without first issuing LOCK TABLES and FLUSH TABLES. Each MyISAM index file (.MYI file) has a counter in the header that can be used to check ...
https://dev.mysql.com/doc/refman/8.4/en/myisamchk-table-info.html
If you start the MySQL server with external locking disabled, myisamchk may report an error for a table that is updated while it runs. Datafile parts For dynamic-row format, this indicates how many data blocks there are. Blocks/Record Average number ... To obtain a description of a MyISAM table or statistics about it, use the commands shown ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-data-node-memory-management.html
Transaction memory is used for all operational resources handling transactions, scans, locks, scan buffers, and trigger operations. Each block in each thread contains block objects that use memory. All memory allocation for a data node is performed ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-ndbinfo-cluster-transactions.html
(Currently, the MySQL Server does not expose the NDB API transaction ID of an ongoing transaction.) block_instance refers to an instance of a kernel block. Together with the block name, this number can be used to look up a given instance in the ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-ndbinfo-dictionary-tables.html
dictionary_tables contains the columns listed here: table_id The table' unique ID database_name Name of the database containing the table table_name Name of the table status The table status; one of New, Changed, Retrieved, Invalid, or Altered.
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-ndbinfo-tc-time-track-stats.html
The tc_time_track_stats table provides time-tracking information obtained from the DBTC block (TC) instances in the data nodes, through API nodes access NDB. tc_time_track_stats presents this information as rows, with a row for each instance of the ...Each TC instance tracks latencies for a set of activities it undertakes on behalf of API nodes or other data nodes; these activities include transactions, transaction errors, key reads, key writes, unique index operations, failed key operations of any type, scans, failed scans, fragment scans, and failed fragment ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-ndbinfo.html
row *************************** Engine: InnoDB Support: DEFAULT Comment: Supports transactions, row-level locking, and foreign keys Transactions: YES XA: YES Savepoints: YES *************************** 3. With the exception of the blocks and ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-privilege-synchronization.html
An SQL node performing a change to user privileges takes a global lock before doing so, which prevents deadlocks by concurrent ACL operations on different SQL nodes. Privilege synchronization is the mechanism used by NDB Cluster for sharing and ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-enterprise.html
Like MySQL Community Edition, MySQL Enterprise Edition includes MySQL Server, a fully integrated transaction-safe, ACID-compliant database with full commit, rollback, crash-recovery, and row-level locking capabilities. In addition, MySQL Enterprise ...
https://dev.mysql.com/doc/refman/8.4/en/optimizing-innodb-configuration-variables.html
Different settings work best for servers with light, predictable loads, versus servers that are running near full capacity all the time, or that experience spikes of high activity. Because the InnoDB storage engine performs many of its ...