opsmx_mysq Metrics List

opsmx_mysql.py

*Service Metrics

• If EXTENDED=False, the selected metrics are 1 to 11

1. mysql.aborted_connects
2. mysql.bytes_received
3. mysql.bytes_sent
4. mysql.com_change_db
5. mysql.com_load
6. mysql.innodb_buffer_pool_reads
7. mysql.innodb_buffer_pool_write_requests
8. mysql.innodb_buffer_pool_pages_flushed
9. mysql.max_used_connections
10. mysql.connections
11. mysql.uptime

---

12. mysql.com_show_create_event  
13. mysql.com_execute_sql  
14. mysql.com_show_procedure_status  
15. mysql.performance_schema_locker_lost  
16. mysql.ssl_accepts  
17. mysql.com_xa_rollback  
18. mysql.innodb_pages_written  
19. mysql.com_replace  
20. mysql.innodb_pages_read
21. mysql.com_create_procedure  
22. mysql.com_preload_keys  
23. mysql.com_kill  
24. mysql.innodb_log_writes  
25. mysql.com_show_engine_status 
26. mysql.com_alter_procedure  
27. mysql.com_ha_open  
28. mysql.com_alter_db_upgrade  
29. mysql.aborted_clients  
30. mysql.com_drop_trigger  
31. mysql.com_show_slave_status  
32. mysql.ssl_verify_depth  
33. mysql.com_stmt_send_long_data  
34. mysql.innodb_buffer_pool_pages_free
35. mysql.threads_connected  
36. mysql.innodb_rows_inserted  
37. mysql.com_create_udf  
38. mysql.qcache_lowmem_prunes  
39. mysql.binlog_cache_use  
40. mysql.com_lock_tables  
41. mysql.com_alter_function  
42. mysql.com_show_authors  
43. mysql.com_resignal  
44. mysql.com_stmt_execute  
45. mysql.com_show_table_status  
46. mysql.innodb_os_log_written
47. mysql.innodb_rows_read  
48. mysql.com_drop_table  
49. mysql.com_show_create_proc  
50. mysql.com_rollback_to_savepoint  
51. mysql.performance_schema_table_handles_lost  
52. mysql.last_query_cost  
53. mysql.com_stmt_fetch  
54. mysql.com_create_view  
55. mysql.performance_schema_cond_classes_lost  
56. mysql.sort_rows  
57. mysql.com_change_master  
58. mysql.com_do  
59. mysql.com_show_create_table  
60. mysql.com_create_trigger  
61. mysql.innodb_data_writes 
62. mysql.handler_read_last  
63. mysql.com_slave_stop  
64. mysql.com_show_master_status  
65. mysql.handler_read_prev  
66. mysql.com_drop_procedure  
67. mysql.not_flushed_delayed_rows  
68. mysql.com_install_plugin  
69. mysql.ssl_session_cache_size  
70. mysql.innodb_log_write_requests  
71. mysql.qcache_inserts  
72. mysql.com_flush  
73. mysql.slave_received_heartbeats  
74. mysql.innodb_buffer_pool_pages_misc  
75. mysql.binlog_stmt_cache_use  
76. mysql.qcache_queries_in_cache   
77. mysql.innodb_buffer_pool_wait_free  
78. mysql.com_admin_commands  
79. mysql.ssl_session_cache_overflows  
80. mysql.com_begin  
81. mysql.com_create_table  
82. mysql.ssl_ctx_verify_mode  
83. mysql.innodb_buffer_pool_pages_dirty  
84. mysql.handler_savepoint_rollback  
85. mysql.sort_merge_passes  
86. mysql.ssl_client_connects  
87. mysql.com_call_procedure  
88. mysql.com_show_relaylog_events  
89. mysql.delayed_insert_threads  
90. mysql.com_show_create_db  
91. mysql.com_show_create_trigger  
92. mysql.com_drop_index  
93. mysql.handler_savepoint  
94. mysql.innodb_row_lock_time_avg  
95. mysql.performance_schema_file_handles_lost  
96. mysql.performance_schema_table_instances_lost  
97. mysql.key_blocks_not_flushed  
98. mysql.com_show_privileges  
99. mysql.innodb_row_lock_current_waits  
100. mysql.select_range_check  
101. mysql.com_repair  
102. mysql.com_show_open_tables  
103. mysql.com_show_slave_hosts  
104. mysql.com_revoke_all  
105. mysql.performance_schema_file_classes_lost 
106. mysql.handler_read_first
107. mysql.innodb_os_log_pending_writes  
108. mysql.com_show_fields  
109. mysql.created_tmp_disk_tables
110. mysql.select_full_range_join  
111. mysql.key_blocks_unused
112. mysql.slave_heartbeat_period  
113. mysql.com_insert  
114. mysql.threads_cached  
115. mysql.ssl_ctx_verify_depth  
116. mysql.ssl_used_session_cache_entries  
117. mysql.innodb_dblwr_pages_written  
118. mysql.innodb_truncated_status_writes  
119. mysql.tc_log_page_waits  
120. mysql.com_create_function  
121. mysql.com_show_errors  
122. mysql.com_analyze  
123. mysql.select_full_join  
124. mysql.handler_read_rnd  
125. mysql.com_signal  
126. mysql.com_drop_event  
127. mysql.performance_schema_rwlock_instances_lost  
128. mysql.handler_delete  
129. mysql.com_create_event  
130. mysql.com_alter_table  
131. mysql.com_delete_multi  
132. mysql.select_range  
133. mysql.opened_table_definitions
134. mysql.innodb_data_pending_reads 
135. mysql.innodb_buffer_pool_pages_total
136. mysql.com_show_triggers  
137. mysql.handler_read_key  
138. mysql.qcache_total_blocks  
139. mysql.com_truncate  
140. mysql.performance_schema_file_instances_lost  
141. mysql.ssl_sessions_reused  
142. mysql.com_rollback  
143. mysql.com_replace_select  
144. mysql.com_show_databases  
145. mysql.ssl_finished_connects  
146. mysql.tc_log_page_size  
147. mysql.ssl_session_cache_hits  
148. mysql.innodb_pages_created  
149. mysql.com_show_storage_engines  
150. mysql.com_drop_view  
151. mysql.com_binlog  
152. mysql.com_show_status  
153. mysql.com_create_index  
154. mysql.com_create_user  
155. mysql.ssl_accept_renegotiates  
156. mysql.qcache_hits  
157. mysql.innodb_data_pending_writes  
158. mysql.slow_queries  
159. mysql.com_show_events  
160. mysql.innodb_row_lock_time_max  
161. mysql.com_check  
162. mysql.innodb_buffer_pool_read_requests
163. mysql.innodb_os_log_pending_fsyncs  
164. mysql.com_xa_commit  
165. mysql.innodb_buffer_pool_bytes_dirty  
166. mysql.com_set_option  
167. mysql.slow_launch_threads  
168. mysql.innodb_os_log_fsyncs
169. mysql.delayed_writes  
170. mysql.table_locks_waited  
171. mysql.innodb_log_waits  
172. mysql.com_uninstall_plugin  
173. mysql.handler_rollback  
174. mysql.com_savepoint  
175. mysql.com_show_grants  
176. mysql.delayed_errors  
177. mysql.handler_prepare  
178. mysql.innodb_data_reads
179. mysql.ssl_connect_renegotiates  
180. mysql.com_show_engine_mutex  
181. mysql.select_scan  13.0
182. mysql.ssl_default_timeout  
183. mysql.flush_commands  
184. mysql.com_revoke  
185. mysql.com_xa_end  
186. mysql.com_show_create_func  
187. mysql.com_purge  
188. mysql.com_optimize  
189. mysql.com_slave_start  
190. mysql.com_stmt_reprepare  
191. mysql.innodb_dblwr_writes  
192. mysql.com_show_binlog_events  
193. mysql.com_xa_recover  
194. mysql.performance_schema_mutex_instances_lost  
195. mysql.innodb_data_read
196. mysql.com_drop_server  
197. mysql.innodb_buffer_pool_read_ahead_evicted  
198. mysql.com_unlock_tables  
199. mysql.tc_log_max_pages_used  
200. mysql.com_assign_to_keycache  
201. mysql.binlog_stmt_cache_disk_use  
202. mysql.sort_range  
203. mysql.com_xa_start  
204. mysql.com_dealloc_sql  
205. mysql.questions
206. mysql.sort_scan  
207. mysql.innodb_rows_deleted  
208. mysql.com_drop_db  
209. mysql.slave_open_temp_tables  
210. mysql.qcache_free_blocks  
211. mysql.queries
212. mysql.com_show_charsets  
213. mysql.ssl_callback_cache_hits  
214. mysql.com_drop_function  
215. mysql.com_select
216. mysql.com_commit  
217. mysql.ssl_verify_mode  
218. mysql.com_create_server  
219. mysql.com_stmt_reset  
220. mysql.com_update_multi  
221. mysql.com_checksum  
222. mysql.handler_discover  
223. mysql.com_alter_tablespace  
224. mysql.com_grant  
225. mysql.com_empty_query  
226. mysql.com_drop_user  
227. mysql.com_show_processlist  
228. mysql.com_show_engine_logs  
229. mysql.table_locks_immediate
230. mysql.innodb_buffer_pool_pages_data
231. mysql.performance_schema_cond_instances_lost  
232. mysql.com_show_binlogs  
233. mysql.qcache_not_cached
234. mysql.ssl_finished_accepts  
235. mysql.com_alter_db  
236. mysql.com_ha_read  
237. mysql.handler_read_rnd_next
238. mysql.com_alter_server  
239. mysql.com_alter_event  
240. mysql.com_show_variables  
241. mysql.com_show_function_status  
242. mysql.com_show_warnings  
243. mysql.key_blocks_used  
244. mysql.open_streams  
245. mysql.ssl_session_cache_misses  
246. mysql.key_reads  
247. mysql.innodb_row_lock_waits  
248. mysql.com_rename_user  
249. mysql.performance_schema_rwlock_classes_lost  
250. mysql.opened_files
251. mysql.handler_read_next  
252. mysql.key_write_requests  
253. mysql.key_writes  
254. mysql.com_stmt_close  
255. mysql.created_tmp_tables
256. mysql.open_tables
257. mysql.com_show_plugins  
258. mysql.ssl_session_cache_timeouts  
259. mysql.com_insert_select  
260. mysql.com_show_profile  
261. mysql.com_xa_prepare  
262. mysql.handler_update  
263. mysql.created_tmp_files
264. mysql.innodb_buffer_pool_read_ahead_rnd  
265. mysql.com_reset  
266. mysql.handler_commit  
267. mysql.innodb_buffer_pool_bytes_data 
268. mysql.handler_write
269. mysql.com_ha_close  
270. mysql.innodb_data_pending_fsyncs  
271. mysql.binlog_cache_disk_use  
272. mysql.com_show_keys  
273. mysql.com_show_profiles  
274. mysql.com_show_tables  
275. mysql.innodb_rows_updated  
276. mysql.threads_created  
277. mysql.com_delete  
278. mysql.innodb_buffer_pool_read_ahead  
279. mysql.qcache_free_memory 
280. mysql.opened_tables 
281. mysql.com_help  
282. mysql.performance_schema_thread_classes_lost  
283. mysql.com_prepare_sql  
284. mysql.com_purge_before_date  
285. mysql.open_table_definitions
286. mysql.threads_running  
287. mysql.com_release_savepoint  
288. mysql.com_show_collations  
289. mysql.innodb_row_lock_time  
290. mysql.performance_schema_thread_instances_lost  
291. mysql.performance_schema_mutex_classes_lost  
292. mysql.com_stmt_prepare  
293. mysql.innodb_data_written
294. mysql.com_update  
295. mysql.slave_retried_transactions 
296. mysql.innodb_data_fsyncs
297. mysql.com_create_db  
298. mysql.uptime_since_flush_status 
299. mysql.key_read_requests  
300. mysql.open_files
301. mysql.com_show_contributors  
302. mysql.innodb_page_size
303. mysql.com_rename_table  
304. mysql.prepared_stmt_count  
305. mysql.lock_system_memory  
306. mysql.file_system_memory  
307. mysql.innodb_lock_structs  
308. mysql.file_writes  
309. mysql.pending_chkp_writes  
310. mysql.queries_queued  
311. mysql.current_transactions  
312. mysql.innodb_lock_wait_secs  
313. mysql.file_reads  
314. mysql.pending_aio_sync_ios  
315. mysql.innodb_sem_wait_time_ms  
316. mysql.innodb_locked_tables  
317. mysql.locked_transactions  
318. mysql.read_views  
319. mysql.innodb_tables_in_use  
320. mysql.pending_aio_log_ios  
321. mysql.queries_inside  
322. mysql.active_transactions  
323. mysql.pending_buf_pool_flushes  
324. mysql.page_hash_memory  
325. mysql.pending_log_writes  
326. mysql.pending_ibuf_aio_reads  
327. mysql.log_writes  
328. mysql.innodb_sem_waits  
329. mysql.sorting_result  
330. mysql.reading_from_net  
331. mysql.freeing_items  
332. mysql.closing_tables  
333. mysql.preparing  
334. mysql.locked  
335. mysql.copying_to_tmp_table  
336. mysql.updating  
337. mysql.none  
338. mysql.statistics  
339. mysql.end  
340. mysql.sending_data  
341. mysql.init  
342. mysql.writing_to_net  
343. mysql.other  
344. mysql.login  
345. mysql.tmp_table_size 
346. mysql.query_cache_size  
347. mysql.binlog_stmt_cache_size 
348. mysql.innodb_log_file_size 
349. mysql.table_open_cache 
350. mysql.thread_concurrency 
351. mysql.query_cache_limit  
352. mysql.innodb_buffer_pool_size 
353. mysql.innodb_additional_mem_pool_size
354. mysql.thread_cache_size
355. mysql.innodb_concurrency_tickets  
356. mysql.innodb_log_buffer_size 
357. mysql.open_files_limit
358. mysql.innodb_io_capacity  
359. mysql.max_connections 
360. mysql.innodb_open_files
361. mysql.table_definition_cache 
362. mysql.read_buffer_size
363. mysql.join_buffer_size