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/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/refman/8.0/en/innodb-checkpoints.html
It often makes sense to set the total size of the log files as large as the buffer pool or even larger. Making your log files very large may reduce disk I/O during checkpointing. How Checkpoint Processing Works InnoDB implements a checkpoint ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-enabling-monitors.html
InnoDB sends the monitor output to stderr rather than to stdout or fixed-size memory buffers to avoid potential buffer overflows. Also, if monitor output is directed to the error log, the log may become quite large if you forget to disable the ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-mgm-definition.html
maxsize: The maximum size (in bytes) to which the file can grow before logging rolls over to a new file. If you plan to deploy a large number of data nodes, it is a good idea to limit the node IDs for management nodes (and API nodes) to values ...
https://dev.mysql.com/doc/refman/8.0/en/replication-solutions-performance.html
If you are using a large number of replicas connected to one source, and that source is also busy processing requests (for example, as part of a scale-out solution), then you may want to improve the performance of the replication process. If heavy ... As the number of replicas connecting to a source increases, the load, although minimal, also increases, as each replica uses a client connection to the ...
https://dev.mysql.com/doc/refman/8.0/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.0/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.0/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.0/en/alter-tablespace.html
The ADD DATAFILE variant enables you to specify an initial size for an NDB Disk Data tablespace using an INITIAL_SIZE clause, where size is measured in bytes; the default value is 134217728 (128 MB). You may optionally follow size with a one-letter ...It can be used to add a new data file to, or to drop a data file from an NDB ...
https://dev.mysql.com/doc/refman/8.0/en/channels-startup-options.html
--max-relay-log-size=size Maximum size of the individual relay log file for each channel; after reaching this limit, the file is rotated. --relay-log-space-limit=size Upper limit for the total size of all relay logs combined, for each individual ...