Search Results
https://dev.mysql.com/doc/relnotes/mysql/8.4/en/news-8-4-6.html
Note These release notes were created with the assistance of MySQL HeatWave GenAI. (Bug #37621360) Installation Notes Debian packages for installing MySQL can now be run by users other than root. (Bug #37478594) InnoDB: Creating a secondary index ...Compilation Notes Configuration Notes InnoDB Notes Installation Notes Functionality Added or Changed Bugs Fixed Compilation Notes macOS: It is now possible to compile the server on MacOS using ...
https://dev.mysql.com/doc/mysql-ai/9.4/en/mys-ai-aml-ml-model-metadata.html
build_timestamp: number A timestamp indicating when the model was created (UNIX epoch time). The model_metadata column in the model catalog allows you to view detailed information on trained models. For example, you can view the algorithm used to ...
https://dev.mysql.com/doc/refman/8.4/en/column-count-limit.html
Functional key parts (see Section 15.1.15, “CREATE INDEX Statement”) are implemented as hidden virtual generated stored columns, so each functional key part in a table index counts against the table total column limit. mysql> CREATE TABLE t (a ... This section describes limits on the number of columns in tables and the size of individual ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-file-per-table-tablespaces.html
File-per-table tablespace characteristics are described under the following topics in this section: File-Per-Table Tablespace Configuration File-Per-Table Tablespace Data Files File-Per-Table Tablespace Advantages File-Per-Table Tablespace ... A ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-online-add-node-example.html
You can do this by issuing a CREATE NODEGROUP command in the cluster management client. ALGORITHM=INPLACE, REORGANIZE PARTITION does not work on tables that were created with the MAX_ROWS option. REORGANIZE PARTITION statements for NDBCLUSTER tables ... In this section we provide a detailed example illustrating how to add new NDB Cluster data nodes online, starting with an NDB Cluster having 2 data nodes in a single node group and concluding with a cluster having 4 data nodes in 2 node ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-programs-ndb-index-stat.html
To force them to be created (or updated if they already exist), invoke ndb_index_stat with the --update option, or execute ANALYZE TABLE on the table in the mysql client. --sys-create Command-Line Format --sys-create Create all statistics tables and ... ndb_index_stat provides per-fragment statistical information about indexes on NDB ...
https://dev.mysql.com/doc/workbench/en/wb-design-table-templates.html
Define table templates with commonly used columns and settings to create new tables from either a live connection or while creating an EER model. From the SQL editor, select Create Table Like from the Tables context menu, as shown in the next ...
https://dev.mysql.com/doc/workbench/en/wb-forward-engineering-live-server.html
The first step of the process is to connect to a MySQL server to create the new database schema. The next page enables you to set options for the database to be created (see the following figure). These options are as described in Section 9.4.1.1.1, ... Use forward engineering to export your schema design to a MySQL ...
https://dev.mysql.com/doc/workbench/en/wb-what-is-new-61.html
Initially, this loads an "Easy Setup" page that is enough for most users. To create a custom group, right-click on a variable and choose either Add to Custom Category (to create a new category), or an existing custom category. This also has a ...
https://dev.mysql.com/doc/connectors/en/connector-j-reference-implementation-notes.html
The driver uses SHOW CREATE TABLE to retrieve this information, so if any other storage engines add support for foreign keys, the driver would transparently support them as well. To enable this functionality, create a Statement instance in the ...