Guest User

Innodb Metrics

a guest
Jul 23rd, 2020
29
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. adaptive_hash_pages_added : 0
  2. adaptive_hash_pages_removed : 0
  3. adaptive_hash_rows_added : 0
  4. adaptive_hash_rows_deleted_no_hash_entry : 0
  5. adaptive_hash_rows_removed : 0
  6. adaptive_hash_rows_updated : 0
  7. adaptive_hash_searches : 5477878
  8. adaptive_hash_searches_btree : 185307
  9. buffer_data_reads : 60724224
  10. buffer_data_written : 166877184
  11. buffer_flush_adaptive : 0
  12. buffer_flush_adaptive_avg_pass : 0
  13. buffer_flush_adaptive_avg_time_est : 0
  14. buffer_flush_adaptive_avg_time_slot : 0
  15. buffer_flush_adaptive_avg_time_thread : 0
  16. buffer_flush_adaptive_pages : 0
  17. buffer_flush_adaptive_total_pages : 0
  18. buffer_flush_avg_page_rate : 0
  19. buffer_flush_avg_pass : 0
  20. buffer_flush_avg_time : 0
  21. buffer_flush_background : 0
  22. buffer_flush_background_pages : 0
  23. buffer_flush_background_total_pages : 0
  24. buffer_flush_batches : 0
  25. buffer_flush_batch_num_scan : 0
  26. buffer_flush_batch_pages : 0
  27. buffer_flush_batch_scanned : 0
  28. buffer_flush_batch_scanned_per_call : 0
  29. buffer_flush_batch_total_pages : 0
  30. buffer_flush_lsn_avg_rate : 0
  31. buffer_flush_neighbor : 0
  32. buffer_flush_neighbor_pages : 0
  33. buffer_flush_neighbor_total_pages : 0
  34. buffer_flush_n_to_flush_by_age : 0
  35. buffer_flush_n_to_flush_requested : 0
  36. buffer_flush_pct_for_dirty : 0
  37. buffer_flush_pct_for_lsn : 0
  38. buffer_flush_sync : 0
  39. buffer_flush_sync_pages : 0
  40. buffer_flush_sync_total_pages : 0
  41. buffer_flush_sync_waits : 0
  42. buffer_LRU_batches_evict : 0
  43. buffer_LRU_batches_flush : 0
  44. buffer_LRU_batch_evict_pages : 0
  45. buffer_LRU_batch_evict_total_pages : 0
  46. buffer_LRU_batch_flush_avg_pass : 0
  47. buffer_LRU_batch_flush_avg_time_est : 0
  48. buffer_LRU_batch_flush_avg_time_slot : 0
  49. buffer_LRU_batch_flush_avg_time_thread : 0
  50. buffer_LRU_batch_flush_pages : 0
  51. buffer_LRU_batch_flush_total_pages : 0
  52. buffer_LRU_batch_num_scan : 0
  53. buffer_LRU_batch_scanned : 0
  54. buffer_LRU_batch_scanned_per_call : 0
  55. buffer_LRU_get_free_loops : 0
  56. buffer_LRU_get_free_search : 0
  57. buffer_LRU_get_free_waits : 0
  58. buffer_LRU_search_num_scan : 0
  59. buffer_LRU_search_scanned : 0
  60. buffer_LRU_search_scanned_per_call : 0
  61. buffer_LRU_single_flush_failure_count : 0
  62. buffer_LRU_single_flush_num_scan : 0
  63. buffer_LRU_single_flush_scanned : 0
  64. buffer_LRU_single_flush_scanned_per_call : 0
  65. buffer_LRU_unzip_search_num_scan : 0
  66. buffer_LRU_unzip_search_scanned : 0
  67. buffer_LRU_unzip_search_scanned_per_call : 0
  68. buffer_pages_created : 301
  69. buffer_pages_read : 3702
  70. buffer_pages_written : 4895
  71. buffer_page_read_blob : 0
  72. buffer_page_read_fsp_hdr : 0
  73. buffer_page_read_ibuf_bitmap : 0
  74. buffer_page_read_ibuf_free_list : 0
  75. buffer_page_read_index_ibuf_leaf : 0
  76. buffer_page_read_index_ibuf_non_leaf : 0
  77. buffer_page_read_index_inode : 0
  78. buffer_page_read_index_leaf : 0
  79. buffer_page_read_index_non_leaf : 0
  80. buffer_page_read_other : 0
  81. buffer_page_read_rseg_array : 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_on_log_no_waits : 0
  98. buffer_page_written_on_log_waits : 0
  99. buffer_page_written_on_log_wait_loops : 0
  100. buffer_page_written_other : 0
  101. buffer_page_written_rseg_array : 0
  102. buffer_page_written_system_page : 0
  103. buffer_page_written_trx_system : 0
  104. buffer_page_written_undo_log : 0
  105. buffer_page_written_xdes : 0
  106. buffer_page_written_zblob : 0
  107. buffer_page_written_zblob2 : 0
  108. buffer_pool_bytes_data : 55410688
  109. buffer_pool_bytes_dirty : 0
  110. buffer_pool_pages_data : 3382
  111. buffer_pool_pages_dirty : 0
  112. buffer_pool_pages_free : 1024
  113. buffer_pool_pages_misc : 202
  114. buffer_pool_pages_total : 4608
  115. buffer_pool_reads : 3086
  116. buffer_pool_read_ahead : 616
  117. buffer_pool_read_ahead_evicted : 0
  118. buffer_pool_read_requests : 16466948
  119. buffer_pool_size : 75497472
  120. buffer_pool_wait_free : 0
  121. buffer_pool_write_requests : 63071
  122. compression_pad_decrements : 0
  123. compression_pad_increments : 0
  124. compress_pages_compressed : 0
  125. compress_pages_decompressed : 0
  126. cpu_n : 0
  127. cpu_stime_abs : 0
  128. cpu_stime_pct : 0
  129. cpu_utime_abs : 0
  130. cpu_utime_pct : 0
  131. ddl_background_drop_tables : 0
  132. ddl_log_file_alter_table : 0
  133. ddl_online_create_index : 0
  134. ddl_pending_alter_table : 0
  135. ddl_sort_file_alter_table : 0
  136. dml_deletes : 265
  137. dml_inserts : 4798
  138. dml_reads : 0
  139. dml_updates : 7049
  140. file_num_open_files : 17
  141. ibuf_merges : 0
  142. ibuf_merges_delete : 0
  143. ibuf_merges_delete_mark : 0
  144. ibuf_merges_discard_delete : 0
  145. ibuf_merges_discard_delete_mark : 0
  146. ibuf_merges_discard_insert : 0
  147. ibuf_merges_insert : 0
  148. ibuf_size : 1
  149. icp_attempts : 0
  150. icp_match : 0
  151. icp_no_match : 0
  152. icp_out_of_range : 0
  153. index_page_discards : 0
  154. index_page_merge_attempts : 0
  155. index_page_merge_successful : 0
  156. index_page_reorg_attempts : 0
  157. index_page_reorg_successful : 0
  158. index_page_splits : 0
  159. innodb_activity_count : 6395
  160. innodb_background_drop_table_usec : 0
  161. innodb_dblwr_pages_written : 4708
  162. innodb_dblwr_writes : 149
  163. innodb_dict_lru_count : 0
  164. innodb_dict_lru_usec : 0
  165. innodb_ibuf_merge_usec : 0
  166. innodb_master_active_loops : 0
  167. innodb_master_idle_loops : 0
  168. innodb_master_purge_usec : 0
  169. innodb_master_thread_sleeps : 0
  170. innodb_mem_validate_usec : 0
  171. innodb_page_size : 16384
  172. innodb_rwlock_sx_os_waits : 0
  173. innodb_rwlock_sx_spin_rounds : 0
  174. innodb_rwlock_sx_spin_waits : 0
  175. innodb_rwlock_s_os_waits : 1
  176. innodb_rwlock_s_spin_rounds : 5
  177. innodb_rwlock_s_spin_waits : 4
  178. innodb_rwlock_x_os_waits : 0
  179. innodb_rwlock_x_spin_rounds : 20
  180. innodb_rwlock_x_spin_waits : 3
  181. lock_deadlocks : 0
  182. lock_rec_locks : 0
  183. lock_rec_lock_created : 0
  184. lock_rec_lock_removed : 0
  185. lock_rec_lock_requests : 0
  186. lock_rec_lock_waits : 0
  187. lock_row_lock_current_waits : 0
  188. lock_row_lock_time : 0
  189. lock_row_lock_time_avg : 0
  190. lock_row_lock_time_max : 0
  191. lock_row_lock_waits : 0
  192. lock_table_locks : 0
  193. lock_table_lock_created : 0
  194. lock_table_lock_removed : 0
  195. lock_table_lock_waits : 0
  196. lock_timeouts : 0
  197. log_checkpoints : 0
  198. log_concurrency_margin : 0
  199. log_flusher_no_waits : 0
  200. log_flusher_waits : 0
  201. log_flusher_wait_loops : 0
  202. log_flush_avg_time : 0
  203. log_flush_lsn_avg_rate : 0
  204. log_flush_max_time : 0
  205. log_flush_notifier_no_waits : 0
  206. log_flush_notifier_waits : 0
  207. log_flush_notifier_wait_loops : 0
  208. log_flush_total_time : 0
  209. log_free_space : 0
  210. log_full_block_writes : 0
  211. log_lsn_archived : 0
  212. log_lsn_buf_dirty_pages_added : 0
  213. log_lsn_buf_pool_oldest_approx : 0
  214. log_lsn_buf_pool_oldest_lwm : 0
  215. log_lsn_checkpoint_age : 0
  216. log_lsn_current : 0
  217. log_lsn_last_checkpoint : 0
  218. log_lsn_last_flush : 0
  219. log_max_modified_age_async : 0
  220. log_max_modified_age_sync : 0
  221. log_next_file : 0
  222. log_on_buffer_space_no_waits : 0
  223. log_on_buffer_space_waits : 0
  224. log_on_buffer_space_wait_loops : 0
  225. log_on_file_space_no_waits : 0
  226. log_on_file_space_waits : 0
  227. log_on_file_space_wait_loops : 0
  228. log_on_flush_no_waits : 0
  229. log_on_flush_waits : 0
  230. log_on_flush_wait_loops : 0
  231. log_on_recent_closed_wait_loops : 0
  232. log_on_recent_written_wait_loops : 0
  233. log_on_write_no_waits : 0
  234. log_on_write_waits : 0
  235. log_on_write_wait_loops : 0
  236. log_padded : 0
  237. log_partial_block_writes : 0
  238. log_waits : 0
  239. log_writer_no_waits : 0
  240. log_writer_on_archiver_waits : 0
  241. log_writer_on_file_space_waits : 0
  242. log_writer_waits : 0
  243. log_writer_wait_loops : 0
  244. log_writes : 10854
  245. log_write_notifier_no_waits : 0
  246. log_write_notifier_waits : 0
  247. log_write_notifier_wait_loops : 0
  248. log_write_requests : 36419
  249. log_write_to_file_requests_interval : 0
  250. metadata_table_handles_closed : 0
  251. metadata_table_handles_opened : 0
  252. metadata_table_reference_count : 0
  253. module_cpu : 0
  254. module_page_track : 0
  255. os_data_fsyncs : 10668
  256. os_data_reads : 3725
  257. os_data_writes : 16033
  258. os_log_bytes_written : 6671872
  259. os_log_fsyncs : 10170
  260. os_log_pending_fsyncs : 0
  261. os_log_pending_writes : 0
  262. os_pending_reads : 0
  263. os_pending_writes : 0
  264. page_track_checkpoint_partial_flush_request : 0
  265. page_track_full_block_writes : 0
  266. page_track_partial_block_writes : 0
  267. page_track_resets : 0
  268. purge_del_mark_records : 0
  269. purge_dml_delay_usec : 0
  270. purge_invoked : 0
  271. purge_resume_count : 0
  272. purge_stop_count : 0
  273. purge_truncate_history_count : 0
  274. purge_truncate_history_usec : 0
  275. purge_undo_log_pages : 0
  276. purge_upd_exist_or_extern_records : 0
  277. trx_active_transactions : 0
  278. trx_commits_insert_update : 0
  279. trx_nl_ro_commits : 0
  280. trx_on_log_no_waits : 0
  281. trx_on_log_waits : 0
  282. trx_on_log_wait_loops : 0
  283. trx_rollbacks : 0
  284. trx_rollbacks_savepoint : 0
  285. trx_rollback_active : 0
  286. trx_ro_commits : 0
  287. trx_rseg_current_size : 0
  288. trx_rseg_history_len : 36
  289. trx_rw_commits : 0
  290. trx_undo_slots_cached : 0
  291. trx_undo_slots_used : 0
  292. undo_truncate_count : 0
  293. undo_truncate_done_logging_count : 0
  294. undo_truncate_flush_count : 0
  295. undo_truncate_flush_usec : 0
  296. undo_truncate_start_logging_count : 0
  297. undo_truncate_sweep_count : 0
  298. undo_truncate_sweep_usec : 0
  299. undo_truncate_usec : 0
RAW Paste Data