Advertisement
rei4u2005

innodb metric 10 july 2019

Jul 9th, 2019
123
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 7.56 KB | None | 0 0
  1. "name" "count"
  2. "adaptive_hash_pages_added" "0"
  3. "adaptive_hash_pages_removed" "0"
  4. "adaptive_hash_rows_added" "0"
  5. "adaptive_hash_rows_deleted_no_hash_entry" "0"
  6. "adaptive_hash_rows_removed" "0"
  7. "adaptive_hash_rows_updated" "0"
  8. "adaptive_hash_searches" "21041537035"
  9. "adaptive_hash_searches_btree" "732295318"
  10. "buffer_data_reads" "2102727168"
  11. "buffer_data_written" "21478359040"
  12. "buffer_flush_adaptive" "0"
  13. "buffer_flush_adaptive_avg_pass" "0"
  14. "buffer_flush_adaptive_avg_time_est" "0"
  15. "buffer_flush_adaptive_avg_time_slot" "0"
  16. "buffer_flush_adaptive_avg_time_thread" "0"
  17. "buffer_flush_adaptive_pages" "0"
  18. "buffer_flush_adaptive_total_pages" "0"
  19. "buffer_flush_avg_page_rate" "0"
  20. "buffer_flush_avg_pass" "0"
  21. "buffer_flush_avg_time" "0"
  22. "buffer_flush_background" "0"
  23. "buffer_flush_background_pages" "0"
  24. "buffer_flush_background_total_pages" "0"
  25. "buffer_flush_batches" "0"
  26. "buffer_flush_batch_num_scan" "0"
  27. "buffer_flush_batch_pages" "0"
  28. "buffer_flush_batch_scanned" "0"
  29. "buffer_flush_batch_scanned_per_call" "0"
  30. "buffer_flush_batch_total_pages" "0"
  31. "buffer_flush_lsn_avg_rate" "0"
  32. "buffer_flush_neighbor" "0"
  33. "buffer_flush_neighbor_pages" "0"
  34. "buffer_flush_neighbor_total_pages" "0"
  35. "buffer_flush_n_to_flush_by_age" "0"
  36. "buffer_flush_n_to_flush_requested" "0"
  37. "buffer_flush_pct_for_dirty" "0"
  38. "buffer_flush_pct_for_lsn" "0"
  39. "buffer_flush_sync" "0"
  40. "buffer_flush_sync_pages" "0"
  41. "buffer_flush_sync_total_pages" "0"
  42. "buffer_flush_sync_waits" "0"
  43. "buffer_LRU_batches_evict" "0"
  44. "buffer_LRU_batches_flush" "0"
  45. "buffer_LRU_batch_evict_pages" "0"
  46. "buffer_LRU_batch_evict_total_pages" "0"
  47. "buffer_LRU_batch_flush_avg_pass" "0"
  48. "buffer_LRU_batch_flush_avg_time_est" "0"
  49. "buffer_LRU_batch_flush_avg_time_slot" "0"
  50. "buffer_LRU_batch_flush_avg_time_thread" "0"
  51. "buffer_LRU_batch_flush_pages" "0"
  52. "buffer_LRU_batch_flush_total_pages" "0"
  53. "buffer_LRU_batch_num_scan" "0"
  54. "buffer_LRU_batch_scanned" "0"
  55. "buffer_LRU_batch_scanned_per_call" "0"
  56. "buffer_LRU_get_free_loops" "0"
  57. "buffer_LRU_get_free_search" "0"
  58. "buffer_LRU_get_free_waits" "0"
  59. "buffer_LRU_search_num_scan" "0"
  60. "buffer_LRU_search_scanned" "0"
  61. "buffer_LRU_search_scanned_per_call" "0"
  62. "buffer_LRU_single_flush_failure_count" "0"
  63. "buffer_LRU_single_flush_num_scan" "0"
  64. "buffer_LRU_single_flush_scanned" "0"
  65. "buffer_LRU_single_flush_scanned_per_call" "0"
  66. "buffer_LRU_unzip_search_num_scan" "0"
  67. "buffer_LRU_unzip_search_scanned" "0"
  68. "buffer_LRU_unzip_search_scanned_per_call" "0"
  69. "buffer_pages_created" "49870"
  70. "buffer_pages_read" "128336"
  71. "buffer_pages_written" "1307534"
  72. "buffer_page_read_blob" "0"
  73. "buffer_page_read_fsp_hdr" "0"
  74. "buffer_page_read_ibuf_bitmap" "0"
  75. "buffer_page_read_ibuf_free_list" "0"
  76. "buffer_page_read_index_ibuf_leaf" "0"
  77. "buffer_page_read_index_ibuf_non_leaf" "0"
  78. "buffer_page_read_index_inode" "0"
  79. "buffer_page_read_index_leaf" "0"
  80. "buffer_page_read_index_non_leaf" "0"
  81. "buffer_page_read_other" "0"
  82. "buffer_page_read_system_page" "0"
  83. "buffer_page_read_trx_system" "0"
  84. "buffer_page_read_undo_log" "0"
  85. "buffer_page_read_xdes" "0"
  86. "buffer_page_read_zblob" "0"
  87. "buffer_page_read_zblob2" "0"
  88. "buffer_page_written_blob" "0"
  89. "buffer_page_written_fsp_hdr" "0"
  90. "buffer_page_written_ibuf_bitmap" "0"
  91. "buffer_page_written_ibuf_free_list" "0"
  92. "buffer_page_written_index_ibuf_leaf" "0"
  93. "buffer_page_written_index_ibuf_non_leaf" "0"
  94. "buffer_page_written_index_inode" "0"
  95. "buffer_page_written_index_leaf" "0"
  96. "buffer_page_written_index_non_leaf" "0"
  97. "buffer_page_written_other" "0"
  98. "buffer_page_written_system_page" "0"
  99. "buffer_page_written_trx_system" "0"
  100. "buffer_page_written_undo_log" "0"
  101. "buffer_page_written_xdes" "0"
  102. "buffer_page_written_zblob" "0"
  103. "buffer_page_written_zblob2" "0"
  104. "buffer_pool_bytes_data" "2919497728"
  105. "buffer_pool_bytes_dirty" "840581120"
  106. "buffer_pool_pages_data" "178192"
  107. "buffer_pool_pages_dirty" "51305"
  108. "buffer_pool_pages_free" "127797"
  109. "buffer_pool_pages_misc" "21651"
  110. "buffer_pool_pages_total" "327640"
  111. "buffer_pool_reads" "83088"
  112. "buffer_pool_read_ahead" "43393"
  113. "buffer_pool_read_ahead_evicted" "0"
  114. "buffer_pool_read_requests" "47910886218"
  115. "buffer_pool_size" "5368709120"
  116. "buffer_pool_wait_free" "0"
  117. "buffer_pool_write_requests" "215501609"
  118. "compression_pad_decrements" "0"
  119. "compression_pad_increments" "0"
  120. "compress_pages_compressed" "0"
  121. "compress_pages_decompressed" "0"
  122. "ddl_background_drop_indexes" "0"
  123. "ddl_background_drop_tables" "0"
  124. "ddl_log_file_alter_table" "0"
  125. "ddl_online_create_index" "0"
  126. "ddl_pending_alter_table" "0"
  127. "ddl_sort_file_alter_table" "0"
  128. "dml_deletes" "36059"
  129. "dml_inserts" "116871109"
  130. "dml_reads" "0"
  131. "dml_updates" "17302"
  132. "file_num_open_files" "2134"
  133. "ibuf_merges" "1916"
  134. "ibuf_merges_delete" "8"
  135. "ibuf_merges_delete_mark" "210"
  136. "ibuf_merges_discard_delete" "0"
  137. "ibuf_merges_discard_delete_mark" "0"
  138. "ibuf_merges_discard_insert" "0"
  139. "ibuf_merges_insert" "2047"
  140. "ibuf_size" "1"
  141. "icp_attempts" "0"
  142. "icp_match" "0"
  143. "icp_no_match" "0"
  144. "icp_out_of_range" "0"
  145. "index_page_discards" "0"
  146. "index_page_merge_attempts" "0"
  147. "index_page_merge_successful" "0"
  148. "index_page_reorg_attempts" "0"
  149. "index_page_reorg_successful" "0"
  150. "index_page_splits" "0"
  151. "innodb_activity_count" "316792"
  152. "innodb_background_drop_table_usec" "0"
  153. "innodb_checkpoint_usec" "0"
  154. "innodb_dblwr_pages_written" "0"
  155. "innodb_dblwr_writes" "0"
  156. "innodb_dict_lru_count" "0"
  157. "innodb_dict_lru_usec" "0"
  158. "innodb_ibuf_merge_usec" "0"
  159. "innodb_log_flush_usec" "0"
  160. "innodb_master_active_loops" "0"
  161. "innodb_master_idle_loops" "0"
  162. "innodb_master_purge_usec" "0"
  163. "innodb_master_thread_sleeps" "0"
  164. "innodb_mem_validate_usec" "0"
  165. "innodb_page_size" "16384"
  166. "innodb_rwlock_sx_os_waits" "36"
  167. "innodb_rwlock_sx_spin_rounds" "5257"
  168. "innodb_rwlock_sx_spin_waits" "781"
  169. "innodb_rwlock_s_os_waits" "5513"
  170. "innodb_rwlock_s_spin_rounds" "25598149"
  171. "innodb_rwlock_s_spin_waits" "0"
  172. "innodb_rwlock_x_os_waits" "483"
  173. "innodb_rwlock_x_spin_rounds" "1446225"
  174. "innodb_rwlock_x_spin_waits" "0"
  175. "lock_deadlocks" "0"
  176. "lock_rec_locks" "0"
  177. "lock_rec_lock_created" "0"
  178. "lock_rec_lock_removed" "0"
  179. "lock_rec_lock_requests" "0"
  180. "lock_rec_lock_waits" "0"
  181. "lock_row_lock_current_waits" "0"
  182. "lock_row_lock_time" "1712"
  183. "lock_row_lock_time_avg" "342"
  184. "lock_row_lock_time_max" "711"
  185. "lock_row_lock_waits" "5"
  186. "lock_table_locks" "0"
  187. "lock_table_lock_created" "0"
  188. "lock_table_lock_removed" "0"
  189. "lock_table_lock_waits" "0"
  190. "lock_timeouts" "0"
  191. "log_checkpoints" "0"
  192. "log_lsn_buf_pool_oldest" "0"
  193. "log_lsn_checkpoint_age" "0"
  194. "log_lsn_current" "0"
  195. "log_lsn_last_checkpoint" "0"
  196. "log_lsn_last_flush" "0"
  197. "log_max_modified_age_async" "0"
  198. "log_max_modified_age_sync" "0"
  199. "log_num_log_io" "0"
  200. "log_padded" "13793792"
  201. "log_pending_checkpoint_writes" "0"
  202. "log_pending_log_flushes" "0"
  203. "log_waits" "0"
  204. "log_writes" "22018"
  205. "log_write_requests" "72810"
  206. "metadata_table_handles_closed" "0"
  207. "metadata_table_handles_opened" "0"
  208. "metadata_table_reference_count" "0"
  209. "os_data_fsyncs" "69925"
  210. "os_data_reads" "130476"
  211. "os_data_writes" "1336341"
  212. "os_log_bytes_written" "58593280"
  213. "os_log_fsyncs" "26073"
  214. "os_log_pending_fsyncs" "0"
  215. "os_log_pending_writes" "0"
  216. "os_pending_reads" "0"
  217. "os_pending_writes" "0"
  218. "purge_del_mark_records" "0"
  219. "purge_dml_delay_usec" "0"
  220. "purge_invoked" "0"
  221. "purge_resume_count" "0"
  222. "purge_stop_count" "0"
  223. "purge_undo_log_pages" "0"
  224. "purge_upd_exist_or_extern_records" "0"
  225. "trx_active_transactions" "0"
  226. "trx_commits_insert_update" "0"
  227. "trx_nl_ro_commits" "0"
  228. "trx_rollbacks" "0"
  229. "trx_rollbacks_savepoint" "0"
  230. "trx_rollback_active" "0"
  231. "trx_ro_commits" "0"
  232. "trx_rseg_current_size" "0"
  233. "trx_rseg_history_len" "3"
  234. "trx_rw_commits" "0"
  235. "trx_undo_slots_cached" "0"
  236. "trx_undo_slots_used" "0"
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement