PDF (US Ltr)
- 43.2Mb
PDF (A4)
- 43.3Mb
Man Pages (TGZ)
- 295.2Kb
Man Pages (Zip)
- 400.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/spatial-relation-functions-object-shapes.html
The OpenGIS specification defines the following functions to test the relationship between two geometry values g1 and g2, using precise object shapes. The return values 1 and 0 indicate true and false, respectively, except that distance functions ...If any geometry argument is not a syntactically well-formed geometry, an ER_GIS_INVALID_DATA error ...
https://dev.mysql.com/doc/refman/8.0/en/timestamp-lookups.html
Temporal values are stored in TIMESTAMP columns as UTC values, and values inserted into and retrieved from TIMESTAMP columns are converted between the session time zone and UTC. If the session time zone is UTC, there is effectively no time zone ...
https://dev.mysql.com/doc/refman/8.0/en/trigger-syntax.html
It also includes clauses that specify the trigger action time, the triggering event, and what to do when the trigger activates: The keyword BEFORE indicates the trigger action time. It is possible to define multiple triggers for a given table that ... To create a trigger or drop a trigger, use the CREATE TRIGGER or DROP TRIGGER statement, described in Section 15.1.22, “CREATE TRIGGER Statement”, and Section 15.1.34, “DROP TRIGGER ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-instrument-naming.html
Example names: wait/io/file/myisam/log wait/io/file/mysys/charset wait/lock/table/sql/handler wait/synch/cond/mysys/COND_alarm wait/synch/cond/sql/BINLOG::update_cond wait/synch/mutex/mysys/BITMAP_mutex wait/synch/mutex/sql/LOCK_delete ...This ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-error-log-table.html
The LOGGED column stores values using the TIMESTAMP data type, for which values are stored in UTC but displayed when retrieved in the current session time zone; see Section 13.2.2, “The DATE, DATETIME, and TIMESTAMP Types”. Granting the SELECT ... Of the logs the MySQL server maintains, one is the error log to which it writes diagnostic messages (see Section 7.4.2, “The Error ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-wait-summary-tables.html
The Performance Schema maintains tables for collecting current and recent wait events, and aggregates that information in summary tables. See that discussion for information about the content of wait events, the current and recent wait event ...
https://dev.mysql.com/doc/refman/8.0/en/query-log.html
However, when using row-based binary logging, updates are sent as row changes rather than SQL statements, and thus these statements are never written to the query log when binlog_format is ROW. To disable or enable the general query log or change ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-stage-tables.html
For additional information about configuring event collection, see Section 29.3, “Performance Schema Startup Configuration”, and Section 29.4, “Performance Schema Runtime Configuration”. During execution of an ALTER TABLE statement, the ...
https://dev.mysql.com/doc/refman/8.0/en/repair-table.html
Table Repair Considerations REPAIR TABLE upgrades a table if it contains old temporal columns in pre-5.6.4 format (TIME, DATETIME, and TIMESTAMP columns without support for fractional seconds precision) and the avoid_temporal_upgrade system variable ...See Section B.3.3.3, “What to Do If MySQL Keeps Crashing”, and Section 18.2.4, “MyISAM Table ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema-introduction.html
Other terms that are sometimes used for this information are data dictionary and system catalog. Performance Considerations INFORMATION_SCHEMA queries that search for information from more than one database might take a long time and impact ...They ... INFORMATION_SCHEMA provides access to database metadata, information about the MySQL server such as the name of a database or table, the data type of a column, or access ...