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-optimization.html
InnoDB maintains a storage area called the buffer pool for caching data and indexes in memory. Knowing how the InnoDB buffer pool works, and taking advantage of it to keep frequently accessed data in memory, is an important aspect of MySQL tuning.
https://dev.mysql.com/doc/refman/8.0/en/innodb-memcached-dml.html
Benchmarks suggest that the daemon_memcached plugin speeds up DML operations (inserts, updates, and deletes) more than it speeds up queries. INSERT becomes add, UPDATE becomes set, incr or decr, and DELETE becomes delete. Therefore, consider ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-truncate-table-reclaim-space.html
Additionally, there cannot be a foreign key constraint between the table being truncated and other tables, otherwise the TRUNCATE TABLE operation fails. When a table is truncated, it is dropped and re-created in a new .ibd file, and the freed space ... To reclaim operating system disk space when truncating an InnoDB table, the table must be stored in its own .ibd ...
https://dev.mysql.com/doc/refman/8.0/en/ipv6-local-connections.html
For example, put the following lines in the server option file and restart the server: [mysqld] bind_address = * Specifying * (or ::) as the value for bind_address permits both IPv4 and IPv6 connections on all server host IPv4 and IPv6 interfaces.
https://dev.mysql.com/doc/refman/8.0/en/json-function-reference.html
->> Return value from JSON column after evaluating path and unquoting the result; equivalent to JSON_UNQUOTE(JSON_EXTRACT()). You can see how much storage space a given JSON value takes up, and how much space remains for additional storage, using ...
https://dev.mysql.com/doc/refman/8.0/en/keyring-component-plugin-comparison.html
This section briefly compares keyring components and plugins to provide an overview of their differences. Keyring components have fewer restrictions than keyring plugins with respect to key types and lengths. The sensitive data that can be protected ... The MySQL Keyring originally implemented keystore capabilities using server plugins, but began transitioning to use the component infrastructure in MySQL ...
https://dev.mysql.com/doc/refman/8.0/en/keyring-file-plugin.html
As of MySQL 8.0.34, this plugin is deprecated and subject to removal in a future release of MySQL. Security standards such as PCI, FIPS, and others require use of key management systems to secure, manage, and protect encryption keys in key vaults or ... The keyring_file keyring plugin stores keyring data in a file local to the server ...
https://dev.mysql.com/doc/refman/8.0/en/load-index.html
When preloading indexes for multiple partitions, the partitions need not be contiguous, and you need not list their names in any particular order. To determine index block sizes for a table, use myisamchk -dv and check the Blocksize column.
https://dev.mysql.com/doc/refman/8.0/en/loadable-function-reference.html
The following table lists each function that is loadable at runtime and provides a short description of each one. For a table listing built-in functions and operators, see Section 14.1, “Built-In Function and Operator Reference” For general ...
https://dev.mysql.com/doc/refman/8.0/en/multiple-windows-command-line-servers.html
The procedure for starting a single MySQL server manually from the command line is described in Section 2.3.4.6, “Starting MySQL from the Windows Command Line”. To start multiple servers this way, you can specify the appropriate options on the ...It is more convenient to place the options in an option file, but it is necessary to make sure that each server gets its own set of ...