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-buffer-pool-resize.html
Command line: $> mysqld --innodb-buffer-pool-chunk-size=134217728 Configuration file: [mysqld] innodb_buffer_pool_chunk_size=134217728 The following conditions apply when altering innodb_buffer_pool_chunk_size: If the new ... You can configure ...
https://dev.mysql.com/doc/refman/8.0/en/key-cache-block-size.html
It is possible to specify the size of the block buffers for an individual key cache using the key_cache_block_size variable. The best performance for I/O operations is achieved when the size of read buffers is equal to the size of the native ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-init-startup-configuration.html
The sum of file sizes must be, at a minimum, slightly larger than 12MB. The following configuration permits ibdata1 to grow to a limit of 500MB: [mysqld] innodb_data_file_path=ibdata1:12M:autoextend:max:500M A minimum file size is enforced for the ... The first decisions to make about InnoDB configuration involve the configuration of data files, log files, page size, and memory buffers, which should be configured before initializing ...
https://dev.mysql.com/doc/refman/8.0/en/data-size.html
(InnoDB compressed tables are readable and writable, while MyISAM compressed tables are read-only.) For MyISAM tables, if you do not have any variable-length columns (VARCHAR, TEXT, or BLOB columns), a fixed-size row format is used. MySQL supports ... Design your tables to minimize their space on the ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-programs-ndb-size-pl.html
ndb_size.pl can also be found in the MySQL sources in storage/ndb/tools. Note ndb_size.pl is deprecated, and no longer supported, in NDB 8.0.40 and later. Options that can be used with ndb_size.pl are shown in the following table. This is a Perl ...
https://dev.mysql.com/doc/refman/8.0/en/data-masking-component-functions.html
Example: mysql> SELECT mask_canada_sin('046-454-286'), mask_canada_sin('abcdefijk'); +--------------------------------+------------------------------+ | mask_canada_sin('046-454-286') | mask_canada_sin('abcdefijk') | ...mask_canada_sin(str [, ...
https://dev.mysql.com/doc/refman/8.0/en/server-options.html
Starting the server with --skip-host-cache does not prevent runtime changes to the value of host_cache_size, but such changes have no effect and the cache is not re-enabled even if host_cache_size is set larger than 0. --super-large-pages ...This ...
https://dev.mysql.com/doc/refman/8.0/en/converting-tables-to-innodb.html
Or if you run many consecutive INSERT statements, do a single COMMIT after all the data is loaded; if you are doing millions of INSERT statements, perhaps split up the huge transaction by issuing a COMMIT every ten thousand or hundred thousand ...
https://dev.mysql.com/doc/refman/8.0/en/replication-options-replica.html
If you need to put the relay logs in some area other than the data directory because your relay logs tend to be very large and you do not want to decrease max_relay_log_size. The setting for replica_max_allowed_packet must be larger than the ...
https://dev.mysql.com/doc/refman/8.0/en/miscellaneous-functions.html
As a result, the address value for rows within each name group is nondeterministic. GROUPING(expr [, expr] ...) For GROUP BY queries that include a WITH ROLLUP modifier, the ROLLUP operation produces super-aggregate output rows where NULL represents ...The function return value and type are the same as the return value and type of its argument, but the function result is not checked for the ONLY_FULL_GROUP_BY SQL ...