Search Results
https://dev.mysql.com/doc/refman/8.4/en/dynamic-format.html
Dynamic storage format is used if a MyISAM table contains any variable-length columns (VARCHAR, VARBINARY, BLOB, or TEXT), or if the table was created with the ROW_FORMAT=DYNAMIC table option. You can use OPTIMIZE TABLE or myisamchk -r to ...
https://dev.mysql.com/doc/refman/8.4/en/password-management.html
To establish policy for individual accounts, use the PASSWORD EXPIRE option of the CREATE USER and ALTER USER statements. To establish policy for individual accounts, use the PASSWORD HISTORY and PASSWORD REUSE INTERVAL options of the CREATE USER ...
https://dev.mysql.com/doc/mysql-enterprise-backup/8.4/en/bugs.backup.html
When creating a backup using transportable tablespace (TTS) for a server containing tables with a mix of the Antelope and Barracuda file formats, do not apply full locking on the tables (that is, do not specify --use-tts=with-full-locking). Backup ...Here is a list of limitations of MySQL Enterprise Backup: In some cases, backups of non-transactional tables such as MyISAM tables could contain additional uncommitted ...
https://dev.mysql.com/doc/mysql-enterprise-backup/8.4/en/meb-files-backed-up-summary.html
The backup_history and backup_progress tables created by mysqlbackup use the CSV format, so the backup always includes some files with this extension. The backup_history and backup_progress tables created by mysqlbackup use the CSV format, so the ...
https://dev.mysql.com/doc/refman/8.4/en/handler.html
] HANDLER tbl_name CLOSE The HANDLER statement provides direct access to table storage engine interfaces. OPEN statement opens a table, making it accessible using subsequent HANDLER ... This table object is not shared by other sessions and is not ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-object-filtering.html
The setup_objects table controls whether the Performance Schema monitors particular table and stored program objects. TABLE filtering affects table I/O events (wait/io/table/sql/handler instrument) and table lock events (wait/lock/table/sql/handler ...The OBJECT_TYPE column indicates the type of object to which a row ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-genai-generate-embeddings.html
Using this method, you can create vector embedding tables that you can use to perform similarity searches using the DISTANCE() function, without setting up a vector store. Note In versions older than MySQL 9.2.1, to alter an existing table or create ...You can pass the text string in the routine manually or use data from tables in your ... This section ...
https://dev.mysql.com/doc/mysql-monitor/8.0/en/performance-advisors-ref.html
Excessive Disk Temporary Table Usage Detected If the space required to build a temporary table exceeds either tmp_table_size or max_heap_table_size, MySQL creates a disk-based table in the server's tmpdir directory. For performance reasons it is ...
https://dev.mysql.com/doc/mysql-ai/9.4/en/mys-mysqlai-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 to use with AutoML.
https://dev.mysql.com/doc/refman/8.4/en/innodb-locking.html
Client A creates a table containing two index records (90 and 102) and then starts a transaction that places an exclusive lock on index records with an ID greater than 100. Intention Locks InnoDB supports multiple granularity locking which permits ...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 types of locks, shared (S) locks and exclusive (X) ...