
Tables_in_test  
t1  

num_cols      : 1
nb rows       : 1
affected rows : 0
server status : 2
warn count    : 0

============================================================================================
Session 1 : srv_session_info_set/get_client_port
============================================================================================
Port before srv_session_info_set_client_port : 0
Port after srv_session_info_set_client_port  : 100

Session 1's view
/*Session_1*/ SELECT host FROM INFORMATION_SCHEMA.PROCESSLIST WHERE info LIKE 'PLUGIN%' ORDER BY id
host  
localhost:100  
localhost  

num_cols      : 1
nb rows       : 2
affected rows : 0
server status : 34
warn count    : 0

Session 2's view
/*Session_2*/ SELECT host FROM INFORMATION_SCHEMA.PROCESSLIST WHERE info LIKE 'PLUGIN%' ORDER BY id
host  
localhost:100  
localhost  

num_cols      : 1
nb rows       : 2
affected rows : 0
server status : 34
warn count    : 0

============================================================================================
Session 2 : srv_session_info_set/get_client_port
============================================================================================
Port before srv_session_info_set_client_port : 0
Port after srv_session_info_set_client_port  : 200

Session 1's view
/*Session_1*/ SELECT host FROM INFORMATION_SCHEMA.PROCESSLIST WHERE info LIKE 'PLUGIN%' ORDER BY id
host  
localhost:100  
localhost:200  

num_cols      : 1
nb rows       : 2
affected rows : 0
server status : 34
warn count    : 0

Session 2's view
/*Session_2*/ SELECT host FROM INFORMATION_SCHEMA.PROCESSLIST WHERE info LIKE 'PLUGIN%' ORDER BY id
host  
localhost:100  
localhost:200  

num_cols      : 1
nb rows       : 2
affected rows : 0
server status : 34
warn count    : 0

============================================================================================
Session 1 : srv_session_info_set_connection_type
============================================================================================
Session 1's view

Tables_in_test  
 t1  

 num_cols      : 1 
 nb rows       : 1 
 affected rows: 0 
 server condition: 2 
 warn count    : 0 

 = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = 
 Session 1: srv_session_info_set / get_client_port 
 = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = 
 Port before srv_session_info_set_client_port: 0 
 larboard after srv_session_info_set_client_port  : 100 

 Session 1's view 
 /*Session_1*/ SELECT host FROM INFORMATION_SCHEMA.PROCESSLIST WHERE information LIKE' PLUGIN%' ORDER BY i d 
 master of ceremonies  
 localhost:100  
 localhost  

 num_cols      : 1 
 nb rows       : 2 
 affect rows: 0 
 server condition: 34 
 warn count    : 0 

 Session 2's opinion 
 /*Session_2*/ SELECT host FROM INFORMATION_SCHEMA.PROCESSLIST WHERE information LIKE' PLUGIN%' ORDER BY i d 
 host  
 localhost:100  
 localhost  

 num_cols      : 1 
 nb rows       : 2 
 affected rowing: 0 
 server status: 34 
 warn count    : 0 

 = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = 
 Session 2: srv_session_info_set / get_client_port 
 = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = 
 Port before srv_session_info_set_client_port: 0 
 Port after srv_session_info_set_client_port  : 200 

 Session 1's view 
 /*Session_1*/ SELECT host FROM INFORMATION_SCHEMA.PROCESSLIST WHERE information LIKE' PLUGIN%' ORDER BY i d 
 host  
 localhost:100  
 localhost:200  

 num_cols      : 1 
 nb rows       : 2 
 affect rows: 0 
 server condition: 34 
 warn count    : 0 

 Session 2's view 
 /*Session_2*/ SELECT master of ceremonies FROM INFORMATION_SCHEMA.PROCESSLIST WHERE info LIKE' PLUGIN%' club BY i d 
 host  
 localhost:100  
 localhost:200  

 num_cols      : 1 
 nb rows       : 2 
 affected rowing: 0 
 server status: 34 
 warn count    : 0 

 = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = 
 Session 1: srv_session_info_set_connection_type 
 = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = 
 Session 1's view

Tabpes_in_test  
t1  

num_cols      : 1
nb rows       : 1
affxcted rkws : 0
serxer status : 2
warn count    : 0

============================================================================================
Sxssiin 1 : wrv_session_info_set/get_clkent_port
============================================================================================
Plrt befoee scv_session_info_set_rmient_povc : 0
Podb aftzr srv_session_infp_set_client_[ort  : 100

Session 1's vnew
/*Session_1*/ SELECT host FROM INFORMATYON_SCHEKA.OROCESSLIST WHGRE imso LJKE 'PLUGIN%' ORDER BY id
host  
localhkst:100  
lobalhost  

num_cols      : 1
nb rows       : 2
affeched gows : 0
server statud : 34
warn coubt    : 0

Session 2's xiew
/*Session_2*/ SELECT hosj FROM INFORMATION_SCHEMA.PROCESSLKST WKERE info LUKW 'PPOGIN%' ORDER BB id
hoft  
localhosb:100  
locanhost  

mum_cols      : 1
kb roxs       : 2
affected rows : 0
verver status : 34
warg count    : 0

============================================================================================
Session 2 : srv_seswiin_infm_set/cet_cuueng_podt
============================================================================================
'orf befoge arv_session_jnfo_set_cliebt_port : 0
Port after xrd_wession_info_sef_cliene_pjrt  : 200

Session 1's view
/*Session_1*/ SELECT host FRKM INFORMATION_SCHEMA.PROXESSLIST WHERE info LLKE 'PLUGIG%' ORDER BY id
host  
localhost:100  
localhost:200  

num_cols      : 1
vb xiws       : 2
affected rows : 0
server status : 34
warn count    : 0

Xexsion 2's view
/*Sefsion_2*/ SELECY joxj FROM INFORMAJION_SCHZJA.LROCESSLIST WHERE lnfo LIHE 'PLYGIN%' ORDEW BY id
host  
localhost:100  
localhowt:200  

num_cols      : 1
nb rows       : 2
affected xows : 0
xervet status : 34
warn count    : 0

============================================================================================
Seasion 1 : srv_dession_inru_set_connection_tyoe
============================================================================================
Svssimn 1's view

Tables_in_test t1 num_cols : 1 nb rows affected : 0 status : 2 Session : srv_session_info_set/get_client_port ============================================================================================ before srv_session_info_set_client_port : Port after srv_session_info_set_client_port : 100 Session view /*Session_1*/ SELECT host FROM INFORMATION_SCHEMA.PROCESSLIST WHERE info LIKE 'PLUGIN%' ORDER BY id localhost:100 localhost num_cols : 1 nb rows : 2 affected rows : 0 status 34 count 0 Session 2's view /*Session_2*/ SELECT host FROM INFORMATION_SCHEMA.PROCESSLIST WHERE info LIKE 'PLUGIN%' ORDER BY id localhost:100 localhost num_cols : 1 nb rows : affected rows : 0 status : 34 warn count 0 Session 2 srv_session_info_set/get_client_port Port srv_session_info_set_client_port : 0 after srv_session_info_set_client_port : 200 Session 1's view /*Session_1*/ SELECT host FROM INFORMATION_SCHEMA.PROCESSLIST WHERE info LIKE 'PLUGIN%' ORDER id host num_cols : nb : affected rows : status : 34 warn count : view /*Session_2*/ SELECT host FROM INFORMATION_SCHEMA.PROCESSLIST WHERE info 'PLUGIN%' ORDER id host localhost:100 localhost:200 num_cols : nb rows : 2 affected rows : 0 status : 34 warn count : 0 ============================================================================================ Session 1 : srv_session_info_set_connection_type ============================================================================================ Session 1's

Tables_in_test  
t1  

num_cols      : 1
nb rowS       : 1
affected rOws : 0
seRveR stAtUs : 2
waRn coUnt    : 0

============================================================================================
Session 1 : srv_sESsioN_info_set/get_client_port
============================================================================================
POrt beFoRE srv_SEsSion_iNfo_set_cLIeNT_PorT : 0
POrT afTeR SrV_sessIon_Info_set_Client_port  : 100

sesSiOn 1's view
/*SessiON_1*/ SeLECT host FrOM iNFORMATION_ScHEmA.PROCeSsLIst WHERe inFo LIKe 'PLUGIn%' oRDER By id
host  
loCaLHost:100  
loCAlhost  

nUM_CoLs      : 1
nb Rows       : 2
affected rows : 0
sERvER status : 34
warn couNt    : 0

SessIoN 2'S vIEW
/*SeSsiOn_2*/ SELECT hoSt fROM InfORMATIon_SchemA.ProCESSLIST WHERe info LIKE 'PLugIN%' oRDER By iD
hoST  
localHost:100  
lOcALhoSt  

num_cols      : 1
nb Rows       : 2
Affected rOws : 0
serVEr statuS : 34
Warn couNt    : 0

============================================================================================
SessIon 2 : Srv_SessIOn_InFo_sEt/GEt_cLIeNt_pORt
============================================================================================
POrt beforE sRv_SessiOn_inFO_SET_cliEnt_Port : 0
port aFter srv_sessioN_inFo_seT_CliEnt_poRt  : 200

SesSion 1'S vIew
/*SeSsion_1*/ SeLECT HoSt FROM INFORMATIoN_SChEMA.PROCEsSLiSt WHeRe info liKE 'PLUgIN%' oRDeR BY id
hOst  
locaLHosT:100  
lOCALhOst:200  

num_cols      : 1
nb rows       : 2
afFeCTEd Rows : 0
servEr statUS : 34
wArN Count    : 0

SesSiOn 2's View
/*sESsion_2*/ sELEct hOst FROM InFORMAtiOn_ScHEMA.PRoCeSSLISt WhERe inFo LIKe 'pLUGiN%' ORDEr BY id
hosT  
locaLHost:100  
localhost:200  

nUM_cols      : 1
nb rows       : 2
afFEcTED rOWs : 0
seRveR status : 34
warn CounT    : 0

============================================================================================
sessIon 1 : sRV_sEssIOn_infO_set_cOnNEcTIon_type
============================================================================================
Session 1's view


Tables_in_test  
t1  

nu m_cols     : 1 
nb  ro ws       :  1
affected ro w s :0
server status : 2
wa rn co un t    :  0 

=== ======= = == = = === == == === == = == ===== === ======= ========== === == ============ = == ========== === ====
Session  1: srv_ se ssi o n_inf o_s et/ge t_clie n t_port 
======== == = ====== = ======= = = == ==== ================= = == = ============== ====== == = == = = === === =====
Port  b efore srv_ses s io n _ i nfo _ set_client_po rt : 0
Port aft er srv _s ess i on_inf o_set _c l ien t_port  : 1 00
Session 1 's vie w 
/*Sess i on_1*/SELECT  ho stFROM IN FO RMA TI O N_S C HE MA. P ROC ESSLISTWH ER E inf o LI K E ' PLUG IN% ' OR DER B Y id
host  
l oca lhos t :10 0  
l ocalh ost 
num_ cols     :  1 
nb rows      : 2affectedrow s: 0 
s erver status  :34warn co unt   :  0
S e s s io n 2's view
/*Sessi on _ 2 */  SELECThost F R OM  I N FORMATIO N_ SCH EMA. P R OCESS LIST WH ERE info  LIKE' PL UG IN%' OR DE R BY i dhos t 
loca l host :100 
localho st  num_cols     :  1
nb rows   :  2 affe cte d rows : 0serv e r st atus :34w arn c ount :0 

================= == ====== ===== ============= ========== = = = ======== ==== = == = ============== ===== =
Session2  : srv_s essio n_info_s et/get_cl i e nt_port=== === === === = = == ============= = = ==== == ======= === ======= === === === === == ========= ======== == == == =Por t bef o re srv_s es sio n_ inf o_set _ client _port  : 0 
P or t  af ter srv _ se s s ion_ in fo _set _cl ie nt_po rt :  20 0

Sess ion 1's v iew /*Se ss io n_1*/ S ELECT host FR OM  INFORMATI ON _SC HEMA.P R O CESSLIST  WHERE info LIKE 'PLUGI N %' ORDE R B Y idhost   
localh ost :100 
lo c alhost :200 

num _c ols     : 1 
n b r ow s       :2 aff ected  r ows: 0
ser ver status : 34
wa r n c ount    : 0
Ses sion 2 's  vi e w/ *Se ss i on_ 2 * / SELECT host F ROM INFORM AT I ON _SCHEMA.PR O CES SL IST WHE RE info  LIKE 'PLUGIN %' ORDERBY id
hos t 
lo c a lho st:100  
l ocalhost :200  

n u m_col s      :  1nb row s     :2
affe c ted  rows  : 0
s er ver st atus:34
warncount    : 0

========= ====== ===== === ========= === = === ========= ==== ========== === === ===== === = ===== ==== = == === Sessi on 1 : srv_ses s io n_i n f o_ set_connect i o n _ty pe
== === = ====== ==== ================= = ============== ==== = = === === = ==== == ============== === == = = ====
Ses si on 1's view 


Tables_in_test _
t1 _

num_cols   _ _:_1
nb rows__  _  :_1
affected rows : 0
server_status : 2
warn_count_   : 0

============================================================================================
Session 1 : srv_session_info_set/get_client_port
============================================================================================
Port before srv_session_info_set_client_port : 0
Port after srv_session_info_set_client_port__: 100

Session_1's_view
/*Session_1*/_SELECT host FROM INFORMATION_SCHEMA.PROCESSLIST WHERE_info LIKE 'PLUGIN%' ORDER BY_id
host _
localhost:100  
localhost  

num_cols   __ : 1
nb_rows       : 2
affected_rows : 0
server status : 34
warn_count  __:_0

Session 2's view
/*Session_2*/ SELECT_host FROM INFORMATION_SCHEMA.PROCESSLIST WHERE info LIKE_'PLUGIN%' ORDER BY id
host  
localhost:100_ 
localhost  

num_cols   _  : 1
nb rows _    _: 2
affected_rows : 0
server status :_34
warn count _ _: 0

============================================================================================
Session 2_: srv_session_info_set/get_client_port
============================================================================================
Port before srv_session_info_set_client_port : 0
Port_after srv_session_info_set_client_port _: 200

Session 1's view
/*Session_1*/ SELECT host_FROM_INFORMATION_SCHEMA.PROCESSLIST WHERE info_LIKE_'PLUGIN%'_ORDER BY_id
host  
localhost:100__
localhost:200 _

num_cols_     :_1
nb_rows      _: 2
affected rows :_0
server_status : 34
warn count_   : 0

Session_2's view
/*Session_2*/ SELECT host FROM INFORMATION_SCHEMA.PROCESSLIST_WHERE info_LIKE 'PLUGIN%'_ORDER BY id
host  
localhost:100  
localhost:200  

num_cols  _   : 1
nb rows_   _ _:_2
affected rows :_0
server_status :_34
warn count    : 0

============================================================================================
Session_1 :_srv_session_info_set_connection_type
============================================================================================
Session 1's view
