Search Results
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-ndbinfo.html
row *************************** Engine: InnoDB Support: DEFAULT Comment: Supports transactions, row-level locking, and foreign keys Transactions: YES XA: YES Savepoints: YES *************************** 3. ndbinfo is a database containing ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-tp-connections-table.html
This column and TP_PROCESSING_THREAD_NUMBER serve as a foreign key into the tp_thread_state table. The tp_connections table contains one row per connection managed by the Thread Pool plugin. Each row provides information about the current state of ...
https://dev.mysql.com/doc/refman/8.4/en/replication-rules-examples.html
Operations to watch out for include transactions involving multi-table UPDATE statements, triggers, cascading foreign keys, stored functions that update multiple tables, and DML statements that invoke stored functions that update one or more tables.
https://dev.mysql.com/doc/refman/8.4/en/show-engines.html
row *************************** Engine: InnoDB Support: DEFAULT Comment: Supports transactions, row-level locking, and foreign keys Transactions: YES XA: YES Savepoints: YES *************************** 3. SHOW [STORAGE] ENGINES SHOW ENGINES ...
https://dev.mysql.com/doc/refman/8.4/en/stored-program-restrictions.html
Restrictions for Triggers For triggers, the following additional restrictions apply: Triggers are not activated by foreign key actions. Some of the restrictions noted here apply to all stored routines; that is, both to stored procedures and stored ...
https://dev.mysql.com/doc/refman/8.4/en/upgrade-prerequisites.html
There must be no tables that have foreign key constraint names longer than 64 characters. To make a partitioned table nonpartitioned, execute this statement: ALTER TABLE table_name REMOVE PARTITIONING; Some keywords may be reserved in MySQL 8.4 that ... Before upgrading to the latest MySQL 8.4 release, ensure the upgrade readiness of your current MySQL 8.3 or MySQL 8.4 server instance by performing the preliminary checks described ...
https://dev.mysql.com/doc/relnotes/connector-j/en/news-8-0-27.html
(WL #14660) Bugs Fixed The method DatabaseMetaData.getImportedKeys() sometimes returned multiple rows for the same foreign key. With this fix, Connector/J performs more accurate checks by looking at the statement keywords and the context, as well as ... Version 8.0.27 is the latest General Availability release of the 8.0 series of MySQL ...
https://dev.mysql.com/doc/mysql-ai/9.5/en/mys-ai-bulk-load-limitations.html
LOAD DATA with ALGORITHM=BULK supports tables with at least one column with the VECTOR data type. If you attempt to load a table without at least one column with the VECTOR data type, an error occurs. LOAD DATA with ALGORITHM=BULK has the following ...
MySQL 8.4 Reference Manual :: A.11 MySQL 8.4 FAQ: MySQL Chinese, Japanese, and Korean Character Sets
https://dev.mysql.com/doc/refman/8.4/en/faqs-cjk.html
This set of Frequently Asked Questions derives from the experience of MySQL's Support and Development groups in handling many inquiries about CJK (Chinese-Japanese-Korean) issues. What problems should I be aware of when working with the Big5 ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-data-encryption.html
When a tablespace is encrypted, a tablespace key is encrypted and stored in the tablespace header. When an application or authenticated user wants to access encrypted tablespace data, InnoDB uses a master encryption key to decrypt the tablespace key. The decrypted version of a tablespace key never changes, but the master encryption key can be changed as ... InnoDB supports data-at-rest ...