lveinfo

Navigation:  Limits > Command Line Tools > lve-stats 2 > Command Line Tools >

lveinfo

Previous pageReturn to chapter overviewNext page

[lve-stats-2.2-2]

 

usage: lveinfo [-h] [-v] [--dbgov DBGOV] [-f YYYY-MM-DD[HH:MM]]

              [-t YYYY-MM-DD[HH:MM]] [--period PERIOD] [-u USER | --id ID]

              [-d] [-o ALIAS] [-b ALIAS [ALIAS ...]] [-p 0..100]

              [--by-fault ALIAS [ALIAS ...]] [-r FAULTS]

              [--style {user,admin}] [-l LIMIT] [-c [PATH] | -j]

              [--server_id SERVER_ID] [--servers-info]

              [--show-all | --show-columns COLUMN_NAME [COLUMN_NAME ...]]

              [--time-unit TIME_UNIT] [-m {v1,v2}]

              [--blank-value [BLANK_VALUE]]

 

lveinfo - Utility to display historical information about LVE usage

 

Optional arguments:

 

-h, --help

show this help message and exit

-v, --version

show program's version number and exit

--dbgov DBGOV

show MySql governor statistic

-u USER, --user USER

Use username instead of LVE id, and show only record for that user

--id ID

will display record only for that LVE id

-d, --display-username

try to convert LVE id into username when possible

-o ALIAS, --order-by ALIAS

orders results by one of the following:

ALIAS

ALIAS

DESCRIPTION

cpu_avg

aCPU

average CPU usage

cpu_max

mCPU

max CPU usage

total_cpu_faults

CPUf

total number of max CPU usage faults

vmem_avg

aVMem

average virtual memory usage

vmem_max

mVMem

average virtual memory usage

total_vmem_faults

VMemF

total number of out of virtual memory faults  

mep_avg

aEP

average number of entry processes (concurrent connections)

mep_max

mEP

max number of entry processes (concurrent connections)

total_ep_faults

EPf

total number of max entry processes faults

pmem_avg

aPMem

average physical memory usage (LVE version >= 6)

pmem_max

mPMem

max physical memory usage (LVE version >= 6)

nproc_avg

aNproc

average number of processes (LVE version >= 6)

nproc_max

mNproc

max number of processes (LVE version >= 6)

io_avg

aIO

average io usage (LVE version >= 6)

io_max

mIO

max io usage (LVE version >= 6)

total_pmem_faults

PMemF

total number of out of physical memory faults (LVE version >= 6)

total_nproc_faults

NprocF

total number of max processes faults (LVE version >= 6)

total_io_faults

IOf

total number of max io faults (LVE version >= 6)

iops_avg

aIOPS

average io operations (LVE version >= 8)

iops_max

mIOPS

max io operations (LVE version >= 8)

total_iops_faults

IOPSf

total number of max io operations faults (LVE version >= 8)

any_faults

anyF

total number of faults of all types

-b ALIAS [ALIAS ...]

--by-usage ALIAS [ALIAS ...]

 

show LVEs with usage (averaged) within 90 percent of the limit available values:

ALIAS

ALIAS

ALIAS

DESCRIPTION

cpu_avg

cpu

aCPU

average CPU usage

cpu_max

cpu_max

mCPU

max CPU usage

vmem_avg

vmem

aVMem

average virtual memory usage

vmem_max

vmem_max

mVMem

max virtual memory usage

mep_avg

mep

aEP

average number of entry processes (concurrent connections)

mep_max

mep_max

mEP

max number of entry processes (concurrent connections)

pmem_avg

pmem

aPMem

average physical memory usage (LVE version >= 6)

pmem_max

pmem_max

mPMem

max physical memory usage (LVE version >= 6)

nproc_avg

nproc

aNproc

average number of processes (LVE version >= 6)

nproc_max

nproc_max

mNproc

max number of processes (LVE version >= 6)

io_avg

io

aIO

average io usage (LVE version >= 6)

io_max

io_max

mIO

max io usage (LVE version >= 6)

iops_avg

iops

aIOPS

average io operations (LVE version >= 8)

iops_max

iops_max

mIOPS

max io operations (LVE version >= 8)

-p 0..100, --percentage 0..100

defines percentage for --by-usage option; default 90

--style {user,admin}

deprecated, not used.

-l LIMIT, --limit LIMIT

max number of results to display, 10 by default, if 0 no limit

-c [PATH], --csv [PATH]

save statistics in CSV format; "-" by default (output to screen)

-j, --json

display output in JSON format

--server_id SERVER_ID

used with central database for multiple servers, default "localhost"

--servers-info

Show servers LVE versions"

--show-all

full output (show all limits); brief output is default; equivalent --show-columns all

-show-columns COLUMN_NAME [COLUMN_NAME ...]

 

show only the listed columns; "all" for all supported columns


COLUMN_NAME

DESCRIPTION


From

Show start period statistics


To

Show end period statistics


ID

LVE Id or username


aCPU

Average CPU usage


uCPU

The percentage of user-allocated resource CPU


mCPU

deprecated


lCPU

CPU Limit


CPUf

Out Of CPU usage Faults


aEP

Average Entry Processes


uEP

The percentage of user-allocated resource Entry processes


mEP

deprecated


lEP

maxEntryProc limit


aVMem

Average Virtual Memory Usage


uVMem

The percentage of user-allocated resource Virtual Memory


mVMem

deprecated


lVMem

Virtual Memory Limit


VMemF

Out Of Memory Faults


EPf

Entry processes faults


aPMem

Average Physical Memory Usage (LVE version >= 6)


uPMem

The percentage of user-allocated resource Physical Memory (LVE version >= 6)


mPMem

deprecated (LVE version >= 6)


lPMem

Physical Memory Limit (LVE version >= 6)


aNproc

Average Number of processes (LVE version >= 6)


uNproc

The percentage of user-allocated resource Number of processes (LVE version >= 6)


mNproc

deprecated (LVE version >= 6)


lNproc

Limit of Number of processes (LVE version >= 6)


PMemF

Out Of Physical Memory Faults (LVE version >= 6)


NprocF

Number of processes faults (LVE version >= 6)


aIO

Average I/O (LVE version >= 6)


uIO

The percentage of user-allocated resource I/O (LVE version >= 6)


mIO

deprecated (LVE version >= 6)


lIO

I/O Limit (LVE version >= 6)


IOf

Out Of I/O usage Faults (LVE version >= 6)


aIOPS

Average I/O Operations (LVE version >= 8)


mIOPS

deprecated (LVE version >= 8)


uIOPS

The percentage of user-allocated resource I/O Operations (LVE version >= 8)


lIOPS

I/O Operations Limit (LVE version >= 8)


IOPSf

Out Of I/O Operations Faults (LVE version >= 8)

--time-unit TIME_UNIT

time step for grouping statistic in minutes; 1 min., by default; can use m|h|d suffixes; for example: 1h or 1h30m or 1d12h

-m {v1,v2}, --compat {v1,v2}

v1 - return old output mode; v2 - new mode; default v1; you can change default in config

--blank-value [BLANK_VALUE]

Use to fill unsupported limits; default "-"

-f YYYY-MM-DD[ HH:MM],

--from YYYY-MM-DD[ HH:MM]

 

run report from date and time in [YY]YY-MM-DD[ HH:MM] format; if not present last 10 minutes are assumed

-t YYYY-MM-DD[ HH:MM],

--to YYYY-MM-DD[ HH:MM]

 

run report up to date and time in [YY]YY-MM-DD[ HH:MM] format; if not present, reports results up to now

--period PERIOD

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 today

--by-fault ALIAS [ALIAS ...]

show LVEs which failed on max processes limit or memory limit


ALIAS

ALIAS

ALIAS

DESCRIPTION


mcpu

cpu

CPUf

total number of max CPU usage faults


mem

vmem

VMemF

total number of out of virtual memory faults


mep

ep

EPf

total number of max entry processes faults  


pmem

pmem

PMemF

total number of out of physical memory faults (LVE version >= 6)


nproc

nproc

NprocF

total number of max processes faults (LVE version >= 6)


io

io

IOf

total number of max io faults (LVE version >= 6)


iops

iops

IOPSf

total number of max io operations faults (LVE version >= 8)


any_faults

any

anyF

total number of faults of all types

-r FAULTS, --threshold FAULTS

in combination with --by-fault, shows only LVEs with number of faults above; default 1

                             

Prefixes Kb, Mb and Gb indicates powers of 1024.

 

*All ALIAS options are not case sensitive.