Search Results
https://dev.mysql.com/doc/mysql-ai/9.4/en/mys-mysqlai-ml-train.html
table_name: The name of the table that contains the labeled training dataset. The table name must be valid and fully qualified, so it must include the database name, database_name.table_name. The table cannot exceed 10 GB, 100 million rows, or 1017 ... Run the ML_TRAIN routine on a training dataset to produce a trained machine learning ...
https://dev.mysql.com/doc/relnotes/mysql/8.4/en/news-8-4-6.html
(Bug #37481548) Microsoft Windows: When upgrading a MySQL Server using MySQL Configurator, the process hung in the "Starting the server and upgrading system tables" step if a custom error log name was used. (Bug #37463478) InnoDB Notes Fixed an ...
https://dev.mysql.com/doc/internals/en/event-data-for-specific-event-types.html
How come statements with a nonzero error code can exist in the binary log? This is mainly due to the use of nontransactional tables within transactions. SELECT fails after inserting 1000 rows into a MyISAM table (for example, with a duplicate-key ...
https://dev.mysql.com/doc/relnotes/mysql/8.4/en/news-8-4-1.html
It was removed due to a critical issue that could stop the server from restarting following the creation of a very large number of tables (8001 or more). (Bug #35205358) Data Dictionary Notes Attempting to upgrade a MyISAM table containing a mix of ...Now pruning continues in such cases, but with a warning printed in the error log stating that it was not possible to delete the missing audit log ...
https://dev.mysql.com/doc/refman/8.4/en/stored-program-restrictions.html
The following statements are not permitted: The locking statements LOCK TABLES and UNLOCK TABLES. This includes SELECT statements that do not have an INTO var_list clause and other statements such as SHOW, EXPLAIN, and CHECK TABLE. A stored function ...Some of the restrictions noted here apply to all stored routines; that is, both to stored procedures and stored ...
https://dev.mysql.com/doc/ndbapi/en/ndb-ndboperation.html
Enumeration values Possible values are shown, along with descriptions, in the following table: Table 2.51 NdbOperation::AbortOption type values and descriptions Name Description AbortOnError A failed operation causes the transaction to abort. When ...Beginning with NDB 8.0.30, NdbOperation supports an interpreted code API similar to that implemented by ...
https://dev.mysql.com/doc/refman/8.4/en/data-size.html
Design your tables to minimize their space on the disk. Smaller tables normally require less main memory while their contents are being actively processed during query execution. Any space reduction for table data also results in smaller indexes ...
https://dev.mysql.com/doc/refman/8.4/en/insert-on-duplicate.html
In general, you should try to avoid using an ON DUPLICATE KEY UPDATE clause on tables with multiple unique indexes. It is possible to use IGNORE with ON DUPLICATE KEY UPDATE in an INSERT statement, but this may not behave as you expect when ... If ...
https://dev.mysql.com/doc/refman/8.4/en/memory-use.html
The InnoDB buffer pool is a memory area that holds cached InnoDB data for tables, indexes, and other auxiliary buffers. For each MyISAM table the server opens, the index file is opened once; the data file is opened once for each concurrently running ... MySQL allocates buffers and caches to improve performance of database ...
https://dev.mysql.com/doc/relnotes/mysql/8.4/en/news-8-4-5.html
If this happens in a table's constraints, default expressions, partitioning expressions, or virtual columns, the table could not be opened. This prevented both analyzing the problem (using, for example, SHOW CREATE TABLE) and addressing it (such as ...(Bug #37570206) Audit Log Notes <COMMAND_CLASS> was not populated for ...