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/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/multiple-servers.html
If you use the following log file options, their values must differ for each server: --general_log_file=file_name --log-bin[=file_name] --slow_query_log_file=file_name --log-error[=file_name] For further discussion of log file options, see Section ...In addition to using different data directories, several other options must have different values for each server instance: --port=port_num --port controls the port number for TCP/IP ...
https://dev.mysql.com/doc/refman/8.0/en/show-engine.html
The statement has these variants: SHOW ENGINE INNODB STATUS SHOW ENGINE INNODB MUTEX SHOW ENGINE PERFORMANCE_SCHEMA STATUS SHOW ENGINE INNODB STATUS displays extensive information from the standard InnoDB Monitor about the state of the InnoDB ...
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/replication-binlog-encryption-scope.html
The data is written to a temporary file on disk if it exceeds the space available in the memory buffer. Note If you use LOAD DATA when binlog_format=STATEMENT is set, which is not recommended as the statement is considered unsafe for statement-based ...Existing binary log files and relay log files that were present on the server when you started encryption are not ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-server.html
A typical my.cnf file might look like this: [mysqld] datadir=/usr/local/mysql/var socket=/var/tmp/mysql.sock port=3306 user=mysql [mysql.server] basedir=/usr/local/mysql The mysql.server script supports the options shown in the following table. If ...To run the server as some specific user, add an appropriate user option to the [mysqld] group of the global /etc/my.cnf option file, as shown later in this ...
https://dev.mysql.com/doc/refman/8.0/en/optimize-overview.html
In practice, the advanced InnoDB performance features mean that InnoDB tables often outperform the simpler MyISAM tables, especially for a busy database. The InnoDB storage engine handles most locking issues without involvement from you, allowing ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-tcp-definition-direct.html
Setting up a cluster using direct connections between data nodes requires specifying explicitly the crossover IP addresses of the data nodes so connected in the [tcp] section of the cluster config.ini file. Note To take the best advantage of direct ...In the following example, we envision a cluster with at least four hosts, one each for a management server, an SQL node, and two data ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-system-variables.html
If the aggregate size of connection attribute data sent by a client is larger than this amount, the Performance Schema truncates the attribute data, increments the Performance_schema_session_connect_attrs_lost status variable, and writes a message ...performance_schema_error_size Command-Line Format --performance-schema-error-size=# System Variable performance_schema_error_size Scope Global Dynamic No SET_VAR Hint Applies No Type Integer Default Value number of server error codes Minimum Value 0 Maximum Value 1048576 The number of instrumented server error ...
https://dev.mysql.com/doc/refman/8.0/en/create-table-ndb-comment-options.html
Setting a value greater than 29980 raises an error; setting a value less than 1 is allowed, but causes the default inline size for the column type to be used. Using any value other than 0 or 1 results in a syntax error. Using such nonlogging tables ... NDB_COLUMN Options NDB_TABLE Options It is possible to set a number of options specific to NDB Cluster in the table comment or column comments of an NDB ...