PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 297.2Kb
Man Pages (Zip)
- 402.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/set-variable.html
The Performance Schema persisted_variables table provides an SQL interface to the mysqld-auto.cnf file, enabling its contents to be inspected at runtime using SELECT statements. For example, you can retrieve system variable values in a SELECT ...
https://dev.mysql.com/doc/refman/8.0/en/slow-query-log.html
To specify the log destination, use the log_output system variable (as described in Section 7.4.1, “Selecting General Query Log and Slow Query Log Output Destinations”). However, further logging of queries to the file does not occur unless the ... The slow query log consists of SQL statements that take more than long_query_time seconds to execute and require at least min_examined_row_limit rows to be ...
https://dev.mysql.com/doc/refman/8.0/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.0/en/spatial-geojson-functions.html
mysql> SELECT ST_AsGeoJSON(ST_GeomFromText('POINT(11.11111 12.22222)'),2); +-------------------------------------------------------------+ | ST_AsGeoJSON(ST_GeomFromText('POINT(11.11111 12.22222)'),2) | ... This section describes functions for ...
https://dev.mysql.com/doc/refman/8.0/en/sys-schema-usage.html
Most of these views come in pairs, such that one member of the pair has the same name as the other member, plus a x$ prefix. The view with the x$ prefix that displays the same values in raw form is intended more for use with other tools that perform ...
https://dev.mysql.com/doc/refman/8.0/en/access-control.html
The primary function of the MySQL privilege system is to authenticate a user who connects from a given host and to associate that user with privileges on a database such as SELECT, INSERT, UPDATE, and DELETE. For example, if you try to select rows ... MySQL enables the creation of accounts that permit client users to connect to the server and access data managed by the ...
https://dev.mysql.com/doc/refman/8.0/en/alter-database.html
The following list details affected SQL statements and operations: The database itself: CREATE DATABASE ALTER DATABASE (except to change the READ ONLY option) DROP DATABASE Views: CREATE VIEW ALTER VIEW DROP VIEW Selecting from views that invoke ...
https://dev.mysql.com/doc/refman/8.0/en/analyze-table.html
mysql> SELECT HISTOGRAM->>'$."sampling-rate"' FROM INFORMATION_SCHEMA.COLUMN_STATISTICS WHERE TABLE_NAME = "employees" AND COLUMN_NAME = "birth_date"; +---------------------------------+ | HISTOGRAM->>'$."sampling-rate"' | ...ANALYZE ...
https://dev.mysql.com/doc/refman/8.0/en/audit-log-legacy-filtering.html
For any of those values, the audit log plugin logs all selected events without distinction as to success or failure. Note This section describes legacy audit log filtering, which applies if the audit_log plugin is installed without the accompanying ...
https://dev.mysql.com/doc/refman/8.0/en/audit-log.html
To select the file format, set the audit_log_format system variable at server startup. For more information about controlling how logging occurs, including audit log file naming and format selection, see Section 8.4.5.5, “Configuring Audit Logging ... Note MySQL Enterprise Audit is an extension included in MySQL Enterprise Edition, a commercial ...