Search Results
https://dev.mysql.com/doc/refman/8.4/en/memory-storage-engine.html
Support for variable-length data types (including BLOB and TEXT) not supported by MEMORY. The MEMORY storage engine (formerly known as HEAP) creates special-purpose tables with contents that are stored in memory. Because the data is vulnerable to ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-install-configuration.html
The configuration file should be located in the /etc directory and can be edited using any text editor. (Create the file if it does not exist.) For example: $> vi /etc/my.cnf Note We show vi being used here to create the file, but any text editor ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-limitations-syntax.html
You cannot create indexes on NDB table columns that use any of the TEXT or BLOB data types. The NDB storage engine does not support FULLTEXT indexes, which are possible for MyISAM and InnoDB tables only. ON DELETE CASCADE is also not supported where ... Some SQL statements relating to certain MySQL features produce errors when used with NDB tables, as described in the following list: Temporary ...
https://dev.mysql.com/doc/refman/8.4/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.4/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.4/en/mysql-cluster-programs-ndb-config.html
The dump can be produced in either text or XML format; for more information, see the discussion of the --configinfo and --xml options later in this section). This tool extracts current configuration information for data nodes, SQL nodes, and API ...
https://dev.mysql.com/doc/refman/8.4/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.4/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.4/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.4/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 ...