blob: 0ee9bb50f2b2d17a209ac563042258ac8cd3da0d (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
|
-- source include/not_embedded.inc
# Tests for sys schema
# Verify the sys.ps_is_thread_instrumented() function perfoms as expected
# Passing NULL/nothing should return NULL
SELECT sys.ps_is_thread_instrumented(NULL);
# By default current thread should be instrumented
SELECT sys.ps_is_thread_instrumented(CONNECTION_ID());
# Now toggle our thread to off and re-check
UPDATE performance_schema.threads SET instrumented = 'NO' WHERE processlist_id = CONNECTION_ID();
SELECT sys.ps_is_thread_instrumented(CONNECTION_ID());
# Try some huge number to check unknown connections
SELECT sys.ps_is_thread_instrumented(234623462376);
--source ../include/ps_threads_cleanup.inc
|