| Server IP : 209.209.40.120 / Your IP : 216.73.217.112 Web Server : Microsoft-IIS/10.0 System : Windows NT NEWWWW 10.0 build 17763 (Windows Server 2019) i586 User : NEWWWW$ ( 0) PHP Version : 8.3.30 Disable Function : NONE MySQL : OFF | cURL : ON | WGET : OFF | Perl : OFF | Python : OFF | Sudo : OFF | Pkexec : OFF Directory : C:/Program Files/MySQL/MySQL Workbench 6.3 CE/modules/ |
Upload File : |
�
�"�Xc @ s d d l m Z m Z m Z m Z m Z m Z m Z d d l Z d d l Z d d l m
Z
m Z d d l m
Z
d d l m Z d d l m Z m Z d d l Z d d l m Z d d l m Z d e j f d
� � YZ d e j f d � � YZ d
e f d � � YZ d S( i����( t newTreeViewt newButtont newBoxt newSelectort newCheckBoxt newLabelt UtilitiesN( t escape_sql_stringt
QueryError( t partial( t dprint_ex( t weakcbt WbAdminBaseTab( t log_error( t not_running_warning_labelt
WBThreadStackc B sD e Z e Z d � Z d � Z d � Z d � Z d � Z d � Z RS( c C s� t j j | t j j � � | j d | � | | _ t j t � } | j d � | j d � | | _
t j t t � } t j
t j � | _ | j j t j d d t � | j j t j d d t � | j j t j d d t � | j j t j d
d t � | j r'| j j t j d d t � n | j j � | j j d
d � | j j | j � | j | j d � t j d � } | j t j � t t � } t t � } | j d � | j d � | j | t t � | j | t t � t j t j � | _ | j j t � | j j d d � | j | j t t � | j | d � | j | t t � | j | � t t � } | j d � t! � | _" | j" j# d � | j" j$ | j% � | j& | j" t t � | j& | t t � | j d d � | j' � d S( Ns Thread Stack for %di i s Event Idi2 s
Event infoi� t Typeid s Timer wait [µs]iP t Sourcei� i����i� s Wait infoi i� i t Closei iX (( t mformst Formt __init__t main_formt set_titlet ctrl_beR t Falset set_paddingt set_spacingt thread_idt newSplittert TrueR t TreeDefaultt treet
add_columnt IntegerColumnTypet StringColumnTypet enable_debug_infot end_columnst set_sizet add_changed_callbackt event_selectedt addR t set_stylet BoldStylet
newTextBoxt VerticalScrollBart textt
set_read_onlyt set_contentR t okt set_textt add_clicked_callbackt
close_formt add_endt center( t selfR R t vboxt splittert lt tboxt lboxt bbox( ( sM C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\wb_admin_connections.pyR % sV
c C s | j � d S( N( t close( R7 ( ( sM C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\wb_admin_connections.pyR4 ] s c C sN | j j � } | rJ | j � } | r: | j j | � qJ | j j � n d S( N( R t get_selected_nodet get_tagR. t set_valuet clear( R7 t nodet tag( ( sM C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\wb_admin_connections.pyR( ` s c C s d } y� | j j d | j | j r* d n d f � } | d k rd | j � rd | j d � } qd n | r� | j d d � } | j t j
| � � SWnx t k
r
} d d l } t
d | j | j r� d n d | j � f � t j j d d
| j | f d d d � d SXt S( Ns" SELECT sys.ps_thread_stack(%d, %s)t TRUEt FALSEi t t i����s1 Exception during sys.ps_thread_stack(%d, %s):
%s
s Error Getting Thread Stacksw The thread stack for thread %d can't be loaded, please check if your sys schema is properly installed and available.
%st OK( t NoneR t
exec_queryR R$ t nextRowt
stringByIndext replacet
parse_datat jsont loadst Exceptiont tracebackR
t
format_excR R t
show_errorR ( R7 t datat resultt eRS ( ( sM C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\wb_admin_connections.pyt load_datai s . /)c C sl i } | j d � d k s1 t | d � d k r5 t Sx�| d D]�} d } t | d � d k r� | j j � } | | d t | d � <nd | j d t | d � � r@ | j d t | d � � } | j � } | | d t | d � <n q@ | j d | d � | j d | d j � � | j d | d j � � d
| k r�| j d t
| d
� � | j � } | r�d } y t | j
d � � } Wn n X| j d t
| d
| � � q�n | j r�| j d
| d j � � n | d r@ | d j � | d j � k r@ | j | d � q@ q@ W| j j � rh| j j d � j � } | rh| j j | � qhn t S( Nt eventsi t nesting_event_ids event_%dt event_idi t
event_infoi t
event_typet
timer_waiti g i t sourcet wait_info( t getRJ t lenR t intR t add_nodet add_childt
set_stringt stript strt
get_parentt floatt
get_stringR$ t set_tagt countt node_at_rowR@ R. RA R ( R7 t datatreet treecachet itemRC t parentt pnodet pnode_twaitRD ( ( sM C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\wb_admin_connections.pyRO { sF + $ *c C s_ | j � } | sQ | d k rD t j j d d | j d d d � n | j � n
| j � d S( Ns Error Getting Thread Stacks� Thread stack is not available for thread %d. Please enable Performance Schema instrumentation (Statement and Stage instrumentations and respective History consumers).RI RH ( RY RJ R R RU R R> t show( R7 t r( ( sM C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\wb_admin_connections.pyt run� s &
(
t __name__t
__module__R R$ R R4 R( RY RO Rx ( ( ( sM C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\wb_admin_connections.pyR " s 8 +t ConnectionDetailsPanelc B s# e Z d � Z d � Z d � Z RS( c C s� t j j | � | | _ | j d � | j d � | j d � | j d � | j d � i | _ | j
d d � | j
d d � | j
d d
� | j
d d � | j
d
d � | j
d d � | j
d d � | j
d d � | j
d d � | j
d d � | j
d d � | j
d d � | j
d d � t j d � } | j t j
� | j | d d! d" d# t j t j B� t j � | _ | j j t j t � | j j t j t � | j j t j t � | j j t j � | j j d d$ � | j | j d d d# d% t j t j Bt j Bt j B� | j j j j d& d' d � r�t j! � | _" | j" j# t � | j" j$ | j j% � | j" j& d( � | j | j" d! d d% d t j � n d | _" d S() Ni i i i s Processlist Id:t PROCESSLIST_IDs
Thread Id:t THREAD_IDs Name:t NAMEs Type:t TYPEs User:t PROCESSLIST_USERs Host:t PROCESSLIST_HOSTs Schema:t PROCESSLIST_DBs Command:t PROCESSLIST_COMMANDs Time:t PROCESSLIST_TIMEs State:t PROCESSLIST_STATEs Role:t ROLEs
Instrumented:t INSTRUMENTEDs Parent Thread Id:t PARENT_THREAD_IDs Info:i i i
i i2 i i i s Explain for Connection(( R t TableR t ownerR t set_row_spacingt set_column_spacingt set_column_countt
set_row_countt labelst make_lineR R* R+ R) t HFillFlagt HExpandFlagt
newCodeEditort infot set_featurest
FeatureGutterR t FeatureReadOnlyR t FeatureWrapTextt set_languaget LanguageMySQL56R& t VFillFlagt VExpandFlagR t target_versiont# is_supported_mysql_version_at_leastR t explaint set_enabledR3 t explain_selectedR2 RJ ( R7 R� R: ( ( sM C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\wb_admin_connections.pyR � sL
&7 %c C s� t | j � } t j | � } | j t j � | j t j � | j | d d | | d t j t j
B� t j d � } | j | d d | | d t j t j
B� | | j | <d S( Ni i RH i ( Rc R� R R t set_text_alignt
MiddleLeftR* R+ R) R� R� ( R7 t captiont namet iR: ( ( sM C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\wb_admin_connections.pyR� � s **c C s� | j d j | r& d | j d � n d � | j d j | rO | j d � n d � | j d j | rx | j d � n d � | j d j | r� | j d
� n d � | j d j | r� | j d � n d � | j d
j | r� d | j d � n d � | j d j | r | j d � n d � | j d j | rMd | j d � n d � | j d j | rv| j d � n d � | j d j | r�| j d � n d � | j d j | r�d | j d � n d � | j d j | r�| j d � n d � | j j t j t � | j j | r-| j
� n d � | j j t j t � | j r~| j j
| rt| j
� rtt n t � n d S( NR| s %si RH R� i R� i R� i R� i R� i R� i R} i R i R~ i R� i
R� i ( R� R2 t get_longRl R� R� R R� R RA R@ R R� R� ( R7 RC ( ( sM C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\wb_admin_connections.pyt update� s" -))))-)-))-)" ( Ry Rz R R� R� ( ( ( sM C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\wb_admin_connections.pyR{ � s 0 t WbAdminConnectionsc B s| e Z e Z d Z e d � � Z e d � � Z d � Z d � Z d � Z
d& d � Z d � Z
d � Z d � Z d
� Z d � Z d � Z d
� Z d � Z d � Z d � Z d � Z d � Z d � Z d � Z d � Z d � Z d � Z d � Z d � Z d � Z d � Z! d& Z" d � Z# d � Z$ d � Z% d � Z& d � Z' d! � Z( d" � Z) d& d d# � Z* d$ � Z+ d% � Z, RS(' i c C s | j | d d t � d S( Nt wba_managements Client Connections( t
register_pageR ( t clst
admin_context( ( sM C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\wb_admin_connections.pyt wba_register s c C s d S( Nt admin_connections( ( R� ( ( sM C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\wb_admin_connections.pyt
identifier
s c C s� t j | | | | � | j � | j � | j d � | j d � t | _ | j � | _ d | _ d | _ | j
� rHd t j d d f d t j d d f d t j d
d f d t j d
d f d t j d d f d t j d d f d t j d d f d t j d d f d t j d d f d t j d d f d t j d d f d t j d d f d t j d! d" f g
| _ d# d$ d% d& g | _ d | _ | j j j d$ d' d' � r�| j j d( t j d) d* f � n t j j � j } i d+ d, 6| d- � d. 6| d/ � d0 6| d1 � d2 6| d1 � d3 6| d4 � d5 6| d6 � d7 6| d8 � d9 6| _ n� d t j d d f d t j d d f d
t j d
d f d
t j d
d f d t j d d f d t j d d f d t j d d f d! t j d! d f g | _ d# d$ g | _ d% | _ d S(: Ni i R| t Idi2 R� t UseriP R� t Hostix R� t DBid R� t CommandR� t Timei< R� t StateR} s Thread IdR R R~ t NameR� s
Parent ThreadR� t Instrumentedt PROCESSLIST_INFOt Infoi� i i i i
i t
ATTR_VALUEt Programi� RH t GLOBALs db.Schema.16x16.pngt SCHEMAs db.Table.16x16.pngt TABLEs db.Role.16x16.pngt FUNCTIONt PROCEDUREs db.Trigger.16x16.pngt TRIGGERs GrtObject.16x16.pngt EVENTs db.Column.16x16.pngt COMMIT( R R t set_managedt set_release_on_addR R R t page_activet check_if_ps_availablet _new_processlistRJ t _refresh_timeoutt warningt new_processlistR t LongIntegerColumnTypeR# t columnst long_int_columnst info_columnR R� R� t appendt AppRb t get_resource_patht icon_for_object_type( R7 R t
instance_infot main_viewt get_path( ( sM C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\wb_admin_connections.pyR s^
"
c C s= t d d � | j � | j d d � | j � rQ t j j j j d d � } n t j j j j d d � } | r� g | j
d � D] } t | � ^ q� } n d } t j
t � | _ | j j d � t t j t j Bt j B� | _ | j j t j � | j j | j � xg t | j � D]V \ } \ } } } } | rX| t | � k rX| | } n | j j | | | t � qW| j j � | j j t � | j j! t" | d � � | j j# | j t t � t j$ � } | j% d
� | j& d � | j' d � | j( d � | j# | j) d
d � d d d d t j* t j+ B� | j# | j) d d � d d
d d t j* t j+ B� | j# | j) d d � d
d d d t j* t j+ B� | j# | j) d d � d d d d t j* t j+ B� | j# | j) d d � d d d d t j* t j+ B� | j# | j) d d � d d d d
t j* t j+ B� | j# | j) d d � d d
d d
t j* t j+ B� | j# | j) d d � d
d d d
t j* t j+ B� | j# | j) d d! � d d d d
t j* t j+ B� | j# | j) d" d# d$ � d d d d
t j* t j+ B� | | _, | j# | t t � | j# | j t t � t
t � } | | _- | j. | t t � | j d% � t/ � }
|
j0 d& � | j. |
t t � |
j1 t" | d' � � t/ � | _2 | j2 j0 d( � | j. | j2 t t � | j2 j1 t" | d) � � t/ � | _3 | j3 j0 d* � | j. | j3 t t � | j3 j1 t" | d+ � � t4 d, � } | j# | t t � t j5 � | _6 | j6 j7 | j8 � | j j9 | j6 � d- d d
d d d d. d/ d0 g | _: t | j: � | _; t< � | _= | j= j> d1 d2 � x+ | j: D] } | j= j? t@ | � d3 � q�W| j= j? d4 � t j j jA jA j d5 d6 � }
| j= jB |
� | jC � | j= j! t" | d7 � � | j# | j= t t � t
t � | _D | jD j d% � tE � | _F | jF j0 d8 � | jF j1 | jG � | jF jH d9 � | jD j# | jF t t � d | _I t | _J | j � r tE � | _K | jK jL t � | jK j0 d: � | jK jH d; � | jK j1 | jG � | jD j# | jK t t � tE � | _M | jM jL t � | jM j0 d< � | jM jH d= � | jM j1 | jG � | jD j# | jM t t � t jN t jO � | _P | jP j> d> d2 � | jP jQ | jR � t jS � | _T tU | � | _V | jT j# | jV � | jP jW | jT d? � | _X d | _Y | jZ j[ j\ d d@ d � r�
t jS � | _] t j
t � | _Y | j] j# | jY � t j4 dA � | _^ | jY j# | j^ t t � t j4 dB � } | j_ t j` � | jY j# | t t � t j4 dC � } | j_ t ja � | jY j# | t t � t j t j � | _b | jb j t jc dD dE t � | jb j t jd dF d1 t � | jb j t jd dG d1 t � | jb j � | jb j> d d1 � | jY j# | jb t t � t j4 dH � } | j_ t j` � | jY j# | t t � t j
t � } | j d � t je � | _f | jf jg t jh j � ji dI � � | j# | jf t t � t j4 dJ � | _j | j# | jj t t � | jY j# | t t � | jP jW | j] dK � | _I n | jZ j[ j\ d dL d � r� t j t j t j B� | _k | jk j t jd dM dN t � | jk j t jd dO dP t � | jk j � | jP jW | jk dQ � | _l n | j j# | jP t t � | jP jm t � t/ � | _n | jn j0 dR � | jn j1 | jo � | jD j. | jn t t � n | j# | jD t t � | jp � | jq � t d dS � d S(T Ni t Enters title_connections.pngs Client Connectionss% wb.admin:ConnectionListColumnWidthsPSs# wb.admin:ConnectionListColumnWidthst ,i t connection_selectedi i i s Threads Connected:t lbl_Threads_connectedi i s Threads Running:t lbl_Threads_runnings Threads Created:t lbl_Threads_createdi s Threads Cached:t lbl_Threads_cacheds Rejected (over limit):t% lbl_Connection_errors_max_connectionss Total Connections:t lbl_Connectionss Connection Limit:t lbl_max_connectionss Aborted Clients:t lbl_Aborted_clientss Aborted Connections:t lbl_Aborted_connectss Errors:t
lbl_errorst tooltip_errorsi t Refresht refreshs Kill Connection(s)t kill_connections
Kill Query(s)t
kill_querys
Refresh Rate:g �?i
i i id i����s secondss
Don't Refreshs, Administrator:refresh_connections_rate_indexi t update_refresh_rates Hide sleeping connectionssB Remove connections in the Sleeping state from the connection list.s Hide background threadssM Remove background threads (internal server threads) from the connection list.s Don't load full thread infos� Toggle whether to load the entire query information for all connections or just the first 255 characters.
Enabling this can have a large impact in busy servers or server executing large INSERTs.i^ t Detailsi s\ Metadata locks (MDL) protect concurrent access to
object metadata (not table row/data locks)s,
Granted Locks (and threads waiting on them)sO Locks this connection currently owns and
connections that are waiting for them.t Objecti� R t Durations
Pending Lockss message_warning.pngs/ Locks this connection is currently waiting for.t Locksi t Attributei� t Valuei� t
Attributess Show Detailst Leave(r R
t suspend_layoutt create_basic_uiR� t grtt roott wbt stateRb RJ t splitRd R R R t connection_boxR R R t TreeFlatListt TreeAltRowColorst connection_listt set_selection_modet TreeSelectMultiplet add_column_resized_callbackt column_resizedt enumerateR� Rc R! R R% t set_allow_sortingR' R R) t newTableR� R� R� R� t create_labeled_infoR� R� t
info_tablet
button_boxR5 R R2 R3 t kill_buttont killq_buttonR t newContextMenut _menut add_will_show_callbackt menu_will_showt set_context_menut refresh_valuest refresh_values_sizeR t refresh_selectorR& t add_itemRi t optionst set_selectedR� t check_boxR t hide_sleep_connectionsR� t set_tooltipt mdl_locks_paget _showing_extrast hide_background_threadst
set_activet
truncate_infot
newTabViewt TabViewSystemStandardt extra_info_tabt add_tab_changed_callbackt extra_tab_changedt newScrollPanelt connection_details_scrollareaR{ t connection_detailst add_paget details_paget mdl_list_boxR R� R� t mdl_list_box_scrollareat mdl_labelR* R+ t SmallHelpTextStylet
mdl_list_heldt IconStringColumnTypeR# t newImageBoxt mdl_blocked_icont set_imageR� R� t mdl_waiting_labelt attributes_listt attributes_pageRv t show_extrast
toggle_extrast
resume_layoutR� ( R7 t widthsR� t
column_widthst fieldt typeR� t widthR t boxt refresh_buttont
refresh_labelt st refresh_rate_indext labelt hbox( ( sM C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\wb_admin_connections.pyt create_uiE s,
+ (
2222222225
$
"
c C s) | j r% t j | j � d | _ n d S( N( R� R t cancel_timeoutRJ ( R7 ( ( sM C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\wb_admin_connections.pyt shutdown
s c C s� t t � } | j d � t j | � } | j | t t � t | | t j d � � | j t j � | j t
| | � t t � | d k r� t j � } | j
t j j � j d � � | j d � | j | t t � t | | | � n | S( Ni RH s mini_notice.png( R R R R R R) R t setattrR* R+ t getattrRJ R. R0 R� Rb R� R ( R7 t lbl_txtt lbl_namet tooltip_nameR< R: R� ( ( sM C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\wb_admin_connections.pyR s
c C s� d d d d d d d g } g } | j j j d d d � rd | j d
� d d d
d d d g } n g } d } | j j d � } | d k r`x� | j � r\| j d � | k r� t | d | j d � d � } | d k r� | j | j d � � q� n | j d � | k r� | t
| j d � � 7} | j d | j d � t
| j d � � f � q� q� Wn | r�| j j t
� | j j d j | � � | j j d | � n | j j t � | j j | j j d � d S( Nt Threads_connectedt Threads_runningt Threads_createdt Threads_cachedt Connectionst Aborted_clientst Aborted_connectsi i t! Connection_errors_max_connectionst Connection_errors_acceptt Connection_errors_internalt Connection_mac_connectionst Connection_per_addrt Connection_errors_selectt Connection_errors_tcpwrapi s SHOW GLOBAL STATUSi s lbl_%si s %s: %ds
s %dt max_connections( R R� R� R� RK RJ RL RM RG R2 Rd R� Rv R R� R t joinR R� t server_variables( R7 t varst errorst
error_tooltipt error_countRW t obj( ( sM C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\wb_admin_connections.pyt load_info_panel_data$ s.
9c C s� | d k r�| j j � | j j � } | r�| j � t k } | s� t g | D]$ } | j d � j d � sP | ^ qP � d k } n | j j
d | j d � } | j j
d | j d � } | j j
d | j
d � } | j | � | j j j d
d � r�| j j � | j j
d | j d
� } t | � d k rF| j t � q�| d j | j � } | so| d k r�| j t � q�n | j � rX| j j
d | j d � } t | � d k r�| j t � n d } g | D] } | j d � j d � ^ q�} t | � rd } n | j j
| | j d � } t | � rXt | � rX| j t � qXn | j j � | j j
d | j d � } | j | � | j j
d | j d � } | j | � | j j � n | j j
d | j d � n d S( Ni t
BACKGROUNDi t Copyt
copy_selecteds Copy Infot copy_selected_infos Show in Editort
edit_selectedi i s Explain for ConnectionR� i t NULLs View Thread Stackt view_thread_stacks! Enable Instrumentation for Threadi t YESs" Disable Instrumentation for Threadt enable_disable_instrumentations
Kill Query(s)R� s Kill Connection(s)R� R� R� ( RJ R t
remove_allR� t
get_selectionR� R Rc Rl t
startswitht add_item_with_titleRd Re Rf R� R R� R� t
add_separatorR� R� Rh t allRj t anyR� R� R� ( R7 Rr t
selected_connt user_threadt selR� t
instr_captiont start_with_yes( ( sM C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\wb_admin_connections.pyR @ sJ
@
+
c C s� g } x6 t | j j � � D] } | j | j j | � � q Wd j g | D] } t | � ^ qL � } | j � r� | t j j
j d <n | t j j
j d <d S( NR� s% wb.admin:ConnectionListColumnWidthsPSs# wb.admin:ConnectionListColumnWidths( t rangeR� t get_column_countR� t get_column_widthRZ Ri R� R� R� R� R� ( R7 t colR7 t ct w( ( sM C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\wb_admin_connections.pyR o s ( c C sn | j j rj | j j j d d � rj | j j d � } | rj | j � rg | j d � d k rd t Sqg qj n t S( Ni i s select @@performance_schemai ( R R� R� RK RL t
intByIndexR R ( R7 RW ( ( sM C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\wb_admin_connections.pyR� z s $
c C sq | j j rm | j j j d d d � rm | j j d � } | rm | j � rj | j d � d k rg t Sqj qm n t S( Ni i i su select count(*) from performance_schema.setup_instruments where name = 'wait/lock/metadata/sql/mdl' and enabled='YES'i ( R R� R� RK RL R} R R ( R7 RW ( ( sM C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\wb_admin_connections.pyt check_if_mdl_available� s '
c C s | j S( N( R� ( R7 ( ( sM C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\wb_admin_connections.pyR� � s c C s t d d � | j j � } | sE | j j t � | j j t � n | j j t � | j j t � | j r� | r� t | � d k r� | j
j | d � n | j
j d � | j
j � } | | j k r� | j � q� | | j k r� | j � q� n t d d � d S( Ni R� i i R� ( R
R� Rl R R� R R
R R Rc R% R� RJ R t get_active_tabR t refresh_mdl_listR3 t refresh_attr_list( R7 Rt t tab( ( sM C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\wb_admin_connections.pyR� � s"
c C s | j j � y� | j j � } | r� t | � d k r� | d j d � } | j j d | � } xZ | r� | j � r� | j j � } | j
d | j d � � | j
d | j d � � qc Wn WnS t k
r} d d l
} t d | j � � t j j d d | d
d d � n Xd S( Ni i sj SELECT * FROM performance_schema.session_connect_attrs WHERE processlist_id = %s ORDER BY ORDINAL_POSITIONt ATTR_NAMER� i����s+ Error looking up attribute information: %s
s Lookup Connection Attributess* Error looking up connection attributes: %sRI RH ( R2 RB R� Rl Rc R� R RK RL Re Rg t stringByNameRR RS R
RT R R RU ( R7 t nodest connidRW RC RX RS ( ( sM C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\wb_admin_connections.pyR� � s
$ c C s� | j j � | j j t � d } y#| j j � } | r?t | � d k r?| d j d � } | j j
d | � } | d k rEx�| j � r8| j
d � } | d k rk| j
d � } | j
d � } | j
d
� } | | g } | d k r� d } n. d
j g | D] }
|
d k r|
^ q� } | j j t � d | } | r_| d t | � 7} n | r|| d t | � 7} n | j
d � } | j
d � }
| j j
d | � } g } x, | r�| j � r�| j | j d � � q�Wd j g | D] } t | � ^ q�� } t | � d k r;d | j � | | f } n d | j � | | f } | d | |
f 7} q� | d k r� | j j � } | j
d � } | j
d � } | j
d
� } | | g } | d k r�| j d d � n8 | j d d
j g | D] }
|
d k r�|
^ q�� � | j d | j j | � � d | } | rY| d t | � 7} n | rv| d t | � 7} n | j d | j
d � � | j d | j
d � � | j j
d | � } xt | r1| j � r1| j � } | j d d | j d � � | j d | j
d � � | j d | j
d � � q�Wq� q� WqEn d } WnS t k
r�} d d l } t d | j � � t j j! d d! | d" d d � n X| j" j# | � d S(# Ns- This connection is not waiting for any locks.i i i sJ SELECT * FROM performance_schema.metadata_locks WHERE owner_thread_id = %st LOCK_STATUSt PENDINGt OBJECT_TYPEt
OBJECT_SCHEMAt OBJECT_NAMER� s <global>t .s OBJECT_TYPE = '%s's AND OBJECT_SCHEMA = '%s's AND OBJECT_NAME = '%s't LOCK_TYPEt
LOCK_DURATIONs� SELECT *
FROM performance_schema.metadata_locks
WHERE %s AND LOCK_STATUS = 'GRANTED't OWNER_THREAD_IDs , sA The connection is waiting for a lock on
%s %s,
held by thread %s.sA The connection is waiting for a lock on
%s %s,
held by threads %ss
Type: %s
Duration: %st GRANTEDi s� SELECT OWNER_THREAD_ID, LOCK_TYPE, LOCK_DURATION
FROM performance_schema.metadata_locks
WHERE %s AND LOCK_STATUS = 'PENDING's thread %sRH i����s/ Error looking up metadata lock information: %s
s Lookup Metadata Lockss. Error looking up metadata lock information: %sRI ($ R, RB R/ Rv R R� Rl Rc R� R RK RJ RL R� RZ R R R� t intByNameRi t lowerRe Rg t
set_icon_pathR� Rb Rf RR RS R
RT R R RU R1 R2 ( R7 t waiting_label_textR� R RW t lock_statust otypet oschemat onamet obj_namet ot sub_exprt lock_typet
lock_durationt subresultt ownersR� t
owner_listRC t subnodeRX RS ( ( sM C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\wb_admin_connections.pyR� � s�
.
( 8
*
$c C s� | j s | j d d � n | j rA | j | j � d | _ n t � | _ | j j d | � | j j t � | j | j t
t � d S( Ns title_connections.pngs Client Connectionss
%s( t headingR� R� t removeRJ R R2 Rv R R) R ( R7 R. ( ( sM C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\wb_admin_connections.pyt show_warning_message s c C s | j d � d S( Nsg The account you are currently using does not have sufficient privileges to view the client connections.( R� ( R7 ( ( sM C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\wb_admin_connections.pyt show_no_permission s c C s | j d � d S( Ns` There was a problem opening the Client Connections. Please check the error log for more details.( R� ( R7 ( ( sM C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\wb_admin_connections.pyt show_generic_error# s c C s� y | j j d � Wn� t k
rv } d d l } t d | | j � f � | j d k rh | j � n
| j � d St k
r� } d d l } t d | | j � f � | j � d SXt
j | � | j s� | j
� t | _ n t | _ | j j � rA| j j t � | j j t � | j j t � | j j t � n@ | j j t � | j j t � | j j t � | j j t � | j � d S( Ns/ SELECT COUNT(*) FROM performance_schema.threadsi����s3 QueryError in Admin for Client Connections:
%s
%s
iv s2 Exception in Admin for Client Connections:
%s
%s
( R RK R RS R
RT t errorR� R� RR R t page_activatedt
ui_createdRC R R� t is_sql_connectedR� Rv R R R R R� ( R7 RX RS ( ( sM C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\wb_admin_connections.pyR� & s:
c C s
t | _ d S( N( R R� ( R7 ( ( sM C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\wb_admin_connections.pyt page_deactivatedL s c C s$ | j � r | j � S| j � Sd S( N( R� t get_process_list_newt get_process_list_old( R7 ( ( sM C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\wb_admin_connections.pyt get_process_listO s
c C s� g } x� | j D]� \ } } } } | d k r> | j d � q | d k ri | j j � ri | j d � q | d k r� | j d | � q | j d | � q W| j j j d d d � r� d
} n d } | j j � r� | j j d d
j | � | f � } n% | j j d d
j | � | f � } | d k r�g } xk | j � r�g } xE t | j � D]4 \ }
\ } } } } | j
| � } | j | � q[W| j | � q9W| Sd S( NR� s^ IF (NAME = 'thread/sql/event_scheduler','event_scheduler',t.PROCESSLIST_USER) PROCESSLIST_USERt INFOs SUBSTR(t.INFO, 0, 255) INFOR� s a.s t.i i s� LEFT OUTER JOIN performance_schema.session_connect_attrs a ON t.processlist_id = a.processlist_id AND (a.attr_name IS NULL OR a.attr_name = 'program_name')RH sK SELECT %s FROM performance_schema.threads t %s WHERE t.TYPE <> 'BACKGROUND'R� s8 SELECT %s FROM performance_schema.threads t %s WHERE 1=1( R� R� R t
get_activeR R� R� R RK RZ RJ RL R R� ( R7 t colsR9 R: R� R; t JOINRW t result_rowst rowR� t value( ( sM C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\wb_admin_connections.pyR� U s2 (% (c C s� | j j d � } | d k r� g } x_ | j � r� g } x9 | j D]. \ } } } } | j | � } | j | � qC W| j | � q' W| Sd S( Ns SHOW FULL PROCESSLIST( R RK RJ RL R� R� R� ( R7 RW R� R� R9 R: R� R; R� ( ( sM C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\wb_admin_connections.pyR� v s c C s� t | j j � � } | t j j j j d <| j d 7_ | j r_ t j
| j � d | _ n | | j k r� t j
| j | t | j d | j �� | _ n d S( Ns, Administrator:refresh_connections_rate_indexi t my_serial( Rd R t get_selected_indexR� R� R� R t serialR� R RD RJ R t add_timeoutR R R� ( R7 t index( ( sM C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\wb_admin_connections.pyR� � s c C s� | j j � } | s d Sd } | d j d � j d � rD d } n x� | D]~ } | j d � } y | j j d | | f � WqK t k
r� } t d | � t j
j d d | | f d
d d � PqK XqK W| j � d S( NRi i i t Noi sV UPDATE performance_schema.threads SET instrumented = '%s' WHERE thread_id = %d LIMIT 1s* Error enabling thread instrumentation: %s
s Toggle Thread Instrumentations/ Error setting instrumentation for thread %d: %sRI RH (
R� Rl Rl Rm R� R t exec_sqlRR R
R R RU R� ( R7 Rr t instr_stateRt R� RX ( ( sM C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\wb_admin_connections.pyRj � s
& c C s | j � d S( N( R� ( R7 ( ( sM C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\wb_admin_connections.pyR" � s c C s� y | j j d � WnB t k
rX } t d | � t j j d d | d d d � d SX| j � | _ | j r� | j j
| j � | j j
| j � d | _ d | _ n
t d � d S( Nsg UPDATE performance_schema.setup_instruments SET enabled='YES' WHERE name = 'wait/lock/metadata/sql/mdl's' Error enabling MDL instrumentation: %s
s Enable MDL Instrumentations9 Error enabling performance_schema MDL instrumentation.
%sRI RH s7 MDL instrumentation enabled, but it's still disabled!?
( R R� RR R
R R RU R~ t _mdl_enabledR( R� t mdl_enable_button_sept mdl_enable_buttonRJ ( R7 RX ( ( sM C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\wb_admin_connections.pyt enable_mdl_instrumentation� s c C s | j | _ | j r� | j d k r7 | j � | _ n | j r� | j r� t j d � | _ | j j | j t t
� t j � | _ | j j
| j � | j j d � | j j | j t t
� n | j j t
� | j � | j j d � n | j j t � | j j d � d S( NsY
MDL instrumentation is currently disabled.
Click [Enable Instrumentation] to enable it.s Enable Instrumentations Hide Detailss Show Details( R R� RJ R~ R( R R R� R) R R R R� R3 R� R2 R Rv R� R4 ( R7 ( ( sM C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\wb_admin_connections.pyR5 � s
c C sB | j j � } | s d St | j | j d � � } | j � d S( Ni ( R� R? R R R� Rx ( R7 Rt t view( ( sM C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\wb_admin_connections.pyRh � s
c C s� | j j � } | s d Sd j g | D] } | j � r& | j � ^ q& � } t | � d k r� | j � r� | j j � r� | d 7} n t j j
| � d S( Ns , i� s! /* statement may be truncated */( R� Rl RZ R@ Rc R� R R� R R t set_clipboard_text( R7 Rr Rt R� ( ( sM C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\wb_admin_connections.pyRe � s 4-
c C s g } | j d | j d � � | j d | j d � � | j d | j d � � | j d | j d � � | j d | j d
� � | j d | j d � � | j d
| j d � � | j � } t | � d k r| j � r| j j � r| d 7} n | j | � d j | � S( Ns -- Connection Id: %s
i s -- User: %s
i s -- Host: %s
i s
-- DB: %s
i s -- Command: %s
i s -- Time: %s
i s
-- State: %s
i i� s! /* statement may be truncated */RH ( R� R� Rl R@ Rc R� R R� RZ ( R7 Rt R. R� ( ( sM C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\wb_admin_connections.pyt
_node_text� s -
c C sR | j j � } | s d St j j d j g | D] } | j | � ^ q/ � � d S( Ns
( R� Rl R R R� RZ R� ( R7 Rr Rt ( ( sM C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\wb_admin_connections.pyRd � s c C sa | j j � } | s d S| j j j � } | j d j g | D] } | j | � ^ q> � � | S( Ns
( R� Rl R� t editort addQueryEditort replaceContentsRZ R� ( R7 Rr R� Rt ( ( sM C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\wb_admin_connections.pyRf � s 2c C s] | j j � } | s d S| j � } t j j j | t | j d � � | j | j
� � d S( Ni ( R� R? Rf R� t modulest SQLIDEQueryAnalysist visualExplainForConnectionRi R� Rl R� ( R7 Rt R� ( ( sM C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\wb_admin_connections.pyR� s
c C s� | j s t d d � t S| j j � sC t d d � d | _ t S| j � | j � rb d } n d } | j
j � } | r� | j | � } n d } d } | d k r� | j
� } n | d k r�| j
j � | j
j � | j j � } t } | j � r| j j � } n zlxe| D]]} | rDt | d � j d � rDqn | rit | d � j d � riqn | j
j � }
x� t | � D]� \ } } | | j k r�y t | � } Wn t k
r�d } n X|
j | | � | | k rr| | k rr|
} qrq�| | j k rV| d k r0|
j | | d
� n |
j | d � |
j | pOd � q�t | � } |
j | | � q�WqWWd | j
j � X| r�| j
j | � n | j � n | | j! k }
|
s�d | _ n |
S(
Ni s Leave. Page is inactives Leave. SQL connection is offlinei i i t Sleepi Rb i� Rg RH (" R� R
R R R� RJ R� R Ra R� R� R? R� R� t freeze_refreshRB R R� R Ri Rm Re R R� t longRR t set_longR� Rg Rm t thaw_refresht select_nodeR� R� ( R7 t query_resultR� t id_columnRC t old_selectedt old_selected_nodet no_sleep_connectionst
no_bg_threadsR� Rw R{ R9 t cont( ( sM C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\wb_admin_connections.pyR� sp
c C s� | j j � s d S| j j � } | s, d Sx� | D]� } | j d � } | j � r� | j d � j d � r� t j j
d d | d d d � d Sy | j j d | � Wq3 t k
r� } t j j
d d | d d d � Pq3 Xq3 W| j
� d S(
Ni i Rb s Error Killing Connections Thread %s cannot be killedRI RH s KILL CONNECTION %ss %s( R R� R� Rl R� R� Rl Rm R R RU R� RR R� ( R7 t
selectionsRt R� RX ( ( sM C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\wb_admin_connections.pyR� Y s
$ c C s� | j j � s d S| j j � } | s, d Sx� | D]� } | j d � } | j � r� | j d � j d � r� t j j
d d | d d d � d Sy | j j d | � Wq3 t k
r� } t j j
d d | | f d d d � Pq3 Xq3 W| j
� d S(
Ni i Rb s Error Killing Connections Thread %s cannot be killedRI RH s
KILL QUERY %ss+ Error executing KILL QUERY on thread %d: %s( R R� R� Rl R� R� Rl Rm R R RU R� RR R� ( R7 R� Rt R� RX ( ( sM C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\wb_admin_connections.pyR� p s
$ & N(- Ry Rz R R� R� t classmethodR� R� R RC RE RJ R Ra R R R� R~ R� R� R� R� R� R� R� R� R� R� R� R� R� Rj R" R� R� R5 Rh Re R� Rd Rf R� R� R� R� ( ( ( sM C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\wb_admin_connections.pyR� sP 7 � /
W
& !
M ( R R R R R R R R R� t workbench.db_utilsR R t functoolsR t wb_commonR
t wb_admin_utilsR R RP t
workbench.logR
R R R R� R{ R� ( ( ( sM C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\wb_admin_connections.pyt <module> s 4 �Q