PDF (US Ltr)
- 35.0Mb
PDF (A4)
- 35.1Mb
Man Pages (TGZ)
- 254.9Kb
Man Pages (Zip)
- 359.9Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/show-function-status.html
SHOW FUNCTION STATUS [LIKE 'pattern' | WHERE expr] This statement is similar to SHOW PROCEDURE STATUS but for stored functions.
https://dev.mysql.com/doc/refman/5.7/en/shutdown.html
Because status variables are initialized for each server startup and do not persist across restarts, Com_shutdown normally has a value of zero, but can be nonzero if SHUTDOWN statements were executed but failed. SIGTERM enables server shutdown to be ...SHUTDOWN provides an SQL-level interface to the same functionality available using the mysqladmin shutdown command or the mysql_shutdown() C API ...
https://dev.mysql.com/doc/refman/5.7/en/sql-statements.html
This chapter describes the syntax for the SQL statements supported by MySQL.
https://dev.mysql.com/doc/refman/5.7/en/sys-extract-schema-from-file-name.html
For this reason, it does not work with partitions or tables defined using their own DATA_DIRECTORY table option. This function is useful when extracting file I/O information from the Performance Schema that includes file path names. Given a file ...
https://dev.mysql.com/doc/refman/5.7/en/sys-list-drop.html
For more information, see the description of list_add() Parameters in_list TEXT: The list to be modified. Removes a value from a comma-separated list of values and returns the result.
https://dev.mysql.com/doc/refman/5.7/en/sys-ps-is-thread-instrumented.html
Returns YES or NO to indicate whether Performance Schema instrumentation for a given connection ID is enabled, UNKNOWN if the ID is unknown, or NULL if the ID is NULL. This is a value of the type given in the PROCESSLIST_ID column of the ...Example ...
https://dev.mysql.com/doc/refman/5.7/en/sys-ps-statement-avg-latency-histogram.html
Displays a textual histogram graph of the average latency values across all normalized statements tracked within the Performance Schema events_statements_summary_by_digest table. For example, * = 2 units in the histogram legend means that each * ...
https://dev.mysql.com/doc/refman/5.7/en/sys-ps-thread-account.html
Given a Performance Schema thread ID, returns the user_name@host_name account associated with the thread. Parameters in_thread_id BIGINT UNSIGNED: The thread ID for which to return the account. The value should match the THREAD_ID column from some ...Example mysql> SELECT sys.ps_thread_account(sys.ps_thread_id(CONNECTION_ID())); +----------------------------------------------------------+ | sys.ps_thread_account(sys.ps_thread_id(CONNECTION_ID())) | +----------------------------------------------------------+ | root@localhost | ...
https://dev.mysql.com/doc/refman/5.7/en/sys-quote-identifier.html
Given a string argument, this function produces a quoted identifier suitable for inclusion in SQL statements. This is useful when a value to be used as an identifier is a reserved word or contains backtick (`) characters. Example mysql> SELECT ...
https://dev.mysql.com/doc/refman/5.7/en/sys-schema-object-overview.html
Note For MySQL instances with a large number of objects, this view might take a long time to execute. This view summarizes the types of objects within each schema. object_type The object type: BASE TABLE, INDEX (index_type), EVENT, FUNCTION, ...