(An Untitled Masterwork)
ActivePublic
Actions

Authored by jcrespo on May 8 2017, 1:59 PM.

Tags

None

Referenced Files

	F7983902:
	May 8 2017, 1:59 PM

Subscribers

None

	$ time ./check_health.py -h db1024
	{"connection": null}

	real 0m1.146s
	user 0m0.124s
	sys 0m0.020s
	root@neodymium:~$ time ./check_health.py -h db1022
	{"connection": null}

	real 0m1.137s
	user 0m0.120s
	sys 0m0.012s
	root@neodymium:~$ time ./check_health.py -h db1200
	{"connection": null}

	real 0m0.142s
	user 0m0.128s
	sys 0m0.012s
	root@neodymium:~$ time ./check_health.py -h db1051 -P3333
	{"connection": null}

	real 0m1.141s
	user 0m0.124s
	sys 0m0.012s

Event Timeline

jcrespo created this paste.May 8 2017, 1:59 PM

$ time ./check_health.py -h db1051 --slave-status
{"query_latency": 0.001035928726196289, "connection": "ok", "datetime": 1494252219.7567518, "read_only": true, "connection_latency": 0.06453084945678711, "version": "10.0.29-MariaDB", "uptime": 5693638, "total_queries": 9932514195, "threads_connected": 30, "heartbeat": {"s1": 0.258404}, "replication": {"": {"Seconds_Behind_Master": 0, "Slave_IO_Running": "Yes", "Slave_SQL_Running": "Yes"}}}

real    0m0.206s
user    0m0.136s
sys     0m0.028s

$ ./check_health.py -h db1001 --slave-status
{"read_only": true, "ssl": true, "connection_latency": 0.08704566955566406, "datetime": 1494426227.6187909, "threads_connected": 3, "heartbeat": {"m1": 0.121514}, "connection": "ok", "total_queries": 1971272955, "ssl_expiration": 1624303877.0, "version": "10.0.29-MariaDB", "uptime": 5955251, "query_latency": 0.0011200904846191406, "replication": {"": {"Last_IO_Error": null, "Slave_IO_Running": "Yes", "Slave_SQL_Running": "Yes", "Last_SQL_Error": null, "Seconds_Behind_Master": 0}}}

(An Untitled Masterwork)ActivePublicActions

Event Timeline

(An Untitled Masterwork)
ActivePublic
Actions