Search Results
https://dev.mysql.com/doc/refman/8.4/en/general-thread-states.html
end This occurs at the end but before the cleanup of ALTER TABLE, CREATE VIEW, DELETE, INSERT, SELECT, or UPDATE statements. init This occurs before the initialization of ALTER TABLE, DELETE, INSERT, SELECT, or UPDATE statements. The following list ...
https://dev.mysql.com/doc/refman/8.4/en/gis-mysql-specific-functions.html
For example, you can insert the geometry return value from Point() directly into a POINT column: INSERT INTO t1 (pt_col) VALUES(Point(1,2)); GeomCollection(g [, g] ...) Constructs a GeomCollection value from the geometry arguments. MySQL provides a ...
https://dev.mysql.com/doc/refman/8.4/en/group-by-handling.html
SQL-92 and earlier does not permit queries for which the select list, HAVING condition, or ORDER BY list refer to nonaggregated columns that are not named in the GROUP BY clause. SQL:1999 and later permits such nonaggregates per optional feature ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-bootstrap.html
mysql> CREATE DATABASE test; mysql> USE test; mysql> CREATE TABLE t1 (c1 INT PRIMARY KEY, c2 TEXT NOT NULL); mysql> INSERT INTO t1 VALUES (1, 'Luis'); Check the content of table t1 and the binary log. Also, the data was inserted into the table and ... The process of starting a group for the first time is called ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-configuring-consistency-guarantees.html
No read skew on read/write transactions, such as this one: > BEGIN; > SELECT x FROM t1; -- x=1 because x=2 is in the backlog; > INSERT x INTO t2; > COMMIT; This query should not cause a conflict but writes outdated values. Although the Transaction ...
https://dev.mysql.com/doc/refman/8.4/en/index-statistics.html
(This may occur for bulk inserts or deletes, or some ALTER TABLE statements, for example.) If this happens, the statistics are collected using whatever value innodb_stats_method or myisam_stats_method has at the time. Storage engines collect ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-events-table.html
The EVENTS table provides information about Event Manager events, which are discussed in Section 27.4, “Using the Event Scheduler”. The EVENTS table has these columns: EVENT_CATALOG The name of the catalog to which the event belongs.
https://dev.mysql.com/doc/refman/8.4/en/information-schema-innodb-ft-index-table-table.html
Before information for newly inserted rows appears in INNODB_FT_INDEX_TABLE, the FULLTEXT index cache must be flushed to disk. The INNODB_FT_INDEX_TABLE table provides information about the inverted index used to process text searches against the ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-innodb-tablestats-table.html
The value could be imprecise if uncommitted transactions are inserting into or deleting from the table. MODIFIED_COUNTER The number of rows modified by DML operations, such as INSERT, UPDATE, DELETE, and also cascade operations from foreign keys.
https://dev.mysql.com/doc/refman/8.4/en/innodb-best-practices.html
Foreign keys also propagate deletes and updates to all affected tables, and prevent insertion of data in a child table if the corresponding IDs are not present in the parent table. While you don't want to commit too often, you also don't want to ...