API tools faq
paste
Advertisement
Guest User

MySQL global status - OLD server

a guest
Apr 30th, 2019
118
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 7.55 KB | None | 0 0
raw download clone embed print report
  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
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
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
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!