PDF (US Ltr)
- 43.2Mb
PDF (A4)
- 43.3Mb
Man Pages (TGZ)
- 295.2Kb
Man Pages (Zip)
- 400.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
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/audit-log.html
From MySQL 8.0.30, you can add statistics for the time and size of each query to detect outliers. Note MySQL Enterprise Audit is an extension included in MySQL Enterprise Edition, a commercial product. MySQL Enterprise Edition includes MySQL ...
https://dev.mysql.com/doc/refman/8.0/en/bit-functions.html
In MySQL 8.0, bit functions and operators permit binary string type arguments (BINARY, VARBINARY, and the BLOB types) and return a value of like type, which enables them to take arguments and produce return values larger than 64 bits. If the ...
https://dev.mysql.com/doc/refman/8.0/en/bit-type.html
The maximum combined size of all BIT columns used in a given NDB table must not exceed 4096 bits. The BIT data type is used to store bit values. If you assign a value to a BIT(M) column that is less than M bits long, the value is padded on the left ...