Search Results
https://dev.mysql.com/doc/refman/8.4/en/monitor-mysql-memory-use.html
The following example demonstrates how to use Performance Schema and sys schema to monitor MySQL memory usage. Instruments can be enabled by updating the ENABLED column of the Performance Schema setup_instruments table. Memory instruments have ...
https://dev.mysql.com/doc/refman/8.4/en/multifactor-authentication.html
The server invokes authentication plugins in the order listed in the account definition. Authentication involves one party establishing its identity to the satisfaction of a second party. Multifactor authentication (MFA) is the use of multiple ...
https://dev.mysql.com/doc/refman/8.4/en/multiple-column-indexes.html
If you specify the columns in the right order in the index definition, a single composite index can speed up several kinds of queries on the same table. MySQL can create composite indexes (that is, indexes on multiple columns). For certain data ...
https://dev.mysql.com/doc/refman/8.4/en/myisam-ftdump.html
It reads the MyISAM index file directly, so it must be run on the server host where the table is located. Before using myisam_ftdump, be sure to issue a FLUSH TABLES statement first if the server is running. myisam_ftdump scans and dumps the entire ...
https://dev.mysql.com/doc/refman/8.4/en/myisam-key-cache.html
To make this choice easier, the key cache module maintains all used blocks in a special list (LRU chain) ordered by time of use. To minimize disk I/O, the MyISAM storage engine exploits a strategy that is used by many database management systems.
https://dev.mysql.com/doc/refman/8.4/en/mysql-batch-commands.html
mysql ignores Unicode byte order mark (BOM) characters at the beginning of input files. The mysql client typically is used interactively, like this: mysql db_name However, it is also possible to put your SQL statements in a file and then tell mysql ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-config-file.html
Cache files are numbered sequentially using seq_id, in the order in which they are created. Configuring NDB Cluster requires working with two files: my.cnf: Specifies options for all NDB Cluster executables. This file, with which you should be ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-connection-strings.html
An NDB Cluster data or API node attempts to contact successive management servers on each host in the order specified, until a successful connection has been established. With the exception of the NDB Cluster management server (ndb_mgmd), each node ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-data-node-memory-management.html
DataMemory is where records are stored, including hash indexes (approximately 15 bytes per row), ordered indexes (10-12 bytes per row per index), and row headers (16-32 bytes per row). All memory allocation for a data node is performed when the ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-importing-data.html
It is common when setting up a new instance of NDB Cluster to need to import data from an existing NDB Cluster, instance of MySQL, or other source. This data is most often available in one or more of the following formats: An SQL dump file such as ...