Search Results
https://dev.mysql.com/doc/refman/8.4/en/server-plugins.html
MySQL supports an plugin API that enables creation of server plugins. Group Replication enables you to create a highly available distributed MySQL service across a group of MySQL server instances, with data consistency, conflict detection and ...
https://dev.mysql.com/doc/refman/8.4/en/set-transaction.html
In read-only mode, it remains possible to change tables created with the TEMPORARY keyword using DML statements. transaction_characteristic: { ISOLATION LEVEL level | access_mode } level: { REPEATABLE READ | READ COMMITTED | READ UNCOMMITTED | ...
https://dev.mysql.com/doc/refman/8.4/en/show-tables.html
The optional EXTENDED modifier causes SHOW TABLES to list hidden tables created by failed ALTER TABLE statements. SHOW [EXTENDED] [FULL] TABLES [{FROM | IN} db_name] [LIKE 'pattern' | WHERE expr] SHOW TABLES lists the non-TEMPORARY tables in a ...
https://dev.mysql.com/doc/refman/8.4/en/solaris-installation-pkg.html
To enable MySQL to startup and shutdown automatically, you should create a link between this file and the init script directories. You can install MySQL on Solaris using a binary package of the native Solaris PKG format instead of the binary ...
https://dev.mysql.com/doc/refman/8.4/en/sorted-index-builds.html
InnoDB performs a bulk load instead of inserting one index record at a time when creating or rebuilding indexes. This method of index creation is also known as a sorted index build. Sorted Index Builds and Compressed Tables For compressed tables, ...In the first phase, the clustered index is scanned, and index entries are generated and added to the sort ...
https://dev.mysql.com/doc/refman/8.4/en/source-installation-doxygen.html
When you install PlantUML on Windows (tested on Windows 10), you must run it at least once as administrator so it creates the registry keys. The MySQL source code contains internal documentation written using Doxygen. It is also possible to ...
https://dev.mysql.com/doc/refman/8.4/en/spatial-aggregate-functions.html
MySQL supports aggregate functions that perform a calculation on a set of values. For general information about these functions, see Section 14.19.1, “Aggregate Function Descriptions”. ST_Collect() can be used as a window function, as signified ...
https://dev.mysql.com/doc/refman/8.4/en/spatial-index-optimization.html
MySQL permits creation of SPATIAL indexes on NOT NULL geometry-valued columns (see Section 13.4.10, “Creating Spatial Indexes”). The optimizer checks the SRID attribute for indexed columns to determine which spatial reference system (SRS) to ...
https://dev.mysql.com/doc/refman/8.4/en/spatial-operator-functions.html
This function processes geometry collections by extracting all vertex points of all components of the collection, creating a MultiPoint value from them, and computing its convex hull. OpenGIS proposes a number of functions that can produce ...
https://dev.mysql.com/doc/refman/8.4/en/starting-server-troubleshooting.html
You can create a my.cnf file and specify startup options for the engines that you plan to use. This section provides troubleshooting suggestions for problems starting the server. For additional suggestions for Windows systems, see Section 2.3.4, ...