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/xa-states.html
An XA transaction progresses through the following states: Use XA START to start an XA transaction and put it in the ACTIVE state. For an ACTIVE XA transaction, issue the SQL statements that make up the transaction, and then issue an XA END ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema-innodb-buffer-pool-stats-table.html
The INNODB_BUFFER_POOL_STATS table provides much of the same buffer pool information provided in SHOW ENGINE INNODB STATUS output. Much of the same information may also be obtained using InnoDB buffer pool server status variables. The idea of ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-performance-compression-oltp.html
Because working with compressed data sometimes involves keeping both compressed and uncompressed versions of a page in memory at the same time, when using compression with an OLTP-style workload, be prepared to increase the value of the ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-performance-ro-txn.html
Eliminating unnecessary transaction IDs reduces the size of internal data structures that are consulted each time a query or data change statement constructs a read view. The transaction is started without the READ ONLY option, but no updates or ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-data-lock-waits-table.html
row *************************** ENGINE: INNODB REQUESTING_ENGINE_LOCK_ID: 140211201964816:2:4:2:140211086465800 REQUESTING_ENGINE_TRANSACTION_ID: 1555 REQUESTING_THREAD_ID: 47 REQUESTING_EVENT_ID: 5 REQUESTING_OBJECT_INSTANCE_BEGIN: 140211086465800 ... The data_lock_waits table implements a many-to-many relationship showing which data lock requests in the data_locks table are blocked by which held data locks in the data_locks ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-replication-group-member-stats-table.html
COUNT_TRANSACTIONS_ROWS_VALIDATING Number of transaction rows which can be used for certification, but have not been garbage collected. Can be thought of as the current size of the conflict detection database against which each transaction is ...The ...
https://dev.mysql.com/doc/refman/8.0/en/pluggable-storage-common-layer.html
From a technical perspective, what are some of the unique supporting infrastructure components that are in a storage engine? Some of the key feature differentiations include: Concurrency: Some applications have more granular lock requirements (such ... A MySQL pluggable storage engine is the component in the MySQL database server that is responsible for performing the actual data I/O operations for a database as well as enabling and enforcing certain feature sets that target a specific application ...
https://dev.mysql.com/doc/refman/8.0/en/show-replica-status.html
Relay_Log_Space The total combined size of all existing relay log files. Last_IO_Error_Timestamp A timestamp in YYMMDD hh:mm:ss format that shows when the most recent I/O error took place. SHOW {REPLICA | SLAVE} STATUS [FOR CHANNEL channel] This ...
https://dev.mysql.com/doc/refman/8.0/en/sys-ps-statement-avg-latency-histogram.html
Displays a textual histogram graph of the average latency values across all normalized statements tracked within the Performance Schema events_statements_summary_by_digest table. This procedure can be used to display a very high-level picture of ...
https://dev.mysql.com/doc/refman/8.0/en/charset-unicode-conversion.html
InnoDB has a maximum index length of 767 bytes for tables that use COMPACT or REDUNDANT row format, so for utf8mb3 or utf8mb4 columns, you can index a maximum of 255 or 191 characters, respectively. Tables created with these row formats enable you ... This section describes issues that you may face when converting character data between the utf8mb3 and utf8mb4 character ...