Search Results
https://dev.mysql.com/doc/extending-mysql/8.4/en/plugin-types.html
The plugin API enables creation of plugins that implement several capabilities: Loadable functions (UDFs) Storage engines Full-text parsers Daemons INFORMATION_SCHEMA tables Semisynchronous replication Auditing Authentication Password validation ...
https://dev.mysql.com/doc/mysqld-version-reference/en/options-variables.html
The following table shows all the options and variables available in MySQL Server. Dyn: Whether the item is dynamically settable while the server is running. An item has a row in the table if it ever existed in any series shown in the table. Intr: ...
https://dev.mysql.com/doc/mysql-ai/9.5/en/mys-ai-bulk-load-limitations.html
Use ALTER TABLE to make any changes to the table after LOAD DATA with ALGORITHM=BULK. 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 ...It does not support automatic rounding or truncation of the input ...
https://dev.mysql.com/doc/refman/8.4/en/example-auto-increment.html
To start with an AUTO_INCREMENT value other than 1, set that value with CREATE TABLE or ALTER TABLE, like this: mysql> ALTER TABLE tbl AUTO_INCREMENT = 100; InnoDB Notes For information about AUTO_INCREMENT usage specific to InnoDB, see Section ...
https://dev.mysql.com/doc/refman/8.4/en/fulltext-search-mecab.html
Creating a FULLTEXT Index that uses the MeCab Parser To create a FULLTEXT index that uses the mecab parser, specify WITH PARSER ngram with CREATE TABLE, ALTER TABLE, or CREATE INDEX. For InnoDB tables, minimum token size is defined by the ... The ...
https://dev.mysql.com/doc/refman/8.4/en/sys-schema-progress-reporting.html
The following sys schema views provide progress reporting for long-running transactions: processlist session x$processlist x$session Assuming that the required instruments and consumers are enabled, the progress column of these views shows the ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-loading-data-manually.html
You can manually load data from InnoDB tables in your DB System into MySQL HeatWave Cluster by using SQL data definition language (DDL) such as CREATE TABLE and ALTER TABLE statements. MySQL version 8.2.0 or higher has a guided load feature which ...Perform the following steps sequentially for each table that you want to load: Exclude table columns with unsupported data types or columns not used in queries Define a secondary engine on the ...
https://dev.mysql.com/doc/heatwave-aws/en/heatwave-aws-channel-details.html
Table without primary key: How the creation and alteration of tables with no primary keys on the source are handled. Possible values are: Raise an error Allow Generate primary key: Allows replicating a CREATE TABLE or ALTER TABLE transaction with no ... Channel Details 8.7.1 Channel Details The Channel Details page contains the following tabs: Table 8-3 Tabs on the Channel Details Page Name Description Details Channel ...
https://dev.mysql.com/doc/heatwave-aws/en/heatwave-aws-creating-channel.html
Advanced options: Tables without primary key: Specify how a replication channel handles the creation and alteration of tables with no primary keys on the source. Raise an error : Raise an error when replicating a CREATE TABLE or ALTER TABLE ...
https://dev.mysql.com/doc/refman/8.4/en/creating-spatial-columns.html
MySQL provides a standard way of creating spatial columns for geometry types, for example, with CREATE TABLE or ALTER TABLE. Use the CREATE TABLE statement to create a table with a spatial column: CREATE TABLE geom (g GEOMETRY); Use the ALTER TABLE ...Spatial columns are supported for MyISAM, InnoDB, NDB, and ARCHIVE ...See also the notes ...