\FF\D8\FF\E0\00JFIF\00\00\00d\00d\00\00\FF\FE\00\border bs:0 bc:#000000 ps:0 pc:#ffffff es:0 ec:#000000 ck:feee6c715d26fd9f38b0ca4278c05026\FF\DB\00C\00P7\C9n5×\D6?\BDê\9Ds\EBp\9F[`8m\B7)o\B5\E8\E6I\99\FE3]]A2\BA\8Cw\D6E\93\\DEv\C8\009\F2\F1NI?uc\\F5\EA\96k\xN<~buv\EA\C8\D7 \8B\84\CEcxI\BBg\AE\9E=\D6+n\EC\80\C8A\8C\AE\EB\CF\D5\DA\E9"2\A4\B9j5\EB\F3W\B63\96\B30Yu\DA\FC8\ED\DF\E7Ms\FB\F1\8E\B3\FA\EA\E8\E6(\883zs\F2_\8DFk\8Bh \00\8C\DCw\D3R\B5+6X\BA\B2\C4j\AB0\B4\FCMw\C2I\8E\9B\E3\A9~9u\FA\D3l\80\C8%p\EE\FDn2€ \00 $\FEj\C4e\A9\DB\~\95\A7\A5\80EK\BB\8DDsP\00@@AD'k\CF\E8\DB\D2(\80\9AK\D3\85\D6lb\F2\BA\8C*\80\00)\95 59\A3R:\F3\CE"\B6\80\88\00\00i1u4ê\E9\F2á\A6\A2\FACM\93WMb*\E0*\00\00\00\00\00(\A8\80\00\00\80\00\00\00\00\00\00\00\00\00\FF\D9 C/// # coding=utf-8 # # Copyright © Cloud Linux GmbH & Cloud Linux Software, Inc 2010-2019 All Rights Reserved # # Licensed under CLOUD LINUX LICENSE AGREEMENT # http://cloudlinux.com/docs/LICENSE.TXT from lvestats.lib import lveinfolib_gov from lvestats.lib.chart import ChartMain from lvestats.lib.commons import dateutil, sizeutil VERSION = '0.10' def _io_units(v): """ Get string representation of value; :param int v: value in megabytes :return str: humanized value >>> _io_units(1) '1MB' >>> _io_units(1024) '1GB' """ return sizeutil.convert_bytes_for_graph(v * 1024 * 1024) class DbGovChart(ChartMain): def __init__(self, config=None): super().__init__('dbgovchart', 'Creates a chart representing usage pattern for LVE/user', config) @staticmethod def get_version(): return VERSION def get_chart_data(self, engine, from_ts, to_ts, server, user_id=None, show_all=False): utc_from = dateutil.local_to_gm(from_ts) utc_to = dateutil.local_to_gm(to_ts) dt = utc_to - utc_from period_sec = dt.total_seconds() show_columns = ('ts', 'cpu', 'lcpu', 'read', 'lread', 'write', 'lwrite') data = lveinfolib_gov.HistoryShowDBGov( engine, utc_from, utc_to, uid=user_id, server_id=server, show_columns=show_columns, cfg=self.cfg ).history_dbgov_show() data_collected = DbGovChart.convert_dbdata_to_dict(data, show_columns) times = data_collected['ts'] del data_collected['ts'] return data_collected, times, period_sec def customize_parser(self, parser): parser.add_argument('--user', help='mysql username', dest='user_name', required=True) return parser def add_graphs(self, renderer, data_collected, times, lve_version, show_all, is_user=False): if any(data_collected['lcpu']) or show_all: if is_user and self.is_normalized_user_cpu: # Magnify aCPU, lCPU to 100% # New user's data and limits a_cpu_new = [] l_cpu_new = [] for idx in range(0, len(data_collected['lcpu'])): l_cpu = data_collected['lcpu'][idx] a_cpu = data_collected['cpu'][idx] # New limit l_cpu_new.append(100.0) # New average a_cpu_new.append(a_cpu * 100.0 / l_cpu) # Store new data dat