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-ssl-rsa-setup.html
Invoke mysql_ssl_rsa_setup like this: mysql_ssl_rsa_setup [options] Typical options are --datadir to specify where to create the files, and --verbose to see the openssl commands that mysql_ssl_rsa_setup executes. If openssl is present, ...This ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-backup-parallel-data-nodes.html
For this to work, all data nodes in the cluster must use multiple LDMs, and each data node must use the same number of LDMs. This means that all data nodes must run ndbmtd (ndbd is single-threaded and thus always has only one LDM) and they must be ... It is possible in NDB 8.0 to take a backup with multiple local data managers (LDMs) acting in parallel on the data ...For information ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-limitations-disk-data.html
Disk data objects are subject to the following maximums and minimums: Maximum number of tablespaces: 232 (4294967296) Maximum number of data files per tablespace: 216 (65536) The minimum and maximum possible sizes of extents for tablespace data ...
https://dev.mysql.com/doc/refman/8.0/en/data-dictionary-usage-differences.html
Use of a data dictionary-enabled MySQL server entails some operational differences compared to a server that does not have a data dictionary: Previously, enabling the innodb_read_only system variable prevented creating and dropping tables only for ...As of MySQL 8.0, enabling innodb_read_only prevents these operations for all storage ...As of ...
https://dev.mysql.com/doc/refman/8.0/en/data-masking-component-functions.html
Return value: The masked Canada SIN as a string encoded in the utf8mb4 character set, an error if the argument is not the correct length, or NULL if str is in incorrect format or contains a multibyte character. Return value: The masked International ...mask_canada_sin(str [, mask_char]) Masks a Canada Social Insurance Number (SIN) and returns the number with all meaningful digits replaced by 'X' ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-importing-data.html
This data is most often available in one or more of the following formats: An SQL dump file such as produced by mysqldump or mysqlpump. Such files can be imported into NDB using LOAD DATA INFILE in the mysql client, or with the ndb_import utility ...
https://dev.mysql.com/doc/refman/8.0/en/error-lost-connection.html
Usually it indicates network connectivity trouble and you should check the condition of your network if this error occurs frequently. If the error message includes “during query,” this is probably the case you are experiencing. If you know that ...Sometimes the “during query” form happens when millions of rows are being sent as part of one or more ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-disk-data.html
Column data and logging metadata are kept in data files and undo log files, conceptualized as tablespaces and log file groups, as described in the next section—see Section 25.6.11.1, “NDB Cluster Disk Data Objects”. For information about these ...See the following documentation for more information: Disk Data latency parameters Section 25.6.16.31, “The ndbinfo diskstat Table” Section 25.6.16.32, “The ndbinfo diskstats_1sec Table” Section 25.6.16.49, “The ndbinfo pgman_time_track_stats ...
https://dev.mysql.com/doc/refman/8.0/en/replication-features-load-data.html
If you need to recover from a replication error involving a LOAD DATA INFILE operation logged in statement format, and the replicated event is trusted, you could grant the FILE privilege to the PRIVILEGE_CHECKS_USER account temporarily, removing it ...If you use LOAD DATA with binlog_format=STATEMENT, each replica on which the changes are to be applied creates a temporary file containing the ...
https://dev.mysql.com/doc/refman/8.0/en/data-dictionary-information-schema.html
In particular, for each INFORMATION_SCHEMA table that is a view on data dictionary tables: The server no longer must create a temporary table for each query of the INFORMATION_SCHEMA table. When the underlying data dictionary tables store values ...