Page Menu
Home
Phabricator
Search
Configure Global Search
Log In
Paste
P6873
s1 latencies
Active
Public
Actions
Authored by
jcrespo
on Mar 21 2018, 4:07 PM.
Edit Paste
Archive Paste
View Raw File
Subscribe
Mute Notifications
Award Token
Flag For Later
Tags
None
Referenced Files
F15947842: s1 latencies
Mar 21 2018, 4:07 PM
2018-03-21 16:07:58 (UTC+0)
Subscribers
None
$ while read host port; do echo "$host:$port:"; python3 ../../check_mariadb.py -h $host --port=$port; done < s1.hosts
db2055.codfw.wmnet:3306:
{"heartbeat": {"s1": 0.0}, "version": "10.0.34-MariaDB", "connection_latency": 0.27933740615844727, "datetime": 1521648373.3548977, "read_only": true, "uptime": 2013482, "total_queries": 405447550, "ssl": true, "connection": "ok", "query_latency": 0.037717580795288086, "ssl_expiration": 1603298507.0, "threads_connected": 13}
db2062.codfw.wmnet:3306:
{"connection": "ok", "version": "10.1.31-MariaDB", "total_queries": 377439646, "datetime": 1521648374.3529046, "query_latency": 0.037625789642333984, "ssl": true, "threads_connected": 13, "connection_latency": 0.2828845977783203, "uptime": 1843121, "heartbeat": {"s1": 0.0}, "ssl_expiration": 1603537819.0, "read_only": true}
db2069.codfw.wmnet:3306:
{"query_latency": 0.03709745407104492, "uptime": 1840843, "ssl": true, "total_queries": 376750964, "datetime": 1521648375.299685, "connection_latency": 0.2781376838684082, "read_only": true, "connection": "ok", "heartbeat": {"s1": 0.0}, "version": "10.0.34-MariaDB", "ssl_expiration": 1603539900.0, "threads_connected": 14}
db2070.codfw.wmnet:3306:
{"read_only": true, "datetime": 1521648376.2694385, "threads_connected": 12, "connection_latency": 0.2785067558288574, "uptime": 2013491, "ssl": true, "connection": "ok", "query_latency": 0.03710675239562988, "version": "10.0.34-MariaDB", "total_queries": 1011993028, "ssl_expiration": 1603539877.0, "heartbeat": {"s1": 0.0}}
db2071.codfw.wmnet:3306:
{"connection_latency": 0.26846909523010254, "read_only": true, "ssl_expiration": 1650348474.0, "heartbeat": {"s1": 0.50968}, "connection": "ok", "version": "10.0.33-MariaDB", "uptime": 6480562, "total_queries": 1104664120, "datetime": 1521648377.9925852, "threads_connected": 12, "query_latency": 0.0372004508972168, "ssl": true}
db2072.codfw.wmnet:3306:
{"ssl": true, "connection": "ok", "read_only": true, "heartbeat": {"s1": 0.148748}, "total_queries": 3838571013, "connection_latency": 0.2702751159667969, "ssl_expiration": 1655805475.0, "threads_connected": 12, "uptime": 6481008, "query_latency": 0.03718972206115723, "version": "10.1.30-MariaDB", "datetime": 1521648379.6318622}
db2085.codfw.wmnet:3311:
{"query_latency": 0.03724527359008789, "datetime": 1521648380.7654624, "read_only": true, "total_queries": 296577860, "version": "10.1.31-MariaDB", "heartbeat": {"s1": 0.282344}, "ssl": true, "connection_latency": 0.2692852020263672, "uptime": 1845570, "threads_connected": 12, "connection": "ok", "ssl_expiration": 1667139829.0}
db2088.codfw.wmnet:3311:
{"datetime": 1521648381.9174678, "connection": "ok", "query_latency": 0.03725099563598633, "uptime": 5864759, "version": "10.1.30-MariaDB", "connection_latency": 0.2700004577636719, "read_only": true, "total_queries": 714834436, "ssl": true, "ssl_expiration": 1666515482.0, "heartbeat": {"s1": 0.434471}, "threads_connected": 12}
dbstore2002.codfw.wmnet:3311:
{"threads_connected": 12, "version": "10.1.30-MariaDB", "connection": "ok", "uptime": 6032555, "datetime": 1521648382.7307289, "ssl_expiration": 1635954994.0, "heartbeat": {"s1": 0.246291}, "connection_latency": 0.2799694538116455, "total_queries": 721897903, "query_latency": 0.03709220886230469, "read_only": false, "ssl": true}
db2048.codfw.wmnet:3306:
{"ssl_expiration": 1653832085.0, "ssl": true, "query_latency": 0.03718900680541992, "heartbeat": {"s1": 0.250129}, "datetime": 1521648383.7335794, "uptime": 464684, "threads_connected": 18, "connection": "ok", "connection_latency": 0.2815220355987549, "version": "10.0.34-MariaDB", "total_queries": 79640184, "read_only": true}
labsdb1009.eqiad.wmnet:3306:
{"heartbeat": {"s3": 0.331997, "s1": 0.332777, "s8": 0.333737, "s2": 0.332887, "s4": 0.333497, "s6": 0.333437, "s5": 0.333687, "s7": 0.333567}, "read_only": false, "connection": "ok", "threads_connected": 36, "ssl": true, "datetime": 1521648384.8340037, "version": "10.1.31-MariaDB", "connection_latency": 0.0619354248046875, "total_queries": 264971656, "query_latency": 0.0012259483337402344, "uptime": 112673, "ssl_expiration": 1626257725.0}
labsdb1010.eqiad.wmnet:3306:
{"read_only": false, "heartbeat": {"s3": 0.534675, "s5": 0.535065, "s7": 0.0, "s8": 0.534865, "s2": 0.0, "s4": 0.0, "s1": 0.534215, "s6": 0.0}, "uptime": 1628173, "datetime": 1521648386.0352662, "connection_latency": 0.053166866302490234, "version": "10.1.31-MariaDB", "ssl_expiration": 1658852501.0, "threads_connected": 47, "total_queries": 2800465595, "query_latency": 0.0014102458953857422, "connection": "ok", "ssl": true}
labsdb1011.eqiad.wmnet:3306:
{"query_latency": 0.0013287067413330078, "threads_connected": 22, "connection_latency": 0.04433846473693848, "datetime": 1521648387.1277826, "version": "10.1.31-MariaDB", "ssl_expiration": 1627232057.0, "uptime": 1744116, "total_queries": 2240535038, "read_only": false, "ssl": true, "connection": "ok", "heartbeat": {"s8": 0.627582, "s2": 0.0, "s1": 0.626852, "s7": 0.0, "s5": 0.627502, "s6": 0.0, "s4": 0.0, "s3": 0.627312}}
db1095.eqiad.wmnet:3306:
{"ssl": true, "version": "10.1.31-MariaDB", "uptime": 104094, "query_latency": 0.0014407634735107422, "ssl_expiration": 1636921810.0, "read_only": true, "datetime": 1521648388.3541064, "connection_latency": 0.05444025993347168, "threads_connected": 15, "total_queries": 70640468, "connection": "ok", "heartbeat": {"s8": 0.854142, "s5": 0.854082, "s1": 0.853432, "s4": 18261090.854272, "s3": 0.852672}}
dbstore1002.eqiad.wmnet:3306:
{"query_latency": 0.0013644695281982422, "read_only": false, "connection": "ok", "total_queries": 6736782513, "connection_latency": 0.044049739837646484, "version": "10.0.22-MariaDB", "datetime": 1521648388.6263118, "ssl": true, "heartbeat": {"s2": 0.125362, "s1": 0.124942, "m3": 19336407.126002, "s8": 0.126062, "x1": 0.125482, "s3": 0.125452, "s4": 0.125982, "s6": 0.126012, "s7": 0.125572, "s5": 0.126212}, "threads_connected": 12, "ssl_expiration": 1593464341.0, "uptime": 6134334}
db1080.eqiad.wmnet:3306:
{"version": "10.0.33-MariaDB", "read_only": true, "query_latency": 0.0013010501861572266, "connection": "ok", "connection_latency": 0.055375099182128906, "total_queries": 57725050648, "uptime": 3489045, "threads_connected": 101, "heartbeat": {"s1": 0.102061}, "ssl_expiration": 1622481558.0, "datetime": 1521648389.6025767, "ssl": true}
db1083.eqiad.wmnet:3306:
{"uptime": 2274851, "read_only": true, "threads_connected": 120, "query_latency": 0.0014803409576416016, "ssl_expiration": 1622477270.0, "version": "10.0.34-MariaDB", "ssl": true, "connection": "ok", "connection_latency": 0.05701923370361328, "total_queries": 38818042612, "heartbeat": {"s1": 0.178065}, "datetime": 1521648390.6786933}
db1089.eqiad.wmnet:3306:
{"uptime": 2625489, "query_latency": 0.001237630844116211, "connection": "ok", "ssl_expiration": 1622562736.0, "datetime": 1521648391.7055814, "threads_connected": 94, "read_only": true, "total_queries": 40947628370, "ssl": true, "version": "10.0.33-MariaDB", "heartbeat": {"s1": 0.20457}, "connection_latency": 0.06063413619995117}
db1066.eqiad.wmnet:3306:
{"read_only": true, "query_latency": 0.0010752677917480469, "connection_latency": 0.04674792289733887, "version": "10.0.34-MariaDB", "heartbeat": {"s1": 0.0}, "ssl_expiration": 1642984349.0, "datetime": 1521648392.110736, "ssl": true, "threads_connected": 51, "total_queries": 19275499747, "uptime": 2957722, "connection": "ok"}
db1067.eqiad.wmnet:3306:
{"total_queries": 9996608364, "ssl": true, "connection": "ok", "connection_latency": 0.04962658882141113, "threads_connected": 19, "ssl_expiration": 1643652231.0, "datetime": 1521648392.4680777, "version": "10.0.33-MariaDB", "query_latency": 0.0012869834899902344, "uptime": 6071318, "read_only": true, "heartbeat": {"s1": 0.0}}
db1106.eqiad.wmnet:3306:
{"total_queries": 223014531, "datetime": 1521648393.1365879, "ssl": true, "connection_latency": 0.05166888236999512, "threads_connected": 23, "connection": "ok", "query_latency": 0.0010912418365478516, "read_only": true, "ssl_expiration": 1657689730.0, "heartbeat": {"s5": 201296.636226, "s1": 0.0}, "version": "10.0.34-MariaDB", "uptime": 200675}
db1099.eqiad.wmnet:3311:
{"ssl_expiration": 1669537523.0, "threads_connected": 30, "uptime": 5980244, "version": "10.1.30-MariaDB", "total_queries": 5475496831, "datetime": 1521648393.6320884, "connection": "ok", "ssl": true, "connection_latency": 0.046765804290771484, "read_only": true, "query_latency": 0.0011563301086425781, "heartbeat": {"s1": 0.131099}}
db1114.eqiad.wmnet:3306:
{"version": "10.1.31-MariaDB", "ssl": true, "read_only": true, "heartbeat": {"s1": 0.0}, "connection_latency": 0.04278922080993652, "datetime": 1521648394.328591, "total_queries": 14645548727, "ssl_expiration": 1677605743.0, "connection": "ok", "query_latency": 0.0010256767272949219, "threads_connected": 122, "uptime": 1119206}
db1105.eqiad.wmnet:3311:
{"read_only": true, "threads_connected": 25, "query_latency": 0.0010290145874023438, "heartbeat": {"s1": 0.318682}, "version": "10.1.30-MariaDB", "total_queries": 5398108439, "uptime": 5908184, "connection": "ok", "ssl_expiration": 1667743217.0, "connection_latency": 0.0516510009765625, "datetime": 1521648394.819633, "ssl": true}
db1052.eqiad.wmnet:3306:
{"version": "10.0.28-MariaDB", "query_latency": 0.0011010169982910156, "ssl": true, "total_queries": 33892898484, "ssl_expiration": 1619276854.0, "heartbeat": {"s1": 0.0}, "datetime": 1521648395.0454216, "uptime": 36345314, "read_only": false, "threads_connected": 46, "connection": "ok", "connection_latency": 0.07273006439208984}
Event Timeline
jcrespo
created this paste.
Mar 21 2018, 4:07 PM
2018-03-21 16:07:58 (UTC+0)
Log In to Comment