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/group-replication-system-variables.html
The debug information is stored in the GCS_DEBUG_TRACE file in the data directory. If you use a host name, you must use a fully qualified name, and ensure it is resolvable through DNS, correctly configured /etc/hosts files, or other name resolution ...Note InnoDB Cluster uses Group Replication, but the default values of the Group Replication system variables may differ from the defaults documented in this ...Some system variables on a ...
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/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/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/keyring-key-migration.html
For example, if keyring_file is the source or destination, you must set the keyring_file_data system variable if the keyring data file location is not the default location. The user a server in key-migration mode runs as must have permission to read ...This means that --defaults-file must not point to the same options file that is used to start the running server if it cantains a line such as ...
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 ...Table 8.24 Plugin and Library Names for Kerberos Authentication Plugin or File Plugin or File Name Server-side plugin authentication_kerberos Client-side plugin authentication_kerberos_client Library file authentication_kerberos.so, authentication_kerberos_client.so The ...
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/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/upgrading-what-is-upgraded.html
With --upgrade=NONE, the server upgrades nothing (skips steps 1 and 2), but also exits with an error if the data dictionary must be upgraded. If both versions indicate an upgrade is needed, the data dictionary upgrade must occur first. If the server ...System tables (that is, the remaining non-data dictionary tables), which are used for other operational ... Installing a new version of MySQL may require upgrading these parts of the existing installation: The mysql system schema, which contains tables ...