Search Results
https://dev.mysql.com/doc/refman/8.4/en/partitioning-range.html
A table that is partitioned by range is partitioned in such a way that each partition contains rows for which the partitioning expression value lies within a given range. While the examples work as shown for purposes of the present discussion, you ...Ranges should be contiguous but not overlapping, and are defined using the VALUES LESS THAN ...
https://dev.mysql.com/doc/refman/8.4/en/problems-connecting.html
Under Linux or Unix, check your IP tables (or similar) configuration to ensure that the port has not been blocked. The grant tables must be properly set up so that the server can use them for access control. For some distribution types (such as ...
https://dev.mysql.com/doc/mysql-enterprise-backup/8.4/en/backup-special-options.html
--safe-replica-backup-timeout=SECONDS For a replication setup, the option specifies the time (in seconds) mysqlbackup will wait for Replica_open_temp_tables to become “0” (which happens when no temporary tables are open) to complete the backup ... These options are for backing up database servers that play specific roles in replication, or contain certain kinds of data that require special care in backing ...
https://dev.mysql.com/doc/refman/8.4/en/backup-methods.html
Making a Hot Backup with MySQL Enterprise Backup Customers of MySQL Enterprise Edition can use the MySQL Enterprise Backup product to do physical backups of entire instances or selected databases, tables, or both. (Ideally, the InnoDB tables should ...Backing up the physical database files makes restore much faster than logical techniques such as the mysqldump ...
https://dev.mysql.com/doc/refman/8.4/en/rewriter-query-rewrite-plugin-usage.html
The plugin determines whether to rewrite statements based on its in-memory cache of rewriting rules, which are loaded from the rewrite_rules table in the query_rewrite database. The following example creates a simple rule to match statements that ...
https://dev.mysql.com/doc/relnotes/mysql-cluster/8.4/en/news-8-4-0.html
(Bug #35997178) The unused INFORMATION_SCHEMA.TABLESPACES table, deprecated in MySQL 8.0.22, has now been removed. The Information Schema FILES table provides tablespace-related information for NDB tables. (WL #14065) ndbinfo Information Database ...
https://dev.mysql.com/doc/ndbapi/en/ndb-object.html
This section provides information about the Object class, which contains meta-information about database objects such as tables and indexes. Description This parameter specifies how data in the table or index is distributed among the cluster's data ...Object::getObjectVersion() Description The method gets the current version of the ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-lakehouse-auto-loading-data-uri.html
To review all syntax options for loading external files, see Auto Parallel Load Syntax and Lakehouse External Table Syntax. mysql> SET @input_list = '[{ "db_name": "lakehouse_db", "tables": [{ "table_name": "table_1", "engine_attribute": { ... To ...
https://dev.mysql.com/doc/heatwave/en/mys-hwaml-ml-model-import.html
Models in ONNX format (.onnx) cannot be loaded directly into a MySQL table. Before running ML_MODEL_IMPORT, follow the instructions in Import an External ONNX Model to pre-process and then load the model into a temporary table for import to MySQL ...
https://dev.mysql.com/doc/refman/8.4/en/fulltext-fine-tuning.html
Some variable changes require that you rebuild the FULLTEXT indexes in your tables. For MyISAM tables, note the remarks regarding myisamchk in the instructions that follow for rebuilding MyISAM full-text indexes. Modifying Boolean Full-Text Search ...You can exert more control over full-text searching behavior if you have a MySQL source distribution because some changes require source code ...