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/mysql-cluster-programs-ndb-restore.html
Afterwards, you can restore indexes for all tables at once with multithreaded building of indexes using --rebuild-indexes, which should be faster than rebuilding indexes concurrently for very large tables. Because some applications may set values ...
https://dev.mysql.com/doc/refman/8.0/en/myisamchk.html
The myisamchk utility gets information about your database tables or checks, repairs, or optimizes them. myisamchk works with MyISAM tables (tables that have .MYD and .MYI files for storing data and indexes). You can also use the CHECK TABLE and ...
https://dev.mysql.com/doc/refman/8.0/en/aggregate-functions.html
If you use an aggregate function in a statement containing no GROUP BY clause, it is equivalent to grouping on all rows. In MySQL 8.0, bit functions and operators permit binary string type arguments (BINARY, VARBINARY, and the BLOB types) and return ... This section describes aggregate functions that operate on sets of ...
https://dev.mysql.com/doc/refman/8.0/en/myisamchk-general-options.html
key_buffer_size is used when you are checking the table with --extend-check or when the keys are repaired by inserting keys row by row into the table (like when doing normal inserts). This is often the case when you have large key values for CHAR, ... The options described in this section can be used for any type of table maintenance operation performed by ...
https://dev.mysql.com/doc/refman/8.0/en/enterprise-encryption-installation.html
To install the component, issue an INSTALL COMPONENT statement: INSTALL COMPONENT "file://component_enterprise_encryption"; INSTALL COMPONENT requires the INSERT privilege for the mysql.component system table because it adds a row to that table to ... In releases before MySQL 8.0.30, the functions provided by MySQL Enterprise Encryption are installed by creating them individually, based on the openssl_udf shared ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-performance-xcom-cache.html
From MySQL 8.0.16, a cache size limit can be set for XCom's message cache using the group_replication_message_cache_size system variable. If the cache size limit is reached, XCom removes the oldest entries that have been decided and delivered. The ... The group communication engine for Group Replication (XCom, a Paxos variant) includes a cache for messages (and their metadata) exchanged between the group members as a part of the consensus ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-programs-ndbxfrm.html
--detailed-info Command-Line Format --encrypt-block-size=# Type Boolean Default Value FALSE Print out file information like --info, but include the file's header and trailer. The ndbxfrm utility, introduced in NDB 8.0.22, can be used to decompress, ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-tcp-definition.html
(NDB 8.0.13) Specifies the size of the buffer used when receiving data from the TCP/IP socket. The default size of the send buffer is 2MB, which is the size recommended in most situations. The minimum size is 64 KB; the theoretical maximum is 4 GB.
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 ...