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/mysql-cluster-replication-backups.html
This section discusses making backups and restoring from them using NDB Cluster replication. We assume that the replication servers have already been configured as covered previously (see Section 25.7.5, “Preparing the NDB Cluster for ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-replication-multi-source.html
This does not automatically create binary logs on the second NDB Cluster's SQL node acting as the replica; in order to cause the binary logs to be created, you must issue a SHOW TABLES statement on that SQL node; this should be done prior to running ... It is possible to use NDB Cluster for bidirectional replication between two clusters, as well as for circular replication between any number of ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-security-networking-issues.html
Any traffic other than that shown in the table for a given node type should be denied. iptables is a very common and reliable firewall application, which is often used with APF as a front end to make configuration easier. In this section, we ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-shm-definition.html
See Section 25.4.3.14, “Configuring NDB Cluster Send Buffer Parameters”, and Section 25.6.16.65, “The ndbinfo transporters Table”, for more information. Communications between NDB cluster nodes are normally handled using TCP/IP. The shared ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-server-side-help.html
The proper operation of this command requires that the help tables in the mysql database be initialized with help topic information (see Section 7.1.17, “Server-Side Help Support”). To make a more specific request, please type 'help <item>', ...
https://dev.mysql.com/doc/refman/8.0/en/mysqld-safe.html
mysqld_safe accepts options on the command line and in option files, as described in the following table. mysqld_safe is the recommended way to start a mysqld server on Unix. mysqld_safe adds some safety features such as restarting the server when ...
https://dev.mysql.com/doc/refman/8.0/en/mysqldump-sql-format.html
Without this option, mysqldump treats the first name as a database name and those following as table names. This section describes how to use mysqldump to create SQL-format dump files. For information about reloading such dump files, see Section ...
https://dev.mysql.com/doc/refman/8.0/en/not-enough-file-handles.html
To tell mysqld to keep open fewer files at a time, you can make the table cache smaller by reducing the value of the table_open_cache system variable (the default value is 64). This may not entirely prevent running out of file descriptors because in ... If you get ERROR 'file_name' not found (errno: 23), Can't open file: file_name (errno: 24), or any other error with errno 23 or errno 24 from MySQL, it means that you have not allocated enough file descriptors for the MySQL ...
https://dev.mysql.com/doc/refman/8.0/en/online-ddl-parallel-thread-configuration.html
Parallel scan is not supported on tables defined with virtual columns. Parallel scan is not supported on tables defined with a full-text index. Parallel scan is not supported on tables defined with a spatial index. The maximum setting is 256, which ...
https://dev.mysql.com/doc/refman/8.0/en/optimizing-innodb-transaction-management.html
Alternatively, for transactions that consist only of a single SELECT statement, turning on AUTOCOMMIT helps InnoDB to recognize read-only transactions and optimize them. When rows are modified or deleted within a long-running transaction, other ...