Search Results
https://dev.mysql.com/doc/refman/8.4/en/server-configuration-defaults.html
The MySQL server has many operating parameters, which you can change at server startup using command-line options or configuration files (option files). For general instructions on setting parameters at startup or runtime, see Section 7.1.7, ...
https://dev.mysql.com/doc/refman/8.4/en/server-status-variables.html
Each object is the privilege combination of a user and its active roles. The MySQL server maintains many status variables that provide information about its operation. You can view these variables and their values by using the SHOW [GLOBAL | ...
https://dev.mysql.com/doc/refman/8.4/en/set.html
A SET is a string object that can have zero or more values, each of which must be chosen from a list of permitted values specified when the table is created. SET column values that consist of multiple set members are specified with members ...
https://dev.mysql.com/doc/refman/8.4/en/show-procedure-status.html
SHOW PROCEDURE STATUS [LIKE 'pattern' | WHERE expr] This statement is a MySQL extension. It returns characteristics of a stored procedure, such as the database, name, type, creator, creation and modification dates, and character set information. A ...
https://dev.mysql.com/doc/refman/8.4/en/show-processlist.html
SHOW [FULL] PROCESSLIST Important The INFORMATION SCHEMA implementation of SHOW PROCESSLIST is deprecated and subject to removal in a future MySQL release. It is recommended to use the Performance Schema implementation of SHOW PROCESSLIST instead.
https://dev.mysql.com/doc/refman/8.4/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”). Note If you specify the TABLE log destination, see Log Tables and “Too ...
https://dev.mysql.com/doc/refman/8.4/en/sorting-rows.html
You may have noticed in the preceding examples that the result rows are displayed in no particular order. It is often easier to examine query output when the rows are sorted in some meaningful way. This means that the order is undefined for columns ...
https://dev.mysql.com/doc/refman/8.4/en/spatial-geojson-functions.html
This section describes functions for converting between GeoJSON documents and spatial values. Feature and FeatureCollection objects are not supported, except that geometry objects are extracted from them. MySQL also supports a native JSON data type ...
https://dev.mysql.com/doc/refman/8.4/en/statement-labels.html
[begin_label:] BEGIN [statement_list] END [end_label] [begin_label:] LOOP statement_list END LOOP [end_label] [begin_label:] REPEAT statement_list UNTIL search_condition END REPEAT [end_label] [begin_label:] WHILE search_condition DO statement_list ...
https://dev.mysql.com/doc/refman/8.4/en/stored-programs-logging.html
The binary log contains information about SQL statements that modify database contents. This information is stored in the form of “events” that describe the modifications. (Binary log events differ from scheduled event stored objects.) The ...