Search Results
https://dev.mysql.com/doc/refman/8.4/en/spatial-relation-functions-mbr.html
When speaking of relationships between geometries, it is important to distinguish between containment and covering, as described here: A geometry g1 contains another geometry g2 if and only if all points in g2 are also in g1, and their boundaries do ... MySQL provides several MySQL-specific functions that test the relationship between minimum bounding rectangles (MBRs) of two geometries g1 and ...
https://dev.mysql.com/doc/refman/8.4/en/spatial-types.html
Additional Resources These standards are important for the MySQL implementation of spatial operations: SQL/MM Part 3: Spatial. The Open Geospatial Consortium (OGC) is an international consortium of more than 250 companies, agencies, and ...
https://dev.mysql.com/doc/refman/8.4/en/starting-server.html
It is important that the MySQL server be run using an unprivileged (non-root) login account. This section describes how start the server on Unix and Unix-like systems. (For Windows, see Section 2.3.3.5, “Starting the Server for the First ...
https://dev.mysql.com/doc/refman/8.4/en/stored-programs-logging.html
(Binary log events differ from scheduled event stored objects.) The binary log has two important purposes: For replication, the binary log is used on source replication servers as a record of the statements to be sent to replica servers. The binary ...
https://dev.mysql.com/doc/refman/8.4/en/string-functions.html
Important When using SOUNDEX(), you should be aware of the following limitations: This function, as currently implemented, is intended to work well with strings that are in the English language only. For functions that operate on string positions, ...
https://dev.mysql.com/doc/refman/8.4/en/table-locking.html
The automatic row-level locking makes these tables suitable for your busiest databases with your most important data, while also simplifying application logic since you do not need to lock and unlock tables. InnoDB tables use row-level locking so ...
https://dev.mysql.com/doc/refman/8.4/en/thread-pool-tuning.html
Of chief importance is the number of thread groups in the thread pool, which can be set on server startup using the --thread-pool-size option; this cannot be changed at runtime. This section provides guidelines on determining the best configuration ...
https://dev.mysql.com/doc/refman/8.4/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. (This is the same type of conversion performed by the CONVERT_TZ() ...
https://dev.mysql.com/doc/refman/8.4/en/triggers.html
Important MySQL triggers activate only for changes made to tables by SQL statements. A trigger is a named database object that is associated with a table, and that activates when a particular event occurs for the table. Some uses for triggers are ...
https://dev.mysql.com/doc/refman/8.4/en/update-optimization.html
If you do this often, it is very important to use OPTIMIZE TABLE occasionally. An update statement is optimized like a SELECT query with the additional overhead of a write. The speed of the write depends on the amount of data being updated and the ...