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/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/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/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/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/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/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/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/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/performance-schema-status-variables.html
This can be nonzero if the value of performance_schema_digests_size is too small. If this value is larger than performance_schema_session_connect_attrs_size, DBAs may wish to increase the latter value, or, alternatively, investigate which clients ...
https://dev.mysql.com/doc/refman/8.0/en/server-status-variables.html
If Key_reads is large, then your key_buffer_size value is probably too small. If the CRL file is large, the server allocates a large chunk of memory (ten times the file size), which is doubled while the new instance is being loaded and the old one ...Binlog_cache_disk_use The number of transactions that used the temporary binary log cache but that exceeded the value of binlog_cache_size and used a temporary file to store statements from the ...