DonatShell
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 :  /Program Files/MySQL/MySQL Workbench 6.3 CE/modules/

Upload File :
current_dir [ Writeable ] document_root [ Writeable ]

 

Command :

[ HOME SHELL ]     

Current File : /Program Files/MySQL/MySQL Workbench 6.3 CE/modules/wb_admin_perfschema_instrumentation.pyc

2zXc@sddlZddlZddlmZddlmZddlmZddlm	Z	m
Z
mZmZddl
mZmZddlmZdZd	d
ddd
gZd	d
ddd
gZdddddgZddddgZdejfdYZdejfdYZdejfdYZdejfdYZdejfdYZdejfdYZdejfd YZ d!ejfd"YZ!d#ej"fd$YZ#d%ejfd&YZ$d'eefd(YZ%dS()iN(t
ChangeCounter(tContext(tImageFigure(tPSConfigurationtPSTimerTypetPSObjecttPSActor(tlog_infot	log_error(tWbAdminPSBaseTabizswait/io/file/%swait/io/table/%swait/lock/table/sql/handlersstatement/%tidletevents_statements_currenttevents_transactions_currenttglobal_instrumentationtthread_instrumentationtstatements_digestt	BigSwitchcBs5eZdZdZdZdZdZRS(cCs)tjj||j|j|j|d|_d|_d|_	t
tjjj
d|_t
tjjj
d|_g|_xddddgD]w}g}xLddd	gD];}t
tjjj
d
||f}|j|qW|jj|t|fqWdS(Ntdefaultsps_switcher_text.pngsps_switcher_legende.pngtfullytcustomtdisabledtoffthoovertonsps_switcher_%s_%s.png(NN(tmformst	PyDrawBoxt__init__tset_managedtset_release_on_addtset_instancetstatetNonethovering_statet	mouse_posRtApptgettget_resource_patht
text_imagetlegendtstate_imagestappendttuple(tselftitemticonsRticon((s\C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\wb_admin_perfschema_instrumentation.pyR;s 


			!!	(cCst|}d|_d}x|jD]\}\}	}
}|	}|j|j|jjd}
||jkry|}nx|jd|
kr|jd|
|jkr|jd|kr|jd||j	kr|dkr|
}||_n|j
|
||j|||j	7}q%W|jj
|
|jd|jj||jj
|
|j|jjd|j
|jj	|jj|dS(NiiiRid(RRR R't	get_widthtwidthR%RR!theighttmovetrenderR&t
get_height(R*tcrtxtytwthtctyyRRRRtimagetxx((s\C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\wb_admin_perfschema_instrumentation.pytrepaintTs$	!	f
8cCs||_|jdS(N(Rtset_needs_repaint(R*R((s\C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\wb_admin_perfschema_instrumentation.pyt	set_statens	cCs||f|_|jdS(N(R!R>(R*R5R6((s\C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\wb_admin_perfschema_instrumentation.pyt
mouse_movesscCs |jr|j|jndS(N(R tcallback(R*tbuttonR5R6((s\C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\wb_admin_perfschema_instrumentation.pytmouse_clickxs	(t__name__t
__module__RR=R?R@RC(((s\C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\wb_admin_perfschema_instrumentation.pyR:s
				t
EasySetupPagecBs>eZdZdZdZdZdZdZRS(cCsXtjj|t|j|j|jd|jd||_|j	dS(Ni(
RtBoxRtFalseRRtset_spacingtset_paddingtownert	create_ui(R*RK((s\C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\wb_admin_perfschema_instrumentation.pyR~s



	c	CsyM|jjd}|dkrF|jjd}|dkrFdSn|jjd}|dkr|jjd}|dkrdSn|jjjdd	drt}t}nt}t}|jjd
ddjg|D]}d
|^qddjg|D]}d
|^qf}|dkrHg}g}g}|j	dxL|D]D}d|kr|j	d||j	d|qU|j	|qUWdjddjg|D]}d
|^qg|}	djddjg|D]}d
|^qg|}
|jjdi|	d6|
d6}|dkrHdSndSWnDt
jk
r}td|t
jjdd|dd d nXdS(!NsJSELECT COUNT(*) FROM performance_schema.setup_consumers WHERE enabled='NO'isySELECT COUNT(*) FROM performance_schema.setup_instruments WHERE NAME NOT LIKE 'memory/%' AND (enabled='NO' OR timed='NO')RsKSELECT COUNT(*) FROM performance_schema.setup_consumers WHERE enabled='YES's{SELECT COUNT(*) FROM performance_schema.setup_instruments WHERE NAME NOT LIKE 'memory/%' AND (enabled='YES' OR timed='YES')Riisv
                SELECT sum(IF(%s, 1, 0)) + sum(IF(%s, 1, 0)) FROM performance_schema.setup_consumers
                sENABLED='NO' AND NAME IN (%s)t,s'%s's"ENABLED='YES' AND NAME NOT IN (%s)s
'memory/%'t%sNAME LIKE '%s'sNAME NOT LIKE '%s's OR sNAME IN (%s)s AND sNAME NOT IN (%s)sl
                    SELECT sum(IF(ENABLED='NO' AND (%(cond)s), 1, 0)) +
                        sum(IF(ENABLED='YES' AND (%(notcond)s), 1, 0)) +
                        sum(IF(TIMED='NO' AND (%(cond)s), 1, 0)) +
                        sum(IF(TIMED='YES' AND (%(notcond)s), 1, 0))
                    FROM performance_schema.setup_instruments
                    tcondtnotcondRRs6MySQL error querying PS instrumentation/consumers: %s
s,Check Performance Schema Configuration States<Error checking configuration state of Performance Schema: %stOKt(RKtget_select_int_resultttarget_versiont#is_supported_mysql_version_at_leasttDEFAULT_INSTRUMENTS_57tDEFAULT_CONSUMERS_57tDEFAULT_INSTRUMENTS_56tDEFAULT_CONSUMERS_56tjoinR(tgrttDBErrorRRt	Utilitiest
show_errorR(R*trtinstrumentst	consumersR9tnlikestlikestinstitexptnexpte((s\C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\wb_admin_perfschema_instrumentation.pytcheck_instrumentation_levelsP		*1

::	$c	Csg}g}x;|D]3}d|kr9|jd|q|j|qWddjddjg|D]}d|^qcg|}dddjg|D]}d|^q}||gS(	NRNsNAME LIKE '%s's
            UPDATE performance_schema.setup_instruments
                SET ENABLED = IF(%s, 'YES', 'NO'),
                    TIMED = ENABLED
        s OR sNAME IN (%s)RMs'%s'sq
            UPDATE performance_schema.setup_consumers
                SET ENABLED = IF(%s, 'YES', 'NO')
        (R(RZ(	R*R`RaRcRdRetisqlR9tcsql((s\C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\wb_admin_perfschema_instrumentation.pytgenerate_updates_for_resets
>.cCsy|dkr_tjjdddddtjkr:dSddg}tjjjd	n|d
krddg}tjjjd
nr|dkr|jjj	dddrt
}t}nt}t
}tjjjd|j||}|GHnx5|D]-}td||jjjj|dq	W|rYtjjjdntjjjd|jjtWn^tjk
r}td|tjjjd|tjjdd|dddnXdS(NRsPerformance Warnings&While enabling all performance_schema instrumentation allows collecting a lot of information from MySQL, it will also impose a significant performance and memory overhead on it.
Do not enable this option if your server is a production server under heavy load, unless you know what you're doing.sLeave UnchangedsEnable EverythingRRs;UPDATE performance_schema.setup_consumers SET enabled='YES'sJUPDATE performance_schema.setup_instruments SET enabled='YES', timed='YES's3Enabling Full Performance Schema Instrumentation...Rs:UPDATE performance_schema.setup_consumers SET enabled='NO'sHUPDATE performance_schema.setup_instruments SET enabled='NO', timed='NO's4Disabling Full Performance Schema Instrumentation...RiiisCResetting Performance Schema settings to default instrumentation...sExecuting %s...
s#Changed Performance Schema Settingss$Disabled Performance Schema Settingss-MySQL error toggling (%s) PS Instrumentation
s5Error toggling Performance Schema Instrumentation: %ss)Toggle Performance Schema InstrumentationsMySQL Error: %sRQ(RR]tshow_warningtResultOkR"R#tset_status_textRKRTRURVRWRXRYRlRt	main_viewteditortexecuteManagementCommandt
rebuild_uiRHR[R\RR^(R*RtsqlR`RatsRh((s\C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\wb_admin_perfschema_instrumentation.pytchange_instrumentationsD			
cCstj|_|jjtjjjd|j|jtt	t
|_|j|j_
|jjdd|j|jtt	tj}|jtjjjd|j|tt	tjd}|jtj|j|tt	dS(Nsps_easysetup_logo.pngiisseparator_vertical.pngs

The MySQL Performance Schema allows you to:
- instrument MySQL to collect statistics and performance data
- log collected events into tables, so they can be analyzed

Use the switch above to change Performance Schema instrumentation or disable it.(RtnewImageBoxtlogot	set_imageR"R#R$taddRHtTrueRtswitch_imageRvRAtset_sizetnewLabeltset_text_aligntMiddleCenter(R*R;tlabel((s\C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\wb_admin_perfschema_instrumentation.pyRLs"cCsY|j}|GH|jjtjjj|dkr;dnd|jj|dS(NRsps_easysetup_logo_enabled.pngsps_easysetup_logo.png(	RiRxRyRR"R#R$R|R?(R*R((s\C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\wb_admin_perfschema_instrumentation.pytreloads4(RDRERRiRlRvRLR(((s\C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\wb_admin_perfschema_instrumentation.pyRF}s		=		*	tSetupInstrumentscBsAeZdZdZdZddZdZdZRS(cCsatjj|t|j|j|jd|jd||_||_	|j
dS(Ni(RRGRRHRRRIRJRKt_dataRL(R*RKtdata((s\C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\wb_admin_perfschema_instrumentation.pyR!s



		cCstjd}|jtj|j|ttd}tj|}|j|tttjtj|_	|j	j
tjddt|j	j
tjddt|j	j
tjddt|j	j
|j|j	tt|j	j|ji|_|j|jjdS(Ns%Select Enabled Instrumentation PointssAn instrument refers to a specific section of the MySQL code that has been enabled for monitoring.
When an instrument is enabled and is executed on the server, it will generate events than can be used for monitoring.

The top level elements on the table below represent the "Event Type" generated by the instrument.

The enabled column indicates whether the events for the instrument are generated.
The timed column indicates whether information about the event duration is recorded.
t
InstrumentitEnabledi2tTimed(RR~t	set_stylet	BoldStyleRzRHR{tnewTreeViewtTreeAltRowColorst_instrumentst
add_columntIconStringColumnTypetTriCheckColumnTypetend_columnstset_cell_edited_callbacktcell_editedt
tag_modelstinsert_nodesRR`(R*tltdescriptionR((s\C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\wb_admin_perfschema_instrumentation.pyRL,s

	cCs&|jj}x|jD]}|jd}|jj}x|D]~}t}d}xZ|r||jkr|j|}|j	d|kr|}t
}q\|d7}q\W|sGd}qGqGW|rxL||D]=}	|	\}
}}|
dkrdnd}
|j|
|qWqqWdS(s`
        Reverts back any change on the UI that has not been committed to the database.
        t/iitenablediN(
Rtget_changestkeystsplitRt	root_nodeRHtcountt	get_childt
get_stringR{Rtset_bool(R*tchangesR+ttokenstnodettokentfoundtindextchildtchangetatttoldtnewtcolumn((s\C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\wb_admin_perfschema_instrumentation.pytrefreshJs(
	
csx|jD]}d}|}|rO|j}dj|j|g}njj}|jd||j|jd||j	|j
d||jd||fd}||j|||j
|<||jds
j|||q
q
WdS(	se
        Inserts nodes based on the model which is an instance
        of PSInstrumentGroup.
        Riiis%scsj|||S(N(tmodel_value_set_callback(tattrtvalueR(R*(s\C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\wb_admin_perfschema_instrumentation.pyt<lambda>{st_data_N(RRt	add_childRZtget_tagRtadd_nodetset_intRttimedt
set_stringtset_tagtset_value_set_notificationRthas_keyR(R*tmodeltparentRRttagtupdate_value_cb((R*s\C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\wb_admin_perfschema_instrumentation.pyRgs cCsB|dkr|jd|n|dkr>|jd|ndS(sb
        Callback to update the UI when an element of the
        model has been changed.
        RiRiN(R(R*RRR((s\C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\wb_admin_perfschema_instrumentation.pyRscCsv|dkrb|j|j}|dkr1dnd}|dkrIdnd}|j||n|j||dS(	sf
        Callback used to updat the model when an element
        of the UI has been updated.
        iit1iRRN(ii(RRR?R(R*RRRRR((s\C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\wb_admin_perfschema_instrumentation.pyRsN(	RDRERRLRRRRR(((s\C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\wb_admin_perfschema_instrumentation.pyR s			 	tSetupDataCollectioncBseeZdZdZd
dZedZddZd
dZ	dZ
dZd	ZRS(cCstjj|t|j|j|jd|jd||_||_	||_
g|_|jjd|jjd|jjdg|_
|j
jd|j
jd|j
jdi|_i|_|jdS(NisCurrent eventssHistory (%s events)sLong History (%s events)sevents_%s_currentsevents_%s_historysevents_%s_history_long(RRGRRHRRRIRJRKRt
_variablest
row_labelsR(t	variablest	_controlst_child_controlsRL(R*RKRR((s\C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\wb_admin_perfschema_instrumentation.pyRs&



							cCsZ|j}||j|_|jj|rVx%|j|D]}|j|q<WndS(N(t
get_activeRRRRtset_enabled(R*tnametcallert	is_activeR((s\C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\wb_admin_perfschema_instrumentation.pytupdate_data_collections
cst}|r|j}ntjjdj|jjdjj	fdj
d<|rjj|sgj|<nj|j
n|jttS(NiicsjdS(Ni(R((tcheckboxR*tvar_lbl(s\C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\wb_admin_perfschema_instrumentation.pyRs(R{RRtnewCheckBoxtset_textRt
set_activeRRtadd_clicked_callbackRRRR(RzRH(R*t	containerRRR((RR*Rs\C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\wb_admin_perfschema_instrumentation.pytcreate_dc_checkboxs
cstj|r8j|jddj}n
j|}j|jt|jj	j
jfdj<|j
ttS(Ntperformance_schema_t_sizecsjS(N(R((RRR*(s\C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\wb_admin_perfschema_instrumentation.pyRs(RRRRRRRtboolRRRRt	ui_fieldsRzRHR{(R*RtelementRtrecordsRtcaption((RRR*s\C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\wb_admin_perfschema_instrumentation.pytcreate_section_rows&


RRcCs|dkrW|}|r0dj||g}n|jd}dj|j}na|dkr|j||}|j|}n4|j||}|j||jd|dj}||fS(Nit_t iRR(RZRt
capitalizeRRRR(R*t	base_nameRtvar_prefix_nametvarRR((s\C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\wb_admin_perfschema_instrumentation.pytget_var_name_and_labels#cCstjtj}|rS|dkr4|jdqn|dkrn|jdqnn|jd|d jtjt}|jd|jd|rx|D]%}|j	||j
|d|qWn\|j	||j
|d}|j	||j
|d	||j	||j
|d
||j||j|tt|j
jjddd
r|j|jj|j|jj|ndS(Ntevents_waits_summarysWait Events Summarytfile_summarysFile Summarys	%s Eventsiiiiiiii(RtnewPaneltTitledBoxPanelt	set_titleRtnewBoxRHRJRIRRRzR{RKRTRURtthread_checkRRR((R*RRtelementstpaneltvboxRtcurrent_ctrl((s\C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\wb_admin_perfschema_instrumentation.pytcreate_sections*


&
cCstjd}|jtj|j|tt|jjj	dddrVd}nd}tj|}|j|tt||_
|jjj	dddr|j||jdd	|_
tjt|_
|j|j
tt|j
g|j|j
<n|jjj	dddrV|j|j
|jd
d	|_g|j|j<ntjt}|jd|jd|jjj	dddr|j|d|j|d
n|j|d|jjj	dddr|j|dn|j
j|tt|jjj	dddsd|j|ddddg|j|dddgn|jjj	dddrd}tj|}|j
j|tt|j|j
|jdd	ndS(Ns5Select performance_schema Event Types to be CollectediiisoPerformance Schema generates execution events only if a consumer for such events is active. A consumer is considered active if it is
enabled and the consumers it depends on are active based on the next hierarchy:

- Global Instrumentation is the top level consumer.
- Thread Instrumentation and Statement Digest depend on Global Instrumentation.
- The Current consumers for Statement, Stage and Wait events depend on Thread Instrumentation
- The History and History Long consumers depend on it's associated Current consumer

The options you toggle determine which of the performance_schema.events_* tables are fed with datas[Performance Schema generates execution events only if a consumer for such events is active.iR
iRit
statementststagestwaitsittransactionsRtby_thread_by_event_namet
by_event_nametby_instanceRsDigesting normalizes statements in a way that permits grouping similar statements and collecting information about how often they occur.
R(RR~RRRzRHR{RKRTRUt_SetupDataCollection__containerRRtglobal_checkRRRRJRIR(R*RRt
desc_labelthboxtdigest_descriptiontdigest_label((s\C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\wb_admin_perfschema_instrumentation.pyRL3sF		!$

cCs|jj}x|jD]}||d\}}}|jj|r|j|}|jt||jj|rx+|j|D]}|jt|qWqqqWdS(s`
        Reverts back any change on the UI that has not been committed to the database.
        iN(	RRRRRRRRR(R*RR+RRRt	item_ctrltcontrol((s\C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\wb_admin_perfschema_instrumentation.pyRys
cCs?d}|dkr|j}n|r;|j|j|ndS(Ntthread(RRRR((R*t	parent_idRR((s\C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\wb_admin_perfschema_instrumentation.pytadd_child_controls
N(
RDRERRRRR{RRRRLRR(((s\C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\wb_admin_perfschema_instrumentation.pyRs		
"	F	tActorInfoDialogcBseZddZdZRS(cCsTtjj|d|jd||_tjt}|jd|j	dd}tj
|}|j|tttj
}|jd|jd|jd|jd|jd	tj|_|jtj
d
tddddtj|j|jddddtjtjBtj|_|jtj
dtddddtj|j|jddddtjtjBtjt}|j	d	tj|_|jjd
tj|_|jjd|j|tttjj||j|j|j|tt|j||jdd|j dS(NsMonitor Events for UseriisDefine the user/host for which performance schema will monitor for events.
You can use the % to indicate any user and/or any hosts.iiiiisUser:isHost:RQtCancelii(!RtFormRRRt	_validateRRHRJRIR~RzR{tnewTablet
set_row_counttset_column_counttset_column_spacingtset_row_spacingtnewTextEntrytusert	HFillFlagtHExpandFlagthostt	newButtontokRtcancelR]tadd_end_ok_cancel_buttonstadd_endtset_contentR}tcenter(R*tvalidate_cbRRRttabletbbox((s\C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\wb_admin_perfschema_instrumentation.pyRsB
	






+)+)

cCsxtrt}|j|j|jrt}|jj}|jj}|j||}|dkrs||fSt
jjd|dddn|s|dkrPqqWdS(NsUser/Host Definition ErrortOkRR(
R{t	run_modalRRRHR
tget_string_valueRRRRR]tshow_message(R*t	cancelledR
Rterror((s\C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\wb_admin_perfschema_instrumentation.pytruns	
N(RDRERRR!(((s\C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\wb_admin_perfschema_instrumentation.pyRs1tObjectInfoDialogcBseZddZdZRS(c	Cstjj|d|jd||_||_tjt}|j	d|j
dd}tj|}|j|tt
tj}|j	d|jd|jd|jd|jd	tj|_|jjjddd
s|jjd|jjtn|jjdd
dddg|jtjdt
ddddtj|j|jdd
ddtjtjBtj|_|jtjdt
dddd
tj|j|jdd
dd
tjtjBtj|_|jtjdt
ddd
dtj|j|jdd
d
dtjtjBtjt
}tj|_ |j j!d|jjjddds|j j"t
|j jtn|j|j t
t
tj|_#|j#j!d|j|j#t
t
|j|ddddtj$tjBtjBtjt
}|j
d	tj%|_&|j&j!dtj%|_'|j'j!d|j|t
t
tj(j)||j&|j'|j*|tt
|j+||j,dd|j-dS(NsMonitor Events Database ObjectiisDefine the database objects which performance schema will monitor for events.
You can use the % to indicate any schema and/or any object name.iiiiiitTABLEtEVENTtFUNCTIONt	PROCEDUREtTRIGGERsType:isSchema:sName:iRiRRQRii(.RRRRRRKRRRHRJRIR~RzR{RRR	R
RtnewSelectorttypeRTRUtadd_itemRt	add_itemsRRRtschemaRRRRRRt	VFillFlagRRRR]RRRR}R(	R*RKRRRRRtchboxR((s\C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\wb_admin_perfschema_instrumentation.pyRsh
		






+)+)+)-

cCsxtrt}|j|j|jrt}|jj}|jj}|jj}|j	j
}|jj
}|j|||}|dkr|||||fStjjd|dddn|s|dkrPqqWdS(Ns Database Object Definition ErrorRRR(R{RRRRHR)RR,RRRRRRRR]R(R*RR)R,RRRR ((s\C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\wb_admin_perfschema_instrumentation.pyR!.s 	N(RDRERRR!(((s\C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\wb_admin_perfschema_instrumentation.pyR"sQtSetupFilteringcBseZdZedZdZdZdZdZdZ	dZ
dZd	Zd
Z
dZdZd
ZRS(cCsjtjj|t|jd|jd|j|j||_||_	||_
|jdS(Ni(RRGRRHRIRJRRRKt_actorst_objectsRL(R*RKtactorstobjects((s\C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\wb_admin_perfschema_instrumentation.pyRDs



			cCs
|jjS(N(RKRT(R*((s\C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\wb_admin_perfschema_instrumentation.pyRTRscCstjt}|jd|jtj|tttj}|jtj	j
jd|j||j|tt|S(Nismini_notice.png(
RRR{RIRzR~RHRwRyR"R#R$tset_tooltip(R*ttextttooltiptboxR((s\C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\wb_admin_perfschema_instrumentation.pytmake_description_boxVs

cCsgtjd}|jtj|j|tttjtj}|j	dtj
t}|jd|jdtj
tjtjB|_|jjtjddt|jjtjddt|jj|jj|j|j|jtttj
t}|jdd}d}|j|j||tttj|_|jjd	|jj|j|jjt|j|jtttj}|jd
|j|j|j|tt|j|tt|j||j|tttjtj}|j	dtj
t}	|	jd|	jdtj
tjtjB|_|jjtjdd
t|jjtjddt|jjtjddt|jjtj ddt|jjtj ddt|jj|jj|j!|jj"|j#|	j|jtttj
t}
|
jdd}d}|
j|j||tttj|_$|j$jd	|j$j|j%|j$jt|
j|j$tttj}|jd
|j|j&|
j|tt|	j|
tt|j|	|j|tt|j'dS(Ns(Filter Users and Objects to be MonitoredtUsersitUseritHostsPerformance Schema allows defining filters to determine the connections for which data will be collected.
New connections having a user@host matching an entry below will be enabled for monitoring.s.Use % to indicate either any user or any host.tRemovetAddsDatabase ObjectstTypeidtSchemaitObjectRi2RsPerformance Schema allows defining filters to determine the objects for which data will be collected.
Any schema/object matching a combination defined above will be enabled for monitoring.sUse % to indicate either any schema or any object.

The enabled column indicates whether events for the matching objects are instrumented.
The timed column indicates whether information about the events duration is recorded.((RR~RRRzRHR{RRRRRIRJRtTreeFlatListRtusersRtStringColumnTypeRtadd_changed_callbacktselected_user_changedR8Rtuser_del_buttonRRtremove_userRRtadd_userR3tCheckColumnTypetselected_object_changedRt
object_editedt
db_del_buttont
remove_objectt
add_objectR(R*Rt
user_panelt	users_boxtuser_buttonsRR6tuser_add_buttontdb_paneltdb_boxt
db_buttonst
db_add_button((s\C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\wb_admin_perfschema_instrumentation.pyRL`s













cCs|jjxF|jD];}|jj}|jd|j|jd|jqW|jjx|jD]t}|jj}|jd|j	|jd|j
|jd|j|jd|j
|jd|jqmWdS(Niiiii(RBtclearR0RRR
RR3R1R)R,RRRR(R*R+R((s\C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\wb_admin_perfschema_instrumentation.pyRs

cCs/|jj}|dk	}|jj|dS(N(RBtget_selected_nodeRRFR(R*RR((s\C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\wb_admin_perfschema_instrumentation.pyREscCsm|jj}|dk	ri|jd}|jd}|jjt|||j|jndS(Nii(	RBRXRRR0tremoveRtremove_from_parentRE(R*RR
R((s\C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\wb_admin_perfschema_instrumentation.pyRGs
cCst|j}|j}|r||jj}|jd|d|jd|d|jjt|d|dndS(Nii(	Rt
validate_userR!RBRRR0R(R(R*tdlgtactorR((s\C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\wb_admin_perfschema_instrumentation.pyRHscCsUd}|dkr'|dkr'd}n*|jjt||dkrQd}n|S(NRRs&Both user and host are required fieldsisPThe specified user/host is already setup for performance schema data collection.(RR0RR(R*R
RR ((s\C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\wb_admin_perfschema_instrumentation.pyR[s	!	cCs/|jj}|dk	}|jj|dS(N(R3RXRRLR(R*RR((s\C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\wb_admin_perfschema_instrumentation.pyRJscCs|dkr|jjt|jd|jd|jddd}|dkr]tnt}|dkr||j|_n||j|_|j	||ndS(	sM
        This method will be used to enable/disable the instruments.
        iiiiiRN(ii(
R1RRRRR{RHRRR(R*RRRRtset((s\C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\wb_admin_perfschema_instrumentation.pyRKs?cCs|jj}|dk	r|jd}|jd}|jd}|jjt|||dd|j|jndS(Niii(	R3RXRRR1RYRRZRJ(R*RR)R,R((s\C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\wb_admin_perfschema_instrumentation.pyRMs"
cCst||j}|j}|r|jj}|jd|d|jd|d|jd|d|jd|d|jd|d|jjt	|d|d|d|d|dndS(Niiiii(
R"tvalidate_objectR!R3RRRR1R(R(R*R\tobjectR((s\C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\wb_admin_perfschema_instrumentation.pyRNscCs^d}|dks|dkr'd}n3|jjt|||dddkrZd}n|S(NRRs+The next fields are required: object, name.isVThe specified database object is already setup for performance schema data collection.(RR1RR(R*R)R,RR ((s\C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\wb_admin_perfschema_instrumentation.pyR_(s	*	(RDRERtpropertyRTR8RLRRERGRHR[RJRKRMRNR_(((s\C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\wb_admin_perfschema_instrumentation.pyR/Cs		
	`			
		
				tSetupOptionscBs>eZdZdZdZdZdZdZRS(cCstjj|t|jd|jd|j|j||_||_	||_
|j
j|_|jj
i|_i|_d|jd<d|jd<d|jd<d|jd	<d
|jd<|jdS(NisKOccurs based on the CPU speed - frequency: %s, resolution: %s, overhead: %stCYCLEs^It is an established frequency on each platform - frequency: %s, resolution: %s, overhead: %s.tTICKsROccurs a thousand times in a second - frequency: %s, resolution: %s, overhead: %s.tMILLISECONDsQOccurs a million times in a second - frequency: %s, resolution: %s, overhead: %s.tMICROSECONDsQOccurs a billion times in a second - frequency: %s, resolution: %s, overhead: %s.t
NANOSECOND(RRGRRHRIRJRRt_timer_typesRKt_timersRt_timer_namestsortRt
_descriptionsRL(R*RKttimersttimer_types((s\C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\wb_admin_perfschema_instrumentation.pyR4s$



			
		




cCs:|jjd}|d j}||j|_dS(Nii(RRtupperRittimer(R*RRR((s\C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\wb_admin_perfschema_instrumentation.pytupdate_timerOscCsC|j|j|j|j|jf}d|jjj|fS(Ns%ss        (%s)(RlRt	frequencyt
resolutiontoverheadtlowerR(R*RpR((s\C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\wb_admin_perfschema_instrumentation.pytget_timer_type_textTs&cs'|jtjdjjtdddtjtjtjj	gj
D]}j|^qbj}j|j
}j
jt|ddd}j|jfdj|<|jdddtjtjBtjBdS(Ns	%s EventsiicsjjS(N(RqRj((toffsettselectorR*(s\C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\wb_admin_perfschema_instrumentation.pyRdsi(RzRR~RjRR{RR(t
SelectorPopupR+RhRvRiRpRRRtset_selectedRDRR-R(R*RRwRpt
timer_nametps_timerR((RwRxR*s\C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\wb_admin_perfschema_instrumentation.pytcreate_timer_rowXs@,
!

cCstjtj}|jdtjt}|jdd}|jtj|tttj	}|jd|j
d|jd|jd|j
dx-tt|jD]}|j||qW|j|tt|j||j|ttdS(	NsEvent TimersisInstruments measure the duration of events, for which they can use different timers.
A timer has characteristics that need to be considered when setting up the timer to be used on the
different instruments:

     - Frequency: Indicates the number of timer units per second.
     - Resolution: Indicates the size used to increase a timer value at a time.
     - Overhead: Minimal number of cycles of overhead to obtain one timing.

Here you can configure which timer will be used for each instrument type.

iiiii(RRRRRRHRJRzR~RRR	R
RtrangetlenRjR}R{(R*RRRRRe((s\C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\wb_admin_perfschema_instrumentation.pyRLks"

	





cCs]xV|jD]K}|j|j}|jjt|ddd}|j|j|q
WdS(N(RRiRpRhRRRRz(R*RR|R((s\C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\wb_admin_perfschema_instrumentation.pyRs!(RDRERRqRvR}RLR(((s\C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\wb_admin_perfschema_instrumentation.pyRb3s					"t	IntroPagecBseZdZRS(cCstjj|d|j|jtjt|_|jjd|jj	dtj
d}|jtj|jj
|tt|jj
tj
dtttj}|jtjjjd|jj
|tttj
d}|jtj|jj
|tt|jj
tj
dtttj
d	}|jtj|jj
|tt|jj
tj
d
tt|j
|jdS(NiiisPerformance Schema BasicssThe performance schema collects data from various aspects of MySQL performance and gives
very detailed information about what exactly is happening inside your MySQL database server.
For each statement executed, the PS instruments will gather various statistics and timing information in different
levels of granularity and from different subsystems, from network to disk storage, and keep them in the 
performance_schema.events_* tables.sps_overview.pngsConfiguring Performance SchemasTo control the trade-off between data collected and overhead, the performance schema gives
you a few fine grained configuration options.
 
You can configure what, when and how much will be instrumented by the Performance Schema by tweaking three option categories:

  * Actors - filters the users, hosts and DB objects to collect data for the performance_schema. This was introduced in MySQL 5.6.
    
  * Instruments - allow fine-tuning of what kind of stats are gathered for whatever is being monitored

  * Consumers - toggle which of the performance_schema.event_* tables should be filled

You can also use the simplified configuration interface for one-click setup of the performance schema for some common use cases.
s#Performance Schema Instrument TypessThe Performance Schema will monitor the following types of events that occur internally in the MySQL server, as client requests are executed.

  * Statement monitoring starts when a new request arrives into a server thread and ends once all processing is complete.
    These are logged in the event_statement_* tables.

  * Stage monitors the different stages that occur during the statement execution. Depends on Thread Instrumentation.
    These are logged in the event_stage_* tables.

  * Wait monitoring is focused on wait events that occur during the statement execution.
    These are logged in the event_wait_* tables.


For more information, refer to the MySQL manuals section on the Performance Schema.
(RtScrollPanelRRRRRHR7RIRJR~RtBigBoldStyleRzR{RwRyR"R#R$R(R*RKRR;R((s\C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\wb_admin_perfschema_instrumentation.pyRs2


(RDRER(((s\C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\wb_admin_perfschema_instrumentation.pyRstSetupThreadscBsGeZdZdZdZdZdZdZdZRS(cCsXtjj|t|jd|jd|j|j||_|j	dS(Ni(
RRGRRHRIRJRRt_threadsRL(R*R((s\C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\wb_admin_perfschema_instrumentation.pyRs



	cCstjd}|jtj|j|tttjd}|j|tttjtjtj	B|_
|j
jtjddt|j
jtj
ddt|j
jtjddt|j
jtj
d	dt|j
jtj
d
dt|j
jtj
ddt|j
jtj
d
dt|j
jtj
ddt|j
jtj
ddt|j
jtj
ddt|j
jtj
ddt|j
j|j
j|j|j|j
tt|jtjt}|jdtj|_|jjd|jj|j|j|jtttj|_|jjd|jj|j|j|jtttj|_|jjd|jj|j|j|jtt|j|ttdS(NsThreads to InstrumentsPerformance Schema allows enabling/disabling the monitoring of events that occur on specific threads in the server.

Changes on the instrumentation status are only effective if Thread Instrumentation is enabled on the Consumers Tab.tIdi2tNameitInstrumentediPR>s
Process IdtAccountidtCommandtTimetStatetInfotDBisInstrument AllsInstrument NonetRefresh(RR~RRRzRHR{RRARtthreadsRtLongIntegerColumnTypeRCRIRRt
thread_editedRRRIRt_enable_allRRt
enable_allt_disable_alltenable_nonet_refresh_buttontrefresh_dataR(R*RRR((s\C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\wb_admin_perfschema_instrumentation.pyRLsH


cCs|jj|jdS(N(RR(R*((s\C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\wb_admin_perfschema_instrumentation.pyRs
cCsk|jj}xUt|jjD]>}|j|}t|j|jd_|j	dtq%WdS(Nii(
RRR~RRR{Rtget_longtinstrumentedR(R*troottrowR((s\C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\wb_admin_perfschema_instrumentation.pyRs
cCsk|jj}xUt|jjD]>}|j|}t|j|jd_|j	dtq%WdS(Nii(
RRR~RRRHRRRR(R*RRR((s\C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\wb_admin_perfschema_instrumentation.pyRs
cCs|jj|jj}|jx|D]}|jj}|jd|j|j|jd|j|j	|j
d|j|j|j|jdkr|jddnC|j|jdkr|jddn|jd|j|j|jd	|j|j
|j|jdkr?|jd
dn.|jd
d|j|j|j|jf|jd
|j|j|jd|j|j|jd|j|j|jd|j|j|jd|j|jq-WdS(s;
        Refreshes the UI based on the model class
        iiit
BACKGROUNDitBGt
FOREGROUNDtFGiis<system>s%s@%siiii	i
N(RRWRRRkRtset_longtidRRRRtthread_typetplist_idt
plist_usert
plist_hostt
plist_commandt
plist_timetplist_statet
plist_infotplist_db(R*titemsR+R((s\C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\wb_admin_perfschema_instrumentation.pyR&s,


.cCsT|dkrP|dkrtnt}||j|jd_|jd|ndS(sM
        This method will be used to enable/disable the instruments.
        iRiN(R{RHRRRR(R*RRR((s\C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\wb_admin_perfschema_instrumentation.pyRDs(	RDRERRLRRRRR(((s\C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\wb_admin_perfschema_instrumentation.pyRs		0				t'WbAdminPerformanceSchemaInstrumentationcBseZdZedZedZdZedZdZ	dZ
dZd	Zd
Z
dZdZd
ZdZdZdZRS(iicCs|j|ddtdS(Ntwba_performancesPerformance Schema Setup(t
register_pageRH(tclst
admin_context((s\C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\wb_admin_perfschema_instrumentation.pytwba_registerRscCsdS(Ntadmin_instrumentation_setup((R((s\C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\wb_admin_perfschema_instrumentation.pyt
identifierVscCs9tj||||tj|||_d|_dS(N(R	RRtctrl_beRtcontent(R*Rt
instance_infoRp((s\C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\wb_admin_perfschema_instrumentation.pyRZs
	cCs
|jjS(N(RRT(R*((s\C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\wb_admin_perfschema_instrumentation.pyRTbscCs3tj|||||jj|jdkdS(Ni(Rtcount_changetapply_buttonRtchange_count(R*RRR((s\C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\wb_admin_perfschema_instrumentation.pyRgscCstj|_|jj|j|jjd|jdd|jtjt|_	tj
tj|_t
||_|jj|jd|j	j|jtt|jt|j|j	ttt|_|jdS(Ns
Show Advancedstitle_instrumentation_setup.pngsPerformance Schema - Setups
Easy Setup(RRtadvanced_buttonRtswitch_advancedRtcreate_basic_uiRRHRtTabViewtTabViewSystemStandardt
config_tabRFt
easy_setuptadd_pageRzR{Rst_showing_advanced(R*((s\C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\wb_admin_perfschema_instrumentation.pyRLns
	cCs3|r|jj|jd|jj|jd|jj|jd|jrj|jj|jdn|jr|jj|jdn|jj|jdn|jj|j|jj|j|jj|j|jr|jj|jn|jr|jj|jn|jj|jdS(NtIntroductiontInstrumentst	ConsumerssActors & ObjectstThreadstOptions(	RRtintroR`tdata_collectiont	filteringRtoptionstremove_page(R*tflag((s\C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\wb_admin_perfschema_instrumentation.pytswitch_config_tabss"				cCs|j|_|jrF|jt|jjt|jjtn-|jt|jjt|jjt|jj|jrdnddS(Ns
Hide Advanceds
Show Advanced(	RRR{Rtshowt
cancel_buttonRHRR(R*((s\C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\wb_admin_perfschema_instrumentation.pyRs
	

cCsv|s|jtn|jjt|j|_|jj|j|jt	||_
t||jjd|_
t||jjd|jj|_|jjjddrt||jjd|jjd|_n	d|_|jjjddr9t|jjd|_|jjd|jn	d|_t||jjd	|jj|_|rRtjt|_|jj d|jj!d
tj"|_#|j#j$d|j#j%d|j#j&|j'|jj(|j#tttj"|_)|j)j%d
|j)j$d|j)j&|j*|j)j+ttj"|_,|j,j%d|j,j$d|j,j&|j-|jj.|j)tt|jj.|j,tt|jjjddr6tj"|_/|j/j$d|j/j%d|j/j&|j0|jj.|j/ttn|j1j(|jttn|rr|j2rr|jtndS(NR`RaiiR2R3RRRmislResets/truncates all performance_schema event tables, deleting all performance schema data collected so far.sClear Event TablestApplysKApply changes to the performance_schema configurations to the MySQL server.tReverts@Revert to the configuration currently saved in the MySQL server.sfReset all performance_schema settings (instruments, threads, actors, objects etc) to factory defaults.sFull Reset to Factory Defaults(3RRHRRRRtconfig_datatloadtcount_changes_onRRRtsectionsR`RRRRTRUR/RRRRRRbRnRRRR{tbuttonsRJRIRtreset_buttonR4RRton_reset_button_clickedRzRton_apply_button_clickedRRton_revert_button_clickedRtreset_to_factory_buttont"on_reset_to_factory_button_clickedRR(R*tfrom_scratch((s\C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\wb_admin_perfschema_instrumentation.pyRss\

%,		%cCs0|jj}|jt|jj|dS(N(Rtget_active_tabRsRHtset_active_tab(R*ttab((s\C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\wb_admin_perfschema_instrumentation.pyRs
cCsz|j|jj|jj|jj|jjjdddr\|jjn|j	j|j
jdS(Niii(RR`RRtrevert_changesRRTRURRR(R*((s\C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\wb_admin_perfschema_instrumentation.pyton_cancel_button_clickeds




cCs|jjdS(N(Rtcommit_changes(R*((s\C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\wb_admin_perfschema_instrumentation.pyR
scCstjjdddddtjkry|jjjddWqtk
r}td|tjj	dd	|d
ddqXndS(NsClear Event Tabless`performance_schema event summary and history tables will be cleared (truncated).
Please confirm.sClear TablesRRRs"call sys.ps_truncate_all_tables(0)is0Error calling sys.ps_truncate_all_tables(0): %s
s@An error occurred truncating performance_schema event tables.
%sRQ(
RR]RRnRpRqRrt	ExceptionRR^(R*Rh((s\C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\wb_admin_perfschema_instrumentation.pyRscCstjjdddddtjkry|jjjddWnBtk
r}td|tjj	dd	|d
dddSX|j
ndS(Ns!Reset Performance Schema SettingsshAll performance_schema instrumentation settings will be reset to factory configurations.
Please confirm.tResetRRRs%call sys.ps_setup_reset_to_default(0)is-Error calling sys.ps_reset_to_default(0): %s
sKAn error occurred resetting performance_schema instrumentation settings.
%sRQ(RR]RRnRpRqRrRRR^R(R*Rh((s\C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\wb_admin_perfschema_instrumentation.pyRs cCsdS(N((R*((s\C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\wb_admin_perfschema_instrumentation.pyR's(iii(RDREtmin_server_versiontclassmethodRRRRaRTRRLRRRsRRRRRR(((s\C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\wb_admin_perfschema_instrumentation.pyROs 						J				
	(&R[Rtworkbench.change_trackerRtworkbench.graphics.cairo_utilsRtworkbench.graphics.canvasRt&wb_admin_perfschema_instrumentation_beRRRRt
workbench.logRRtwb_admin_perfschemaR	tMYSQL_ERR_TABLE_DOESNT_EXISTRVRXRWRYRRRGRFRRRRR"R/RbRRRR(((s\C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\wb_admin_perfschema_instrumentation.pyt<module>s>"		CEga@{

Anon7 - 2022
AnonSec Team