Search Results
https://dev.mysql.com/doc/refman/9.7/en/innodb-restrictions-limitations.html
You cannot create a table with a column name that matches the name of an internal InnoDB column (including DB_ROW_ID, DB_TRX_ID, and DB_ROLL_PTR. mysql> CREATE TABLE t1 (c1 INT, db_row_id INT) ENGINE=INNODB; ERROR 1166 (42000): Incorrect column name ... This section describes restrictions and limitations of the InnoDB storage ...
https://dev.mysql.com/doc/refman/9.7/en/mysql-cluster-programs-ndb-move-data.html
Usage The program is invoked with the names of the source and target tables; either or both of these may be qualified optionally with the database name. ndb_move_data options source target Options that can be used with ndb_move_data are shown in the ...--abort-on-error Command-Line Format --abort-on-error Dump core on permanent error (debug ...
https://dev.mysql.com/doc/mysql-enterprise-backup/9.7/en/meb-backup-osb.html
Each time an online backup is made to a tape using the SBT API , besides recording the backup in the mysql.backup_history and the mysql.backup_progress tables, an entry is also made to the mysql.backup_sbt_history table on the backed up MySQL ...
https://dev.mysql.com/doc/ndbapi/en/overview-terminology.html
In the NDB storage engine, a table is broken up into and stored as a number of subsets, usually referred to as fragments. Under the NDB storage engine, each table fragment has number of fragment replicas in order to provide redundancy. Abstract ...
https://dev.mysql.com/doc/refman/9.7/en/user-variables.html
(Exception: A user with access to the Performance Schema user_variables_by_thread table can see all user variables for all sessions.) All variables for a given client session are automatically freed when that client exits. (This is the same ... You ...
https://dev.mysql.com/doc/workbench/en/wb-model-reporting.html
Content options can also be selected: Output Table Columns: Display all the columns. Output References from Foreign Keys: Display the tables that foreign keys reference. overview_list.html: A summary of schema in the model along with a list of ...
https://dev.mysql.com/doc/heatwave/en/mys-hwaml-progress-tracking.html
mysql> CALL sys.ML_TRAIN('census_data.census_train', 'revenue', JSON_OBJECT('task', 'classification'), @census_model); While ML_TRAIN runs, use the second MySQL Client session and query the performance_schema.rpd_query_stats table, which stores data ... You can monitor the progress of MySQL HeatWave AutoML routines through Performance Schema queries made from a second MySQL Client ...
https://dev.mysql.com/doc/refman/9.7/en/mysql-cluster-replication.html
Although an NDB Cluster itself depends on the NDB storage engine for clustering functionality, it is not necessary to use NDB as the storage engine for the replica's copies of the replicated tables (see Replication from NDB to other storage engines). By comparing the values of these status variables before and after the execution of statements affecting replicated NDB tables, you can observe the corresponding actions taken on the NDB API level by the replica, which can be useful when monitoring or troubleshooting NDB Cluster ...
https://dev.mysql.com/doc/internals/en/item-class.html
To us, the word Item means more than just “thingamabob”; it is a technical term with a precise definition in the context of our source code. In the function category we include operators such as + and ||, because operators are merely functions ...
https://dev.mysql.com/doc/refman/9.7/en/spatial-types.html
MySQL spatial extensions enable the generation, storage, and analysis of geographic features: Data types for representing spatial values Functions for manipulating spatial values Spatial indexing for improved access times to spatial columns The ...