1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
|
##########################################
# Run plugin
##########################################
INSTALL PLUGIN test_sql_shutdown SONAME 'TEST_SQL_SHUTDOWN';
SELECT count(*) FROM information_schema.processlist WHERE info LIKE 'PLUGIN%';
count(*)
1
Warnings:
Warning 1287 'INFORMATION_SCHEMA.PROCESSLIST' is deprecated and will be removed in a future release. Please use performance_schema.processlist instead
##########################################
# Shutdown
##########################################
======================================================
Opening a Session
======================================================
Apparently the server is shutting down
SELECT 1, 2, 3 FROM DUAL
ERROR 3169 : Session was killed
Closing Session. Plugin init cycle = 1
SERVER SHUTDOWN
##########################################
# Restart
##########################################
======================================================
Opening a Session
ERROR 3168 : Server isn't available
======================================================
SELECT 1, 2, 3 FROM DUAL
Closing Session. Plugin init cycle = 2
SELECT plugin_name, plugin_status, plugin_type,
plugin_description, load_option
FROM information_schema.plugins
WHERE plugin_name LIKE "test_sql_shutdown";
plugin_name plugin_status plugin_type plugin_description load_option
test_sql_shutdown ACTIVE DAEMON Test SQL shutdown ON
##########################################
# Stop plugin
##########################################
UNINSTALL PLUGIN test_sql_shutdown;
|
