| Server IP : 180.180.241.3 / Your IP : 216.73.216.252 Web Server : Microsoft-IIS/7.5 System : Windows NT NETWORK-NHRC 6.1 build 7601 (Windows Server 2008 R2 Standard Edition Service Pack 1) i586 User : IUSR ( 0) PHP Version : 5.3.28 Disable Function : NONE MySQL : ON | 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 : |
2zXc @ 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(* iN( 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 eA( ( 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 WHB( 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 eA( ( 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} qW| 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 it 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 st | _ | j r>| j j t n d | _ t d | j | _ t j j d
| j | _ | j j n d S( Ni ii 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 } xt | j D]t\ } } y | j | t
j k rJ| j | j | } | j | | pCd n| j | t
j k r| j | j | } | j | | rt | 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$ | | pd 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>is3 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 rd | k ry1 t t
| | j d d
d ! d d } Wn3 t k
r} t d
| | j | f d } n Xt j } n] | j j d rd } 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 ii
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 eA( ( 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 eA( ( 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 iR 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
['