Search Results
https://dev.mysql.com/doc/refman/8.4/en/repair-table.html
REPAIR TABLE Storage Engine and Partitioning Support REPAIR TABLE Options REPAIR TABLE Output Table Repair Considerations REPAIR TABLE Storage Engine and Partitioning Support REPAIR TABLE works for MyISAM, ARCHIVE, and CSV tables. However, the ...
https://dev.mysql.com/doc/refman/8.4/en/select.html
[into_option] [FROM table_references [PARTITION partition_list]] [WHERE where_condition] [GROUP BY [ {col_name | expr | position}, ... SELECT supports explicit partition selection using the PARTITION clause with a list of partitions or subpartitions ... SELECT [ALL | DISTINCT | DISTINCTROW ] [HIGH_PRIORITY] [STRAIGHT_JOIN] [SQL_SMALL_RESULT] [SQL_BIG_RESULT] [SQL_BUFFER_RESULT] [SQL_NO_CACHE] [SQL_CALC_FOUND_ROWS] select_expr [, select_expr] ...
https://dev.mysql.com/doc/refman/8.4/en/sql-mode.html
To determine the current global or session sql_mode setting, select its value: SELECT @@GLOBAL.sql_mode; SELECT @@SESSION.sql_mode; Important SQL mode and user-defined partitioning. Changing the server SQL mode after creating and inserting data into ... The MySQL server can operate in different SQL modes, and can apply these modes differently for different clients, depending on the value of the sql_mode system ...
https://dev.mysql.com/doc/relnotes/mysql/8.4/en/news-8-4-0.html
(Bug #36337893) Partitioning: Silent omission of columns with index prefixes as part of a table's partitioning key was deprecated in MySQL 8.0.21, and generated a warning. In this release, the use of any such columns in the proposed partitioning key ...(Bug #36301441) Audit log filtering by type, using error as the type, did not work ...
https://dev.mysql.com/doc/ndbapi/en/overview-selecting-tc.html
This is done by providing a table and a partition key (usually the primary key). If the primary key is the partition key, then the transaction is placed on the node where the primary fragment replica of that record resides. The application ... The ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-lakehouse-load-event-based.html
It is typically sufficient to set up streams with only one partition. You should set up a stream with multiple partitions when you plan to do many object operations that should be incrementally loaded automatically through events. Lakehouse reads at ... As of MySQL 9.4.1, you can load data from Object Storage by using event-based incremental ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-rpd-tables-table.html
LOGICAL_PARTS_LOADED_AT_SCN For partitioned tables, contains an array of JSON objects, each corresponding to a loaded partition. For each partition, the following values are stored: id: the id of the partition in InnoDB. load_scn: the system change ... The rpd_tables table provides the system change number (SCN) and load pool type for tables loaded in MySQL ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-secondary-load.html
ALTER TABLE table_name SECONDARY_LOAD [PARTITION (...)] [GUIDED {ON | OFF}]; Specify the following clauses in the ALTER TABLE statement: table_name: Specify the name of the table to load to MySQL HeatWave. mysql> ALTER TABLE airport_geo ... You can ...
https://dev.mysql.com/doc/refman/8.4/en/built-in-function-reference.html
The following table lists each built-in (native) function and operator and provides a short description of each one. For a table listing functions that are loadable at runtime, see Section 14.2, “Loadable Function Reference”. ->> Return value ...
https://dev.mysql.com/doc/refman/8.4/en/create-index.html
CREATE [UNIQUE | FULLTEXT | SPATIAL] INDEX index_name [index_type] ON tbl_name (key_part,...) [index_option] [algorithm_option | lock_option] ... This guideline is especially important for InnoDB tables, where the primary key determines the ...