Search Results
https://dev.mysql.com/doc/refman/8.4/en/innodb-information-schema-fulltext_index-tables.html
INNODB_FT_DEFAULT_STOPWORD: Holds a list of stopwords that are used by default when creating a FULLTEXT index on InnoDB tables. use_stopword: Indicates whether a stopword table is used, which is defined when the FULLTEXT index is created.
https://dev.mysql.com/doc/heatwave/en/mys-hw-tpch-quickstart.html
This quickstart contains the following sections: tpch Requirements Generate tpch Sample Data Create the tpch Sample Database and Import Data Load tpch Data Into MySQL HeatWave Run tpch Queries Additional tpch Queries Unload tpch Tables tpch ... The ...We recommend that you always run the latest version of MySQL Shell, which is currently MySQL version ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-rpd-tables-table.html
The rpd_tables table provides the system change number (SCN) and load pool type for tables loaded in MySQL HeatWave. The rpd_tables table has these columns: ID A unique identifier for the table. The SCN is an internal number that represents a point ...As of MySQL 9.2.1, the possible values are SNAPSHOT and ...
https://dev.mysql.com/doc/refman/8.4/en/mysqlcheck.html
The mysqlcheck client performs table maintenance: It checks, repairs, optimizes, or analyzes tables. Each table is locked and therefore unavailable to other sessions while it is being processed, although for check operations, the table is locked ...
https://dev.mysql.com/doc/refman/8.4/en/myisamchk-table-info.html
To obtain a description of a MyISAM table or statistics about it, use the commands shown here. myisamchk -d tbl_name Runs myisamchk in “describe mode” to produce a description of your table. If you start the MySQL server with external locking ...The output from these commands is explained later in this ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-programs-ndb-desc.html
Three of the table properties that can be set using NDB_TABLE comments embedded in CREATE TABLE and ALTER TABLE statements are also visible in ndb_desc output. You can check that the ALTER TABLE statement has the desired effect using SHOW CREATE ...
https://dev.mysql.com/doc/refman/8.4/en/derived-tables.html
The JSON_TABLE() function generates a table and provides another way to create a derived table: SELECT * FROM JSON_TABLE(arg_list) [AS] tbl_name ... For information about lateral derived tables preceded by the LATERAL keyword, see Section 15.2.15.9, ...This does not work: SELECT AVG(SUM(column1)) FROM t1 GROUP BY column1; However, this query provides the desired information: SELECT AVG(sum_column1) FROM (SELECT SUM(column1) AS sum_column1 FROM t1 GROUP BY column1) AS t1; Notice that the column name used within the subquery (sum_column1) is recognized in the outer ...
https://dev.mysql.com/doc/mysql-monitor/8.0/en/glossary.html
Includes not just SQL SELECT queries, but also DML statements such as INSERT, UPDATE, and DELETE, and DDL statements such as CREATE TABLE and TRUNCATE TABLE. Based on your organization's particular needs, you may create or adapt custom advisors.
https://dev.mysql.com/doc/refman/8.4/en/information-schema-innodb-tables-table.html
Tables assigned to the system tablespace using CREATE TABLE or ALTER TABLE TABLESPACE=innodb_system have a SPACE_TYPE of General. For related usage information and examples, see Section 17.15.3, “InnoDB INFORMATION_SCHEMA Schema Object Tables”.
https://dev.mysql.com/doc/refman/8.4/en/merge-table-advantages.html
For example, you can put data from different months into separate tables, compress some of them with myisampack, and then create a MERGE table to use them as one. As a result, MERGE table collections are very fast to create or remap. (You must still ... MERGE tables can help you solve the following problems: Easily manage a set of log ...