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-ndbinfo-memoryusage.html
used_pages Number of pages currently used for data memory or index memory by this data node; see text. total Total number of bytes of data memory or index memory available for this data node; see text. total_pages Total number of memory pages ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-ndbinfo.html
ndbinfo is a database containing information specific to NDB Cluster. This database contains a number of tables, each providing a different sort of data about NDB Cluster node status, resource usage, and operations. You can find more detailed ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-options-variables.html
Allowing batched updates on the replica greatly improves performance, particularly when replicating TEXT, BLOB, and JSON columns. Allowing batched updates on the replica greatly improves performance, particularly when replicating TEXT, BLOB, and ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-replication-conflict-resolution.html
Note If you are replicating tables with very large columns (such as TEXT or BLOB columns), --ndb-log-updated-only can also be useful for reducing the size of the binary logs and avoiding possible replication failures due to exceeding ...
https://dev.mysql.com/doc/refman/8.0/en/mysqldump.html
The mysqldump command can also generate output in CSV, other delimited text, or XML format. --enable-cleartext-plugin Command-Line Format --enable-cleartext-plugin Type Boolean Default Value FALSE Enable the mysql_clear_password cleartext ... The ...
https://dev.mysql.com/doc/refman/8.0/en/optimize-numeric.html
If you are using numeric data, it is faster in many cases to access information from a database (using a live connection) than to access a text file. Information in the database is likely to be stored in a more compact format than in the text file, ... For unique IDs or other values that can be represented as either strings or numbers, prefer numeric columns to string ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-statement-tables.html
SQL statements are expressed as text, such as DELETE FROM t1 or SELECT * FROM t2. If the request is a statement, the statement text is read and given to the parser. For a request read as a statement from the relay log on a replica: Statements in the ...Statement events occur at a high level of the event ...
https://dev.mysql.com/doc/refman/8.0/en/replication-features-differing-tables.html
Between any of the string types CHAR, VARCHAR, and TEXT, including conversions between different widths. Conversion of a CHAR, VARCHAR, or TEXT to a CHAR, VARCHAR, or TEXT column the same size or larger is never lossy. Source and target tables for ...
https://dev.mysql.com/doc/refman/8.0/en/signal.html
If pval is 1, p() signals an error and sets the MESSAGE_TEXT condition information item. The error terminates the procedure, and the text is returned with the error information. If pval is anything else, p() first signals a warning and sets the ...
https://dev.mysql.com/doc/refman/8.0/en/silent-column-changes.html
If strict SQL mode is not enabled, a VARCHAR column with a length specification greater than 65535 is converted to TEXT, and a VARBINARY column with a length specification greater than 65535 is converted to BLOB. Specifying the CHARACTER SET binary ... In some cases, MySQL silently changes column specifications from those given in a CREATE TABLE or ALTER TABLE ...