Search Results
https://dev.mysql.com/doc/refman/8.4/en/show-create-user.html
The statement requires the SELECT privilege for the mysql system schema, except to see information for the current user. For the current user, the SELECT privilege for the mysql.user system table is required for display of the password hash in the ... SHOW CREATE USER user This statement shows the CREATE USER statement that creates the named ...
https://dev.mysql.com/doc/refman/8.4/en/show-variables.html
SHOW [GLOBAL | SESSION] VARIABLES [LIKE 'pattern' | WHERE expr] SHOW VARIABLES shows the values of MySQL system variables (see Section 7.1.8, “Server System Variables”). These are the values used to initialize the corresponding session ...
https://dev.mysql.com/doc/refman/8.4/en/spatial-geohash-functions.html
mysql> SELECT ST_GeoHash(180,0,10), ST_GeoHash(-180,-90,15); +----------------------+-------------------------+ | ST_GeoHash(180,0,10) | ST_GeoHash(-180,-90,15) | +----------------------+-------------------------+ | xbpbpbpbpb | 000000000000000 | ...
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”). (Prior to MySQL 8.4, the optimizer performs comparisons of SPATIAL index values using Cartesian calculations; the ...The optimizer checks the SRID attribute for indexed columns to determine which spatial reference system (SRS) to use for comparisons, and uses calculations appropriate to the ...
https://dev.mysql.com/doc/refman/8.4/en/structured-system-variables.html
The following example starts the server with three different key caches having sizes in a 3:1:1 ratio: $> mysqld --key_buffer_size=6M \ --hot_cache.key_buffer_size=2M \ --cold_cache.key_buffer_size=2M Structured variable values may be set and ... A ...
https://dev.mysql.com/doc/refman/8.4/en/sys-list-add.html
Example mysql> SELECT @@sql_mode; +----------------------------------------+ | @@sql_mode | +----------------------------------------+ | ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES | +----------------------------------------+ mysql> SET @@sql_mode = ...
https://dev.mysql.com/doc/refman/8.4/en/table-size-limit.html
The effective maximum table size for MySQL databases is usually determined by operating system constraints on file sizes, not by MySQL internal limits. Windows users, please note that FAT and VFAT (FAT32) are not considered suitable for production ...For up-to-date information operating system file size limits, refer to the documentation specific to your operating ...
https://dev.mysql.com/doc/refman/8.4/en/telemetry-trace-install.html
Installing Client Plugin The Telemetry plugin for the MySQL client can be enabled with a command line switch, --telemetry_client or from a configuration option, telemetry-client=ON |OFF, defined in the [mysql] section of the configuration file.
https://dev.mysql.com/doc/refman/8.4/en/triggers.html
Important MySQL triggers activate only for changes made to tables by SQL statements. Triggers do not activate for changes to tables made by APIs that do not transmit SQL statements to the MySQL Server. Additional Resources You may find the MySQL ...
https://dev.mysql.com/doc/refman/8.4/en/using-innodb-tables.html
However, the ENGINE clause is useful if the CREATE TABLE statement is to be replayed on a different MySQL Server instance where the default storage engine is not InnoDB or is unknown. You can determine the default storage engine on a MySQL Server ...