Search Results
https://dev.mysql.com/doc/refman/8.4/en/innodb-locking.html
Shared and Exclusive Locks Intention Locks Record Locks Gap Locks Next-Key Locks Insert Intention Locks AUTO-INC Locks Predicate Locks for Spatial Indexes Shared and Exclusive Locks InnoDB implements standard row-level locking where there are two ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-recovery.html
To achieve point-in-time recovery after restoring a backup, you can apply changes from the binary log that occurred after the backup was made. Recovery from Data Corruption or Disk Failure If your database becomes corrupted or disk failure occurs, ...
https://dev.mysql.com/doc/refman/8.4/en/insert-on-duplicate.html
If you specify an ON DUPLICATE KEY UPDATE clause and a row to be inserted would cause a duplicate value in a UNIQUE index or PRIMARY KEY, an UPDATE of the old row occurs. If column b is also unique, the INSERT is equivalent to this UPDATE statement ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-ndb-api-statistics.html
A number of types of statistical counters relating to actions performed by or affecting Ndb objects are available. Such actions include starting and closing (or aborting) transactions; primary key and unique key operations; table, range, and pruned ...
https://dev.mysql.com/doc/refman/8.4/en/using-innodb-tables.html
InnoDB tables are created using the CREATE TABLE statement; for example: CREATE TABLE t1 (a INT, b CHAR (20), PRIMARY KEY (a)) ENGINE=InnoDB; The ENGINE=InnoDB clause is not required when InnoDB is defined as the default storage engine, which it is ...
https://dev.mysql.com/doc/relnotes/mysql/8.4/en/news-8-4-4.html
Account Management Notes C API Notes Character Set Support Compilation Notes Component Notes Firewall Notes Installation Notes Optimizer Notes Performance Schema Notes Functionality Added or Changed Bugs Fixed Account Management Notes The database ...
https://dev.mysql.com/doc/mysql-ai/9.4/en/mys-ai-aml-model-catalog-table.html
The MODEL_CATALOG table (ML_SCHEMA_user_name.MODEL_CATALOG) has the following columns: model_id A primary key, and a unique auto-incrementing numeric identifier for the model. The model handle is generated or set by the user when the ML_TRAIN ...
https://dev.mysql.com/doc/refman/8.4/en/server-system-variables.html
The MySQL server maintains many system variables that affect its operation. Most system variables can be set at server startup using options on the command line or in an option file. Most of them can be changed dynamically at runtime using the SET ...
https://dev.mysql.com/doc/workbench/en/dbdoc-templates-markers.html
These markers can be used in any template, including custom templates. Using the table The table shows which variables are defined in which sections. The variable should be used in its correct section or its value will not be displayed. If a ...
https://dev.mysql.com/doc/connectors/en/connector-j-usagenotes-last-insert-id.html
getGeneratedKeys() is the preferred method to use if you need to retrieve AUTO_INCREMENT keys and through JDBC; this is illustrated in the first example below. The second example shows how you can retrieve the same value using a standard SELECT ...