Skip to content

Instantly share code, notes, and snippets.

@evan4498
Created June 13, 2013 13:06
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save evan4498/5773509 to your computer and use it in GitHub Desktop.
Save evan4498/5773509 to your computer and use it in GitHub Desktop.
Cloud DB agent check
root@cloudserv:~# raxmon-checks-create --entity-id=enT8WCQUIs --label=clouddbcheck --type=agent.mysql --details="host=<REDACTED>.rackspaceclouddb.com","username=<REDACTED>","password=<REDACTED>","port=3306"
Resource created. ID: chV01XMDLx
root@cloudserv:~# raxmon-checks-test-existing --entity-id=enT8WCQUIs --id=chV01XMDLx
[{u'available': True,
u'metrics': {u'core.aborted_clients': {u'data': 36996,
u'type': u'L',
u'unit': u'clients'},
u'core.connections': {u'data': 2161933,
u'type': u'l',
u'unit': u'connections'},
u'core.queries': {u'data': 65812459,
u'type': u'l',
u'unit': u'queries'},
u'core.uptime': {u'data': 17707162,
u'type': u'L',
u'unit': u'seconds'},
u'innodb.buffer_pool_pages_dirty': {u'data': 0,
u'type': u'L',
u'unit': u'pages'},
u'innodb.buffer_pool_pages_flushed': {u'data': 109774,
u'type': u'L',
u'unit': u'pages'},
u'innodb.buffer_pool_pages_free': {u'data': 8408,
u'type': u'L',
u'unit': u'pages'},
u'innodb.buffer_pool_pages_total': {u'data': 9600,
u'type': u'L',
u'unit': u'pages'},
u'innodb.row_lock_time': {u'data': 0,
u'type': u'L',
u'unit': u'milliseconds'},
u'innodb.row_lock_time_avg': {u'data': 0,
u'type': u'L',
u'unit': u'milliseconds'},
u'innodb.row_lock_time_max': {u'data': 0,
u'type': u'L',
u'unit': u'milliseconds'},
u'innodb.rows_deleted': {u'data': 8065,
u'type': u'l',
u'unit': u'rows'},
u'innodb.rows_inserted': {u'data': 17578,
u'type': u'l',
u'unit': u'rows'},
u'innodb.rows_read': {u'data': 9650530,
u'type': u'l',
u'unit': u'rows'},
u'innodb.rows_updated': {u'data': 25844,
u'type': u'l',
u'unit': u'rows'},
u'qcache.free_blocks': {u'data': 172,
u'type': u'L',
u'unit': u'blocks'},
u'qcache.free_memory': {u'data': 7361256,
u'type': u'L',
u'unit': u'bytes'},
u'qcache.hits': {u'data': 55779279,
u'type': u'l',
u'unit': u'hits'},
u'qcache.inserts': {u'data': 438967,
u'type': u'l',
u'unit': u'inserts'},
u'qcache.lowmem_prunes': {u'data': 0,
u'type': u'l',
u'unit': u'prunes'},
u'qcache.not_cached': {u'data': 1799824,
u'type': u'l',
u'unit': u'queries'},
u'qcache.queries_in_cache': {u'data': 764,
u'type': u'L',
u'unit': u'queries'},
u'qcache.total_blocks': {u'data': 1738,
u'type': u'L',
u'unit': u'blocks'},
u'threads.connected': {u'data': 1,
u'type': u'L',
u'unit': u'threads'},
u'threads.created': {u'data': 206,
u'type': u'L',
u'unit': u'threads'},
u'threads.running': {u'data': 1,
u'type': u'L',
u'unit': u'threads'}},
u'status': u'success',
u'timestamp': 1371128685328}]
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment