1########################################## 2# Run plugin 3########################################## 4SHOW PROCESSLIST; 5Id User Host db Command Time State Info Rows_sent Rows_examined 6ID root HOST_NAME test Query TIME starting SHOW PROCESSLIST 0 0 7INSTALL PLUGIN test_x_sessions_init SONAME 'libtest_x_sessions_init.so'; 8SHOW VARIABLES LIKE '%test_x_session%'; 9Variable_name Value 10test_x_sessions_init_nb_sessions 5 11SHOW PROCESSLIST; 12Id User Host db Command Time State Info Rows_sent Rows_examined 13ID root HOST_NAME test Query TIME starting SHOW PROCESSLIST 0 0 14########################################## 15# Stop plugin 16########################################## 17UNINSTALL PLUGIN test_x_sessions_init; 18########################################## 19# Plugin log 20########################################## 21======================================================================== 22Test in a server thread 23srv_session_open 0 24srv_session_open 1 25srv_session_open 2 26srv_session_open 3 27srv_session_open 4 28Number of threads of this plugin: 0 29Number of threads of all (NULL) plugins: 0 30srv_session_close 4 31srv_session_close 3 32srv_session_close 2 33srv_session_close 1 34srv_session_close 0 35srv_session_open 0 36srv_session_open 1 37srv_session_open 2 38srv_session_open 3 39srv_session_open 4 40Number of open sessions: 5 41srv_session_close 0 42srv_session_close 1 43srv_session_close 2 44srv_session_close 3 45srv_session_close 4 46Number of open sessions: 0 47Number of threads: 0 48Follows threaded run 49======================================================================== 50init thread 51srv_session_open 0 52srv_session_open 1 53srv_session_open 2 54srv_session_open 3 55srv_session_open 4 56Number of threads of this plugin: 1 57Number of threads of all (NULL) plugins: 1 58srv_session_close 4 59srv_session_close 3 60srv_session_close 2 61srv_session_close 1 62srv_session_close 0 63deinit thread 64======================================================================== 65init thread 66srv_session_open 0 67srv_session_open 1 68srv_session_open 2 69srv_session_open 3 70srv_session_open 4 71Number of open sessions: 5 72srv_session_close 0 73srv_session_close 1 74srv_session_close 2 75srv_session_close 3 76srv_session_close 4 77Number of open sessions: 0 78deinit thread 79======================================================================== 80init thread 81deinit thread 82