Search Results
https://dev.mysql.com/doc/refman/8.4/en/create-table-check-constraints.html
The effect of a violation depends on the statement being executed, as described later in this section. CHECK constraints are evaluated for INSERT, UPDATE, REPLACE, LOAD DATA, and LOAD XML statements and an error occurs if a constraint evaluates to ... CREATE TABLE permits the core features of table and column CHECK constraints, for all storage ...
https://dev.mysql.com/doc/refman/8.4/en/general-tablespaces.html
In this example, the my_tablespace directory is at the same level as the data directory: mysql> CREATE TABLESPACE `ts1` ADD DATAFILE '../my_tablespace/ts1.ibd' Engine=InnoDB; Note The ENGINE = InnoDB clause must be defined as part of the CREATE ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-configuring-io-capacity.html
The InnoDB master thread and other threads perform various tasks in the background, most of which are I/O related, such as flushing dirty pages from the buffer pool and writing changes from the change buffer to the appropriate secondary indexes.
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-status-variables.html
Performance_schema_digest_lost The number of digest instances that could not be instrumented in the events_statements_summary_by_digest table. This can be nonzero if the value of performance_schema_max_index_stat is too small. Performance Schema ...
https://dev.mysql.com/doc/refman/8.4/en/upgrade-prerequisites.html
To change a table storage engine to InnoDB, execute this statement: ALTER TABLE table_name ENGINE = INNODB; For information about converting MyISAM tables to InnoDB, see Section 17.6.1.5, “Converting Tables from MyISAM to InnoDB”. To make a ...
https://dev.mysql.com/doc/extending-mysql/8.4/en/adding-functions.html
A stored function is written using SQL statements rather than by compiling object code. A loadable function is compiled as a library file and then loaded and unloaded from the server dynamically using the CREATE FUNCTION and DROP FUNCTION statements. Regardless of the method used to add a function, it can be invoked in SQL statements just like native functions such as ABS() or ...
https://dev.mysql.com/doc/internals/en/differences-master-slave.html
The following is the main rule: (P-rpl-correct) If a replication master and slave reside on identical environments (D-identical-environments) and the server states are identical (D-identical-server-states), and @@client.binlog_format!=STATEMENT, ...
https://dev.mysql.com/doc/internals/en/support-for-update.html
Non-indexed storage engines can typically ignore the contents of the *old_data parameter and just deal with the *new_data buffer. Performing an update will depend on row format and storage implementation. Some storage engines will replace data ...
https://dev.mysql.com/doc/mysql-em-plugin/en/myoem-metric-sysschema-innodbrowlockwaiters-category.html
Lists the Sys Schema InnoDB Row Lock Waits metrics and provides a brief description of each.
https://dev.mysql.com/doc/heatwave/en/mys-hw-bulk-load-mysql-server.html
MySQL includes a bulk load extension to the LOAD DATA statement that is only available in MySQL HeatWave on AWS. Stored generated columns can be part of secondary indexes and the primary key. It can do the following: Optimize the loading of data ...