Search Results
https://dev.mysql.com/doc/refman/8.4/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.4/en/mysql-cluster-shm-definition.html
See Section 25.4.3.14, “Configuring NDB Cluster Send Buffer Parameters”, and Section 25.6.15.66, “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.4/en/mysql-cluster-upgrade-downgrade.html
Some of the reasons for this are listed here: DDL statements on NDB tables are not possible during some phases of data node startup. DDL statements on NDB tables may be rejected if any data nodes are stopped during execution; stopping each data node ... Versions Supported for Upgrade to NDB 8.4 Known Issues When Upgrading or Downgrading NDB Cluster This section provides information about NDB Cluster software and compatibility between different NDB Cluster releases with regard to performing upgrades and ...
https://dev.mysql.com/doc/refman/8.4/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.4/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.4/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 default setting is calculated ...
https://dev.mysql.com/doc/refman/8.4/en/optimizing-innodb-transaction-management.html
When rows are modified or deleted within a long-running transaction, other transactions using the READ COMMITTED and REPEATABLE READ isolation levels have to do more work to reconstruct the older data if they read those same rows. When a ... To ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-build-configuration.html
If you install MySQL over a previous installation that was configured without the Performance Schema (or with an older version of the Performance Schema that has missing or out-of-date tables). One indication of this issue is the presence of ...It ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-status-monitoring.html
When the server cannot create a mutex instrument, these results occur: No row for the instrument is inserted into the setup_instruments table. However, the content of the tables in the performance_schema database misses events. For example, ...Names ...
https://dev.mysql.com/doc/refman/8.4/en/postinstallation.html
This section discusses tasks that you should perform after installing MySQL: If necessary, initialize the data directory and create the MySQL grant tables. Assign passwords to the initial root account in the grant tables, if that was not already ...