SHARE
TWEET

MySQL global status - OLD server

a guest Apr 30th, 2019 7 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. # OLD server - global status
  2.  
  3. Variable_name   Value
  4. Aborted_clients 1789
  5. Aborted_connects    49096
  6. Binlog_cache_disk_use   0
  7. Binlog_cache_use    0
  8. Binlog_stmt_cache_disk_use  0
  9. Binlog_stmt_cache_use   0
  10. Bytes_received  566670473429
  11. Bytes_sent  1107217777271
  12. Com_admin_commands  12383331
  13. Com_assign_to_keycache  0
  14. Com_alter_db    0
  15. Com_alter_db_upgrade    0
  16. Com_alter_event 0
  17. Com_alter_function  0
  18. Com_alter_procedure 0
  19. Com_alter_server    0
  20. Com_alter_table 35898
  21. Com_alter_tablespace    0
  22. Com_analyze 0
  23. Com_begin   11
  24. Com_binlog  0
  25. Com_call_procedure  7
  26. Com_change_db   203168
  27. Com_change_master   0
  28. Com_check   0
  29. Com_checksum    0
  30. Com_commit  127
  31. Com_create_db   148
  32. Com_create_event    0
  33. Com_create_function 0
  34. Com_create_index    0
  35. Com_create_procedure    1
  36. Com_create_server   0
  37. Com_create_table    19845
  38. Com_create_trigger  0
  39. Com_create_udf  0
  40. Com_create_user 0
  41. Com_create_view 0
  42. Com_dealloc_sql 22
  43. Com_delete  20529670
  44. Com_delete_multi    0
  45. Com_do  2
  46. Com_drop_db 161
  47. Com_drop_event  0
  48. Com_drop_function   0
  49. Com_drop_index  0
  50. Com_drop_procedure  1
  51. Com_drop_server 0
  52. Com_drop_table  19636
  53. Com_drop_trigger    0
  54. Com_drop_user   63
  55. Com_drop_view   0
  56. Com_empty_query 5064
  57. Com_execute_sql 28
  58. Com_flush   3
  59. Com_grant   2
  60. Com_ha_close    0
  61. Com_ha_open 0
  62. Com_ha_read 0
  63. Com_help    0
  64. Com_insert  331113394
  65. Com_insert_select   209
  66. Com_install_plugin  0
  67. Com_kill    22
  68. Com_load    0
  69. Com_lock_tables 16177
  70. Com_optimize    0
  71. Com_preload_keys    0
  72. Com_prepare_sql 28
  73. Com_purge   0
  74. Com_purge_before_date   0
  75. Com_release_savepoint   0
  76. Com_rename_table    0
  77. Com_rename_user 0
  78. Com_repair  0
  79. Com_replace 0
  80. Com_replace_select  0
  81. Com_reset   0
  82. Com_resignal    0
  83. Com_revoke  2
  84. Com_revoke_all  0
  85. Com_rollback    73
  86. Com_rollback_to_savepoint   0
  87. Com_savepoint   0
  88. Com_select  561050889
  89. Com_set_option  1070715
  90. Com_signal  0
  91. Com_show_authors    0
  92. Com_show_binlog_events  0
  93. Com_show_binlogs    0
  94. Com_show_charsets   70
  95. Com_show_collations 1262
  96. Com_show_contributors   0
  97. Com_show_create_db  39
  98. Com_show_create_event   0
  99. Com_show_create_func    0
  100. Com_show_create_proc    0
  101. Com_show_create_table   57121
  102. Com_show_create_trigger 0
  103. Com_show_databases  272
  104. Com_show_engine_logs    0
  105. Com_show_engine_mutex   0
  106. Com_show_engine_status  0
  107. Com_show_events 50
  108. Com_show_errors 0
  109. Com_show_fields 152689
  110. Com_show_function_status    205
  111. Com_show_grants 68
  112. Com_show_keys   9227
  113. Com_show_master_status  0
  114. Com_show_open_tables    0
  115. Com_show_plugins    69
  116. Com_show_privileges 0
  117. Com_show_procedure_status   205
  118. Com_show_processlist    80459
  119. Com_show_profile    0
  120. Com_show_profiles   0
  121. Com_show_relaylog_events    0
  122. Com_show_slave_hosts    0
  123. Com_show_slave_status   17
  124. Com_show_status 396042
  125. Com_show_storage_engines    70
  126. Com_show_table_status   54432
  127. Com_show_tables 50203
  128. Com_show_triggers   52363
  129. Com_show_variables  2491
  130. Com_show_warnings   0
  131. Com_slave_start 0
  132. Com_slave_stop  0
  133. Com_stmt_close  28
  134. Com_stmt_execute    491
  135. Com_stmt_fetch  0
  136. Com_stmt_prepare    231
  137. Com_stmt_reprepare  0
  138. Com_stmt_reset  260
  139. Com_stmt_send_long_data 0
  140. Com_truncate    31
  141. Com_uninstall_plugin    0
  142. Com_unlock_tables   16217
  143. Com_update  20835727
  144. Com_update_multi    148
  145. Com_xa_commit   0
  146. Com_xa_end  0
  147. Com_xa_prepare  0
  148. Com_xa_recover  0
  149. Com_xa_rollback 0
  150. Com_xa_start    0
  151. Compression OFF
  152. Connections 319873
  153. Created_tmp_disk_tables 120535340
  154. Created_tmp_files   160876
  155. Created_tmp_tables  124452289
  156. Delayed_errors  0
  157. Delayed_insert_threads  0
  158. Delayed_writes  0
  159. Flush_commands  1
  160. Handler_commit  4301505
  161. Handler_delete  171109101
  162. Handler_discover    0
  163. Handler_prepare 0
  164. Handler_read_first  25552664
  165. Handler_read_key    91378937993
  166. Handler_read_last   7
  167. Handler_read_next   71700392745
  168. Handler_read_prev   4561
  169. Handler_read_rnd    45554313963
  170. Handler_read_rnd_next   78831246287
  171. Handler_rollback    156
  172. Handler_savepoint   0
  173. Handler_savepoint_rollback  0
  174. Handler_update  556546314
  175. Handler_write   46424751939
  176. Innodb_buffer_pool_pages_data   8114
  177. Innodb_buffer_pool_bytes_data   132939776
  178. Innodb_buffer_pool_pages_dirty  0
  179. Innodb_buffer_pool_bytes_dirty  0
  180. Innodb_buffer_pool_pages_flushed    2301451
  181. Innodb_buffer_pool_pages_free   6
  182. Innodb_buffer_pool_pages_misc   71
  183. Innodb_buffer_pool_pages_total  8191
  184. Innodb_buffer_pool_read_ahead_rnd   0
  185. Innodb_buffer_pool_read_ahead   1981
  186. Innodb_buffer_pool_read_ahead_evicted   243
  187. Innodb_buffer_pool_read_requests    666505982
  188. Innodb_buffer_pool_reads    146442
  189. Innodb_buffer_pool_wait_free    0
  190. Innodb_buffer_pool_write_requests   311901239
  191. Innodb_data_fsyncs  522084
  192. Innodb_data_pending_fsyncs  0
  193. Innodb_data_pending_reads   0
  194. Innodb_data_pending_writes  0
  195. Innodb_data_read    2615037952
  196. Innodb_data_reads   159485
  197. Innodb_data_writes  2773619
  198. Innodb_data_written 88101840384
  199. Innodb_dblwr_pages_written  2301451
  200. Innodb_dblwr_writes 73128
  201. Innodb_have_atomic_builtins ON
  202. Innodb_log_waits    0
  203. Innodb_log_write_requests   26503539
  204. Innodb_log_writes   331814
  205. Innodb_os_log_fsyncs    377418
  206. Innodb_os_log_pending_fsyncs    0
  207. Innodb_os_log_pending_writes    0
  208. Innodb_os_log_written   12664313856
  209. Innodb_page_size    16384
  210. Innodb_pages_created    539420
  211. Innodb_pages_read   159475
  212. Innodb_pages_written    2301451
  213. Innodb_row_lock_current_waits   0
  214. Innodb_row_lock_time    1343
  215. Innodb_row_lock_time_avg    33
  216. Innodb_row_lock_time_max    122
  217. Innodb_row_lock_waits   40
  218. Innodb_rows_deleted 204707
  219. Innodb_rows_inserted    67085621
  220. Innodb_rows_read    24735493
  221. Innodb_rows_updated 178564
  222. Innodb_truncated_status_writes  0
  223. Key_blocks_not_flushed  0
  224. Key_blocks_unused   13396
  225. Key_blocks_used 13396
  226. Key_read_requests   189328530139
  227. Key_reads   538805316
  228. Key_write_requests  1497846525
  229. Key_writes  1005896104
  230. Last_query_cost 0.000000
  231. Max_used_connections    152
  232. Not_flushed_delayed_rows    0
  233. Open_files  2
  234. Open_streams    0
  235. Open_table_definitions  400
  236. Open_tables 400
  237. Opened_files    482740888
  238. Opened_table_definitions    116249
  239. Opened_tables   147607
  240. Performance_schema_cond_classes_lost    0
  241. Performance_schema_cond_instances_lost  0
  242. Performance_schema_file_classes_lost    0
  243. Performance_schema_file_handles_lost    0
  244. Performance_schema_file_instances_lost  0
  245. Performance_schema_locker_lost  0
  246. Performance_schema_mutex_classes_lost   0
  247. Performance_schema_mutex_instances_lost 0
  248. Performance_schema_rwlock_classes_lost  0
  249. Performance_schema_rwlock_instances_lost    0
  250. Performance_schema_table_handles_lost   0
  251. Performance_schema_table_instances_lost 0
  252. Performance_schema_thread_classes_lost  0
  253. Performance_schema_thread_instances_lost    0
  254. Prepared_stmt_count 0
  255. Qcache_free_blocks  439
  256. Qcache_free_memory  854792
  257. Qcache_hits 14049391
  258. Qcache_inserts  560410771
  259. Qcache_lowmem_prunes    451738889
  260. Qcache_not_cached   766113
  261. Qcache_queries_in_cache 345
  262. Qcache_total_blocks 3381
  263. Queries 962477576
  264. Questions   949941546
  265. Rpl_status  AUTH_MASTER
  266. Select_full_join    1439
  267. Select_full_range_join  1
  268. Select_range    448760
  269. Select_range_check  1
  270. Select_scan 686972
  271. Slave_heartbeat_period  0.000
  272. Slave_open_temp_tables  0
  273. Slave_received_heartbeats   0
  274. Slave_retried_transactions  0
  275. Slave_running   OFF
  276. Slow_launch_threads 0
  277. Slow_queries    1582
  278. Sort_merge_passes   84831
  279. Sort_range  111649047
  280. Sort_rows   45651584623
  281. Sort_scan   122862046
  282. Ssl_accept_renegotiates 0
  283. Ssl_accepts 0
  284. Ssl_callback_cache_hits 0
  285. Ssl_cipher 
  286. Ssl_cipher_list
  287. Ssl_client_connects 0
  288. Ssl_connect_renegotiates    0
  289. Ssl_ctx_verify_depth    0
  290. Ssl_ctx_verify_mode 0
  291. Ssl_default_timeout 0
  292. Ssl_finished_accepts    0
  293. Ssl_finished_connects   0
  294. Ssl_session_cache_hits  0
  295. Ssl_session_cache_misses    0
  296. Ssl_session_cache_mode  NONE
  297. Ssl_session_cache_overflows 0
  298. Ssl_session_cache_size  0
  299. Ssl_session_cache_timeouts  0
  300. Ssl_sessions_reused 0
  301. Ssl_used_session_cache_entries  0
  302. Ssl_verify_depth    0
  303. Ssl_verify_mode 0
  304. Ssl_version
  305. Table_locks_immediate   1229496217
  306. Table_locks_waited  23
  307. Tc_log_max_pages_used   0
  308. Tc_log_page_size    0
  309. Tc_log_page_waits   0
  310. Threads_cached  4
  311. Threads_connected   15
  312. Threads_created 5521
  313. Threads_running 1
  314. Uptime  19627298
  315. Uptime_since_flush_status   19627298
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