SHARE
TWEET

MySQL global status - NEW server

a guest Apr 30th, 2019 8 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  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
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