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/windows-start-service.html
The error log is located in the MySQL data directory (for example, C:\Program Files\MySQL\MySQL Server 8.0\data). Note On Windows, if the server is started with the --defaults-file and --install options, --install must be first. Install the server ... On Windows, the recommended way to run MySQL is to install it as a Windows service, so that MySQL starts and stops automatically when Windows starts and ...
https://dev.mysql.com/doc/refman/8.0/en/fido-pluggable-authentication.html
The file must be located in the directory named by the plugin_dir system variable. Table 8.27 Plugin and Library Names for FIDO Authentication Plugin or File Plugin or File Name Server-side plugin authentication_fido Client-side plugin ...The file ... Note FIDO pluggable authentication is an extension included in MySQL Enterprise Edition, a commercial ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-install-linux-source.html
(This assumes that all data node hosts use the same architecture and operating system; otherwise you may need to compile separately for each different platform.) The data node binary need not be in any particular location on the host's file system, ...The archived source file should have a name similar to ... This section provides information about ...For ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-programs-ndb-drop-index.html
Usage ndb_drop_index -c connection_string table_name index -d db_name The statement shown above drops the index named index from the table in the database. --core-file Command-Line Format --core-file Removed 8.0.31 Write core file on error; used in ...It is recommended that you use this utility only as an example for writing NDB API applications—see the Warning later in this section for ...--connect-retries ...
https://dev.mysql.com/doc/refman/8.0/en/dynamic-system-variables.html
This differs from the ENUM data type used for table columns, for which the first enumeration value corresponds to 1. For a description of the privilege requirements for setting system variables, see Section 7.1.9.1, “System Variable Privileges” ... Many server system variables are dynamic and can be set at ...
https://dev.mysql.com/doc/refman/8.0/en/replication-gtids-auto-positioning.html
GTIDs replace the file-offset pairs previously required to determine points for starting, stopping, or resuming the flow of data between source and replica. The alternative SOURCE_LOG_FILE | MASTER_LOG_FILE and SOURCE_LOG_POS | MASTER_LOG_POS ...To ...For full instructions to configure and start sources and replicas using GTID-based replication, see Section 19.1.3.4, “Setting Up Replication Using ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-installation.html
In NDB 8.0.21 and earlier releases, all network addresses used for connections to or from data and management nodes must use or be resolvable using IPv4, including addresses used by SQL nodes to contact the other nodes. Whereas the examples in ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-installer-setup.html
MySQL Installer Configuration Files All MySQL Installer files are located within the C:\Program Files (x86) and C:\ProgramData folders. C:\ProgramData\MySQL\MySQL Installer for Windows\Manifest package-rules.xml This file contains the prerequisites ... Choosing a Setup Type Path Conflicts Check Requirements MySQL Installer Configuration Files When you download MySQL Installer for the first time, a setup wizard guides you through the initial installation of MySQL ...
https://dev.mysql.com/doc/refman/8.0/en/optimize-table.html
Use OPTIMIZE TABLE in these cases, depending on the type of table: After doing substantial insert, update, or delete operations on an InnoDB table that has its own .ibd file because it was created with the innodb_file_per_table option enabled. You ...OPTIMIZE TABLE reorganizes the physical storage of table data and associated index data, to reduce storage space and improve I/O efficiency when accessing the ...After deleting a large part of a ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-ndbinfo-nodes.html
config_generation The version of the cluster configuration file in use on this data node. This table contains information on the status of data nodes. For each data node that is running in the cluster, a corresponding row in this table provides the ...For nodes that are starting, it also shows the current start ...This is one of: NOTHING, CMVMI, STARTING, ...