j } d dl Z d dlZd dlZd dlmZ d dlmZmZmZm Z m
Z
m Z m Z m
Z
mZmZmZmZ d dlmZ d dlmZmZ g dZdZdZd Zd
Zd Z G d d
e j Z G d de Z G d de Z ddZ!d Z"ddZ#dS ) N) uidconverter) BY_USAGE_PERCENT
ParseDatetimeSmartFormatter alias_actionargparse_process_periodcheck_from_zero_to_max_intcheck_non_negative_intcheck_percentagescheck_positive_intformat_aliases period_type period_type2)prepare_attention_json)get_lve_versionget_supported_columns)lveinfo_parser dbgov_parsertime_unit_type-)ALIAS 1ALIAS 2zALIAS 3 DESCRIPTION)cpu_avgcpuaCPUaverage CPU usage)cpu_maxr mCPU
max CPU usage)vmem_avgvmemaVMem average virtual memory usage)vmem_maxr& mVMemmax virtual memory usage)mep_avgepaEP:average number of entry processes (concurrent connections))mep_maxmepmEP6max number of entry processes (concurrent connections))pmem_avgpmemaPMem average physical memory usage)pmem_maxr5 mPMemmax physical memory usage) nproc_avgnprocaNprocaverage number of processes) nproc_maxr< mNprocmax number of processes)io_avgioaIOaverage io usage)io_maxrC mIO max io usage)iops_avgiopsaIOPS)average io operations; (LVE version >= 8))iops_maxrJ mIOPS%max io operations; (LVE version >= 8)) r )mcpur CPUf$total number of max CPU usage faults)memr# VMemF,total number of out of virtual memory faults)r. r* EPf*total number of max entry processes faults)r2 r2 PMemF-total number of out of physical memory faults)r9 r9 NprocF$total number of max processes faults)r@ r@ IOf total number of max io faults)rG rG IOPSf= 8))
any_faultsanyanyF#total number of faults of all types))r r r )r r r )r r r! )total_cpu_faultsrN rO )r" r$ r% )r& r' r( )total_vmem_faultsrQ rR )r) r+ r, )r- r/ r0 )total_ep_faultsrS rT )r1 r3 r4 )r5 r6 r7 )r8 r: r; )r< r= r> )r? rA rB )rC rD rE )total_pmem_faultsrU rV )total_nproc_faultsrW rX )total_io_faultsrY rZ )rF rH rI )rJ rK rL )total_iops_faultsr[ r\ )r] r_ r` )') COLUMN_NAMEr )Fromz Show start period statistics)TozShow end period statistics)IDzLVE Id or username)r zAverage CPU usage)uCPUz-The percentage of user-allocated resource CPU)r
deprecated)lCPUz CPU Limit)rN zOut Of CPU usage Faults)r+ zAverage Entry Processes)uEPz9The percentage of user-allocated resource Entry processes)r/ rm )lEPzmaxEntryProc limit)r$ z Average Virtual Memory Usage)uVMemz8The percentage of user-allocated resource Virtual Memory)r' rm )lVMemzVirtual Memory Limit)rQ zOut Of Memory Faults)rS zEntry processes faults)r3 z Average Physical Memory Usage)uPMemz9The percentage of user-allocated resource Physical Memory)r6 rm )lPMemzPhysical Memory Limit)r: zAverage Number of processes)uNprocz=The percentage of user-allocated resource Number of processes)r= rm )lNprocz Limit of Number of processes)rU z Out Of Physical Memory Faults)rW zNumber of processes faults)rA z Average I/O)uIOz-The percentage of user-allocated resource I/O)rD rm )lIOz I/O Limit)rY zOut Of I/O usage Faults)rH z*Average I/O Operations; (LVE version >= 8))rK z deprecated; (LVE version >= 8))uIOPSzLThe percentage of user-allocated resource I/O Operations; (LVE version >= 8))lIOPSz(I/O Operations Limit; (LVE version >= 8))r[ z0Out Of I/O Operations Faults; (LVE version >= 8)c ( e Zd Zd Zd ZddZd ZdS )ArgParsec d|v r| d nd | _ d | _ d | _ d | _ t j j | g|R i | d S )Ndbengine)popr~ lve_versionchanged_optionsoutput_error_handlerargparseArgumentParser__init__)selfargskwargss /builddir/build/BUILDROOT/lve-stats-4.3.2-1.el9.x86_64/opt/cloudlinux/venv/lib/python3.11/site-packages/lvestats/lib/parsers/lveinfoargparse.pyr zArgParse.__init__ sf 2<2F2F
:...D
# $(! (????????? c d | j D }||vr(t d| dd | | j t d || j vS )Nc g | ] }|j
S )dest).0actions r
z,ArgParse.was_not_changed.. s @@@ @@@r z
no such item z; you can use only z, zIYou can use method "was_not_changed" only after used method "parse_args")_actions
ValueErrorjoinr AttributeError)r r actions_dests r was_not_changedzArgParse.was_not_changed st @@$-@@@ | # # _T _ _diiP\F]F] _ _`` ` ' !lmm m4///r Nc : |t j dd }d|v sd|v r t | _ t j | || }t t | |t j
d | _ t | |j
rB| d }t j |j
||j | j pd|_ | d r|j s|j rd|_ |S ) N -j--jsonr namespacer server_idlimit)sysargvr r r r
parse_argstuplevars_parse_known_args Namespacer r user get_defaultr username_to_uidr r~ idr csvjsonr )r r r local_server_ids r r zArgParse.parse_args s <8ABBD % +66t$R[6\\ %T$*@*@xGYG[G[*\*\]^*_%`%` a a *** > [ " . .{ ; ;O'71Ddm U U [XZ
L ( ( im y~ IOr c t | j d r.| | }| d| d S t j | | d S )N__call__r )statusmessage)hasattrr exitr r error)r r error_strs r r zArgParse.error se 4,j 9 9 9 11'::I IIQ I 2 2 2 2 2 # ) )$ 8 8 8 8 8r NN)__name__
__module__ __qualname__r r r r r r r r| r| sX @ @ @0 0 0 29 9 9 9 9r r| c e Zd ZddZdS )ArgParseLVEInfoNc * t | || }|j r t j |j |_ |j r t j |j |_ | d s#|j s |j s|
d | j '| j t | j |j | _ d|j v s|j r-|j dk r"g dt% d z |_ d |_ nX| d
s d|j v r:t% | j |j }|j r
d d
g|z |_ n dg|z |_ | d r8|j s1|j t) |d z
}| |_ | d r+|j r$|j r |j dk s |j dk rd|_ | d r|j d|_ |S )Nr time_unit:--id or --user option should be specified with --time_unit)r~ r allv2)ri rj rk )r T show_columns)r moderi rj rk fromr v1r r r )r| r
reseller_namer convert_name_to_lvp_idr reseller_idconvert_id_to_lvp_idr r r r r~ r r r show_allcompatr togetattr
total_secondsr r styler )r r r
show_columns_dts r r zArgParseLVEInfo.parse_args sH ''49'MM " X'>y?VWWIL T'T5T5T 1d>NU^Ue f f fM|
@*0$ -)G &&*.-)? & , , 5Y\ 5 6 : ::B"$"2"2"4"4I , , % %)- % _..)2Bd2J2J"$I ( ( Y\-E IOr r r r r r r r r r r s( ) ) ) ) ) )r r c e Zd ZddZdS )ArgParseDBGOVInfoNc < t | || }t |j t r2t |j d t r|j d |_ |j r d|j v s|j rt
| d |_ |j rOd|j v rF|j d }|j d | ddgz |j |dz d z |_ | d s |j s|
d |S )
Nr r all_columns_namesTSFROMTOr r r ) r| r
isinstanceformatlistr r r indexr r )r r r ts_indexs r r z ArgParseDBGOVInfo.parse_args s+ ''dI>> i& - - 3*Y=Ma=PRV2W2W 3 ( / 2I B)9 9 9Y=O 9 &t-@ A AI < nDI$4 4 4 '--d33H ( / :fd^ KiN^_gjk_k_l_lNm mI ##K00 U), U JJS T T Tr r r r r r r r s( r r c H d}d}d}|p t j t t |d }t |dg d | }| dd t t j d
z
d d
| ddt d d | d fdd | }| ddt d | dt d | dd t d | d d t | d t d t | d!" | d#d$t t d%d&' | d(d)t | d*t | d!+ | } | d,d-d t | t# |d d.t | d!/ | d0d1d2d34 | d5d6t | d7d8 d9: | d;t& t) | d: | }
|
d?d@dAt+ j dBC dDdEdFG |
dHdId1d2dJ4 |S )Kz
Parser for dbgov statistics (use as subparser)
:param config: parsed config
:param _datetime_now: time now
:param dbengine: database engine
:return:
))ALIASr )con average connections; deprecated)r r )readaverage READ usage)writeaverage WRITE usage)r@ zaverage READ+WRITE usage) rh r r )tsr ztimestamp records)usernameUSERz user name)r rk zuser idr CPUr )r READr )r WRITEr )r CONr )lcpurn z CPU limit)lreadlREADz
READ limit)lwritelWRITEz WRITE limit) RESTRICTz3C-cpu restrict, R- read restrict, W- write restrict)r r )r@ IOzaverage IO usagezF%(prog)s - Utility to display historical information about MySQL usage)formatter_classr~ descriptionr )
r r r r r r rn r r r -f--from
minutes+hrun report from date and time in [YY]YY-MM-DD[ HH:MM] format; if not present last 10 minutes are assumed)r defaultnargshelp-t--tohrun report up to date and time in [YY]YY-MM-DD[ HH:MM] format; if not present, reports results up to now--periodc $ t | S Nr value datetime_nows r z dbgov_parser..E |E<'H'H r time period; specify minutes with m, h - hours, days with d, and values: today, yesterday; 5m - last 5 minutes, 4h -- last four hours, 2d - last 2 days, as well as todaytyper -u--userzSystem user name--idzUser id-l--limitz/max number of results to display, if 0 no limit
--by-usage)R|show LVEs with usage (averaged) within z) percent 'of the limit available values:
r r r r metavar-p --percentage=defines percentage for --by-usage option; default %(default)s0..100r r r r -o
--order-by*R|orders results by one of the following:
r r r -bz--formatz)R|show only specific fields into output:
r r r r r
--show-all
store_trueFz6full output (show all limits); brief output is defaultr r r --server_id --server-idr localhostFused with central database for multiple servers, default "%(default)s"r r r --time-unitaggregation_period< time step for grouping statistic in minutes; 1 min., by default; can use m|h|d suffixes;or can use dyn[amic] for using in v1 mode for example: 1h or 1h30m or 1d12h-c--csv?wr r Hsave statistics in CSV format; "%(const)s" by default (output to screen)PATHr r constr r r r display output in JSON format)datetimenowr r setattradd_argument_group add_argumentr timedelta add_mutually_exclusive_groupstrr
r r r r
r r getr intr FileType) config
_datetime_nowr~ dbgov_order_by_dscrdbgov_columns_dscrdbgov_by_usage_dscrparser group_period
group_user group_fieldsgroup_output_formatr
s @r r r s: ? n@ !;H$5$9$9$;$;L
~(0+su u uF F' ` ` `b b b ,,..L h} x 1" = = ==
w y y y
fm
w y y y
HHHHd e e e
4466J hS
! ! ! +
i 8
> @ @ @ C 5H(I(IW9I W W1?@S1T1TW W
n#4>N
LV^ ` ` ` l<0C#D#D
`>J];^;^
`
` 6688L jL9K,L,L 344
^.I[:\:\
^
^
\5
E G G G }3
;P[8\8\
U W W W NC
CWY[8\8\4]4]2 3 3 3 !==??$$ gSx'8c'B'B'B#
Wag % i i i $$ h|U
, % . . . Mr c , | dv rdS t | S )zO
ArgParse type for parsing time-unit with additional support dyn[amic]
)dyndynamicr )r )r s r r r | s#
"""r5!!!r lveinfoc
|p t j
g dt | dd z }t t
d||d }d t d d
D }||_ | d d d
| | dd | }| ddt
t j d z
ddd | ddt
dd d | d
fd d | } | d!d"t d# | d$t d% | d&t d' | d(t d) | d*d+d,d-d./ | d0d1t t d2t# t d34 | d5d6dt t$ d7t& d8t# t$ d39 | d:d;t( t& d | }
|
d?dt t* d@t# t* d39 |
dAdBt, d dCdD> | dEdFdGgdGdHI | dJdKt. ddLM | } | dNdOdPt1 j dQ dRdSdTU | dVdWd,d-dX/ | dYdZt | d[d\ d]M | d^d,d-d_/ | } | d`d,d-da/ | dbdt t dcz t5 | ddt# t def | dgt6 t9 | dhdi djM | dkdlt dm| dd dno | dpdPt: dqr |S )sz
Function for parsing command line arguments
:param config:
:param name:
:param _datetime_now:
:param ver:
:param dbengine:
:return: parsed arguments
)rk ri rj r r r7 zD%(prog)s - Utility to display historical information about LVE usagez0Prefixes Kb, Mb and Gb indicates powers of 1024.)r r progr~ epilogc g | ]
}|d S )r r )r _s r r z"lveinfo_parser.. s 888!1888r r Nz-vz --versionversion)r r[ z--dbgovz show MySql governor statistic)r r r r r r r zYYYY-MM-DD[ HH:MM])r r r r r r r r r c $ t | S r r
r s r r z lveinfo_parser.. r r r r r r zBUse username instead of LVE id, and show only record for that userr z(will display record only for that LVE idz--reseller-namezKUse reseller name instead of LVP id, and show only record for that resellerz
--reseller-idz(will display record only for that LVP idz-dz--display-usernamer( Fz1try to convert LVE id into username when possibler) r! r" r# r r$ r% r r z( percent of the limit available values:
r r r r r r z
--by-faultz@R|show LVEs which failed on max processes limit or memory limit
z-rz --thresholdz`in combination with --by-fault, shows only LVEs with number of faults above; default %(default)sFAULTSz--styler adminzdeprecated, not used.)choicesr r r r zDmax number of results to display, if 0 no limit; default %(default)sr. r3 r4 r5 r6 r r8 r9 r: r r r< r* r+ r r, r- z--servers-infozShow servers LVE versions"r' zUfull output (show all limits); brief output is default; equivalent --show-columns allz--show-columns))r r z@R|show only the listed columns; "all" for all supported columns
rh r& r/ r0 r1 r2 z-mz--compat)r r zav1 - return old output mode; v2 - new mode; default %(default)s; you can change default in config)r r_ r r z
--blank-valuez3Use to fill unsupported limits; default "%(const)s")r r; r ) r= r> r rE r r COLUMNS_DSCRr rA r@ r rB rC rD r
r
ORDER_BY_DSCRr
BY_USAGE_DSCRr r
BY_FAULT_DSCRr r r rG r r rF DEF_BLANK_VALUE)rH namerI verr~ default_col cl_parserr rN rO
group_by_faulrQ group_show_columnsr
s @r r r sN !;H$5$9$9$;$;L&&&)>FJJvW[D\D\)])])]]K &Z
A C C CI 98|ABB'7888"3I
4YLLL
9+JKKK //11L h} x 1" = = ==
w$ & & & f]L
w$ & & &
HHHHd e e e
7799J hS
Q S S S +
7 9 9 9
Z \ \ \ 4
7 9 9 9 "<
@ B B B l<
#>#>
Z>-;X;X
Z
Zdk m m m l#l=.I.IP9I P P0>}0M0MP P
n#4>N
LV^ ` ` ` 0022M C ](C(C
pQ_`mQnQn
p
p m"4a
o 9vw.?Wnooo
i 8"
S U U U $@@BB$$ gSx'8c'B'B'B#
Wag % i i i $$ h|U
, % . . . }3
;P[8\8\
U W W W u
) + + + #??AA##\5
d $ f f f ##L 9V,W,Wk""
oQ_`lQmQm
o
o $ NC
CWY[8\8\4]4]2 3 3 3
jsL&**VUYBZBZ
p r r r s/
B D D D r r )rU NNN)$r r= r lvestats.libr #lvestats.lib.commons.argparse_utilsr r r r r r r
r r r
r r lvestats.lib.jsonhandlerr lvestats.lib.lveinfolibr r __all__rd rb rc ra r` r r| r r r r r r r r rp s
% % % % % %
< ; ; ; ; ; J J J J J J J J
>
>
>e
0Z
$ P
D*F ^29 29 29 29 29x& 29 29 29j* * * * *h * * *Z (e e e eP" " "z z z z z zr