PDF (US Ltr)
- 41.8Mb
PDF (A4)
- 41.9Mb
Man Pages (TGZ)
- 272.3Kb
Man Pages (Zip)
- 378.3Kb
Info (Gzip)
- 4.2Mb
Info (Zip)
- 4.2Mb
Search Results
https://dev.mysql.com/doc/refman/9.7/en/server-options.html
When you start the mysqld server, you can specify program options using any of the methods described in Section 6.2.2, “Specifying Program Options”. The most common methods are to provide options in an option file or on the command line.
https://dev.mysql.com/doc/refman/9.7/en/server-status-variables.html
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 | SESSION] STATUS statement (see Section 15.7.7.39, “SHOW STATUS Statement”).
https://dev.mysql.com/doc/refman/9.7/en/server-system-variable-reference.html
The following table lists all system variables applicable within mysqld. The table lists command-line options (Cmd-line), options valid in configuration files (Option file), server system variables (System Var), and status variables (Status var) in ...
https://dev.mysql.com/doc/refman/9.7/en/show-columns.html
SHOW [EXTENDED] [FULL] {COLUMNS | FIELDS} {FROM | IN} tbl_name [{FROM | IN} db_name] [LIKE 'pattern' | WHERE expr] SHOW COLUMNS displays information about the columns in a given table. SHOW COLUMNS displays information only for those columns for ...
https://dev.mysql.com/doc/refman/9.7/en/show-create-trigger.html
SHOW CREATE TRIGGER trigger_name This statement shows the CREATE TRIGGER statement that creates the named trigger. This statement requires the TRIGGER privilege for the table associated with the trigger. row *************************** Trigger: ...
https://dev.mysql.com/doc/refman/9.7/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/9.7/en/show-triggers.html
SHOW TRIGGERS [{FROM | IN} db_name] [LIKE 'pattern' | WHERE expr] SHOW TRIGGERS lists the triggers currently defined for tables in a database (the default database unless a FROM clause is given). This statement returns results only for databases ...
https://dev.mysql.com/doc/refman/9.7/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”). System variable information is also available from these sources: ...
https://dev.mysql.com/doc/refman/9.7/en/srjsapi-routines.html
Two functions, listed here, provide JavaScript Function objects reflecting MySQL stored routines: getFunction(): Get a Function instance given the name of a stored function. getProcedure(): Get a Function instance given the name of a stored ...
https://dev.mysql.com/doc/refman/9.7/en/sys-metrics.html
This view summarizes MySQL server metrics to show variable names, values, types, and whether they are enabled. The metric type determines the source from which the name is taken: For global status variables: The VARIABLE_NAME column of the ...