Back
Current Directory
/opt/sharedrads/mysql/__pycache__
Type Name Operations
myisam_repair.cpython-313.pyc
Edit Get
mysqlrepair.cpython-313.pyc
Edit Get
queryparser.cpython-313.pyc
Edit Get
slowqueryparser.cpython-313.pyc
Edit Get

File Transfer

Upload files to current directory

File Editor: slowqueryparser.cpython-313.pyc

{iSSKrSSKrSSKJr SSKrSSKrSSKJr \R"S5r \R"S5r Sr "SS5r S rS rS rS r\S :Xa\"5 gg)N)Path)Parserz^# User@Host:\s+([a-z0-9]+)zc^# Query_time:\s+([0-9\.]+)\s+Lock_time:\s+([0-9\.]+)\s+Rows_sent:\s+(\d+)\s+Rows_examined:\s+(\d+)c([R"5nURSSSSSS9 URSSS SS S9 URS S S SS9 URSSSSSS9 URSSSSS9 URSSSS9 UR5$)Nz-qz--quietquiet store_truezSuppress stderr output)destactionhelpz-Hz --no-header no_headerzSuppress column headersz-oz--outputFILEz&Write output to FILE (default: stdout))metavarr z-uz--userUSERz'Output USER's queries instead of tallys)r defaultr z-az --averagez*Print averages per query instead of totals)r r logpath?zPath to slow query log)nargsr )argparseArgumentParser add_argument parse_args)parsers (/opt/sharedrads/mysql/slowqueryparser.pyrrs  $ $ &F  igl %  m+l &  j& 5  h 6  k, 9  3KL    c\rSrSrSrS\4SjrS\R4Sjr \ \ R4Sj5r \ \ R4Sj5r\\ R4S \\4S jj5r\ R4S jr\ R4S jrS rg) MySQLUser,z/Holds a user name and tracks numbers of queriesusernamecVXlSUlSUlSUlSUlSUlg)Nrg)r num_queries query_time lock_time rows_sent rows_examined)selfrs r__init__MySQLUser.__init__/s, r stats_matchcDUR5up#pEU=RS- slU=R[U5- slU=R[U5- slU=R [ U5- slU=R[ U5- slg)N)groupsrr floatr!r"intr#)r$r'r r!r"r#s r add_queryMySQLUser.add_query7st:E:L:L:N7 y A 5,, % ** #i.( c-00rc(UR/SQUS9 g)N)QUERIESTIMELOCKTIMEROWSSENT ROWSRECVDfileheaderclsr6s r row_headerMySQLUser.row_header?s D4  rc(UR/SQUS9 g)N)r0zTIME/Qz LOCKTIME/Qz ROWSSENT/Qz ROWSRECV/Qr5r7r9s r avg_headerMySQLUser.avg_headerEs K  rcolscd[SRS5SUS9 [[SU5SU06 g)Nr endr6c$URS5$)N )rjustxs r"MySQLUser.header..Os QWWR[rr6)printrHmap)r@r6s rr8MySQLUser.headerLs, fll2Cd3 s($/;d;rc [URRS5[UR5RS5[[ UR 55RS5[[ UR55RS5[UR5RS5[UR5RS5US9 gNrBrGr5 rMrrHstrrr,r r!r"r#r$r6s r row_printMySQLUser.row_printQs MM   #   ! ' ' + DOO$ % + +B / DNN# $ * *2 .   % %b ) "" # ) )" - rc X[URRS5[UR5RS5[[ UR UR- 55RS5[[ URUR- 55RS5[[ URUR- 55RS5[[ URUR- 55RS5US9 grQrRrTs r avg_printMySQLUser.avg_print\s MM   #   ! ' ' + DOOd&6&667 8 > >r B DNNT%5%556 7 = =b A DNNT%5%556 7 = =b A D&&)9)99: ; A A" E r)r!rr r#r"rN)__name__ __module__ __qualname____firstlineno____doc__rSr%reMatchr- classmethodsysstdoutr;r> staticmethodlistr8rUrX__static_attributes__rrrr,s91RXX1 ZZ   ZZ  %(ZZ?@HHJ 4 $ $ ;#** M4y   sA>AA>3 A>>BBcVUR(d[RR5(aw[ 5nU(d.[ S[R S9 [R"S5 UR(d'[ SUS3[R S9 [USSS9$UR(aURS :XaI[RnUR(d([ S [R S9 [R$[URSSS9$) Nz2Failed to get slow query log path from /etc/my.cnfr5r)z$Reading from the default log file, `'utf-8replace)encodingerrors-z6MySQL slow query log parser reading from stdin/pipe...) rrbstdinisattyrtrMrpexitropen)args query_logs ropen_logrvs <B BB c[5nUR(a[URSSS9nO[RnU 0nSn[ U5GHn[ RU5=n(aBURS5nUR(aX0R:Xa [USUS9 M^M`Mb[RU5=n(aVX2;a [U5X#'X#RU5 UR(aX0R:Xa [USUS9 MMMUR(dMX0R:XdM[USUS9 GM UR(a SSS5 gUR (d<UR"(a[R%U5 O[R'U5 [)UR+5S S 9H8nUR"(aUR-U5 M'UR/U5 M: SSS5 g![a [R"S 5 GMf=f!,(df  g=f) Nwrw)ry NO_SUCH_USERr)rCrDrcUR$r)rrIs rrKmain..sammr)key)routputrrbrcrUSER_REmatchgroupuserrMSTATS_RErr- Exceptionr~r averager>r;sortedvaluesrXrU)rout_file user_table this_userr user_matchr'datas rmainrs C3I ; I  H#I 8B"I # II II  I__main__)rrqpathlibrrbr_pymysql.optionfilerrlcompilerrrrrtrrrrZrgrrrss 6 **3 4 ::3  89 9 x B8%)P zFr