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/kerberos-pluggable-authentication.html
For example: [mysqld] authentication_kerberos_service_key_tab=/var/mysql/data/mysql.keytab If the keytab file is not in the correct place or does not contain a valid SPN key, the MySQL server does not validate this, but clients return authentication ...The file must be located in the directory named by the plugin_dir system ...MySQL Router supports the use of an ...It is useful in ...
https://dev.mysql.com/doc/refman/8.0/en/mysqld-multi.html
The Unix socket file and the TCP/IP port number must be different for every mysqld. mysqld_multi searches for groups named [mysqldN] in my.cnf (or in the file named by the --defaults-file option). (See, for example, Section 2.9.5, “Starting and ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-nodes-groups.html
Note All node groups in an NDB Cluster must have the same number of data nodes. This section discusses the manner in which NDB Cluster divides and duplicates data for storage. It is common for the terms “node” and “data node” to be used ...
https://dev.mysql.com/doc/refman/8.0/en/clone-plugin-options-variables.html
The delay is intended to provide enough time for the file system on the recipient host to free space before data is cloned from the donor MySQL Server instance. On these file systems, cloning data too soon after dropping existing data can result in ...In this case, the server may also produce error messages for other clone settings because it does not recognize ...
https://dev.mysql.com/doc/refman/8.0/en/docker-mysql-getting-started.html
In the File Download dialogue box that appears, click and download the .zip file for the Docker image. Because the MYSQL_ONETIME_PASSWORD option is true by default, after you have connected a mysql client to the server, you must reset the server ...
https://dev.mysql.com/doc/refman/8.0/en/memory-storage-engine.html
Loading Data To populate a MEMORY table when the MySQL server starts, you can use the init_file system variable. SELECT or LOAD DATA into a file to load the table from a persistent data source, and use init_file to name the file. Because the data is ... The MEMORY storage engine (formerly known as HEAP) creates special-purpose tables with contents that are stored in ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-config-starting.html
NoOfFragmentLogFiles=300 DataDir=path/to/data/node/data/directory MaxNoOfConcurrentOperations=100000 SchedulerSpinTimer=400 SchedulerExecutionTimer=100 RealTimeScheduler=1 # Setting these parameters allows you to take advantage of real-time ...For ...# It is also possible (but not required) in NDB 8.0 to use more than two # fragment replicas, although two fragment replicas are sufficient to provide # high ...
https://dev.mysql.com/doc/refman/8.0/en/upgrade-binary-package.html
In this case, you should remove all redo log files, start your MySQL 5.7 server on the same data directory, and fix the cause of any errors. For example: mysqld_safe --user=mysql --datadir=/path/to/existing-datadir & If there are encrypted InnoDB ...
https://dev.mysql.com/doc/refman/8.0/en/system-schema.html
mysql system tables and data dictionary tables reside in a single InnoDB tablespace file named mysql.ibd in the MySQL data directory. Data dictionary tables and system tables use the InnoDB storage engine unless otherwise indicated. Previously, ...A ...It contains tables that store information required by the MySQL server as it ...For more information, see Chapter 3, ...
https://dev.mysql.com/doc/refman/8.0/en/persisted-system-variables.html
SET can also be used to persist certain global system variables to the mysqld-auto.cnf file in the data directory, to affect server operation for subsequent startups. To augment administrative capabilities for server configuration beyond what is ...