Search Results
https://dev.mysql.com/doc/refman/8.4/en/partitioning-management-range-list.html
For information about working with tables that are partitioned by hash or key, see Section 26.3.2, “Management of HASH and KEY Partitions”. Dropping a partition from a table that is partitioned by either RANGE or by LIST can be accomplished ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-ndbinfo-transporters.html
Notes For each running data node in the cluster, the transporters table displays a row showing the status of each of that node's connections with all nodes in the cluster, including itself. This information is shown in the table's status column, ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-lakehouse-limitations-delta.html
MySQL HeatWave Lakehouse has the following limitations for delta lake tables. Loading delta lake tables is only supported in MySQL HeatWave on OCI. Support for delta lake tables is restricted to delta tables with features enabled by default by a ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-secondary-load.html
You can load tables into HeatWave using the SECONDARY_LOAD clause. Loading Tables Statement To load a table into MySQL HeatWave, specify the SECONDARY_LOAD clause in an ALTER TABLE statement and use the following syntax. ALTER TABLE table_name ...
https://dev.mysql.com/doc/refman/8.4/en/static-format.html
It is used when the table contains no variable-length columns (VARCHAR, VARBINARY, BLOB, or TEXT). Also, when scanning a table, it is very easy to read a constant number of rows with each disk read operation. MyISAM table indexes can always be ...Of ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-ndbinfo-server-transactions.html
The server_transactions table is subset of the cluster_transactions table, but includes only those transactions in which the current SQL node (MySQL Server) is a participant, while including the relevant connection IDs. Together with the block ...
https://dev.mysql.com/doc/refman/8.4/en/partitioning-limitations.html
Tables employing user-defined partitioning do not preserve the SQL mode in effect at the time that they were created. Therefore, a change in the SQL mode at any time after the creation of partitioned tables may lead to major changes in the behavior ... This section discusses current restrictions and limitations on MySQL partitioning ...
https://dev.mysql.com/doc/refman/8.4/en/reproducible-test-case.html
For information about steps to take when encountering InnoDB table corruption, see Section 1.6, “How to Report Bugs or Problems”. If you encounter corrupted MyISAM tables or if mysqld always fails after some update statements, you can test ...
https://dev.mysql.com/doc/refman/8.4/en/sys-innodb-buffer-stats-by-table.html
These views summarize the information in the INFORMATION_SCHEMA INNODB_BUFFER_PAGE table, grouped by schema and table. Warning Querying views that access the INNODB_BUFFER_PAGE table can affect performance. Do not query these views on a production ...To avoid impacting performance on a production system, reproduce the issue you want to investigate and query buffer pool statistics on a test ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-lakehouse-key-partitioning.html
As of MySQL 9.6.1, you can specify the PARTITION BY KEY option in the CREATE EXTERNAL TABLE statement. Before You Begin Review how to Create an External Table Manually. Once MySQL HeatWave Lakehouse loads a table, you cannot modify the partitioning. mysql> CREATE EXTERNAL TABLE table_1 ( col_1 int, col_2 int, _metadata_filename varchar(1024) ) FILE_FORMAT = (FORMAT csv) FILES = (URI = 'oci://mybucket@mynamespace/data_files/data_file_[1-3].csv') PARTITION BY KEY (_metadata_filename); The following example uses a generated column over the metadata ...