Search Results
https://dev.mysql.com/doc/mysql-ai/9.4/en/mys-ai-genai-vector-store-load.html
This section describes how to generate vector embeddings for files or folders stored in , and load the embeddings into a vector store table. To create and store vector store tables using the steps described in this topic, you can create a new ...
https://dev.mysql.com/doc/connectors/en/connector-j-usagenotes-spring-config-transactional.html
ALTER TABLE City ENGINE=InnoDB; ALTER TABLE Country ENGINE=InnoDB; ALTER TABLE CountryLanguage ENGINE=InnoDB; A good programming practice emphasized by Spring is separating interfaces and implementations. To use transactional database access, we ...
https://dev.mysql.com/doc/connector-j/en/connector-j-usagenotes-spring-config-transactional.html
ALTER TABLE City ENGINE=InnoDB; ALTER TABLE Country ENGINE=InnoDB; ALTER TABLE CountryLanguage ENGINE=InnoDB; A good programming practice emphasized by Spring is separating interfaces and implementations. To use transactional database access, we ...
https://dev.mysql.com/doc/refman/8.4/en/create-procedure.html
By default, MySQL automatically grants the ALTER ROUTINE and EXECUTE privileges to the routine creator. The following example shows a simple stored procedure that, given a country code, counts the number of cities for that country that appear in the ...By default, a stored routine is associated with the default ...
https://dev.mysql.com/doc/refman/8.4/en/socket-pluggable-authentication.html
Alternatively, to load the plugin at runtime, use this statement: INSTALL PLUGIN auth_socket SONAME 'auth_socket.so'; INSTALL PLUGIN loads the plugin immediately, and also registers it in the mysql.plugins system table to cause the server to load it ...To verify plugin installation, examine the Information Schema PLUGINS table or use the SHOW PLUGINS statement (see Section 7.6.2, “Obtaining Server Plugin ...
https://dev.mysql.com/doc/workbench/en/wb-validation-plugins.html
Alternatively, you can run the same validation tests from the Validate tab within the panel as the following figure shows. In addition, the output is organized by category: Validating routine groups, Validating routines, Validating tables, and ...
https://dev.mysql.com/doc/internals/en/transactions-notes-on-ddl-and-normal-transaction.html
In addition, some DDL statements issue interim transaction commits: for example, ALTER TABLE issues a commit after data is copied from the original table to the internal temporary table. DDL statements use a form of "semantic" logging to maintain ...
https://dev.mysql.com/doc/mysql-installer/en/mysql-installer-catalog-dashboard.html
For upgrades, a check box enables you to skip the upgrade check and process for system tables, while checking and processing data dictionary tables normally. This behavior represents a change in how MySQL Server performs an upgrade (see What the ...
https://dev.mysql.com/doc/mysql-monitor/8.0/en/mem-ui-configuration-views-ref.html
DDL Statements: filters on statements of type CREATE, DROP, ALTER, TRUNCATE, and RENAME. Statements with Full Table Scans: filters on the advanced filter options of Table Scan notices and Total Table Scans > 0. Statements with Temporary Tables: ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-limitations-other.html
Operations involving ALTER TABLE such as loading, unloading, or recovering data when MySQL Server is running in SUPER_READ_ONLY mode. For a list of supported SQL modes, see Section 5.2, “Supported SQL Modes”. The WITH ROLLUP modifier in GROUP BY ...