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 (x86)/MySQL/MySQL Workbench 6.1 CE/modules/

Upload File :
current_dir [ Writeable ] document_root [ Writeable ]

 

Command :

[ HOME SHELL ]     

Current File : /Program Files (x86)/MySQL/MySQL Workbench 6.1 CE/modules/wb_admin_perfschema_instrumentation.pyc

,2Sc@sddlZddlZddlmZddlmZddlmZddlm	Z	m
Z
mZmZddl
mZmZddlmZdZd	ejfd
YZdejfdYZd
ejfdYZdejfdYZdejfdYZdejfdYZdejfdYZdejfdYZdejfdYZdejfdYZ deefdYZ!dS(iN(t
ChangeCounter(tContext(tImageFigure(tPSConfigurationtPSTimerTypetPSObjecttPSActor(tlog_infot	log_error(tWbAdminPSBaseTabizt	BigSwitchcBs,eZdZdZdZdZRS(cCstjj||j|j|j|t|_tjj	j
d|_tjj	j
d|_t
|j|_dS(Nsbig_switcher_no.pngsbig_switcher_yes.png(tmformst	PyDrawBoxt__init__tset_managedtset_release_on_addtset_instancetFalsetstatetApptgettget_resource_patht	off_imageton_imageRtimage(tself((sbC:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\wb_admin_perfschema_instrumentation.pyR
"s


	cCsA|jj|j|jjdd|jjt|dS(Nii(Rtmovet	get_widthtwidthtrenderR(Rtcrtxtytwth((sbC:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\wb_admin_perfschema_instrumentation.pytrepaint/s'cCs<||_|jj|jr$|jn|j|jdS(N(RRtset_image_fileRRtset_needs_repaint(Rtflag((sbC:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\wb_admin_perfschema_instrumentation.pyt	set_state4s	%cCs%|j|j|j|jdS(N(R'Rtcallback(RtbuttonRR ((sbC:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\wb_admin_perfschema_instrumentation.pytmouse_click9s(t__name__t
__module__R
R#R'R*(((sbC:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\wb_admin_perfschema_instrumentation.pyR
!s	
		t
EasySetupPagecBs5eZdZdZdZdZdZRS(cCsXtjj|t|j|j|jd|jd||_|j	dS(Ni(
RtBoxR
RRRtset_spacingtset_paddingtownert	create_ui(RR1((sbC:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\wb_admin_perfschema_instrumentation.pyR
?s



	cCsyK|jjd}|dkrF|jjd}|dkrFtSntSWnDtjk
r}td|tjj	dd|dddnXdS(	NsJSELECT COUNT(*) FROM performance_schema.setup_consumers WHERE enabled='NO'isZSELECT COUNT(*) FROM performance_schema.setup_instruments WHERE enabled='NO' OR timed='NO's6MySQL error querying PS instrumentation/consumers: %s
s,Check Performance Schema Configuration States<Error checking configuration state of Performance Schema: %stOKt(R1tget_select_int_resulttTrueRtgrttDBErrorRRt	Utilitiest
show_errortNone(Rtrte((sbC:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\wb_admin_perfschema_instrumentation.pytcheck_full_instrumentationJs$cCs0y|r.ddg}tjjjdndg}tjjjdx5|D]-}td||jjjj|dqTW|rtjjjdntjjjd	|jj	t
Wn^tjk
r+}t
d
|tjjjd|tjjdd
|dddnXdS(Ns;UPDATE performance_schema.setup_consumers SET enabled='YES'sJUPDATE performance_schema.setup_instruments SET enabled='YES', timed='YES's3Enabling Full Performance Schema Instrumentation...s:UPDATE performance_schema.setup_consumers SET enabled='NO's4Disabling Full Performance Schema Instrumentation...sExecuting %s...
is/Enabled Full Performance Schema Instrumentations0Disabled Full Performance Schema Instrumentations2MySQL error toggling (%s) Full PS Instrumentation
s:Error toggling Full Performance Schema Instrumentation: %ss)Toggle Performance Schema InstrumentationsMySQL Error: %sR3R4(RRRtset_status_textRR1t	main_viewteditortexecuteManagementCommandt
rebuild_uiRR7R8RR9R:(RRtsqltsR=((sbC:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\wb_admin_perfschema_instrumentation.pyttoggle_full_instrumentationYs(		
cCstj}|jtjjjd|j|ttt	|_
|j|j
_|j
j
dd|j|j
tttj}|jtjjjd|j|tttjd}|jtj|j|ttdS(Nsps_easysetup_logo.pngii2sseparator_vertical.pngs

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

Use the switch above to enable all available Performance Schema instruments.(RtnewImageBoxt	set_imageRRRtaddRR6R
tswitch_imageRFR(tset_sizetnewLabeltset_text_aligntMiddleCenter(RRtlabel((sbC:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\wb_admin_perfschema_instrumentation.pyR2tscCs|jj|jdS(N(RJR'R>(R((sbC:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\wb_admin_perfschema_instrumentation.pytreloads(R+R,R
R>RFR2RP(((sbC:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\wb_admin_perfschema_instrumentation.pyR->s
				tSetupInstrumentscBsAeZdZdZdZddZdZdZRS(cCsatjj|t|j|j|jd|jd||_||_	|j
dS(Ni(RR.R
RRRR/R0R1t_dataR2(RR1tdata((sbC:\Program Files (x86)\MySQL\MySQL Workbench 6.1 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(RRLt	set_stylet	BoldStyleRIRR6tnewTreeNodeViewtTreeAltRowColorst_instrumentst
add_columntIconStringColumnTypetTriCheckColumnTypetend_columnstset_cell_edited_callbacktcell_editedt
tag_modelstinsert_nodesRRtinstruments(RtltdescriptionRO((sbC:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\wb_admin_perfschema_instrumentation.pyR2s

	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(
RRtget_changestkeystsplitR[t	root_nodeRtcountt	get_childt
get_stringR6R;tset_bool(Rtchangestitemttokenstnodettokentfoundtindextchildtchangetatttoldtnewtcolumn((sbC:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\wb_admin_perfschema_instrumentation.pytrefreshs(
	
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.
        Rgiiis%scsj|||S(N(tmodel_value_set_callback(tattrtvalueRt(R(sbC:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\wb_admin_perfschema_instrumentation.pyt<lambda>st_data_N(RjR;t	add_childtjointget_tagR[tadd_nodetset_intRhttimedt
set_stringtset_tagtset_value_set_notificationRbthas_keyRc(RtmodeltparentRxRtttagtupdate_value_cb((RsbC:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\wb_admin_perfschema_instrumentation.pyRcs cCsB|dkr|jd|n|dkr>|jd|ndS(sb
        Callback to update the UI when an element of the
        model has been changed.
        RhiRiN(R(RRRRt((sbC:\Program Files (x86)\MySQL\MySQL Workbench 6.1 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.
        iit1iRhRN(ii(RbRR'R(RRtR}RRR((sbC:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\wb_admin_perfschema_instrumentation.pyRasN(	R+R,R
R2R~R;RcRRa(((sbC:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\wb_admin_perfschema_instrumentation.pyRQs			 	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sCollect current eventssHistory (%s events)sLong History (%s events)sevents_%s_currentsevents_%s_historysevents_%s_history_long(RR.R
RRRR/R0R1RRt
_variablest
row_labelstappendt	variablest	_controlst_child_controlsR2(RR1RSR((sbC:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\wb_admin_perfschema_instrumentation.pyR
s&



							cCsZ|j}||j|_|jj|rVx%|j|D]}|j|q<WndS(N(t
get_activeRRRhRRtset_enabled(Rtnametcallert	is_activeRx((sbC:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\wb_admin_perfschema_instrumentation.pytupdate_data_collection,s
cst}|r|j}ntjjdj|jjdjj	fdj
d<|rjj|sgj|<nj|j
n|jttS(NiicsjdS(Ni(R((tcheckboxRtvar_lbl(sbC:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\wb_admin_perfschema_instrumentation.pyRBs(R6RRtnewCheckBoxtset_textRt
set_activeRRRhtadd_clicked_callbackRRRRRIR(Rt	containerRRRh((RRRsbC:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\wb_admin_perfschema_instrumentation.pytcreate_dc_checkbox6s
cstj|r8j|jddj}n
j|}j|j|jjj	j
fdj<|jt
t
S(Ntperformance_schema_t_sizecsjS(N(R((RRR(sbC:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\wb_admin_perfschema_instrumentation.pyR_s(RRRRRRRRRRRhRt	ui_fieldsRIR(RRtelementRtrecordsRhtcaption((RRRsbC:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\wb_admin_perfschema_instrumentation.pytcreate_section_rowSs&



R4cCs|dkrW|}|r0dj||g}n|jd}dj|j}na|dkr|j||}|j|}n4|j||}|j||jd|dj}||fS(Nit_t iRR(RRkt
capitalizeRRRR(Rt	base_nameRwtvar_prefix_nametvarRsR((sbC:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\wb_admin_perfschema_instrumentation.pytget_var_name_and_labelfs#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_titleRtnewBoxRR0R/RRRIR6R1ttarget_versiont#is_supported_mysql_version_at_leastRtthread_checkRRR(RRRtelementstpaneltvboxRtcurrent_ctrl((sbC:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\wb_admin_perfschema_instrumentation.pytcreate_section|s*


&
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|j
j|tt|jjj	ddds6|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.itglobal_instrumentationitthread_instrumentationit
statementststagestwaitsRtby_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.
tstatements_digest(RRLRWRXRIRR6R1RRt_SetupDataCollection__containerRRtglobal_checkRRRR0R/R(RReRft
desc_labelthboxtdigest_descriptiontdigest_label((sbC:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\wb_admin_perfschema_instrumentation.pyR2sB		!$

cCs|jj}x|jD]}||d\}}}|jj|r|j|}|j||jj|rx%|j|D]}|j|qWqqqWdS(s`
        Reverts back any change on the UI that has not been committed to the database.
        iN(RRRiRjRRRRR(RRqRrRzR{R|t	item_ctrltcontrol((sbC:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\wb_admin_perfschema_instrumentation.pyR~s

cCs?d}|dkr|j}n|r;|j|j|ndS(Ntthread(R;RRR(Rt	parent_idRxR((sbC:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\wb_admin_perfschema_instrumentation.pytadd_child_controls
N(
R+R,R
RR;RR6RRRR2R~R(((sbC:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\wb_admin_perfschema_instrumentation.pyRs		
"	C	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:R3tCancelii(!RtFormR
R;Rt	_validateRRR0R/RLRIR6tnewTablet
set_row_counttset_column_counttset_column_spacingtset_row_spacingtnewTextEntrytusert	HFillFlagtHExpandFlagthostt	newButtontokRtcancelR9tadd_end_ok_cancel_buttonstadd_endtset_contentRKtcenter(Rtvalidate_cbRRRettabletbbox((sbC:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\wb_admin_perfschema_instrumentation.pyR
sB
	






+)+)

cCsxtrt}|j|j|jrt}|jj}|jj}|j||}|dkrs||fSt
jjd|dddn|s|dkrPqqWdS(NsUser/Host Definition ErrortOkR4(
R6t	run_modalRRRRtget_string_valueRRR;RR9tshow_message(Rt	cancelledRRterror((sbC:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\wb_admin_perfschema_instrumentation.pytrun1s	
N(R+R,R;R
R(((sbC:\Program Files (x86)\MySQL\MySQL Workbench 6.1 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|ddddtjtjBtjt
}|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 for which performance schema will monitor for events.
You can use the % to indicate any schema and/or any object name.iiiiiitTABLEtEVENTtFUNCTIONt	PROCEDUREtTRIGGERsType:isSchema:sName:iRUiRVR3Rii(-RRR
R;RR1RRRR0R/RLRIR6RRRRRtnewSelectorttypeRRtadd_itemRt	add_itemsRRRtschemaRRRhRRRRRRR9RRRRKR(	RR1RRRReRtchboxR((sbC:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\wb_admin_perfschema_instrumentation.pyR
Esh
		






+)+)+)&

cCsxtrt}|j|j|jrt}|jj}|jj}|jj}|j	j
}|jj
}|j|||}|dkr|||||fStjjd|dddn|s|dkrPqqWdS(Ns Database Object Definition ErrorRR4(R6RRRRRRRRRhRRRR;RR9R(RRRRRRhRR((sbC:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\wb_admin_perfschema_instrumentation.pyRs 	N(R+R,R;R
R(((sbC:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\wb_admin_perfschema_instrumentation.pyRDsQtSetupFilteringcBseZdZedZdZdZdZdZdZ	dZ
dZd	Zd
Z
dZdZRS(
cCsjtjj|t|jd|jd|j|j||_||_	||_
|jdS(Ni(RR.R
RR/R0RRR1t_actorst_objectsR2(RR1tactorstobjects((sbC:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\wb_admin_perfschema_instrumentation.pyR
s



			cCs
|jjS(N(R1R(R((sbC:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\wb_admin_perfschema_instrumentation.pyRscCsUtjd}|jtj|j|tttjtj}|j	dtj
t}|jd|jdtjd}|j|tttj
tjtjB|_|jjtjddt|jjtjddt|jj|jj|j|j|jtttj
t}|jdtj|_|jjd|jj|j|jjt|j|jtttj}|jd	|j|j|j|tt|j|tt|j||j|tttjtj}|j	d
tj
t}|jd|jdtjd}|j|tttj
tjtjB|_|jjtjdd
t|jjtjddt|jjtjddt|jjtjddt|jjtjddt|jj|jj|j |jj!|j"|j|jtttj
t}	|	jdtj|_#|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sPerformance 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.

Use % to indicate either any user or any host.tUseritHosttRemovetAddsDatabase ObjectssPerformance Schema allows defining filters to determine the objects for which data will be collected.
Any schema/object matching a combination defined below will be enabled for monitoring.

Use % 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.tTypeidtSchemaitObjectRUi2RV('RRLRWRXRIRR6RRRRR/R0RYtTreeFlatListRZtusersR\tStringColumnTypeR_tadd_changed_callbacktselected_user_changedRtuser_del_buttonRRtremove_userRRtadd_userRtCheckColumnTypetselected_object_changedR`t
object_editedt
db_del_buttont
remove_objectt
add_objectR~(RRet
user_panelt	users_boxRftuser_buttonstuser_add_buttontdb_paneltdb_boxt
db_buttonst
db_add_button((sbC:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\wb_admin_perfschema_instrumentation.pyR2s|













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(RtclearRRRRRRRRRRRpRhR(RRrRt((sbC:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\wb_admin_perfschema_instrumentation.pyR~s

cCs/|jj}|dk	}|jj|dS(N(Rtget_selected_nodeR;RR(RRtRh((sbC:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\wb_admin_perfschema_instrumentation.pyR0scCsm|jj}|dk	ri|jd}|jd}|jjt|||j|jndS(Nii(	RR'R;RoRtremoveRtremove_from_parentR(RRtRR((sbC:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\wb_admin_perfschema_instrumentation.pyR6s
cCst|j}|j}|r||jj}|jd|d|jd|d|jjt|d|dndS(Nii(	Rt
validate_userRRRRRRR(RtdlgtactorRt((sbC:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\wb_admin_perfschema_instrumentation.pyR@scCsUd}|dkr'|dkr'd}n*|jjt||dkrQd}n|S(NR4s&Both user and host are required fieldsisPThe specified user/host is already setup for performance schema data collection.(R;RRmR(RRRR((sbC:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\wb_admin_perfschema_instrumentation.pyR*Ks	!	cCs/|jj}|dk	}|jj|dS(N(RR'R;RR(RRtRh((sbC:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\wb_admin_perfschema_instrumentation.pyRUs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(
RRwRRoR;R6RRhRRp(RRtR}RRwtset((sbC:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\wb_admin_perfschema_instrumentation.pyR[s?cCs|jj}|dk	r|jd}|jd}|jd}|jjt|||dd|j|jndS(Niii(	RR'R;RoRR(RR)R(RRtRRR((sbC:\Program Files (x86)\MySQL\MySQL Workbench 6.1 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(
Rtvalidate_objectRRRRRpRRR(RR+tobjectRt((sbC:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\wb_admin_perfschema_instrumentation.pyRxscCs^d}|dks|dkr'd}n3|jjt|||dddkrZd}n|S(NR4s+The next fields are required: object, name.isVThe specified database object is already setup for performance schema data collection.(R;RRmR(RRRRR((sbC:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\wb_admin_perfschema_instrumentation.pyR.s	*	(R+R,R
tpropertyRR2R~RRRR*RRRRR.(((sbC:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\wb_admin_perfschema_instrumentation.pyRs		`			
		
				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(RR.R
RR/R0RRt_timer_typesR1t_timersRjt_timer_namestsortRt
_descriptionsR2(RR1ttimersttimer_types((sbC:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\wb_admin_perfschema_instrumentation.pyR
s$



			
		




cCs:|jjd}|d j}||j|_dS(Nii(RRktupperR8ttimer(RRRR((sbC:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\wb_admin_perfschema_instrumentation.pytupdate_timerscCsC|j|j|j|j|jf}d|jjj|fS(Ns%ss        (%s)(R;Rt	frequencyt
resolutiontoverheadtlowerR(RR?Rf((sbC:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\wb_admin_perfschema_instrumentation.pytget_timer_type_texts&cs |jtjdjjtdddtjtjtjj	gj
D]}j|^qbj}j|j
}j
jt|ddd}j|jfdj|<|jdddtjtjBdS(Ns	%s EventsiicsjjS(N(R@R9((Rtselectortoffset(sbC:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\wb_admin_perfschema_instrumentation.pyRsi(RIRRLR9RR6RRt
SelectorPopupRR7RER8R?RwRR;tset_selectedRRR(RRRGR?t
timer_nametps_timerRw((RRFRGsbC:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\wb_admin_perfschema_instrumentation.pytcreate_timer_rows@,
!

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 that 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(RRRRRRR0RIRLRRRRRtrangetlenR9RL(RRRRfRti((sbC:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\wb_admin_perfschema_instrumentation.pyR2s"

	





cCs]xV|jD]K}|j|j}|jjt|ddd}|j|j|q
WdS(N(RR8R?R7RwRR;RI(RRRKRw((sbC:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\wb_admin_perfschema_instrumentation.pyR~s!(R+R,R
R@RERLR2R~(((sbC:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\wb_admin_perfschema_instrumentation.pyR1s					"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.
(RtScrollPanelR
RRRRtboxR/R0RLRWtBigBoldStyleRIR6RGRHRRRRX(RR1ReRRO((sbC:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\wb_admin_perfschema_instrumentation.pyR
s2


(R+R,R
(((sbC:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\wb_admin_perfschema_instrumentation.pyRPstSetupThreadscBsGeZdZdZdZdZdZdZdZRS(cCsXtjj|t|jd|jd|j|j||_|j	dS(Ni(
RR.R
RR/R0RRt_threadsR2(RRS((sbC:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\wb_admin_perfschema_instrumentation.pyR
3s



	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(RRLRWRXRIRR6RYRRZtthreadsR\tLongIntegerColumnTypeRRR_R`t
thread_editedR~RR/Rt_enable_allRRt
enable_allt_disable_alltenable_nonet_refresh_buttontrefresh_dataR(RReRfR((sbC:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\wb_admin_perfschema_instrumentation.pyR2?sH


cCs|jj|jdS(N(RUR~(R((sbC:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\wb_admin_perfschema_instrumentation.pyRhos
cCsk|jj}xUt|jjD]>}|j|}t|j|jd_|j	dtq%WdS(Nii(
R`RlRMRmRnR6RUtget_inttinstrumentedRp(RtroottrowRt((sbC:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\wb_admin_perfschema_instrumentation.pyRdvs
cCsk|jj}xUt|jjD]>}|j|}t|j|jd_|j	dtq%WdS(Nii(
R`RlRMRmRnRRURiRjRp(RRkRlRt((sbC:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\wb_admin_perfschema_instrumentation.pyRf}s
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(R`R&RURjR:RRtidRRRpRjtthread_typetplist_idt
plist_usert
plist_hostt
plist_commandt
plist_timetplist_statet
plist_infotplist_db(RtitemsRrRt((sbC:\Program Files (x86)\MySQL\MySQL Workbench 6.1 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(R6RRURiRjRp(RRtR}R((sbC:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\wb_admin_perfschema_instrumentation.pyRbs(	R+R,R
R2RhRdRfR~Rb(((sbC:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\wb_admin_perfschema_instrumentation.pyRT2s		0				t'WbAdminPerformanceSchemaInstrumentationcBseZedZedZdZedZdZdZ	dZ
dZdZd	Z
d
ZdZdZd
ZdZRS(cCs|j|ddtdS(Ntwba_performancesPerformance Schema Setup(t
register_pageR(tclst
admin_context((sbC:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\wb_admin_perfschema_instrumentation.pytwba_registerscCsdS(Ntadmin_instrumentation_setup((R((sbC:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\wb_admin_perfschema_instrumentation.pyt
identifierscCs9tj||||tj|||_d|_dS(N(R	R
Rtctrl_beR;tcontent(RRt
instance_infoR@((sbC:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\wb_admin_perfschema_instrumentation.pyR
s
	cCs
|jjS(N(RR(R((sbC:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\wb_admin_perfschema_instrumentation.pyRscCs-tj|||||jj|jdS(N(Rtcount_changetapply_buttonRtchange_count(RRyRR((sbC:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\wb_admin_perfschema_instrumentation.pyRscCstj|_|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_uiRRRtTabViewtTabViewSystemStandardt
config_tabR-t
easy_setuptadd_pageRIR6RCt_showing_advanced(R((sbC:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\wb_admin_perfschema_instrumentation.pyR2s
	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(	RRtintroRdtdata_collectiont	filteringR`toptionstremove_page(RR&((sbC:\Program Files (x86)\MySQL\MySQL Workbench 6.1 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(	RRR6Rtshowt
cancel_buttonRRR(R((sbC:\Program Files (x86)\MySQL\MySQL Workbench 6.1 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(NRdt	consumersiiRRR`RR<i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.s:Reset all performance_schema settings to factory defaults.sReset to Factory Defaults(3RRRRPRRtconfig_datatloadtcount_changes_onRPRRQtsectionsRdRRRRRRRR;RTR`RR1R=RRRR6tbuttonsR0R/Rtreset_buttontset_tooltipRRton_reset_button_clickedRIRton_apply_button_clickedRRton_revert_button_clickedRtreset_to_factory_buttont"on_reset_to_factory_button_clickedRR(Rtfrom_scratch((sbC:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\wb_admin_perfschema_instrumentation.pyRCs\

%,		%cCs0|jj}|jt|jj|dS(N(Rtget_active_tabRCRtset_active_tab(Rttab((sbC:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\wb_admin_perfschema_instrumentation.pyRLs
cCsz|j|jj|jj|jj|jjjdddr\|jjn|j	j|j
jdS(Niii(R~RdRRtrevert_changesRRRRRR`(R((sbC:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\wb_admin_perfschema_instrumentation.pyton_cancel_button_clickedSs




cCs|jjdS(N(Rtcommit_changes(R((sbC:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\wb_admin_perfschema_instrumentation.pyRiscCstjjdddddtjkry|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 TablesRR4s"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.
%sR3(
RR9RtResultOkR@RARBt	ExceptionRR:(RR=((sbC:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\wb_admin_perfschema_instrumentation.pyRms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.tResetRR4s%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.
%sR3(RR9RRR@RARBRRR:R(RR=((sbC:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\wb_admin_perfschema_instrumentation.pyRws cCsdS(N((R((sbC:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\wb_admin_perfschema_instrumentation.pyR~s(R+R,tclassmethodRRR
R0RRR2RRRCRRRRRR~(((sbC:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\wb_admin_perfschema_instrumentation.pyR|s						J				
	("R7Rtworkbench.change_trackerRtworkbench.graphics.cairo_utilsRtworkbench.graphics.canvasRt&wb_admin_perfschema_instrumentation_beRRRRt
workbench.logRRtwb_admin_perfschemaR	tMYSQL_ERR_TABLE_DOESNT_EXISTRR
R.R-RQRRRRRR1RQRPRTR|(((sbC:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\wb_admin_perfschema_instrumentation.pyt<module>s&"MEga@{

Anon7 - 2022
AnonSec Team