Guest User

MySQL global status - OLD server

a guest
Apr 30th, 2019
27
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