API tools faq
paste
mahmoodn

mysql-status

mahmoodn
Jul 10th, 2020
403
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 9.45 KB | None | 0 0
raw download clone embed print report
  1. Variable_name Value
  2. Aborted_clients 1
  3. Aborted_connects 10054
  4. Binlog_cache_disk_use 0
  5. Binlog_cache_use 0
  6. Binlog_stmt_cache_disk_use 0
  7. Binlog_stmt_cache_use 0
  8. Bytes_received 4735688920
  9. Bytes_sent 24726891374
  10. Com_admin_commands 1
  11. Com_assign_to_keycache 0
  12. Com_alter_db 0
  13. Com_alter_db_upgrade 0
  14. Com_alter_event 0
  15. Com_alter_function 0
  16. Com_alter_instance 0
  17. Com_alter_procedure 0
  18. Com_alter_server 0
  19. Com_alter_table 0
  20. Com_alter_tablespace 0
  21. Com_alter_user 0
  22. Com_analyze 0
  23. Com_begin 422958
  24. Com_binlog 0
  25. Com_call_procedure 0
  26. Com_change_db 1611
  27. Com_change_master 0
  28. Com_change_repl_filter 0
  29. Com_check 0
  30. Com_checksum 0
  31. Com_commit 422827
  32. Com_create_db 0
  33. Com_create_event 0
  34. Com_create_function 0
  35. Com_create_index 112
  36. Com_create_procedure 0
  37. Com_create_server 0
  38. Com_create_table 39
  39. Com_create_trigger 0
  40. Com_create_udf 0
  41. Com_create_user 0
  42. Com_create_view 0
  43. Com_dealloc_sql 0
  44. Com_delete 187865
  45. Com_delete_multi 303
  46. Com_do 0
  47. Com_drop_db 0
  48. Com_drop_event 0
  49. Com_drop_function 0
  50. Com_drop_index 0
  51. Com_drop_procedure 0
  52. Com_drop_server 0
  53. Com_drop_table 39
  54. Com_drop_trigger 0
  55. Com_drop_user 0
  56. Com_drop_view 0
  57. Com_empty_query 0
  58. Com_execute_sql 0
  59. Com_explain_other 0
  60. Com_flush 1
  61. Com_get_diagnostics 0
  62. Com_grant 0
  63. Com_ha_close 0
  64. Com_ha_open 0
  65. Com_ha_read 0
  66. Com_help 0
  67. Com_insert 603536
  68. Com_insert_select 51
  69. Com_install_plugin 0
  70. Com_kill 0
  71. Com_load 0
  72. Com_lock_tables 0
  73. Com_optimize 0
  74. Com_preload_keys 0
  75. Com_prepare_sql 0
  76. Com_purge 0
  77. Com_purge_before_date 0
  78. Com_release_savepoint 0
  79. Com_rename_table 0
  80. Com_rename_user 0
  81. Com_repair 0
  82. Com_replace 0
  83. Com_replace_select 0
  84. Com_reset 0
  85. Com_resignal 0
  86. Com_revoke 0
  87. Com_revoke_all 0
  88. Com_rollback 134
  89. Com_rollback_to_savepoint 0
  90. Com_savepoint 0
  91. Com_select 5869892
  92. Com_set_option 1856901
  93. Com_signal 0
  94. Com_show_binlog_events 0
  95. Com_show_binlogs 0
  96. Com_show_charsets 0
  97. Com_show_collations 0
  98. Com_show_create_db 0
  99. Com_show_create_event 0
  100. Com_show_create_func 0
  101. Com_show_create_proc 0
  102. Com_show_create_table 0
  103. Com_show_create_trigger 0
  104. Com_show_databases 3
  105. Com_show_engine_logs 0
  106. Com_show_engine_mutex 0
  107. Com_show_engine_status 0
  108. Com_show_events 0
  109. Com_show_errors 0
  110. Com_show_fields 1422
  111. Com_show_function_code 0
  112. Com_show_function_status 0
  113. Com_show_grants 0
  114. Com_show_keys 0
  115. Com_show_master_status 0
  116. Com_show_open_tables 0
  117. Com_show_plugins 0
  118. Com_show_privileges 0
  119. Com_show_procedure_code 0
  120. Com_show_procedure_status 0
  121. Com_show_processlist 0
  122. Com_show_profile 0
  123. Com_show_profiles 0
  124. Com_show_relaylog_events 0
  125. Com_show_slave_hosts 0
  126. Com_show_slave_status 0
  127. Com_show_status 3
  128. Com_show_storage_engines 0
  129. Com_show_table_status 0
  130. Com_show_tables 9504
  131. Com_show_triggers 0
  132. Com_show_variables 200230
  133. Com_show_warnings 0
  134. Com_show_create_user 0
  135. Com_shutdown 0
  136. Com_slave_start 0
  137. Com_slave_stop 0
  138. Com_group_replication_start 0
  139. Com_group_replication_stop 0
  140. Com_stmt_execute 0
  141. Com_stmt_close 0
  142. Com_stmt_fetch 0
  143. Com_stmt_prepare 0
  144. Com_stmt_reset 0
  145. Com_stmt_send_long_data 0
  146. Com_truncate 5
  147. Com_uninstall_plugin 0
  148. Com_unlock_tables 0
  149. Com_update 562283
  150. Com_update_multi 457
  151. Com_xa_commit 0
  152. Com_xa_end 0
  153. Com_xa_prepare 0
  154. Com_xa_recover 0
  155. Com_xa_rollback 0
  156. Com_xa_start 0
  157. Com_stmt_reprepare 0
  158. Connection_errors_accept 0
  159. Connection_errors_internal 0
  160. Connection_errors_max_connections 434
  161. Connection_errors_peer_address 0
  162. Connection_errors_select 0
  163. Connection_errors_tcpwrap 0
  164. Connections 911023
  165. Created_tmp_disk_tables 226136
  166. Created_tmp_files 670
  167. Created_tmp_tables 1404185
  168. Delayed_errors 0
  169. Delayed_insert_threads 0
  170. Delayed_writes 0
  171. Flush_commands 1
  172. Handler_commit 7739608
  173. Handler_delete 345501
  174. Handler_discover 0
  175. Handler_external_lock 22012925
  176. Handler_mrr_init 0
  177. Handler_prepare 0
  178. Handler_read_first 599035
  179. Handler_read_key 91346208
  180. Handler_read_last 1653
  181. Handler_read_next 450490604
  182. Handler_read_prev 2863694
  183. Handler_read_rnd 19887074
  184. Handler_read_rnd_next 584101163
  185. Handler_rollback 57
  186. Handler_savepoint 0
  187. Handler_savepoint_rollback 0
  188. Handler_update 2114538
  189. Handler_write 127484368
  190. Innodb_buffer_pool_dump_status Dumping of buffer pool not started
  191. Innodb_buffer_pool_load_status Buffer pool(s) load completed at 200709 8:40:33
  192. Innodb_buffer_pool_resize_status
  193. Innodb_buffer_pool_pages_data 320846
  194. Innodb_buffer_pool_bytes_data 7474290688
  195. Innodb_buffer_pool_pages_dirty 2956
  196. Innodb_buffer_pool_bytes_dirty 28114944
  197. Innodb_buffer_pool_pages_flushed 588449
  198. Innodb_buffer_pool_pages_free 60184
  199. Innodb_buffer_pool_pages_misc 143234
  200. Innodb_buffer_pool_pages_total 524264
  201. Innodb_buffer_pool_read_ahead_rnd 0
  202. Innodb_buffer_pool_read_ahead 100440
  203. Innodb_buffer_pool_read_ahead_evicted 0
  204. Innodb_buffer_pool_read_requests 1047677477
  205. Innodb_buffer_pool_reads 179920
  206. Innodb_buffer_pool_wait_free 0
  207. Innodb_buffer_pool_write_requests 24895993
  208. Innodb_data_fsyncs 1070097
  209. Innodb_data_pending_fsyncs 1
  210. Innodb_data_pending_reads 0
  211. Innodb_data_pending_writes 0
  212. Innodb_data_read 2521436672
  213. Innodb_data_reads 304892
  214. Innodb_data_writes 1511364
  215. Innodb_data_written 17926340608
  216. Innodb_dblwr_pages_written 574569
  217. Innodb_dblwr_writes 31066
  218. Innodb_log_waits 0
  219. Innodb_log_write_requests 2461080
  220. Innodb_log_writes 887200
  221. Innodb_os_log_fsyncs 890760
  222. Innodb_os_log_pending_fsyncs 1
  223. Innodb_os_log_pending_writes 0
  224. Innodb_os_log_written 2230255104
  225. Innodb_page_size 16384
  226. Innodb_pages_created 16521
  227. Innodb_pages_read 304330
  228. Innodb_pages_written 588449
  229. Innodb_row_lock_current_waits 0
  230. Innodb_row_lock_time 220
  231. Innodb_row_lock_time_avg 2
  232. Innodb_row_lock_time_max 70
  233. Innodb_row_lock_waits 84
  234. Innodb_rows_deleted 345501
  235. Innodb_rows_inserted 5111084
  236. Innodb_rows_read 846149510
  237. Innodb_rows_updated 577169
  238. Innodb_num_open_files 553
  239. Innodb_truncated_status_writes 0
  240. Innodb_available_undo_logs 128
  241. Key_blocks_not_flushed 0
  242. Key_blocks_unused 13396
  243. Key_blocks_used 3
  244. Key_read_requests 6
  245. Key_reads 3
  246. Key_write_requests 0
  247. Key_writes 0
  248. Locked_connects 0
  249. Max_execution_time_exceeded 0
  250. Max_execution_time_set 0
  251. Max_execution_time_set_failed 0
  252. Max_used_connections 152
  253. Max_used_connections_time 2020-07-09 19:28:43
  254. Not_flushed_delayed_rows 0
  255. Ongoing_anonymous_transaction_count 0
  256. Open_files 0
  257. Open_streams 0
  258. Open_table_definitions 718
  259. Open_tables 2000
  260. Opened_files 1882
  261. Opened_table_definitions 1021
  262. Opened_tables 137528
  263. Performance_schema_accounts_lost 0
  264. Performance_schema_cond_classes_lost 0
  265. Performance_schema_cond_instances_lost 0
  266. Performance_schema_digest_lost 0
  267. Performance_schema_file_classes_lost 0
  268. Performance_schema_file_handles_lost 0
  269. Performance_schema_file_instances_lost 0
  270. Performance_schema_hosts_lost 0
  271. Performance_schema_index_stat_lost 0
  272. Performance_schema_locker_lost 0
  273. Performance_schema_memory_classes_lost 0
  274. Performance_schema_metadata_lock_lost 0
  275. Performance_schema_mutex_classes_lost 0
  276. Performance_schema_mutex_instances_lost 0
  277. Performance_schema_nested_statement_lost 0
  278. Performance_schema_prepared_statements_lost 0
  279. Performance_schema_program_lost 0
  280. Performance_schema_rwlock_classes_lost 0
  281. Performance_schema_rwlock_instances_lost 0
  282. Performance_schema_session_connect_attrs_lost 0
  283. Performance_schema_socket_classes_lost 0
  284. Performance_schema_socket_instances_lost 0
  285. Performance_schema_stage_classes_lost 0
  286. Performance_schema_statement_classes_lost 0
  287. Performance_schema_table_handles_lost 0
  288. Performance_schema_table_instances_lost 0
  289. Performance_schema_table_lock_stat_lost 0
  290. Performance_schema_thread_classes_lost 0
  291. Performance_schema_thread_instances_lost 0
  292. Performance_schema_users_lost 0
  293. Prepared_stmt_count 0
  294. Qcache_free_blocks 2122
  295. Qcache_free_memory 6135552
  296. Qcache_hits 14161648
  297. Qcache_inserts 5746238
  298. Qcache_lowmem_prunes 1739291
  299. Qcache_not_cached 114422
  300. Qcache_queries_in_cache 4715
  301. Qcache_total_blocks 11875
  302. Queries 25202729
  303. Questions 25202727
  304. Rsa_public_key -----BEGIN PUBLIC KEY-----\nMIIBIjANBgkqhkiG9w0BAQEFAAOCAQ8AMIIBCgKCAQEAyQBNuzmtlP0SHNrXZbGK\n2/pdV5+hdow3NRIl7NdWfc/0DF+BEVFwTaEp0ecy8EEv+P5gD+8tWezQyEVEgH9g\ntp6rmFBTMlxR0WBlL2nQoNpiVY3igMK/vZYhv77NHoitzqbWPQ0PPzxq6YoFJvak\n/z6usETC2IRB7tIyqsbH9fK0tka6gg0F6lXL4MDwxfIBbhycjVdypYHm/R4WjaY6\nOLkopkCdwlenEfwIJ1ITIohlFPNriB3hEa44tF1WDdr7i84T8citziszW1xiH16F\nRyEagXv5yBi8/f2tX5xKkBNWk8uMsq2L/6BsDAErhHQW+cDCvFxr0yotxom6NqOz\nDQIDAQAB\n-----END PUBLIC KEY-----\n
  305. Select_full_join 19282
  306. Select_full_range_join 3442
  307. Select_range 570445
  308. Select_range_check 7
  309. Select_scan 1067468
  310. Slave_open_temp_tables 0
  311. Slow_launch_threads 0
  312. Slow_queries 0
  313. Sort_merge_passes 575
  314. Sort_range 694279
  315. Sort_rows 19883454
  316. Sort_scan 693449
  317. Ssl_accept_renegotiates 0
  318. Ssl_accepts 0
  319. Ssl_callback_cache_hits 0
  320. Ssl_cipher
  321. Ssl_cipher_list
  322. Ssl_client_connects 0
  323. Ssl_connect_renegotiates 0
  324. Ssl_ctx_verify_depth 18446744073709551615
  325. Ssl_ctx_verify_mode 5
  326. Ssl_default_timeout 0
  327. Ssl_finished_accepts 0
  328. Ssl_finished_connects 0
  329. Ssl_server_not_after Feb 25 18:26:29 2030 GMT
  330. Ssl_server_not_before Feb 28 18:26:29 2020 GMT
  331. Ssl_session_cache_hits 0
  332. Ssl_session_cache_misses 0
  333. Ssl_session_cache_mode SERVER
  334. Ssl_session_cache_overflows 0
  335. Ssl_session_cache_size 128
  336. Ssl_session_cache_timeouts 0
  337. Ssl_sessions_reused 0
  338. Ssl_used_session_cache_entries 0
  339. Ssl_verify_depth 0
  340. Ssl_verify_mode 0
  341. Ssl_version
  342. Table_locks_immediate 200332
  343. Table_locks_waited 0
  344. Table_open_cache_hits 10705086
  345. Table_open_cache_misses 137377
  346. Table_open_cache_overflows 135369
  347. Tc_log_max_pages_used 0
  348. Tc_log_page_size 0
  349. Tc_log_page_waits 0
  350. Threads_cached 2
  351. Threads_connected 65
  352. Threads_created 29751
  353. Threads_running 4
  354. Uptime 96267
  355. Uptime_since_flush_status 96267
  356. validate_password_dictionary_file_last_parsed 2020-07-09 08:39:56
  357. validate_password_dictionary_file_words_count 0
Add Comment
Please, Sign In to add comment
Public Pastes
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!