Search Results
https://dev.mysql.com/doc/refman/8.4/en/information-schema-innodb-ft-default-stopword-table.html
The INNODB_FT_DEFAULT_STOPWORD table holds a list of stopwords that are used by default when creating a FULLTEXT index on InnoDB tables. For information about the default InnoDB stopword list and how to define your own stopword lists, see Section ...This is not used if you override the default stopword processing with either the innodb_ft_server_stopword_table or the innodb_ft_user_stopword_table system ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-innodb-indexes-table.html
0 = nonunique secondary index; 1 = automatically generated clustered index (GEN_CLUST_INDEX); 2 = unique nonclustered index; 3 = clustered index; 32 = full-text index; 64 = spatial index; 128 = secondary index on a virtual generated column. For ...
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 ...