import plotly.plotly
from plotly.graph_objs import *
import plotly.graph_objs as abc
import matplotlib.pyplot as plt
host = "*.*.*.*"
user = "monitor"
passwd = "monitor"
db = "monitor"
port = 3306
charset = "utf8"
conn = pymysql.connect(
host=host,
port=port,
user=user,
passwd=passwd,
db=db,
charset=charset,
)
cur = conn.cursor()
re = cur.execute("SELECT add_time,t,t_mysql FROM monitor.monitor_result_t ")
dfs = cur.fetchall()
listx = []
listy = []
listy2 = []
for row in dfs:
listx.append(row[0])
listy.append(row[1])
listy2.append(row[2])
cur.close()
conn.commit()
conn.close()
length = listy.__len__()
data_1 = abc.Scatter(
x=listx,
y=listy,
name='syncer_delay_time_tidb',
mode='markers',
marker=dict(
size=10,
color="rgba(255,47,167,.9)",
line=dict(
width=2,
color='rgb(2,2,2)'
)
)
)
data_2 = abc.Scatter(
x=listx,
y=listy2,
name='syncer_delay_time_mysql',
mode='markers',
marker=dict(
size=10,
color="rgba(255,47,167,.9)",
line=dict(
width=2,
color='rgb(3,3,3)'
)
)
)
data1 = Data([data_1])
plotly.offline.plot(data1)
data2 = Data([data_2])
plotly.offline.plot(data2)
部分时间段效果如下:
耿小厨已开通个人微信公众号,想进一步沟通或想了解其他文章的同学可以关注我
|