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/myisam-storage-engine.html
For the case of a key longer than 250 bytes, a larger key block size than the default of 1024 bytes is used. This is done by automatically combining adjacent deleted blocks and by extending blocks if the next block is deleted. MyISAM supports ...
https://dev.mysql.com/doc/refman/8.0/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.0/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.0/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.0/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.0/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.0/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.0/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 *************************** 4. With the exception of the blocks and ...
https://dev.mysql.com/doc/refman/8.0/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.0/en/mysql-upgrade.html
Each table is locked and therefore unavailable to other sessions while it is being processed. Note As of MySQL 8.0.16, the MySQL server performs the upgrade tasks previously handled by mysql_upgrade (for details, see Section 3.4, “What the MySQL ...