Temporary tables. CREATE TEMPORARY TABLE and DROP TEMPORARY TABLE statements are not supported inside transactions when using GTIDs (that is, when the server was started with the -- enforce-gtid-consistency [2056] option). It is possible to use us...
Transaction isolation level. The NDBCLUSTER storage engine supports only the READ COMMITTED [1502] transaction isolation level. (InnoDB, for example, supports READ COMMITTED [1502], READ UNCOMMITTED [1502], REPEATABLE READ [1501], and SERIALIZABL...
MyISAM Table Problems The file format that MySQL uses to store data has been extensively tested, but there are always circumstances that may cause database tables to become corrupted. The following discussion describes how this can happen and how...
Performance Schema Wait Event Tables These tables store wait events: • events_waits_current: Current wait events • events_waits_history: The most recent wait events for each thread • events_waits_history_long: The most recent wait events ov...
Top Level Instrument Components • idle: An instrumented idle event. This instrument has no further components. • stage: An instrumented stage event. • statement: An instrumented statement event. • wait: An instrumented wait event. ...
Spatial supported Functions There are some useful functions that takes Geometry values: • SpatialDimension • SpatialEnvelope • IsSimpleGeometry • SpatialTypeName • CoordinateSystemId • Point • XCoordinate • YCoordinate • GeometryFromText • SpatialContains • AsText • SpatialBuffer • Spa...
