API tools faq
paste
Advertisement
Guest User

MySQL global status - NEW server

a guest
Apr 30th, 2019
129
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 8.76 KB | None | 0 0
raw download clone embed print report
  1. # Global status - NEW server
  2.  
  3. Variable_name Value
  4. Aborted_clients 4
  5. Aborted_connects 10
  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 88293058
  11. Bytes_sent 1153284065
  12. Com_admin_commands 5
  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_instance 0
  19. Com_alter_procedure 0
  20. Com_alter_server 0
  21. Com_alter_table 0
  22. Com_alter_tablespace 0
  23. Com_alter_user 0
  24. Com_analyze 0
  25. Com_begin 5926
  26. Com_binlog 0
  27. Com_call_procedure 0
  28. Com_change_db 6742
  29. Com_change_master 0
  30. Com_change_repl_filter 0
  31. Com_check 0
  32. Com_checksum 0
  33. Com_commit 2747
  34. Com_create_db 1
  35. Com_create_event 0
  36. Com_create_function 0
  37. Com_create_index 0
  38. Com_create_procedure 0
  39. Com_create_server 0
  40. Com_create_table 0
  41. Com_create_trigger 0
  42. Com_create_udf 0
  43. Com_create_user 0
  44. Com_create_view 0
  45. Com_dealloc_sql 0
  46. Com_delete 3491
  47. Com_delete_multi 0
  48. Com_do 0
  49. Com_drop_db 0
  50. Com_drop_event 0
  51. Com_drop_function 0
  52. Com_drop_index 0
  53. Com_drop_procedure 0
  54. Com_drop_server 0
  55. Com_drop_table 0
  56. Com_drop_trigger 0
  57. Com_drop_user 0
  58. Com_drop_view 0
  59. Com_empty_query 0
  60. Com_execute_sql 0
  61. Com_explain_other 0
  62. Com_flush 1
  63. Com_get_diagnostics 0
  64. Com_grant 2
  65. Com_ha_close 0
  66. Com_ha_open 0
  67. Com_ha_read 0
  68. Com_help 0
  69. Com_insert 228
  70. Com_insert_select 0
  71. Com_install_plugin 0
  72. Com_kill 0
  73. Com_load 0
  74. Com_lock_tables 15
  75. Com_optimize 0
  76. Com_preload_keys 0
  77. Com_prepare_sql 0
  78. Com_purge 0
  79. Com_purge_before_date 0
  80. Com_release_savepoint 0
  81. Com_rename_table 0
  82. Com_rename_user 0
  83. Com_repair 0
  84. Com_replace 10249
  85. Com_replace_select 0
  86. Com_reset 0
  87. Com_resignal 0
  88. Com_revoke 0
  89. Com_revoke_all 0
  90. Com_rollback 0
  91. Com_rollback_to_savepoint 0
  92. Com_savepoint 0
  93. Com_select 535192
  94. Com_set_option 14856
  95. Com_signal 0
  96. Com_show_binlog_events 0
  97. Com_show_binlogs 0
  98. Com_show_charsets 2
  99. Com_show_collations 2
  100. Com_show_create_db 0
  101. Com_show_create_event 0
  102. Com_show_create_func 0
  103. Com_show_create_proc 0
  104. Com_show_create_table 94
  105. Com_show_create_trigger 0
  106. Com_show_databases 6
  107. Com_show_engine_logs 0
  108. Com_show_engine_mutex 0
  109. Com_show_engine_status 0
  110. Com_show_events 0
  111. Com_show_errors 0
  112. Com_show_fields 656
  113. Com_show_function_code 0
  114. Com_show_function_status 0
  115. Com_show_grants 2
  116. Com_show_keys 0
  117. Com_show_master_status 0
  118. Com_show_open_tables 0
  119. Com_show_plugins 0
  120. Com_show_privileges 0
  121. Com_show_procedure_code 0
  122. Com_show_procedure_status 0
  123. Com_show_processlist 0
  124. Com_show_profile 0
  125. Com_show_profiles 0
  126. Com_show_relaylog_events 0
  127. Com_show_slave_hosts 0
  128. Com_show_slave_status 0
  129. Com_show_status 290
  130. Com_show_storage_engines 0
  131. Com_show_table_status 17
  132. Com_show_tables 27
  133. Com_show_triggers 0
  134. Com_show_variables 13
  135. Com_show_warnings 259
  136. Com_show_create_user 0
  137. Com_shutdown 0
  138. Com_slave_start 0
  139. Com_slave_stop 0
  140. Com_group_replication_start 0
  141. Com_group_replication_stop 0
  142. Com_stmt_execute 0
  143. Com_stmt_close 0
  144. Com_stmt_fetch 0
  145. Com_stmt_prepare 0
  146. Com_stmt_reset 0
  147. Com_stmt_send_long_data 0
  148. Com_truncate 0
  149. Com_uninstall_plugin 0
  150. Com_unlock_tables 15
  151. Com_update 537
  152. Com_update_multi 14
  153. Com_xa_commit 0
  154. Com_xa_end 0
  155. Com_xa_prepare 0
  156. Com_xa_recover 0
  157. Com_xa_rollback 0
  158. Com_xa_start 0
  159. Com_stmt_reprepare 0
  160. Connection_errors_accept 0
  161. Connection_errors_internal 0
  162. Connection_errors_max_connections 0
  163. Connection_errors_peer_address 0
  164. Connection_errors_select 0
  165. Connection_errors_tcpwrap 0
  166. Connections 7039
  167. Created_tmp_disk_tables 11789
  168. Created_tmp_files 42
  169. Created_tmp_tables 12397
  170. Delayed_errors 0
  171. Delayed_insert_threads 0
  172. Delayed_writes 0
  173. Flush_commands 1
  174. Handler_commit 7252
  175. Handler_delete 5527
  176. Handler_discover 0
  177. Handler_external_lock 1185895
  178. Handler_mrr_init 0
  179. Handler_prepare 0
  180. Handler_read_first 23902
  181. Handler_read_key 1560379
  182. Handler_read_last 0
  183. Handler_read_next 848763
  184. Handler_read_prev 880
  185. Handler_read_rnd 416651
  186. Handler_read_rnd_next 527918
  187. Handler_rollback 0
  188. Handler_savepoint 0
  189. Handler_savepoint_rollback 0
  190. Handler_update 5604
  191. Handler_write 35491
  192. Innodb_buffer_pool_dump_status Dumping of buffer pool not started
  193. Innodb_buffer_pool_load_status Buffer pool(s) load completed at 190430 6:14:45
  194. Innodb_buffer_pool_resize_status
  195. Innodb_buffer_pool_pages_data 2043
  196. Innodb_buffer_pool_bytes_data 33472512
  197. Innodb_buffer_pool_pages_dirty 0
  198. Innodb_buffer_pool_bytes_dirty 0
  199. Innodb_buffer_pool_pages_flushed 5203
  200. Innodb_buffer_pool_pages_free 6137
  201. Innodb_buffer_pool_pages_misc 12
  202. Innodb_buffer_pool_pages_total 8192
  203. Innodb_buffer_pool_read_ahead_rnd 0
  204. Innodb_buffer_pool_read_ahead 0
  205. Innodb_buffer_pool_read_ahead_evicted 0
  206. Innodb_buffer_pool_read_requests 2115416
  207. Innodb_buffer_pool_reads 1475
  208. Innodb_buffer_pool_wait_free 0
  209. Innodb_buffer_pool_write_requests 617029
  210. Innodb_data_fsyncs 2379
  211. Innodb_data_pending_fsyncs 0
  212. Innodb_data_pending_reads 0
  213. Innodb_data_pending_writes 0
  214. Innodb_data_read 24236544
  215. Innodb_data_reads 1580
  216. Innodb_data_writes 7102
  217. Innodb_data_written 136910848
  218. Innodb_dblwr_pages_written 2952
  219. Innodb_dblwr_writes 222
  220. Innodb_log_waits 0
  221. Innodb_log_write_requests 4194
  222. Innodb_log_writes 1174
  223. Innodb_os_log_fsyncs 1591
  224. Innodb_os_log_pending_fsyncs 0
  225. Innodb_os_log_pending_writes 0
  226. Innodb_os_log_written 3085824
  227. Innodb_page_size 16384
  228. Innodb_pages_created 569
  229. Innodb_pages_read 1474
  230. Innodb_pages_written 5203
  231. Innodb_row_lock_current_waits 0
  232. Innodb_row_lock_time 0
  233. Innodb_row_lock_time_avg 0
  234. Innodb_row_lock_time_max 0
  235. Innodb_row_lock_waits 0
  236. Innodb_rows_deleted 354
  237. Innodb_rows_inserted 358750
  238. Innodb_rows_read 1033296
  239. Innodb_rows_updated 431
  240. Innodb_num_open_files 97
  241. Innodb_truncated_status_writes 0
  242. Innodb_available_undo_logs 128
  243. Key_blocks_not_flushed 0
  244. Key_blocks_unused 0
  245. Key_blocks_used 13396
  246. Key_read_requests 8733977
  247. Key_reads 22578
  248. Key_write_requests 44621
  249. Key_writes 33184
  250. Locked_connects 0
  251. Max_execution_time_exceeded 0
  252. Max_execution_time_set 0
  253. Max_execution_time_set_failed 0
  254. Max_used_connections 21
  255. Max_used_connections_time 2019-04-30 15:00:11
  256. Not_flushed_delayed_rows 0
  257. Ongoing_anonymous_transaction_count 0
  258. Open_files 794
  259. Open_streams 0
  260. Open_table_definitions 473
  261. Open_tables 1223
  262. Opened_files 1664
  263. Opened_table_definitions 473
  264. Opened_tables 1523
  265. Performance_schema_accounts_lost 0
  266. Performance_schema_cond_classes_lost 0
  267. Performance_schema_cond_instances_lost 0
  268. Performance_schema_digest_lost 0
  269. Performance_schema_file_classes_lost 0
  270. Performance_schema_file_handles_lost 0
  271. Performance_schema_file_instances_lost 0
  272. Performance_schema_hosts_lost 0
  273. Performance_schema_index_stat_lost 0
  274. Performance_schema_locker_lost 0
  275. Performance_schema_memory_classes_lost 0
  276. Performance_schema_metadata_lock_lost 0
  277. Performance_schema_mutex_classes_lost 0
  278. Performance_schema_mutex_instances_lost 0
  279. Performance_schema_nested_statement_lost 0
  280. Performance_schema_prepared_statements_lost 0
  281. Performance_schema_program_lost 0
  282. Performance_schema_rwlock_classes_lost 0
  283. Performance_schema_rwlock_instances_lost 0
  284. Performance_schema_session_connect_attrs_lost 0
  285. Performance_schema_socket_classes_lost 0
  286. Performance_schema_socket_instances_lost 0
  287. Performance_schema_stage_classes_lost 0
  288. Performance_schema_statement_classes_lost 0
  289. Performance_schema_table_handles_lost 0
  290. Performance_schema_table_instances_lost 0
  291. Performance_schema_table_lock_stat_lost 0
  292. Performance_schema_thread_classes_lost 0
  293. Performance_schema_thread_instances_lost 0
  294. Performance_schema_users_lost 0
  295. Prepared_stmt_count 0
  296. Qcache_free_blocks 1
  297. Qcache_free_memory 16760152
  298. Qcache_hits 0
  299. Qcache_inserts 0
  300. Qcache_lowmem_prunes 0
  301. Qcache_not_cached 535136
  302. Qcache_queries_in_cache 0
  303. Qcache_total_blocks 1
  304. Queries 588400
  305. Questions 588106
  306. Select_full_join 94
  307. Select_full_range_join 0
  308. Select_range 5587
  309. Select_range_check 153
  310. Select_scan 3028
  311. Slave_open_temp_tables 0
  312. Slow_launch_threads 0
  313. Slow_queries 0
  314. Sort_merge_passes 36
  315. Sort_range 1165
  316. Sort_rows 411999
  317. Sort_scan 12115
  318. Ssl_accept_renegotiates 0
  319. Ssl_accepts 0
  320. Ssl_callback_cache_hits 0
  321. Ssl_cipher
  322. Ssl_cipher_list
  323. Ssl_client_connects 0
  324. Ssl_connect_renegotiates 0
  325. Ssl_ctx_verify_depth 0
  326. Ssl_ctx_verify_mode 0
  327. Ssl_default_timeout 0
  328. Ssl_finished_accepts 0
  329. Ssl_finished_connects 0
  330. Ssl_server_not_after
  331. Ssl_server_not_before
  332. Ssl_session_cache_hits 0
  333. Ssl_session_cache_misses 0
  334. Ssl_session_cache_mode NONE
  335. Ssl_session_cache_overflows 0
  336. Ssl_session_cache_size 0
  337. Ssl_session_cache_timeouts 0
  338. Ssl_sessions_reused 0
  339. Ssl_used_session_cache_entries 0
  340. Ssl_verify_depth 0
  341. Ssl_verify_mode 0
  342. Ssl_version
  343. Table_locks_immediate 581502
  344. Table_locks_waited 32
  345. Table_open_cache_hits 592192
  346. Table_open_cache_misses 1523
  347. Table_open_cache_overflows 293
  348. Tc_log_max_pages_used 0
  349. Tc_log_page_size 0
  350. Tc_log_page_waits 0
  351. Threads_cached 6
  352. Threads_connected 13
  353. Threads_created 24
  354. Threads_running 1
  355. Uptime 46036
  356. Uptime_since_flush_status 46036
  357. validate_password_dictionary_file_last_parsed 2019-04-30 06:14:45
  358. validate_password_dictionary_file_words_count 0
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!