PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 297.1Kb
Man Pages (Zip)
- 402.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/server-plugins.html
The plugins supported by this interface include, but are not limited to, storage engines, INFORMATION_SCHEMA tables, full-text parser plugins, and server extensions. MySQL supports an plugin API that enables creation of server plugins. Plugins can ...
https://dev.mysql.com/doc/refman/8.0/en/set-resource-group.html
Thread IDs can be determined from the Performance Schema threads table. An alternative to SET RESOURCE GROUP is the RESOURCE_GROUP optimizer hint, which assigns individual statements to a resource group. SET RESOURCE GROUP group_name [FOR thread_id ...
https://dev.mysql.com/doc/refman/8.0/en/show-character-set.html
Character set information is also available from the INFORMATION_SCHEMA CHARACTER_SETS table. SHOW {CHARACTER SET | CHARSET} [LIKE 'pattern' | WHERE expr] The SHOW CHARACTER SET statement shows all available character sets. The LIKE clause, if ...
https://dev.mysql.com/doc/refman/8.0/en/show-create-database.html
row *************************** Database: test Create Database: CREATE DATABASE `test` /*!40100 DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci */ /*!80014 DEFAULT ENCRYPTION='N' */ SHOW CREATE DATABASE quotes table and column names ...
https://dev.mysql.com/doc/refman/8.0/en/show-create-user.html
For the current user, the SELECT privilege for the mysql.user system table is required for display of the password hash in the IDENTIFIED AS clause; otherwise, the hash displays as <secret>. Password hash values displayed in the IDENTIFIED WITH ...
https://dev.mysql.com/doc/refman/8.0/en/source-installation-layout.html
See Table 2.3, “MySQL Installation Layout for Generic Unix/Linux Binary Package”, and Section 2.3.1, “MySQL Installation Layout on Microsoft Windows”. By default, when you install MySQL after compiling it from source, the installation step ...
https://dev.mysql.com/doc/refman/8.0/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.0/en/spatial-index-optimization.html
MySQL still maintains such indexes, as follows: They are updated for table modifications (INSERT, UPDATE, DELETE, and so forth). MySQL permits creation of SPATIAL indexes on NOT NULL geometry-valued columns (see Section 13.4.10, “Creating Spatial ...
https://dev.mysql.com/doc/refman/8.0/en/spatial-types.html
MySQL spatial extensions enable the generation, storage, and analysis of geographic features: Data types for representing spatial values Functions for manipulating spatial values Spatial indexing for improved access times to spatial columns The ...
https://dev.mysql.com/doc/refman/8.0/en/start-replica.html
Important The password that you set using START REPLICA is masked when it is written to MySQL Server’s logs, Performance Schema tables, and SHOW PROCESSLIST statements. START REPLICA [thread_types] [until_option] [connection_options] ...