Search Results
https://dev.mysql.com/doc/refman/8.4/en/binary-log-setting.html
When row-based binary logging is used, the binlog_row_event_max_size system variable and its corresponding startup option --binlog-row-event-max-size set a soft limit on the maximum size of row events. Where possible, rows stored in the binary log ...There are several reasons why a client might want to set binary logging on a per-session basis: A session that makes many small changes to the database might want to use row-based ...
https://dev.mysql.com/doc/connectors/en/connector-net-programming-trace-source.html
Total rows=272, skipped rows=0, size (bytes)=7058 mysql Information: 6 : 1: Query Closed mysql Information: 3 : 1: Query Opened: SHOW COLLATION mysql Information: 4 : 1: Resultset Opened: field(s) = 6, affected rows = -1, inserted id = -1 mysql ...
https://dev.mysql.com/doc/x-devapi-userguide/en/working-with-sql-result-sets.html
An SqlResult instance exports methods for accessing data and to retrieving the last inserted ID or number of affected rows. If hasData() returns true, then the SqlResult origins from a SELECT or similar command that can return rows. A return value ... When you execute an SQL operation on a Session using the sql() method, an SqlResult is ...
https://dev.mysql.com/doc/heatwave-aws/en/heatwave-aws-cloudwatch-metrics.html
dbSystemId Detailed heatwave.heap_usage Bytes The size of the MySQL HeatWave data dictionary, which consumes heap space on the DB system nodes. dbSystemId Detailed heatwave.lakehouse_total_loaded_bytes Bytes The total size of all Lakehouse tables ...
https://dev.mysql.com/doc/refman/8.4/en/general-tablespaces.html
General Tablespace Row Format Support General tablespaces support all table row formats (REDUNDANT, COMPACT, DYNAMIC, COMPRESSED) with the caveat that compressed and uncompressed tables cannot coexist in the same general tablespace due to different ...CREATE TABLESPACE tablespace_name [ADD DATAFILE 'file_name'] [FILE_BLOCK_SIZE = value] [ENGINE [=] engine_name] A general tablespace can be created in the data directory or outside of ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-innodb-cmp-table.html
row *************************** page_size: 1024 compress_ops: 0 compress_ops_ok: 0 compress_time: 0 uncompress_ops: 0 uncompress_time: 0 *************************** 2. row *************************** page_size: 2048 compress_ops: 0 compress_ops_ok: ...The INNODB_CMP and INNODB_CMP_RESET tables have these columns: PAGE_SIZE The compressed page size in ... The ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-innodb-cmpmem-table.html
row *************************** page_size: 1024 buffer_pool_instance: 0 pages_used: 0 pages_free: 0 relocation_ops: 0 relocation_time: 0 *************************** 2. row *************************** page_size: 2048 buffer_pool_instance: 0 ...The ...
https://dev.mysql.com/doc/refman/8.4/en/added-deprecated-removed.html
Gr_certification_garbage_collector_time_sum: Sum of the time in micro-seconds that certification garbage collection runs took. If this number grows, it means that at least of the node is having issues answering to Proposals, either by slowliness or ... Options and Variables Introduced in MySQL 8.4 Options and Variables Deprecated in MySQL 8.4 Options and Variables Removed in MySQL 8.4 This section lists server variables, status variables, and options that were added for the first time, have been deprecated, or have been removed in MySQL 8.4 since ...
https://dev.mysql.com/doc/ndbapi/en/ndb-start-mysql-data-types.html
This means that each of these types requires the same amount of storage as a CHAR of the same size. Each row in an NDB Cluster BLOB or TEXT column is made up of two separate parts. One of these is of fixed size (256 bytes), and is actually stored in ... This section provides information about the way in which MySQL data types are represented in NDBCLUSTER table columns and how these values can be accessed in NDB API ...
https://dev.mysql.com/doc/mysqld-version-reference/en/optvar-changes-5-7.html
The following list details the changes to specific options and variables within MySQL 5.7.