/opt/dedrads/mysql/__pycache__
Edit: /opt/dedrads/mysql/__pycache__/slowqueryparser.cpython-313.pyc (10797B)
}j S SK r S SKrS SKJr S SKrS SKrS SKJr \R " S5 r
\R " S5 r S r " S S5 r
S rS
rS rS r\S
:X a \" 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 " 5 n U R SSSSSS9 U R SSS SS
S9 U R S S S
SS9 U R SSSS SS9 U R SSSSS9 U R SSSS 9 U R 5 $ ) 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/dedrads/mysql/slowqueryparser.pyr r s
$
$
&F
igl
% m+l
& j&
5 h
6 k,
9 3KL c \ rS rSrSrS\4S jrS\R 4S jr \
\ R 4S j5 r
\
\ R 4S j5 r\\ R 4S \\ 4S
jj5 r\ R 4S jr\ R 4S jrS
rg) MySQLUser, z/Holds a user name and tracks numbers of queriesusernamec V Xl SU l SU l SU l SU l SU l g )Nr g )r num_queries
query_time lock_time rows_sent
rows_examined)selfr s r __init__MySQLUser.__init__/ s,
r stats_matchc D UR 5 u p#pEU =R S-
sl U =R [ U5 -
sl U =R [ U5 -
sl U =R
[
U5 -
sl U =R [
U5 -
sl g )N )groupsr r floatr! r" intr# )r$ r' r r! r" r# s r add_queryMySQLUser.add_query7 st :E:L:L:N7
y A 5,, % ** #i.( c- 00r c ( U R / SQUS9 g )N)QUERIESTIMELOCKTIMEROWSSENT ROWSRECVDfileheaderclsr6 s r
row_headerMySQLUser.row_header? s
D4
r c ( U R / SQUS9 g )N)r0 zTIME/Qz
LOCKTIME/Qz
ROWSSENT/Qz
ROWSRECV/Qr5 r7 r9 s r
avg_headerMySQLUser.avg_headerE s
K
r colsc d [ SR S5 SUS9 [ [ S U 5 SU06 g )Nr endr6 c $ U R S5 $ )N
)rjustxs r
"MySQLUser.header..O s QWWR[r r6 )printrH map)r@ r6 s r r8 MySQLUser.headerL s,
fll2 Cd3
s($/;d;r c
[ U R R S5 [ U R 5 R S5 [ [ U R 5 5 R S5 [ [ U R 5 5 R S5 [ U R 5 R S5 [ U R 5 R S5 US9 g NrB rG r5
rM r rH strr r, r r! r" r# r$ r6 s r row_printMySQLUser.row_printQ s
MM # ! ' ' + DOO$ % + +B / DNN# $ * *2 . % %b ) "" # ) )" -
r c
X [ U R R S5 [ U R 5 R S5 [ [ U R U R - 5 5 R S5 [ [ U R U R - 5 5 R S5 [ [ U R U R - 5 5 R S5 [ [ U R U R - 5 5 R S5 US9 g rQ rR rT s 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! r r r# r" r N)__name__
__module__ __qualname____firstlineno____doc__rS r% reMatchr- classmethodsysstdoutr; r> staticmethodlistr8 rU rX __static_attributes__ r r r r , s 9 1RXX 1 ZZ
ZZ
%(ZZ ?@HHJ 4 $ $ ;#** M4y s A> AA> 3
A> >BBc V U R ( d [ R R 5 ( aw [ 5 nU( d. [ S[ R S9 [ R " S5 U R ( d' [ SU S3[ R S9 [ USSS9$ U R ( a U R S :X aI [ R nU R ( d( [ S
[ R S9 [ R $ [ U R SSS9$ ) Nz2Failed to get slow query log path from /etc/my.cnfr5 r) z$Reading from the default log file, `'utf-8replace)encodingerrors-z6MySQL slow query log parser reading from stdin/pipe...)
r rb stdinisattyrt rM rp exitr open)args query_logs r open_logr v s <B BB c [ 5 n U R ( a [ U R SSS9nO[ R nU 0 nSn[ U 5 GH n[ R U5 =n( aB UR S5 nU R ( a X0R :X a
[ USUS9 M^ M` Mb [ R U5 =n( aV X2; a
[ U5 X#' X# R U5 U R ( a X0R :X a
[ USUS9 M M M U R ( d M X0R :X d M [ USUS9 GM U R ( a
S S S 5 g U R ( d< U R" ( a [ R% U5 O[ R' U5 [) UR+ 5 S
S 9 H8 nU R" ( a UR- U5 M' UR/ U5 M: S S S 5 g ! [ a [ R " S 5 GM f = f! , ( d f g = f) Nwrw )ry NO_SUCH_USERr) rC rD r c U R $ r )r rI s r rK main.. s ammr )key)r outputr rb rc r USER_REmatchgroupuserrM STATS_REr r- Exceptionr~ r averager> r; sortedvaluesrX rU )r out_file
user_table this_userr
user_matchr' datas r mainr s C3I ;
I
H#I 8B"I # II II
I__main__)r rq pathlibr rb r_ pymysql.optionfiler rl compiler r r r rt r r r rZ rg r r r ss
6
**3
4
::3 89
9
x B8%)P zF r