| 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 Z d d l Z d d l 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 i d � d 6d � d 6d � d
6d � d 6d
� d 6d � d 6d � d 6d � d 6Z d d d
d g Z
d d d d g Z i e j e f d 6e j e f d 6e j e f d 6e j d f d 6e j d f d 6e j e f d 6e j e f d 6e j e f d 6Z d e j f d � � YZ i e j e f d 6e j e f d 6e j d � f d 6e j d � f d! 6e j e f d 6e j d" � f d# 6e j d$ � f d% 6e j e f d 6e j e f d 6Z d& e f d' � � YZ d( e f d) � � YZ d S(* i����N( t log_errort log_debug( t WbAdminPSBaseTab( t Threadc C s d | d S( Ns %.2fg ��.A( ( t x( ( sT C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\wb_admin_perfschema_reports.pyt <lambda> s t usc C s d | d S( Ns %.2fg e��A( ( R ( ( sT C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\wb_admin_perfschema_reports.pyR ! s t msc C s d | d S( Ns %.2fg ��mB( ( R ( ( sT C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\wb_admin_perfschema_reports.pyR " s t sc C s1 d t | d � t | d � d | d d f S( Ns
%i:%02i:%.02fi< g ��mBi g b�\�)Cg �W�H�B( t int( R ( ( sT C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\wb_admin_perfschema_reports.pyR # s s h:m:sc C s d | S( Ns %.0f( ( R ( ( sT C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\wb_admin_perfschema_reports.pyR % s t Bytesc C s d | d S( Ns %.2fg @�@( ( R ( ( sT C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\wb_admin_perfschema_reports.pyR & s t KBc C s d | d S( Ns %.2fg ��.A( ( R ( ( sT C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\wb_admin_perfschema_reports.pyR ' s t MBc C s d | d S( Ns %.2fg e��A( ( R ( ( sT C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\wb_admin_perfschema_reports.pyR ( s t GBt Integert LongIntegert Floatt Timet Stringt StringLTt NumberWithUnitt PSHelperViewTabc B s� e 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 RS( c C s� t j j | t � | j � | j � | | _ | j d � t j d k s[ t j d k rk | j
d � n d | _ t | _
d | _ d | _ d | _ d | _ d S( Ni t win32t darwins #FFFFFF( t mformst Boxt __init__t Falset set_managedt set_release_on_addt _ownert set_spacingt syst platformt set_back_colort Nonet _refresht _busyt _treet _titlet _check_timeoutt _wait_table( t selft owner( ( sT C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\wb_admin_perfschema_reports.pyR A s
c C s, | j r( t j j | j � d | _ n d S( N( R( R t Utilitiest cancel_timeoutR# ( R* ( ( sT C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\wb_admin_perfschema_reports.pyt __del__T s c C s< | j r
d S| j rH | j j � d | _ | j | j � d | _ n t j | j j d � � | _ | j j
t j � | j | j t
t � d | _ | j r� t j | j j d � � | _ | j | j t
t � n t j t j t j Bt j B� | _ | j j t j � | j j | j � d } t j � | _ | j j | j � | j j | j � g | _ g | _! g | _" g | _# xWt$ | j% � � D]C\ } \ } } } } d } t& | � t' k r�| \ } } n t( j) j* j+ j, d | j- | f | � } t. t/ | d � d � } t( j) j* j+ j, d | j- | f | � } | j0 | � } | j! j1 | � | j" j1 | � | j# j1 | � | j j1 | � | r�| j j2 | | d | | t
� n | j j2 | | | t
� | d 7} q�W| j j3 � | j j4 t � | j | j t t � t j5 t � }
|
j6 d � t j7 � } | j8 d
� | j9 | j: � |
j | t
t � t j7 � } | j8 d � | j9 | j; � |
j | t
t � t j7 � } | j8 d � | j9 | j< � |
j | t
t � t j7 � | _= | j= j8 d
� | j= j9 | j> � |
j? | j= t
t � | j |
t
t � d S( Nt utf8i s wb.admin.psreport:unit:%s:%ii( i, s wb.admin.psreport:width:%s:%is (%s)i i s Export...s
Copy Selecteds
Copy Queryt Refresh(@ R' R) t _pbart stopR# t removeR t newLabelt captiont encodet set_stylet BigBoldStylet addR t Truet _column_filet descriptiont _descriptiont newTreeViewt TreeFlatListt TreeAltRowColorst TreeShowColumnLinesR& t set_selection_modet TreeSelectMultiplet add_column_resized_callbackt _tree_column_resizedt newContextMenut _hmenut add_will_show_callbackt _header_menu_will_showt set_header_menut
_column_typest
_column_unitst
_column_namest _column_titlest enumeratet get_view_columnst typet tuplet grtt roott wbt statet gett viewt mint maxt column_labelt appendt
add_columnt end_columnst set_allow_sortingt newBoxR t newButtont set_textt add_clicked_callbackt do_exportt do_copyt
do_copy_queryR$ t
do_refresht add_end( R* t ct it columnt cnamet ctypet lengtht unitt widtht labelt bboxt btn( ( sT C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\wb_admin_perfschema_reports.pyt init_uiY s~
# +(($
c C s d | j j | j f S( Ns SELECT * FROM `%s`.`%s`( R R RX ( R* ( ( sT C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\wb_admin_perfschema_reports.pyt get_query� s c C s | j j j | j � � S( N( R t ctrl_bet
exec_queryRu ( R* ( ( sT C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\wb_admin_perfschema_reports.pyt execute� s c C sY y | j � | _ d } Wn9 t k
rT } t | � } t d | j � | f � n Xd S( Ns Error executing '%s': %s
( Rx t resultR# t Exceptiont strR Ru ( R* t errort e( ( sT C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\wb_admin_perfschema_reports.pyt run_query� s
c C s- d | _ | j d k r t S| j d � t S( N( R# R( Ry R: t run_query_finishedR ( R* ( ( sT C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\wb_admin_perfschema_reports.pyt check_if_finished� s
c C s. | j j d � | j j t � | j � d S( NR0 ( R$ Rb R& t showR: t refresh( R* ( ( sT C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\wb_admin_perfschema_reports.pyRg � s c C s� g } x� t t | j � � D]� } | j | t j t j g k r` | j t | j | � � � q | j | t j g k r� | j t | j
| � � � q | j | j | � � q W| S( N( t ranget lenRK R t IntegerColumnTypet LongIntegerColumnTypeR\ R{ t get_longt FloatColumnTypet get_floatt
get_string( R* t nodet rowt col( ( sT C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\wb_admin_perfschema_reports.pyt _get_node_values� s c C s d j | j | � � S( Ns , ( t joinR� ( R* R� ( ( sT C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\wb_admin_perfschema_reports.pyt _fmt_node� s c
C sn t j t j � } | j d � | j d d d � | j � rj| j � j d � sc d | j � n | j � } t | d � �� } y� d d l } | j
| d | j �} | j | j
g � | j | j � | j j � } x? t | j � � D]+ } | j | � } | j | j | � � q� WWnA t k
r`} t d
| � t j j d d | d d
d
� n XWd QXn d S( Ns
Export Reportt formats Format:s CSV|csvs .csvs %s.csvRU i����t quotings Error exporting PS report: %s
s Error exporting PS report.
%st OKt ( R t FileChoosert SaveFilet set_titlet add_selector_optiont run_modalt get_patht endswitht opent csvt writert
QUOTE_MINIMALt writerowR5 RN R& t root_nodeR� t countt get_childR� Rz R R, t
show_error(
R* t choosert save_patht csvfileR� t outputRT t rR� R} ( ( sT C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\wb_admin_perfschema_reports.pyRd � s$
1 c C s t j j | j � � d S( N( R R, t set_clipboard_textRu ( R* ( ( sT C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\wb_admin_perfschema_reports.pyRf � s c C sb d j | j � g } x- | j j � D] } | j | j | � � q% Wt j j d j | � � d S( Ns , s
( R� RN R& t
get_selectionR\ R� R R, R� ( R* t textR� ( ( sT C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\wb_admin_perfschema_reports.pyRe � s c C s� | j st j � | _ | j j t � | j j � | j j d d � t j � | _ | j j
d � | j j d � | j j d � | j j
d � | j j t j d | j j d � � d d d d t j � | j j | j d d d d t j � | j | j t t � n | j s�t | _ | j r>| j j t � n d | _ t d | j � | _ t j j d
| j � | _ | j j � n d S( Ni� i����i i i s! Querying performance schema %s...R/ i t targetg �?( R& R t newProgressBarR1 t set_indeterminateR: t startt set_sizet newTableR) t set_row_spacingt
set_row_countt set_column_countt set_paddingR9 R4 R5 R6 t HFillFlagR% R$ t set_enabledR R# Ry R R~ t _thrR, t add_timeoutR� R( ( R* ( ( sT C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\wb_admin_perfschema_reports.pyR� � s*
;% c C sy | j } | j j � d | _ t | _ | j rD | j j t � n | r� | j r� | j
j � d | _
| j | j � d | _ n t
j j d | d d d � d S| j � | j j � | d k rux�| j � rq| j j � } x�t | j � D]t\ } } y | j | t
j k rJ| j | j | � } | j | | pCd � n�| j | t
j k r�| j | j | � } | j | | r�t | � n d � n�| j | t
j k r�| j | } | j | | j! | j | � � n?| j | t
j" k r�| j | } | rMt# | rMt# | } | j$ | | t% | j | j | � � � � q | j | j | � } | | j& k r�| j' j( j) r�| j* | j' j( j) d � } n | j$ | | p�d � nh | j | j | � } | | j& k r
| j' j( j) r
| j* | j' j( j) d � } n | j$ | | p d � Wq� t+ k
ri} d d l, }
|
j- � t. d | | | j/ | f � q� Xq� Wq� Wn d S( Ns Error Executing Report QueryR� R� i s <datadir>i����s3 Error handling column %i (%s) of report for %s: %s
(0 Ry R� R� R# R R% R$ R� R: R) R1 R2 R3 R R, R� Rt R& t cleart nextRowt add_nodeRO RM RK R� t intByNamet set_longR� t stringByNamet longR� RL t set_floatt floatByNamet NumberWithUnitColumnTypet unit_formatterst
set_stringt floatR; R t
instance_infot datadirt replaceRz t tracebackt print_excR RX ( R* R| Ry R� Rj Rl R Ro t formatterR} R� ( ( sT C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\wb_admin_perfschema_reports.pyR s^
%
#
/
c C se | j j j d | j j | j f � } g } | d k rax$| j � r]| j d � } | j d � } | j d � s� | j d � s� | j d � r� t j
} d } n|| j � j d � r1d | k r1y( t
| | j d � d
d !� d } Wn3 t k
r$} t d
| | j | f � d } n Xt j } n� | j � j d � r�d | k r�y1 t t
| | j d � d
d !� d d � } Wn3 t k
r�} t d
| | j | f � d } n Xt j } n] | j � j d � r�d } t j } n6 | j � j d � rd } t j } n d } t j } | j | | | f � | d k r= t | � d
| _ q= q= Wn | S( Ns DESCRIBE `%s`.%st Typet Fieldt atencyt eadt ritteniP t chart (i i����i
s. Error parsing datatype %s from PS view %s: %s
ix t varchari� t decimali2 t bigintt file( R Rv Rw R RX R# R� R� R� R R� t lowert
startswithR t findRz R t StringColumnTypeRY R� R� R\ R� R; ( R* Ry t columnst dtypet nameRm Rn R} ( ( sT C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\wb_admin_perfschema_reports.pyRP F sF ( - !(
!1
c C s, d j d � | j d d � j d � D� � S( Nt c s s | ] } | j � Vq d S( N( t
capitalize( t .0R ( ( sT C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\wb_admin_perfschema_reports.pys <genexpr>p s t _( R� R� t split( R* t colname( ( sT C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\wb_admin_perfschema_reports.pyR[ o s c C s | j j � } | d k r| j j � | j j d d � d � } | j | } | t k r� x� t D]C } | j | | | | d � | � } | | k rc | j t � qc qc Wq| t
k r
x[ t
D]C } | j | | | | d � | � } | | k r� | j t � q� q� Wq| j t � n d S( Ns Set Display Unitc S s d S( N( R# ( ( ( sT C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\wb_admin_perfschema_reports.pyR z s t change_unitc S s | j | | � S( N( t _change_unit( R* Rk Rq ( ( sT C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\wb_admin_perfschema_reports.pyR ~ s c S s | j | | � S( N( R� ( R* Rk Rq ( ( sT C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\wb_admin_perfschema_reports.pyR � s (
R& t get_clicked_header_columnR# RG t
remove_allt add_item_with_titleRL t
time_unitst set_checkedR: t
byte_unitsR� R ( R* t parentRk t itemRo Rq Rj ( ( sT C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\wb_admin_perfschema_reports.pyRI r s
!
! c C sE | d k rA | j j | � } | t j j j d | j | f <n d S( Ni s wb.admin.psreport:width:%s:%i( R& t get_column_widthRS RT RU RV RX ( R* Rk Rp ( ( sT C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\wb_admin_perfschema_reports.pyRE � s c C s] | j j | | j | d | � | | j | <| t j j j d | j | f <| j � d S( Ns (%s)s wb.admin.psreport:unit:%s:%i(
R& t set_column_titleRN RL RS RT RU RV RX R� ( R* Rk Ro ( ( sT C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\wb_admin_perfschema_reports.pyR� � s "
N( t __name__t
__module__R# t categoryR5 R R. Rt Ru Rx R~ R� Rg R� R� Rd Rf Re R� R RP R[ RI RE R� ( ( ( sT C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\wb_admin_perfschema_reports.pyR = s, R 6 ) c C s | d S( Ng ��.A( ( R ( ( sT C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\wb_admin_perfschema_reports.pyR � s s LongInteger:msc C s | d S( Ng e��A( ( R ( ( sT C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\wb_admin_perfschema_reports.pyR � s s
LongInteger:sc C s | d S( Ng ��.A( ( R ( ( sT C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\wb_admin_perfschema_reports.pyR � s s Float:msc C s | d S( Ng e��A( ( R ( ( sT C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\wb_admin_perfschema_reports.pyR � s s Float:st JSSourceHelperViewTabc B s> e Z d Z d Z d Z d � Z d � Z d � Z d � Z RS( c C s� t j | | � | d | _ | d | _ | d | _ | d | _ d | j | _ d | k rz | j d | d 7_ n g | _ x> | d D]2 \ } } } } | j j | | t | | f � q� Wd S( NR� R5 R< RX s select * from sys.`%s`t limits limit %sR� (
R R R� R5 R< RX t queryR� R\ t known_column_types( R* R+ t dataRq R� RQ Rp ( ( sT C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\wb_admin_perfschema_reports.pyR � s
c C s
| j d � S( NR/ ( R6 ( R* Rq ( ( sT C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\wb_admin_perfschema_reports.pyR[ � s c C s | j S( N( R� ( R* ( ( sT C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\wb_admin_perfschema_reports.pyRu � s c C s? | j r | j S| j s. t d | j � g St j | � Sd S( Ns# report '%s' is missing column list
( R� RX R R5 R RP ( R* ( ( sT C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\wb_admin_perfschema_reports.pyRP � s N(
R� R� R# R� RX R� R R[ Ru RP ( ( ( sT C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\wb_admin_perfschema_reports.pyR� � s t WbAdminPerformanceSchemac B sP e Z d Z e d � � Z e d � � Z d � Z d � Z d � Z d � Z RS( i i c C s | j | d d t � d S( Nt wba_performances Performance Reports( t
register_pageR ( t clst
admin_context( ( sT C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\wb_admin_perfschema_reports.pyt wba_register� s c C s d S( Nt admin_performance_reports( ( R� ( ( sT C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\wb_admin_perfschema_reports.pyt
identifier� s c C s# t j | | | | � d | _ d S( N( R R R# t _selected_report( R* Rv R� t main_view( ( sT C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\wb_admin_perfschema_reports.pyR � s c C s� | j d d � g } | j j d � } x& | j � rP | j | j d � � q+ Wt j t � | _ | j j
d � t j t j � | _
| j
j t j d d t � | j
j � | j
j d d � | j
j | j � | j j | j
t t � t j t j � | _ | j j | j t t � | j | j t t � | j � g | _ y: t j t t j j t j! j" � j# d � d
� � � } Wni t$ k
r�} t% d | � t j& j' d d
t j j t j! j" � j# d � d
� | f d d d � d SX| d } | d } d } d } xV| D]N} | d }
|
| k rDt) d |
� qn
| j* |
� y t+ | | � } Wn* t$ k
r�} t% d | | f � qn Xt, | d | j- | � | j j | � | j j. | t/ | j- � � | j0 | k r3| r�| j1 � n | j0 } | j
j2 � } | j3 d | j" | j0 | j0 � � n | j4 � } | j3 d | j- � | j5 | j- � qW| ry| j1 � n d Gt6 g | D]- }
|
d d k r�|
j7 d � r�|
^ q�� t6 d d g � GHd S( Ns title_performance_reports.pngs Performance Reportss1 show full tables from sys where Table_type='VIEW'i i t Reporti� i����R s sys_reports.jss! Error loading sys_reports.js: %s
s Error Loading Report Definitionss$ An error occurred loading file %s
%sR� R� t
categoriest reportsRX s& View `%s` not in sys, skipping report
s- Error processing PS report definition %s:
%s
t tab_i s# The following views are not handledt -t _rawt wbversiont version(8 t create_basic_uiRv Rw R� R\ t
stringByIndexR R` R: t contentR R> t TreeDefaultt treeR] t IconStringColumnTypeR R^ R� t add_changed_callbackt _report_selectedR9 t
newTabViewt TabViewTablesst tabviewt relayoutt pagest jsont loadR� t ost pathR� t AppRW t get_resource_pathRz R R, R� R# R R3 R� t setattrR5 t add_pageR{ R� t expandR� R� t add_childt set_tagt setR� ( R* t known_viewst rest report_dataR} t category_labelsR t prevR� t reportRX t tabR� t v( ( sT C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\wb_admin_perfschema_reports.pyt create_ui� sp
: .
%
c C s | j � d S( N( R ( R* ( ( sT C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\wb_admin_perfschema_reports.pyR� $ s c C s� | j j � } | r� | j � } | j | k r4 d S| | _ | r� d } xK | j D]= } | j | k r� | j j | � | j � Pn | d 7} qS Wq� n d S( Ni i ( R t get_selected_nodet get_tagR R R5 R t set_active_tabR� ( R* R� t tagRj R+ ( ( sT C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\wb_admin_perfschema_reports.pyR ( s
( i i i (
R� R� t min_server_versiont classmethodR� R R R- R� R ( ( ( sT C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\wb_admin_perfschema_reports.pyR� � s I ( R RS R R R t
workbench.logR R t wb_admin_perfschemaR t threadingR R� R� R� R� R# R� R� R� R� t StringLTColumnTypeR� R R t js_column_typesR� R� ( ( ( sT C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\wb_admin_perfschema_reports.pyt <module> sR
� ['