PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 256.4Kb
Man Pages (Zip)
- 361.3Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
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, ...
https://dev.mysql.com/doc/refman/5.7/en/sys-schema-redundant-indexes.html
The schema_redundant_indexes view displays indexes that duplicate other indexes or are made redundant by them. In the following column descriptions, the dominant index is the one that makes the redundant index redundant. The ...
https://dev.mysql.com/doc/refman/5.7/en/sys-schema-reference.html
The sys schema includes tables and triggers, views, and stored procedures and functions.
https://dev.mysql.com/doc/refman/5.7/en/sys-schema-unused-indexes.html
These views display indexes for which there are no events, which indicates that they are not being used. This view is most useful when the server has been up and processing long enough that its workload is representative. Otherwise, presence of an ...