SHARE
TWEET

global stat dump

a guest Nov 22nd, 2017 11 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. Aborted_clients 98
  2. Aborted_connects    2
  3. Binlog_cache_disk_use   45048
  4. Binlog_cache_use    3570737
  5. Binlog_stmt_cache_disk_use  0
  6. Binlog_stmt_cache_use   288432
  7. Bytes_received  4038760136
  8. Bytes_sent  43422409306
  9. Com_admin_commands  18388
  10. Com_assign_to_keycache  0
  11. Com_alter_db    0
  12. Com_alter_db_upgrade    0
  13. Com_alter_event 0
  14. Com_alter_function  0
  15. Com_alter_instance  0
  16. Com_alter_procedure 0
  17. Com_alter_server    0
  18. Com_alter_table 1468
  19. Com_alter_tablespace    0
  20. Com_alter_user  0
  21. Com_analyze 0
  22. Com_begin   0
  23. Com_binlog  0
  24. Com_call_procedure  0
  25. Com_change_db   27
  26. Com_change_master   0
  27. Com_change_repl_filter  0
  28. Com_check   0
  29. Com_checksum    0
  30. Com_commit  5
  31. Com_create_db   0
  32. Com_create_event    0
  33. Com_create_function 0
  34. Com_create_index    0
  35. Com_create_procedure    0
  36. Com_create_server   0
  37. Com_create_table    892
  38. Com_create_trigger  0
  39. Com_create_udf  0
  40. Com_create_user 0
  41. Com_create_view 0
  42. Com_dealloc_sql 0
  43. Com_delete  40843
  44. Com_delete_multi    0
  45. Com_do  0
  46. Com_drop_db 0
  47. Com_drop_event  0
  48. Com_drop_function   0
  49. Com_drop_index  0
  50. Com_drop_procedure  0
  51. Com_drop_server 0
  52. Com_drop_table  0
  53. Com_drop_trigger    0
  54. Com_drop_user   0
  55. Com_drop_view   0
  56. Com_empty_query 0
  57. Com_execute_sql 0
  58. Com_explain_other   0
  59. Com_flush   0
  60. Com_get_diagnostics 0
  61. Com_grant   0
  62. Com_ha_close    0
  63. Com_ha_open 0
  64. Com_ha_read 0
  65. Com_help    20
  66. Com_insert  995438
  67. Com_insert_select   365886
  68. Com_install_plugin  0
  69. Com_kill    0
  70. Com_load    0
  71. Com_lock_tables 0
  72. Com_optimize    0
  73. Com_preload_keys    0
  74. Com_prepare_sql 0
  75. Com_purge   0
  76. Com_purge_before_date   2
  77. Com_release_savepoint   0
  78. Com_rename_table    0
  79. Com_rename_user 0
  80. Com_repair  0
  81. Com_replace 200
  82. Com_replace_select  0
  83. Com_reset   0
  84. Com_resignal    0
  85. Com_revoke  0
  86. Com_revoke_all  0
  87. Com_rollback    0
  88. Com_rollback_to_savepoint   0
  89. Com_savepoint   0
  90. Com_select  7925385
  91. Com_set_option  5218873
  92. Com_signal  0
  93. Com_show_binlog_events  0
  94. Com_show_binlogs    0
  95. Com_show_charsets   1
  96. Com_show_collations 1
  97. Com_show_create_db  0
  98. Com_show_create_event   0
  99. Com_show_create_func    0
  100. Com_show_create_proc    0
  101. Com_show_create_table   19
  102. Com_show_create_trigger 0
  103. Com_show_databases  16
  104. Com_show_engine_logs    0
  105. Com_show_engine_mutex   0
  106. Com_show_engine_status  6179
  107. Com_show_events 0
  108. Com_show_errors 0
  109. Com_show_fields 11402
  110. Com_show_function_code  0
  111. Com_show_function_status    2
  112. Com_show_grants 0
  113. Com_show_keys   635
  114. Com_show_master_status  4
  115. Com_show_open_tables    0
  116. Com_show_plugins    0
  117. Com_show_privileges 0
  118. Com_show_procedure_code 0
  119. Com_show_procedure_status   2
  120. Com_show_processlist    0
  121. Com_show_profile    0
  122. Com_show_profiles   0
  123. Com_show_relaylog_events    0
  124. Com_show_slave_hosts    0
  125. Com_show_slave_status   6165
  126. Com_show_status 18660
  127. Com_show_storage_engines    1
  128. Com_show_table_status   0
  129. Com_show_tables 15
  130. Com_show_triggers   0
  131. Com_show_variables  103567
  132. Com_show_warnings   1
  133. Com_show_create_user    0
  134. Com_shutdown    0
  135. Com_slave_start 0
  136. Com_slave_stop  0
  137. Com_group_replication_start 0
  138. Com_group_replication_stop  0
  139. Com_stmt_execute    22
  140. Com_stmt_close  22
  141. Com_stmt_fetch  0
  142. Com_stmt_prepare    22
  143. Com_stmt_reset  0
  144. Com_stmt_send_long_data 0
  145. Com_truncate    102346
  146. Com_uninstall_plugin    0
  147. Com_unlock_tables   0
  148. Com_update  5001767
  149. Com_update_multi    0
  150. Com_xa_commit   0
  151. Com_xa_end  0
  152. Com_xa_prepare  0
  153. Com_xa_recover  0
  154. Com_xa_rollback 0
  155. Com_xa_start    0
  156. Com_stmt_reprepare  0
  157. Connection_errors_accept    0
  158. Connection_errors_internal  0
  159. Connection_errors_max_connections   0
  160. Connection_errors_peer_address  0
  161. Connection_errors_select    0
  162. Connection_errors_tcpwrap   0
  163. Connections 3013893
  164. Created_tmp_disk_tables 34750
  165. Created_tmp_files   17266
  166. Created_tmp_tables  224474
  167. Delayed_errors  0
  168. Delayed_insert_threads  0
  169. Delayed_writes  0
  170. Flush_commands  1
  171. Handler_commit  17832686
  172. Handler_delete  41600
  173. Handler_discover    0
  174. Handler_external_lock   30573445
  175. Handler_mrr_init    0
  176. Handler_prepare 7141504
  177. Handler_read_first  3955855
  178. Handler_read_key    739193984
  179. Handler_read_last   12958
  180. Handler_read_next   25988435486
  181. Handler_read_prev   147061784
  182. Handler_read_rnd    93043905
  183. Handler_read_rnd_next   16348394592
  184. Handler_rollback    145
  185. Handler_savepoint   0
  186. Handler_savepoint_rollback  0
  187. Handler_update  41347738
  188. Handler_write   218511584
  189. Innodb_buffer_pool_dump_status  Dumping of buffer pool not started
  190. Innodb_buffer_pool_load_status  Buffer pool(s) load completed at 171120 21:36:34
  191. Innodb_buffer_pool_resize_status   
  192. Innodb_buffer_pool_pages_data   805540
  193. Innodb_buffer_pool_bytes_data   13197967360
  194. Innodb_buffer_pool_pages_dirty  14932
  195. Innodb_buffer_pool_bytes_dirty  244645888
  196. Innodb_buffer_pool_pages_flushed    7544401
  197. Innodb_buffer_pool_pages_free   1655598
  198. Innodb_buffer_pool_pages_misc   28926
  199. Innodb_buffer_pool_pages_total  2490064
  200. Innodb_buffer_pool_read_ahead_rnd   0
  201. Innodb_buffer_pool_read_ahead   158478
  202. Innodb_buffer_pool_read_ahead_evicted   0
  203. Innodb_buffer_pool_read_requests    13774678796
  204. Innodb_buffer_pool_reads    608728
  205. Innodb_buffer_pool_wait_free    0
  206. Innodb_buffer_pool_write_requests   662336905
  207. Innodb_data_fsyncs  5486422
  208. Innodb_data_pending_fsyncs  0
  209. Innodb_data_pending_reads   0
  210. Innodb_data_pending_writes  0
  211. Innodb_data_read    12771103232
  212. Innodb_data_reads   849072
  213. Innodb_data_writes  12523588
  214. Innodb_data_written 275618656768
  215. Innodb_dblwr_pages_written  6716525
  216. Innodb_dblwr_writes 309065
  217. Innodb_log_waits    0
  218. Innodb_log_write_requests   78202542
  219. Innodb_log_writes   4209653
  220. Innodb_os_log_fsyncs    4219258
  221. Innodb_os_log_pending_fsyncs    0
  222. Innodb_os_log_pending_writes    0
  223. Innodb_os_log_written   41944738816
  224. Innodb_page_size    16384
  225. Innodb_pages_created    2089039
  226. Innodb_pages_read   779482
  227. Innodb_pages_written    7546865
  228. Innodb_row_lock_current_waits   0
  229. Innodb_row_lock_time    199078
  230. Innodb_row_lock_time_avg    11
  231. Innodb_row_lock_time_max    3952
  232. Innodb_row_lock_waits   17412
  233. Innodb_rows_deleted 41755
  234. Innodb_rows_inserted    164558426
  235. Innodb_rows_read    42876006525
  236. Innodb_rows_updated 8703662
  237. Innodb_num_open_files   2000
  238. Innodb_truncated_status_writes  0
  239. Innodb_available_undo_logs  128
  240. Key_blocks_not_flushed  0
  241. Key_blocks_unused   6697
  242. Key_blocks_used 4
  243. Key_read_requests   183748
  244. Key_reads   8
  245. Key_write_requests  0
  246. Key_writes  0
  247. Locked_connects 0
  248. Max_execution_time_exceeded 0
  249. Max_execution_time_set  0
  250. Max_execution_time_set_failed   0
  251. Max_used_connections    62
  252. Max_used_connections_time   2017-11-22 00:36:33
  253. Not_flushed_delayed_rows    0
  254. Ongoing_anonymous_transaction_count 0
  255. Open_files  9
  256. Open_streams    0
  257. Open_table_definitions  1400
  258. Open_tables 2000
  259. Opened_files    18282162
  260. Opened_table_definitions    17779744
  261. Opened_tables   1039342
  262. Performance_schema_accounts_lost    0
  263. Performance_schema_cond_classes_lost    0
  264. Performance_schema_cond_instances_lost  0
  265. Performance_schema_digest_lost  0
  266. Performance_schema_file_classes_lost    0
  267. Performance_schema_file_handles_lost    0
  268. Performance_schema_file_instances_lost  0
  269. Performance_schema_hosts_lost   0
  270. Performance_schema_index_stat_lost  0
  271. Performance_schema_locker_lost  0
  272. Performance_schema_memory_classes_lost  0
  273. Performance_schema_metadata_lock_lost   0
  274. Performance_schema_mutex_classes_lost   0
  275. Performance_schema_mutex_instances_lost 0
  276. Performance_schema_nested_statement_lost    0
  277. Performance_schema_prepared_statements_lost 0
  278. Performance_schema_program_lost 0
  279. Performance_schema_rwlock_classes_lost  0
  280. Performance_schema_rwlock_instances_lost    0
  281. Performance_schema_session_connect_attrs_lost   0
  282. Performance_schema_socket_classes_lost  0
  283. Performance_schema_socket_instances_lost    0
  284. Performance_schema_stage_classes_lost   0
  285. Performance_schema_statement_classes_lost   0
  286. Performance_schema_table_handles_lost   0
  287. Performance_schema_table_instances_lost 0
  288. Performance_schema_table_lock_stat_lost 0
  289. Performance_schema_thread_classes_lost  0
  290. Performance_schema_thread_instances_lost    0
  291. Performance_schema_users_lost   0
  292. Prepared_stmt_count 0
  293. Qcache_free_blocks  1
  294. Qcache_free_memory  1031832
  295. Qcache_hits 0
  296. Qcache_inserts  0
  297. Qcache_lowmem_prunes    0
  298. Qcache_not_cached   7922540
  299. Qcache_queries_in_cache 0
  300. Qcache_total_blocks 1
  301. Queries 22832048
  302. Questions   22813453
  303. Rpl_semi_sync_master_clients    1
  304. Rpl_semi_sync_master_estimated_slave_lag    10845
  305. Rpl_semi_sync_master_net_avg_wait_time  0
  306. Rpl_semi_sync_master_net_wait_time  0
  307. Rpl_semi_sync_master_net_waits  3851445
  308. Rpl_semi_sync_master_no_times   3
  309. Rpl_semi_sync_master_no_tx  4213
  310. Rpl_semi_sync_master_status ON
  311. Rpl_semi_sync_master_timefunc_failures  0
  312. Rpl_semi_sync_master_tx_avg_wait_time   1062
  313. Rpl_semi_sync_master_tx_wait_time   4042116730
  314. Rpl_semi_sync_master_tx_waits   3806064
  315. Rpl_semi_sync_master_wait_pos_backtraverse  0
  316. Rpl_semi_sync_master_wait_sessions  0
  317. Rpl_semi_sync_master_yes_tx 3812496
  318. Rpl_semi_sync_slave_status  OFF
  319. Select_full_join    1217
  320. Select_full_range_join  0
  321. Select_range    52085
  322. Select_range_check  0
  323. Select_scan 3585354
  324. Slave_open_temp_tables  0
  325. Slow_launch_threads 0
  326. Slow_queries    649
  327. Sort_merge_passes   14215
  328. Sort_range  72012
  329. Sort_rows   42582001
  330. Sort_scan   206124
  331. Ssl_accept_renegotiates 0
  332. Ssl_accepts 0
  333. Ssl_callback_cache_hits 0
  334. Ssl_cipher  AES256-SHA
  335. Ssl_cipher_list ECDHE-ECDSA-AES128-GCM-SHA256:ECDHE-RSA-AES128-GCM-SHA256:ECDHE-ECDSA-AES128-SHA:ECDHE-RSA-AES128-SHA:ECDHE-ECDSA-AES256-SHA:ECDHE-RSA-AES256-SHA:AES128-GCM-SHA256:AES128-SHA:AES256-SHA:DES-CBC3-SHA
  336. Ssl_client_connects 0
  337. Ssl_connect_renegotiates    0
  338. Ssl_ctx_verify_depth    18446744073709551615
  339. Ssl_ctx_verify_mode 1
  340. Ssl_default_timeout 7200
  341. Ssl_finished_accepts    0
  342. Ssl_finished_connects   0
  343. Ssl_server_not_after    Dec 25 00:15:58 2018 GMT
  344. Ssl_server_not_before   Dec 25 00:14:58 2016 GMT
  345. Ssl_session_cache_hits  0
  346. Ssl_session_cache_misses    0
  347. Ssl_session_cache_mode  SERVER
  348. Ssl_session_cache_overflows 0
  349. Ssl_session_cache_size  128
  350. Ssl_session_cache_timeouts  0
  351. Ssl_sessions_reused 0
  352. Ssl_used_session_cache_entries  11
  353. Ssl_verify_depth    18446744073709551615
  354. Ssl_verify_mode 1
  355. Ssl_version TLSv1.1
  356. Table_locks_immediate   405400
  357. Table_locks_waited  1
  358. Table_open_cache_hits   14250465
  359. Table_open_cache_misses 1039342
  360. Table_open_cache_overflows  929932
  361. Tc_log_max_pages_used   0
  362. Tc_log_page_size    0
  363. Tc_log_page_waits   0
  364. Threads_cached  43
  365. Threads_connected   13
  366. Threads_created 144
  367. Threads_running 2
  368. Uptime  184941
  369. Uptime_since_flush_status   184941
RAW Paste Data
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy. OK, I Understand
Top