Search Results
https://dev.mysql.com/doc/internals/en/the-myi-file.html
A .MYI file for a MyISAM table contains the table's indexes. In MySQL terminology, a "key" is something that you create with CREATE [UNIQUE] INDEX. Program files which read and write .MYI headers are in the ./myisam directory: mi_open.c has the ...
https://dev.mysql.com/doc/refman/8.4/en/optimizing-innodb-ddl-operations.html
Many DDL operations on tables and indexes (CREATE, ALTER, and DROP statements) can be performed online. Online DDL support for adding secondary indexes means that you can generally speed up the process of creating and loading a table and associated ...Use TRUNCATE TABLE to empty a table, not DELETE FROM ...
https://dev.mysql.com/doc/relnotes/mysql-cluster/8.4/en/news-8-4-4.html
ndbinfo Information Database: At table create and drop time, access of ndbinfo tables such as operations_per_fragment and memory_per_fragment sometimes examined data which was not valid. To fix this, during scans of these ndbinfo tables, we ignore ...(Bug #37049014) Bugs Fixed Microsoft Windows: Successive iterations of the sequence ndb_sign_keys --create-key followed by ndb_sign_keys --promote were unsuccessful on ... MySQL NDB Cluster 8.4.4 is a new LTS release of NDB ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-limitations-database-objects.html
In addition, the maximum offset for a fixed-width column of an NDB table is 8188 bytes; attempting to create a table that violates this limitation fails with NDB error 851 Maximum offset for fixed-size columns exceeded. Some database objects such ...The maximum permitted size of any one row is 30000 ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-programs-ndb-select-all.html
ndb_select_all prints all rows from an NDB table to stdout. Usage ndb_select_all -c connection_string tbl_name -d db_name [> file_name] Options that can be used with ndb_select_all are shown in the following table. --database=dbname, -d dbname Name ...--connect-retries Command-Line Format --connect-retries=# Type Integer Default Value 12 Minimum Value 0 Maximum Value 12 Number of times to retry connection before giving ...
https://dev.mysql.com/doc/refman/8.4/en/function-optimization.html
If a function is tagged nondeterministic, a reference to it in a WHERE clause is evaluated for every row (when selecting from one table) or combination of rows (when selecting from a multiple-table join). MySQL also determines when to evaluate ...A ...
https://dev.mysql.com/doc/refman/8.4/en/replication-features-create-if-not-exists.html
Similarly, every CREATE TABLE IF NOT EXISTS statement without a SELECT is replicated, whether or not the table already exists on the source. SELECT follows somewhat different rules; see Section 19.5.1.7, “Replication of CREATE TABLE ... IF NOT ...
https://dev.mysql.com/doc/heatwave/en/mys-hwaml-prepare-a-forecasting-model.html
mysql> CREATE DATABASE forecasting_data; mysql> USE forecasting_data; Create the table that is the sample dataset. mysql> CREATE TABLE electricity_demand ( date DATE PRIMARY KEY, demand FLOAT NOT NULL, temperature FLOAT NOT NULL ); Insert the sample ...To ensure reliable predictions, you should create an additional validation ... This topic ...
https://dev.mysql.com/doc/mysql-ai/9.5/en/mys-ai-aml-prepare-a-forecasting-model.html
mysql> CREATE DATABASE forecasting_data; mysql> USE forecasting_data; Create the table that is the sample dataset. mysql> CREATE TABLE electricity_demand ( date DATE PRIMARY KEY, demand FLOAT NOT NULL, temperature FLOAT NOT NULL ); Insert the sample ...To ensure reliable predictions, you should create an additional validation ... This topic ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-quick.html
Try to create an NDBCLUSTER table: $> mysql mysql> USE test; Database changed mysql> CREATE TABLE ctest (i INT) ENGINE=NDBCLUSTER; Query OK, 0 rows affected (0.09 sec) mysql> SHOW CREATE TABLE ctest \G *************************** 1. You can now ...