extract_schema_from_file_name |
def |
sys |
extract_schema_from_file_name |
FUNCTION |
varchar |
64 |
256 |
NULL
|
NULL
|
NULL
|
utf8mb4 |
utf8mb4_0900_ai_ci |
varchar(64) |
SQL |
BEGIN
RETURN LEFT(SUBSTRING_INDEX(SUBSTRING_IN...
|
NULL
|
SQL |
SQL |
YES |
NO SQL |
NULL
|
INVOKER |
2019-10-30 15:09:30 |
2019-10-30 15:09:30 |
ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_... |
Description
-----------
Takes a raw file path, a... |
mysql.sys@localhost |
utf8mb4 |
utf8mb4_0900_ai_ci |
utf8mb4_0900_ai_ci |
extract_table_from_file_name |
def |
sys |
extract_table_from_file_name |
FUNCTION |
varchar |
64 |
256 |
NULL
|
NULL
|
NULL
|
utf8mb4 |
utf8mb4_0900_ai_ci |
varchar(64) |
SQL |
BEGIN
RETURN LEFT(SUBSTRING_INDEX(REPLACE(SUBS...
|
NULL
|
SQL |
SQL |
YES |
NO SQL |
NULL
|
INVOKER |
2019-10-30 15:09:30 |
2019-10-30 15:09:30 |
ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_... |
Description
-----------
Takes a raw file path, a... |
mysql.sys@localhost |
utf8mb4 |
utf8mb4_0900_ai_ci |
utf8mb4_0900_ai_ci |
format_bytes |
def |
sys |
format_bytes |
FUNCTION |
text |
65535 |
65535 |
NULL
|
NULL
|
NULL
|
utf8mb4 |
utf8mb4_0900_ai_ci |
text |
SQL |
BEGIN
IF bytes IS NULL THEN RETURN NULL;
ELSEI...
|
NULL
|
SQL |
SQL |
YES |
NO SQL |
NULL
|
INVOKER |
2019-10-30 15:09:30 |
2019-10-30 15:09:30 |
ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_... |
Description
-----------
Takes a raw bytes value,... |
mysql.sys@localhost |
utf8mb4 |
utf8mb4_0900_ai_ci |
utf8mb4_0900_ai_ci |
format_path |
def |
sys |
format_path |
FUNCTION |
varchar |
512 |
2048 |
NULL
|
NULL
|
NULL
|
utf8mb4 |
utf8mb4_0900_ai_ci |
varchar(512) |
SQL |
BEGIN
DECLARE v_path VARCHAR(512);
DECLARE v_u...
|
NULL
|
SQL |
SQL |
YES |
NO SQL |
NULL
|
INVOKER |
2019-10-30 15:09:30 |
2019-10-30 15:09:30 |
ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_... |
Description
-----------
Takes a raw path value, ... |
mysql.sys@localhost |
utf8mb4 |
utf8mb4_0900_ai_ci |
utf8mb4_0900_ai_ci |
format_statement |
def |
sys |
format_statement |
FUNCTION |
longtext |
4294967295 |
4294967295 |
NULL
|
NULL
|
NULL
|
utf8mb4 |
utf8mb4_0900_ai_ci |
longtext |
SQL |
BEGIN
-- Check if we have the configured length,...
|
NULL
|
SQL |
SQL |
YES |
NO SQL |
NULL
|
INVOKER |
2019-10-30 15:09:30 |
2019-10-30 15:09:30 |
ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_... |
Description
-----------
Formats a normalized sta... |
mysql.sys@localhost |
utf8mb4 |
utf8mb4_0900_ai_ci |
utf8mb4_0900_ai_ci |
format_time |
def |
sys |
format_time |
FUNCTION |
text |
65535 |
65535 |
NULL
|
NULL
|
NULL
|
utf8mb4 |
utf8mb4_0900_ai_ci |
text |
SQL |
BEGIN
IF picoseconds IS NULL THEN RETURN NULL;
...
|
NULL
|
SQL |
SQL |
YES |
NO SQL |
NULL
|
INVOKER |
2019-10-30 15:09:30 |
2019-10-30 15:09:30 |
ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_... |
Description
-----------
Takes a raw picoseconds ... |
mysql.sys@localhost |
utf8mb4 |
utf8mb4_0900_ai_ci |
utf8mb4_0900_ai_ci |
list_add |
def |
sys |
list_add |
FUNCTION |
text |
65535 |
65535 |
NULL
|
NULL
|
NULL
|
utf8mb4 |
utf8mb4_0900_ai_ci |
text |
SQL |
BEGIN
IF (in_add_value IS NULL) THEN
S...
|
NULL
|
SQL |
SQL |
YES |
CONTAINS SQL |
NULL
|
INVOKER |
2019-10-30 15:09:30 |
2019-10-30 15:09:30 |
ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_... |
Description
-----------
Takes a list, and a valu... |
mysql.sys@localhost |
utf8mb4 |
utf8mb4_0900_ai_ci |
utf8mb4_0900_ai_ci |
list_drop |
def |
sys |
list_drop |
FUNCTION |
text |
65535 |
65535 |
NULL
|
NULL
|
NULL
|
utf8mb4 |
utf8mb4_0900_ai_ci |
text |
SQL |
BEGIN
IF (in_drop_value IS NULL) THEN
...
|
NULL
|
SQL |
SQL |
YES |
CONTAINS SQL |
NULL
|
INVOKER |
2019-10-30 15:09:30 |
2019-10-30 15:09:30 |
ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_... |
Description
-----------
Takes a list, and a valu... |
mysql.sys@localhost |
utf8mb4 |
utf8mb4_0900_ai_ci |
utf8mb4_0900_ai_ci |
ps_is_account_enabled |
def |
sys |
ps_is_account_enabled |
FUNCTION |
enum |
3 |
12 |
NULL
|
NULL
|
NULL
|
utf8mb4 |
utf8mb4_0900_ai_ci |
enum('YES','NO') |
SQL |
BEGIN
RETURN IF(EXISTS(SELECT 1
...
|
NULL
|
SQL |
SQL |
YES |
READS SQL DATA |
NULL
|
INVOKER |
2019-10-30 15:09:30 |
2019-10-30 15:09:30 |
ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_... |
Description
-----------
Determines whether instr... |
mysql.sys@localhost |
utf8mb4 |
utf8mb4_0900_ai_ci |
utf8mb4_0900_ai_ci |
ps_is_consumer_enabled |
def |
sys |
ps_is_consumer_enabled |
FUNCTION |
enum |
3 |
12 |
NULL
|
NULL
|
NULL
|
utf8mb4 |
utf8mb4_0900_ai_ci |
enum('YES','NO') |
SQL |
BEGIN
DECLARE v_is_enabled ENUM('YES', 'NO') D...
|
NULL
|
SQL |
SQL |
YES |
READS SQL DATA |
NULL
|
INVOKER |
2019-10-30 15:09:30 |
2019-10-30 15:09:30 |
ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_... |
Description
-----------
Determines whether a con... |
mysql.sys@localhost |
utf8mb4 |
utf8mb4_0900_ai_ci |
utf8mb4_0900_ai_ci |
ps_is_instrument_default_enabled |
def |
sys |
ps_is_instrument_default_enabled |
FUNCTION |
enum |
3 |
12 |
NULL
|
NULL
|
NULL
|
utf8mb4 |
utf8mb4_0900_ai_ci |
enum('YES','NO') |
SQL |
BEGIN
DECLARE v_enabled ENUM('YES', 'NO');
...
|
NULL
|
SQL |
SQL |
YES |
READS SQL DATA |
NULL
|
INVOKER |
2019-10-30 15:09:30 |
2019-10-30 15:09:30 |
ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_... |
Description
-----------
Returns whether an instr... |
mysql.sys@localhost |
utf8mb4 |
utf8mb4_0900_ai_ci |
utf8mb4_0900_ai_ci |
ps_is_instrument_default_timed |
def |
sys |
ps_is_instrument_default_timed |
FUNCTION |
enum |
3 |
12 |
NULL
|
NULL
|
NULL
|
utf8mb4 |
utf8mb4_0900_ai_ci |
enum('YES','NO') |
SQL |
BEGIN
DECLARE v_timed ENUM('YES', 'NO');
-...
|
NULL
|
SQL |
SQL |
YES |
READS SQL DATA |
NULL
|
INVOKER |
2019-10-30 15:09:30 |
2019-10-30 15:09:30 |
ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_... |
Description
-----------
Returns whether an instr... |
mysql.sys@localhost |
utf8mb4 |
utf8mb4_0900_ai_ci |
utf8mb4_0900_ai_ci |
ps_is_thread_instrumented |
def |
sys |
ps_is_thread_instrumented |
FUNCTION |
enum |
7 |
28 |
NULL
|
NULL
|
NULL
|
utf8mb4 |
utf8mb4_0900_ai_ci |
enum('YES','NO','UNKNOWN') |
SQL |
BEGIN
DECLARE v_enabled ENUM('YES', 'NO', 'UNK...
|
NULL
|
SQL |
SQL |
NO |
READS SQL DATA |
NULL
|
INVOKER |
2019-10-30 15:09:30 |
2019-10-30 15:09:30 |
ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_... |
Description
-----------
Checks whether the provi... |
mysql.sys@localhost |
utf8mb4 |
utf8mb4_0900_ai_ci |
utf8mb4_0900_ai_ci |
ps_thread_id |
def |
sys |
ps_thread_id |
FUNCTION |
bigint |
NULL
|
NULL
|
20 |
0 |
NULL
|
NULL
|
NULL
|
bigint(20) unsigned |
SQL |
BEGIN
RETURN (SELECT THREAD_ID
F...
|
NULL
|
SQL |
SQL |
NO |
READS SQL DATA |
NULL
|
INVOKER |
2019-10-30 15:09:30 |
2019-10-30 15:09:30 |
ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_... |
Description
-----------
Return the Performance S... |
mysql.sys@localhost |
utf8mb4 |
utf8mb4_0900_ai_ci |
utf8mb4_0900_ai_ci |
ps_thread_account |
def |
sys |
ps_thread_account |
FUNCTION |
text |
65535 |
65535 |
NULL
|
NULL
|
NULL
|
utf8mb4 |
utf8mb4_0900_ai_ci |
text |
SQL |
BEGIN
RETURN (SELECT IF(
...
|
NULL
|
SQL |
SQL |
NO |
READS SQL DATA |
NULL
|
INVOKER |
2019-10-30 15:09:30 |
2019-10-30 15:09:30 |
ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_... |
Description
-----------
Return the user@host acc... |
mysql.sys@localhost |
utf8mb4 |
utf8mb4_0900_ai_ci |
utf8mb4_0900_ai_ci |
ps_thread_stack |
def |
sys |
ps_thread_stack |
FUNCTION |
longtext |
4294967295 |
4294967295 |
NULL
|
NULL
|
NULL
|
latin1 |
latin1_swedish_ci |
longtext |
SQL |
BEGIN
DECLARE json_objects LONGTEXT;
...
|
NULL
|
SQL |
SQL |
NO |
READS SQL DATA |
NULL
|
INVOKER |
2019-10-30 15:09:30 |
2019-10-30 15:09:30 |
ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_... |
Description
-----------
Outputs a JSON formatted... |
mysql.sys@localhost |
utf8mb4 |
utf8mb4_0900_ai_ci |
utf8mb4_0900_ai_ci |
ps_thread_trx_info |
def |
sys |
ps_thread_trx_info |
FUNCTION |
longtext |
4294967295 |
4294967295 |
NULL
|
NULL
|
NULL
|
utf8mb4 |
utf8mb4_0900_ai_ci |
longtext |
SQL |
BEGIN
DECLARE v_output LONGTEXT DEFAULT '{}';
...
|
NULL
|
SQL |
SQL |
NO |
READS SQL DATA |
NULL
|
INVOKER |
2019-10-30 15:09:30 |
2019-10-30 15:09:30 |
ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_... |
Description
-----------
Returns a JSON object wi... |
mysql.sys@localhost |
utf8mb4 |
utf8mb4_0900_ai_ci |
utf8mb4_0900_ai_ci |
quote_identifier |
def |
sys |
quote_identifier |
FUNCTION |
text |
65535 |
65535 |
NULL
|
NULL
|
NULL
|
utf8mb4 |
utf8mb4_0900_ai_ci |
text |
SQL |
BEGIN
RETURN CONCAT('`', REPLACE(in_identifier...
|
NULL
|
SQL |
SQL |
YES |
NO SQL |
NULL
|
INVOKER |
2019-10-30 15:09:30 |
2019-10-30 15:09:30 |
ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_... |
Description
-----------
Takes an unquoted identi... |
mysql.sys@localhost |
utf8mb4 |
utf8mb4_0900_ai_ci |
utf8mb4_0900_ai_ci |
sys_get_config |
def |
sys |
sys_get_config |
FUNCTION |
varchar |
128 |
512 |
NULL
|
NULL
|
NULL
|
utf8mb4 |
utf8mb4_0900_ai_ci |
varchar(128) |
SQL |
BEGIN
DECLARE v_value VARCHAR(128) DEFAULT NUL...
|
NULL
|
SQL |
SQL |
YES |
READS SQL DATA |
NULL
|
INVOKER |
2019-10-30 15:09:30 |
2019-10-30 15:09:30 |
ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_... |
Description
-----------
Returns the value for th... |
mysql.sys@localhost |
utf8mb4 |
utf8mb4_0900_ai_ci |
utf8mb4_0900_ai_ci |
version_major |
def |
sys |
version_major |
FUNCTION |
tinyint |
NULL
|
NULL
|
3 |
0 |
NULL
|
NULL
|
NULL
|
tinyint(3) unsigned |
SQL |
BEGIN
RETURN SUBSTRING_INDEX(SUBSTRING_INDEX(V...
|
NULL
|
SQL |
SQL |
NO |
NO SQL |
NULL
|
INVOKER |
2019-10-30 15:09:30 |
2019-10-30 15:09:30 |
ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_... |
Description
-----------
Returns the major versio... |
mysql.sys@localhost |
utf8mb4 |
utf8mb4_0900_ai_ci |
utf8mb4_0900_ai_ci |
version_minor |
def |
sys |
version_minor |
FUNCTION |
tinyint |
NULL
|
NULL
|
3 |
0 |
NULL
|
NULL
|
NULL
|
tinyint(3) unsigned |
SQL |
BEGIN
RETURN SUBSTRING_INDEX(SUBSTRING_INDEX(S...
|
NULL
|
SQL |
SQL |
NO |
NO SQL |
NULL
|
INVOKER |
2019-10-30 15:09:30 |
2019-10-30 15:09:30 |
ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_... |
Description
-----------
Returns the minor (relea... |
mysql.sys@localhost |
utf8mb4 |
utf8mb4_0900_ai_ci |
utf8mb4_0900_ai_ci |
version_patch |
def |
sys |
version_patch |
FUNCTION |
tinyint |
NULL
|
NULL
|
3 |
0 |
NULL
|
NULL
|
NULL
|
tinyint(3) unsigned |
SQL |
BEGIN
RETURN SUBSTRING_INDEX(SUBSTRING_INDEX(V...
|
NULL
|
SQL |
SQL |
NO |
NO SQL |
NULL
|
INVOKER |
2019-10-30 15:09:30 |
2019-10-30 15:09:30 |
ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_... |
Description
-----------
Returns the patch releas... |
mysql.sys@localhost |
utf8mb4 |
utf8mb4_0900_ai_ci |
utf8mb4_0900_ai_ci |
create_synonym_db |
def |
sys |
create_synonym_db |
PROCEDURE |
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
SQL |
BEGIN
DECLARE v_done bool DEFAULT FALSE;
D...
|
NULL
|
SQL |
SQL |
NO |
MODIFIES SQL DATA |
NULL
|
INVOKER |
2019-10-30 15:09:31 |
2019-10-30 15:09:31 |
ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_... |
Description
-----------
Takes a source database ... |
mysql.sys@localhost |
utf8mb4 |
utf8mb4_0900_ai_ci |
utf8mb4_0900_ai_ci |
execute_prepared_stmt |
def |
sys |
execute_prepared_stmt |
PROCEDURE |
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
SQL |
BEGIN
-- Set configuration options
IF (@sy...
|
NULL
|
SQL |
SQL |
NO |
READS SQL DATA |
NULL
|
INVOKER |
2019-10-30 15:09:31 |
2019-10-30 15:09:31 |
ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_... |
Description
-----------
Takes the query in the a... |
mysql.sys@localhost |
utf8mb4 |
utf8mb4_0900_ai_ci |
utf8mb4_0900_ai_ci |
diagnostics |
def |
sys |
diagnostics |
PROCEDURE |
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
SQL |
BEGIN
DECLARE v_start, v_runtime, v_iter_start...
|
NULL
|
SQL |
SQL |
NO |
READS SQL DATA |
NULL
|
INVOKER |
2019-10-30 15:09:31 |
2019-10-30 15:09:31 |
ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_... |
Description
-----------
Create a report of the c... |
mysql.sys@localhost |
utf8mb4 |
utf8mb4_0900_ai_ci |
utf8mb4_0900_ai_ci |