def oracle_monitor(request):
messageinfo_list = models_frame.TabAlarmInfo.objects.all()
tagsinfo = models_oracle.TabOracleServers.objects.all().order_by('tags')
tagsdefault = request.GET.get('tagsdefault')
if not tagsdefault:
tagsdefault = models_oracle.TabOracleServers.objects.order_by(
'tags')[0].tags
conn_range_default = request.GET.get('conn_range_default')
if not conn_range_default:
conn_range_default = '1小时'.decode("utf-8")
undo_range_default = request.GET.get('undo_range_default')
if not undo_range_default:
undo_range_default = '1小时'.decode("utf-8")
tmp_range_default = request.GET.get('tmp_range_default')
if not tmp_range_default:
tmp_range_default = '1小时'.decode("utf-8")
ps_range_default = request.GET.get('ps_range_default')
if not ps_range_default:
ps_range_default = '1小时'.decode("utf-8")
conn_begin_time = tools.range(conn_range_default)
undo_begin_time = tools.range(undo_range_default)
tmp_begin_time = tools.range(tmp_range_default)
ps_begin_time = tools.range(ps_range_default)
end_time = datetime.datetime.now().strftime("%Y-%m-%d %H:%M:%S")
# 取当前数据库状态
try:
oracle_curr = models_oracle.OracleDb.objects.filter(
tags=tagsdefault).get(tags=tagsdefault, )
except models_oracle.OracleDb.DoesNotExist:
oracle_curr = \
models_oracle.OracleDbHis.objects.filter(tags=tagsdefault).order_by(
'-chk_time')[0]
# 取上一次有效采集的数据
try:
try:
oracleinfo = models_oracle.OracleDb.objects.filter(
tags=tagsdefault,
percent_process__isnull=False).get(tags=tagsdefault, )
except models_oracle.OracleDb.DoesNotExist:
oracleinfo = \
models_oracle.OracleDbHis.objects.filter(tags=tagsdefault, percent_process__isnull=False).order_by(
'-chk_time')[0]
except Exception, e:
oracleinfo = \
models_oracle.OracleDbHis.objects.filter(tags=tagsdefault).order_by(
'-chk_time')[0]
def mysql_monitor(request):
messageinfo_list = models_frame.TabAlarmInfo.objects.all()
tagsinfo = models_mysql.TabMysqlServers.objects.all().order_by('tags')
tagsdefault = request.GET.get('tagsdefault')
if not tagsdefault:
tagsdefault = models_mysql.TabMysqlServers.objects.order_by(
'tags')[0].tags
conn_range_default = request.GET.get('conn_range_default')
if not conn_range_default:
conn_range_default = '1小时'.decode("utf-8")
ps_range_default = request.GET.get('ps_range_default')
if not ps_range_default:
ps_range_default = '1小时'.decode("utf-8")
thread_range_default = request.GET.get('thread_range_default')
if not thread_range_default:
thread_range_default = '1小时'.decode("utf-8")
net_range_default = request.GET.get('net_range_default')
if not net_range_default:
net_range_default = '1小时'.decode("utf-8")
conn_begin_time = tools.range(conn_range_default)
ps_begin_time = tools.range(ps_range_default)
thread_begin_time = tools.range(thread_range_default)
net_begin_time = tools.range(net_range_default)
end_time = datetime.datetime.now().strftime("%Y-%m-%d %H:%M:%S")
try:
mysql_curr = models_mysql.MysqlDb.objects.get(tags=tagsdefault)
except models_mysql.MysqlDb.DoesNotExist:
print tagsdefault
mysql_curr = \
models_mysql.MysqlDbHis.objects.filter(tags=tagsdefault).order_by('-chk_time')[
0]
try:
try:
mysqlinfo = models_mysql.MysqlDb.objects.get(tags=tagsdefault,
version__isnull=False)
except models_mysql.MysqlDb.DoesNotExist:
mysqlinfo = \
models_mysql.MysqlDbHis.objects.filter(tags=tagsdefault, version__isnull=False).order_by('-chk_time')[
0]
except Exception, e:
mysqlinfo = \
models_mysql.MysqlDbHis.objects.filter(tags=tagsdefault).order_by('-chk_time')[
0]
def show_mysql_res(request):
messageinfo_list = models_frame.TabAlarmInfo.objects.all()
tagsinfo = models_mysql.TabMysqlServers.objects.all()
tagsdefault = request.GET.get('tagsdefault')
if not tagsdefault:
tagsdefault = models_mysql.TabMysqlServers.objects.order_by('tags')[0].tags
# 时间区间
range_default = request.GET.get('range_default')
if not range_default:
range_default = '1小时'
# 主机信息
begin_time = tools.range(range_default)
end_time = datetime.datetime.now().strftime("%Y-%m-%d %H:%M:%S")
mysql_grow = models_mysql.MysqlDbHis.objects.filter(tags=tagsdefault,uptime__isnull=False).filter(
chk_time__gt=begin_time, chk_time__lt=end_time).order_by('-chk_time')
mysql_grow_list = list(mysql_grow)
mysql_grow_list.reverse()
dbinfo = models_mysql.MysqlDb.objects.filter(tags=tagsdefault).all()
big_table_list = models_mysql.MysqlBigTable.objects.filter(tags=tagsdefault).all()
# alert日志
mysql_alert_logs = models_oracle.AlertLog.objects.filter(server_type='MySQL',tags=tagsdefault).order_by('-log_time')
if request.method == 'POST':
if request.POST.has_key('select_tags') :
tagsdefault = request.POST.get('select_tags', None).encode("utf-8")
return HttpResponseRedirect('/show_mysql_res?tagsdefault=%s' %(tagsdefault))
else:
logout(request)
return HttpResponseRedirect('/login/')
if messageinfo_list:
msg_num = len(messageinfo_list)
msg_last = models_frame.TabAlarmInfo.objects.latest('id')
msg_last_content = msg_last.alarm_content
tim_last = (datetime.datetime.now() - msg_last.alarm_time).seconds / 60
else:
msg_num = 0
msg_last_content = ''
tim_last = ''
return render_to_response('mysql_mon/show_mysql_res.html', {'tagsdefault': tagsdefault, 'tagsinfo': tagsinfo, 'msg_num':msg_num,
'msg_last_content': msg_last_content, 'tim_last': tim_last, 'dbinfo':dbinfo,'mysql_grow_list':mysql_grow_list,
'big_table_list':big_table_list,'mysql_alert_logs':mysql_alert_logs})
def mysql_big_table(request):
messageinfo_list = models_frame.TabAlarmInfo.objects.all()
tags = request.GET.get('tags')
db = request.GET.get('db')
table_name = request.GET.get('table_name')
table_range_default = request.GET.get('table_range_default')
if not table_range_default:
table_range_default = '1小时'.decode("utf-8")
table_begin_time = tools.range(table_range_default)
end_time = datetime.datetime.now().strftime("%Y-%m-%d %H:%M:%S")
tablegrow = models_mysql.MysqlBigTableHis.objects.filter(
tags=tags, db=db, table_name=table_name).filter(
chk_time__gt=table_begin_time,
chk_time__lt=end_time).order_by('-chk_time')
tablegrow_list = list(tablegrow)
tablegrow_list.reverse()
if request.method == 'POST':
logout(request)
return HttpResponseRedirect('/login/')
if messageinfo_list:
msg_num = len(messageinfo_list)
msg_last = models_frame.TabAlarmInfo.objects.latest('id')
msg_last_content = msg_last.alarm_content
tim_last = (datetime.datetime.now() - msg_last.alarm_time).seconds / 60
else:
msg_num = 0
msg_last_content = ''
tim_last = ''
return render_to_response(
'mysql_mon/mysql_big_table.html', {
'tags': tags,
'table_name': table_name,
'msg_num': msg_num,
'db': db,
'msg_last_content': msg_last_content,
'tim_last': tim_last,
'tablegrow_list': tablegrow_list,
})
def linux_monitor(request):
messageinfo_list = models_frame.TabAlarmInfo.objects.all()
tagsdefault = request.GET.get('tagsdefault')
if not tagsdefault:
tagsdefault = models_linux.TabLinuxServers.objects.order_by(
'tags')[0].tags
load_range_defualt = request.GET.get('load_range_default')
if not load_range_defualt:
load_range_defualt = '1小时'.decode("utf-8")
cpu_range_defualt = request.GET.get('cpu_range_default')
if not cpu_range_defualt:
cpu_range_defualt = '1小时'.decode("utf-8")
mem_range_default = request.GET.get('mem_range_default')
if not mem_range_default:
mem_range_default = '1小时'.decode("utf-8")
net_range_default = request.GET.get('net_range_default')
if not net_range_default:
net_range_default = '1小时'.decode("utf-8")
tcp_range_default = request.GET.get('tcp_range_default')
if not tcp_range_default:
tcp_range_default = '1小时'.decode("utf-8")
hostinfo = models_linux.TabLinuxServers.objects.all().order_by('tags')
net_begin_time = tools.range(net_range_default)
cpu_begin_time = tools.range(cpu_range_defualt)
mem_begin_time = tools.range(mem_range_default)
tcp_begin_time = tools.range(tcp_range_default)
end_time = datetime.datetime.now().strftime("%Y-%m-%d %H:%M:%S")
netgrow = models_linux.OsInfoHis.objects.filter(
tags=tagsdefault, recv_kbps__isnull=False).filter(
chk_time__gt=net_begin_time,
chk_time__lt=end_time).order_by('-chk_time')
netgrow_list = list(netgrow)
netgrow_list.reverse()
loadgrow = models_linux.OsInfoHis.objects.filter(
tags=tagsdefault, load1__isnull=False).filter(
chk_time__gt=cpu_begin_time,
chk_time__lt=end_time).order_by('-chk_time')
loadgrow_list = list(loadgrow)
loadgrow_list.reverse()
cpugrow = models_linux.OsInfoHis.objects.filter(
tags=tagsdefault, cpu_used__isnull=False).filter(
chk_time__gt=cpu_begin_time,
chk_time__lt=end_time).order_by('-chk_time')
cpugrow_list = list(cpugrow)
cpugrow_list.reverse()
memgrow = models_linux.OsInfoHis.objects.filter(
tags=tagsdefault, mem_used__isnull=False).filter(
chk_time__gt=mem_begin_time,
chk_time__lt=end_time).order_by('-chk_time')
memgrow_list = list(memgrow)
memgrow_list.reverse()
tcpgrow = models_linux.OsInfoHis.objects.filter(
tags=tagsdefault, tcp_connected__isnull=False).filter(
chk_time__gt=tcp_begin_time,
chk_time__lt=end_time).order_by('-chk_time')
tcpgrow_list = list(tcpgrow)
tcpgrow_list.reverse()
diskinfos = models_linux.OsFilesystem.objects.filter(tags=tagsdefault)
# 取当前主机状态
try:
os_curr = models_linux.OsInfo.objects.filter(tags=tagsdefault).get(
tags=tagsdefault)
except models_linux.OsInfo.DoesNotExist:
os_curr = \
models_linux.OsInfoHis.objects.filter(tags=tagsdefault).order_by('-chk_time')[0]
try:
try:
osinfo = models_linux.OsInfo.objects.filter(
tags=tagsdefault, cpu_used__isnull=False).get(tags=tagsdefault)
except models_linux.OsInfo.DoesNotExist:
osinfo = \
models_linux.OsInfoHis.objects.filter(tags=tagsdefault, cpu_used__isnull=False).order_by('-chk_time')[0]
except Exception, e:
osinfo = \
models_linux.OsInfoHis.objects.filter(tags=tagsdefault).order_by('-chk_time')[0]
def oracle_monitor(request):
messageinfo_list = models_frame.TabAlarmInfo.objects.all()
tagsinfo = models_oracle.TabOracleServers.objects.all().order_by('tags')
tagsdefault = request.GET.get('tagsdefault')
if not tagsdefault:
tagsdefault = models_oracle.TabOracleServers.objects.order_by('tags')[0].tags
conn_range_default = request.GET.get('conn_range_default')
if not conn_range_default:
conn_range_default = '1小时'.decode("utf-8")
undo_range_default = request.GET.get('undo_range_default')
if not undo_range_default:
undo_range_default = '1小时'.decode("utf-8")
tmp_range_default = request.GET.get('tmp_range_default')
if not tmp_range_default:
tmp_range_default = '1小时'.decode("utf-8")
conn_begin_time = tools.range(conn_range_default)
undo_begin_time = tools.range(undo_range_default)
tmp_begin_time = tools.range(tmp_range_default)
end_time = datetime.datetime.now().strftime("%Y-%m-%d %H:%M:%S")
try:
oracleinfo = models_oracle.OracleDb.objects.get(tags=tagsdefault)
except models_oracle.OracleDb.DoesNotExist:
oracleinfo = models_oracle.OracleDbHis.objects.filter(tags=tagsdefault,percent_process__isnull=False).order_by('-chk_time')[0]
eventinfo = models_oracle.OracleDbEvent.objects.filter(tags=tagsdefault)
lockinfo = models_oracle.OracleLock.objects.filter(tags=tagsdefault)
try:
conninfo = models_oracle.OracleDb.objects.get(tags=tagsdefault)
except models_oracle.OracleDb.DoesNotExist:
conninfo = models_oracle.OracleDbHis.objects.filter(tags=tagsdefault, percent_process__isnull=False).order_by('-chk_time')[0]
conngrow = models_oracle.OracleDbHis.objects.filter(tags=tagsdefault, percent_process__isnull=False).filter(
chk_time__gt=conn_begin_time, chk_time__lt=end_time).order_by('-chk_time')
conngrow_list = list(conngrow)
conngrow_list.reverse()
try:
undoinfo = models_oracle.OracleUndoTbs.objects.get(tags=tagsdefault)
except models_oracle.OracleUndoTbs.DoesNotExist:
undoinfo = models_oracle.OracleUndoTbsHis.objects.filter(tags=tagsdefault, pct_used__isnull=False).order_by('-chk_time')[0]
undogrow = models_oracle.OracleUndoTbsHis.objects.filter(tags=tagsdefault, pct_used__isnull=False).filter(
chk_time__gt=undo_begin_time, chk_time__lt=end_time).order_by('-chk_time')
undogrow_list = list(undogrow)
undogrow_list.reverse()
try:
tmpinfo = models_oracle.OracleTmpTbs.objects.get(tags=tagsdefault,tmp_tbs_name='TEMP')
except models_oracle.OracleTmpTbs.DoesNotExist:
tmpinfo = models_oracle.OracleTmpTbsHis.objects.filter(tags=tagsdefault, pct_used__isnull=False).order_by('-chk_time')[0]
tmpgrow = models_oracle.OracleTmpTbsHis.objects.filter(tags=tagsdefault, pct_used__isnull=False).filter(
chk_time__gt=tmp_begin_time, chk_time__lt=end_time).order_by('-chk_time')
tmpgrow_list = list(tmpgrow)
tmpgrow_list.reverse()
if request.method == 'POST':
if request.POST.has_key('select_tags') or request.POST.has_key('select_conn') or request.POST.has_key('select_undo') or request.POST.has_key('select_tmp'):
if request.POST.has_key('select_tags'):
tagsdefault = request.POST.get('select_tags', None).encode("utf-8")
elif request.POST.has_key('select_conn'):
conn_range_default = request.POST.get('select_conn',None)
elif request.POST.has_key('select_undo'):
undo_range_default = request.POST.get('select_undo', None)
elif request.POST.has_key('select_tmp'):
tmp_range_default = request.POST.get('select_tmp', None)
return HttpResponseRedirect('/oracle_monitor?tagsdefault=%s&conn_range_default=%s&undo_range_default=%s&tmp_range_default=%s' %(tagsdefault,conn_range_default,undo_range_default,tmp_range_default))
else:
logout(request)
return HttpResponseRedirect('/login/')
if messageinfo_list:
msg_num = len(messageinfo_list)
msg_last = models_frame.TabAlarmInfo.objects.latest('id')
msg_last_content = msg_last.alarm_content
tim_last = (datetime.datetime.now() - msg_last.alarm_time).seconds / 60
return render_to_response('oracle_monitor.html', {'conngrow_list':conngrow_list,'undogrow_list': undogrow_list,'tmpinfo':tmpinfo,'tmpgrow_list':tmpgrow_list, 'tagsdefault':tagsdefault, 'tagsinfo':tagsinfo, 'oracleinfo': oracleinfo,'undoinfo': undoinfo,'eventinfo':eventinfo,'lockinfo':lockinfo, 'messageinfo_list': messageinfo_list,
'msg_num': msg_num,'conn_range_default':conn_range_default,'undo_range_default':undo_range_default,'tmp_range_default':tmp_range_default,
'msg_last_content': msg_last_content, 'tim_last': tim_last})
else:
return render_to_response('oracle_monitor.html', {'conngrow_list':conngrow_list,'undogrow_list': undogrow_list, 'tagsdefault':tagsdefault, 'tagsinfo':tagsinfo, 'tmpinfo':tmpinfo,'tmpgrow_list':tmpgrow_list,'oracleinfo': oracleinfo,'undoinfo': undoinfo,
'eventinfo':eventinfo,'lockinfo':lockinfo,'conn_range_default':conn_range_default,'undo_range_default':undo_range_default,'tmp_range_default':tmp_range_default})
def linux_monitor(request):
messageinfo_list = models_frame.TabAlarmInfo.objects.all()
tagsdefault = request.GET.get('tagsdefault')
if not tagsdefault:
tagsdefault = models_linux.TabLinuxServers.objects.order_by(
'tags')[0].tags
cpu_range_defualt = request.GET.get('cpu_range_default')
if not cpu_range_defualt:
cpu_range_defualt = '1小时'.decode("utf-8")
mem_range_default = request.GET.get('mem_range_default')
if not mem_range_default:
mem_range_default = '1小时'.decode("utf-8")
net_range_default = request.GET.get('net_range_default')
if not net_range_default:
net_range_default = '1小时'.decode("utf-8")
hostinfo = models_linux.TabLinuxServers.objects.all().order_by('tags')
net_begin_time = tools.range(net_range_default)
cpu_begin_time = tools.range(cpu_range_defualt)
mem_begin_time = tools.range(mem_range_default)
end_time = datetime.datetime.now().strftime("%Y-%m-%d %H:%M:%S")
netgrow = models_linux.OsInfoHis.objects.filter(
tags=tagsdefault, recv_kbps__isnull=False).filter(
chk_time__gt=net_begin_time,
chk_time__lt=end_time).order_by('-chk_time')
netgrow_list = list(netgrow)
netgrow_list.reverse()
cpugrow = models_linux.OsInfoHis.objects.filter(
tags=tagsdefault, cpu_used__isnull=False).filter(
chk_time__gt=cpu_begin_time,
chk_time__lt=end_time).order_by('-chk_time')
cpugrow_list = list(cpugrow)
cpugrow_list.reverse()
memgrow = models_linux.OsInfoHis.objects.filter(
tags=tagsdefault, mem_used__isnull=False).filter(
chk_time__gt=mem_begin_time,
chk_time__lt=end_time).order_by('-chk_time')
memgrow_list = list(memgrow)
memgrow_list.reverse()
diskinfos = models_linux.OsFilesystem.objects.filter(tags=tagsdefault)
try:
osinfo = models_linux.OsInfo.objects.get(tags=tagsdefault)
except models_linux.OsInfo.DoesNotExist:
osinfo = models_linux.OsInfoHis.objects.filter(
tags=tagsdefault, cpu_used__isnull=False).order_by('-chk_time')[0]
if request.method == 'POST':
if request.POST.has_key('select_tags') or request.POST.has_key(
'select_cpu') or request.POST.has_key(
'select_mem') or request.POST.has_key('select_net'):
if request.POST.has_key('select_tags'):
tagsdefault = request.POST.get('select_tags',
None).encode("utf-8")
elif request.POST.has_key('select_net'):
net_range_default = request.POST.get('select_net', None)
elif request.POST.has_key('select_cpu'):
cpu_range_defualt = request.POST.get('select_cpu', None)
elif request.POST.has_key('select_mem'):
mem_range_default = request.POST.get('select_mem', None)
return HttpResponseRedirect(
'/linux_monitor?tagsdefault=%s&net_range_default=%s&cpu_range_default=%s&mem_range_default=%s'
% (tagsdefault, net_range_default, cpu_range_defualt,
mem_range_default))
else:
logout(request)
return HttpResponseRedirect('/login/')
if messageinfo_list:
msg_num = len(messageinfo_list)
msg_last = models_frame.TabAlarmInfo.objects.latest('id')
msg_last_content = msg_last.alarm_content
tim_last = (datetime.datetime.now() - msg_last.alarm_time).seconds / 60
return render_to_response(
'linux_monitor.html', {
'netgrow_list': netgrow_list,
'cpugrow_list': cpugrow_list,
'memgrow_list': memgrow_list,
'tagsdefault': tagsdefault,
'hostinfo': hostinfo,
'osinfo': osinfo,
'net_range_default': net_range_default,
'cpu_range_default': cpu_range_defualt,
'mem_range_default': mem_range_default,
'messageinfo_list': messageinfo_list,
'msg_num': msg_num,
'msg_last_content': msg_last_content,
'tim_last': tim_last,
'diskinfos': diskinfos
})
else:
return render_to_response(
'linux_monitor.html', {
'netgrow_list': netgrow_list,
'cpugrow_list': cpugrow_list,
'memgrow_list': memgrow_list,
'tagsdefault': tagsdefault,
'hostinfo': hostinfo,
'osinfo': osinfo,
'net_range_default': net_range_default,
'cpu_range_default': cpu_range_defualt,
'mem_range_default': mem_range_default,
'diskinfos': diskinfos
})
def show_linux_res(request):
messageinfo_list = models_frame.TabAlarmInfo.objects.all()
tagsinfo = models_linux.TabLinuxServers.objects.all()
# 默认主机标签
tagsdefault = request.GET.get('tagsdefault')
if not tagsdefault:
tagsdefault = models_linux.TabLinuxServers.objects.order_by(
'tags')[0].tags
# 时间区间
linux_range_default = request.GET.get('linux_range_default')
if not linux_range_default:
linux_range_default = '1小时'
# 磁盘选择
diskinfo = models_linux.LinuxIoStat.objects.filter(tags=tagsdefault,
disk__isnull=False)
select_disk = request.GET.get('select_disk')
if select_disk:
select_disk = re.sub('\d+$', '', os.path.basename(select_disk))
if not select_disk:
select_disk = models_linux.LinuxIoStat.objects.filter(
tags=tagsdefault, disk__isnull=False)[0].disk
# 磁盘使用信息
diskinfo_list = models_linux.OsFilesystem.objects.filter(
tags=tagsdefault).order_by('-pct_used')
linux_begin_time = tools.range(linux_range_default)
end_time = datetime.datetime.now().strftime("%Y-%m-%d %H:%M:%S")
disk_grow = models_linux.LinuxIoStatHis.objects.filter(
tags=tagsdefault,
disk=select_disk).filter(chk_time__gt=linux_begin_time,
chk_time__lt=end_time).order_by('-chk_time')
disk_grow_list = list(disk_grow)
disk_grow_list.reverse()
# 主机信息
linux_begin_time = tools.range(linux_range_default)
end_time = datetime.datetime.now().strftime("%Y-%m-%d %H:%M:%S")
linux_grow = models_linux.OsInfoHis.objects.filter(
tags=tagsdefault, updays__isnull=False).filter(
chk_time__gt=linux_begin_time,
chk_time__lt=end_time).order_by('-chk_time')
linux_grow_list = list(linux_grow)
linux_grow_list.reverse()
if request.method == 'POST':
if request.POST.has_key('select_tags'):
tagsdefault = request.POST.get('select_tags', None).encode("utf-8")
return HttpResponseRedirect('/show_linux_res?tagsdefault=%s' %
(tagsdefault))
else:
logout(request)
return HttpResponseRedirect('/login/')
if messageinfo_list:
msg_num = len(messageinfo_list)
msg_last = models_frame.TabAlarmInfo.objects.latest('id')
msg_last_content = msg_last.alarm_content
tim_last = (datetime.datetime.now() - msg_last.alarm_time).seconds / 60
else:
msg_num = 0
msg_last_content = ''
tim_last = ''
return render_to_response(
'show_linux_res.html', {
'tagsdefault': tagsdefault,
'tagsinfo': tagsinfo,
'msg_num': msg_num,
'msg_last_content': msg_last_content,
'tim_last': tim_last,
'diskinfo': diskinfo,
'select_disk': select_disk,
'diskinfo_list': diskinfo_list,
'disk_grow_list': disk_grow_list,
'linux_grow_list': linux_grow_list
})
def mysql_monitor(request):
messageinfo_list = models_frame.TabAlarmInfo.objects.all()
tagsinfo = models_mysql.TabMysqlServers.objects.all().order_by('tags')
tagsdefault = request.GET.get('tagsdefault')
if not tagsdefault:
tagsdefault = models_mysql.TabMysqlServers.objects.order_by('tags')[0].tags
conn_range_default = request.GET.get('conn_range_default')
if not conn_range_default:
conn_range_default = '1小时'.decode("utf-8")
qps_range_default = request.GET.get('qps_range_default')
if not qps_range_default:
qps_range_default = '1小时'.decode("utf-8")
tps_range_default = request.GET.get('tps_range_default')
if not tps_range_default:
tps_range_default = '1小时'.decode("utf-8")
conn_begin_time = tools.range(conn_range_default)
qps_begin_time = tools.range(qps_range_default)
tps_begin_time = tools.range(tps_range_default)
end_time = datetime.datetime.now().strftime("%Y-%m-%d %H:%M:%S")
try:
mysqlinfo = models_mysql.MysqlDb.objects.get(tags=tagsdefault)
except models_mysql.MysqlDb.DoesNotExist:
print tagsdefault
mysqlinfo = \
models_mysql.MysqlDbHis.objects.filter(tags=tagsdefault, conn_rate__isnull=False).order_by('-chk_time')[0]
try:
conninfo = models_mysql.MysqlDb.objects.get(tags=tagsdefault)
except models_mysql.MysqlDb.DoesNotExist:
conninfo = \
models_mysql.MysqlDbHis.objects.filter(tags=tagsdefault, conn_rate__isnull=False).order_by('-chk_time')[0]
conngrow = models_mysql.MysqlDbHis.objects.filter(tags=tagsdefault, conn_rate__isnull=False).filter(
chk_time__gt=conn_begin_time, chk_time__lt=end_time).order_by('-chk_time')
conngrow_list = list(conngrow)
conngrow_list.reverse()
print qps_begin_time
qpsgrow = models_mysql.MysqlDbHis.objects.filter(tags=tagsdefault, qps__isnull=False).filter(
chk_time__gt=qps_begin_time, chk_time__lt=end_time).order_by('-chk_time')
qpsgrow_list = list(qpsgrow)
qpsgrow_list.reverse()
tpsgrow = models_mysql.MysqlDbHis.objects.filter(tags=tagsdefault, tps__isnull=False).filter(
chk_time__gt=tps_begin_time, chk_time__lt=end_time).order_by('-chk_time')
tpsgrow_list = list(tpsgrow)
tpsgrow_list.reverse()
if request.method == 'POST':
if request.POST.has_key('select_tags') or request.POST.has_key('select_conn') or request.POST.has_key(
'select_qps') or request.POST.has_key('select_tps'):
if request.POST.has_key('select_tags'):
tagsdefault = request.POST.get('select_tags', None).encode("utf-8")
elif request.POST.has_key('select_conn'):
conn_range_default = request.POST.get('select_conn', None)
elif request.POST.has_key('select_qps'):
qps_range_default = request.POST.get('select_qps', None)
elif request.POST.has_key('select_tps'):
tps_range_default = request.POST.get('select_tps', None)
return HttpResponseRedirect(
'/mysql_monitor?tagsdefault=%s&conn_range_default=%s&qps_range_default=%s&tps_range_default=%s' % (
tagsdefault, conn_range_default, qps_range_default, tps_range_default))
else:
logout(request)
return HttpResponseRedirect('/login/')
if messageinfo_list:
msg_num = len(messageinfo_list)
msg_last = models_frame.TabAlarmInfo.objects.latest('id')
msg_last_content = msg_last.alarm_content
tim_last = (datetime.datetime.now() - msg_last.alarm_time).seconds / 60
return render_to_response('mysql_monitor.html', { 'messageinfo_list': messageinfo_list, 'msg_num': msg_num,
'msg_last_content': msg_last_content, 'tim_last': tim_last,'conngrow_list': conngrow_list,'qpsgrow_list': qpsgrow_list, 'tagsdefault': tagsdefault,
'conn_range_default': conn_range_default,'qps_range_default': qps_range_default,'tps_range_default': tps_range_default,
'tagsinfo': tagsinfo, 'mysqlinfo': mysqlinfo,'qpsgrow_list': qpsgrow_list,'tpsgrow_list': tpsgrow_list})
else:
return render_to_response('mysql_monitor.html', {'conngrow_list': conngrow_list,'qpsgrow_list': qpsgrow_list, 'tagsdefault': tagsdefault,'conn_range_default': conn_range_default,'qps_range_default': qps_range_default,'tps_range_default': tps_range_default,
'tagsinfo': tagsinfo, 'mysqlinfo': mysqlinfo,'qpsgrow_list': qpsgrow_list,'tpsgrow_list': tpsgrow_list
})
