Search Results
https://dev.mysql.com/doc/refman/9.7/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/refman/9.7/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/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/9.7/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/9.7/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/9.7/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 ...
https://dev.mysql.com/doc/refman/9.7/en/mysql-cluster-ndbinfo-cluster-operations.html
The cluster_operations table provides a per-operation (stateful primary key op) view of all activity in the NDB Cluster from the point of view of the local data management (LQH) blocks (see The DBLQH Block). (If the MySQL Server is running with ...
https://dev.mysql.com/doc/refman/9.7/en/mysql-cluster-ndbinfo-cluster-transactions.html
The cluster_transactions table shows information about all ongoing transactions in an NDB Cluster. Together with the block name, this number can be used to look up a given instance in the threadblocks table. You can use this along with the block ...