SHARE
TWEET

Untitled

jackuk Feb 15th, 2020 75 in 354 days
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. Variable_name   Value  
  2. Aborted_clients     0
  3. Aborted_connects    1
  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  155437083
  9. Bytes_sent  739980081
  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   2
  24. Com_binlog  0
  25. Com_call_procedure  0
  26. Com_change_db   8
  27. Com_change_master   0
  28. Com_change_repl_filter  0
  29. Com_check   0
  30. Com_checksum    0
  31. Com_commit  2
  32. Com_create_db   0
  33. Com_create_event    0
  34. Com_create_function     0
  35. Com_create_index    0
  36. Com_create_procedure    0
  37. Com_create_server   0
  38. Com_create_table    0
  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  4
  45. Com_delete_multi    1
  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  0
  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   0
  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  740
  68. Com_insert_select   41
  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    0
  89. Com_rollback_to_savepoint   0
  90. Com_savepoint   0
  91. Com_select  406714
  92. Com_set_option  865
  93. Com_signal  0
  94. Com_show_binlog_events  0
  95. Com_show_binlogs    1
  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. Variable_name   Value    
  103. Com_show_create_table   0
  104. Com_show_create_trigger     0
  105. Com_show_databases  2
  106. Com_show_engine_logs    0
  107. Com_show_engine_mutex   0
  108. Com_show_engine_status  0
  109. Com_show_events     0
  110. Com_show_errors     0
  111. Com_show_fields     0
  112. Com_show_function_code  0
  113. Com_show_function_status    0
  114. Com_show_grants     1
  115. Com_show_keys   0
  116. Com_show_master_status  0
  117. Com_show_open_tables    0
  118. Com_show_plugins    0
  119. Com_show_privileges     0
  120. Com_show_procedure_code     0
  121. Com_show_procedure_status   0
  122. Com_show_processlist    0
  123. Com_show_profile    0
  124. Com_show_profiles   0
  125. Com_show_relaylog_events    0
  126. Com_show_slave_hosts    1
  127. Com_show_slave_status   1
  128. Com_show_status     7
  129. Com_show_storage_engines    1
  130. Com_show_table_status   4
  131. Com_show_tables     0
  132. Com_show_triggers   0
  133. Com_show_variables  27
  134. Com_show_warnings   4
  135. Com_show_create_user    0
  136. Com_shutdown    0
  137. Com_slave_start     0
  138. Com_slave_stop  0
  139. Com_group_replication_start     0
  140. Com_group_replication_stop  0
  141. Com_stmt_execute    0
  142. Com_stmt_close  0
  143. Com_stmt_fetch  0
  144. Com_stmt_prepare    0
  145. Com_stmt_reset  0
  146. Com_stmt_send_long_data     0
  147. Com_truncate    0
  148. Com_uninstall_plugin    0
  149. Com_unlock_tables   0
  150. Com_update  175
  151. Com_update_multi    1
  152. Com_xa_commit   0
  153. Com_xa_end  0
  154. Com_xa_prepare  0
  155. Com_xa_recover  0
  156. Com_xa_rollback     0
  157. Com_xa_start    0
  158. Com_stmt_reprepare  0
  159. Connection_errors_accept    0
  160. Connection_errors_internal  0
  161. Connection_errors_max_connections   0
  162. Connection_errors_peer_address  0
  163. Connection_errors_select    0
  164. Connection_errors_tcpwrap   0
  165. Connections     1012
  166. Created_tmp_disk_tables     3262
  167. Created_tmp_files   19
  168. Created_tmp_tables  92968
  169. Delayed_errors  0
  170. Delayed_insert_threads  0
  171. Delayed_writes  0
  172. Flush_commands  1
  173. Handler_commit  407362
  174. Handler_delete  4
  175. Handler_discover    0
  176. Handler_external_lock   1786247
  177. Handler_mrr_init    0
  178. Handler_prepare     0
  179. Handler_read_first  16983
  180. Handler_read_key    61056750
  181. Handler_read_last   839
  182. Handler_read_next   54413990
  183. Handler_read_prev   227460
  184. Handler_read_rnd    390001
  185. Handler_read_rnd_next   11389144
  186. Handler_rollback    0
  187. Handler_savepoint   0
  188. Handler_savepoint_rollback  0
  189. Handler_update  27566
  190. Handler_write   16845096
  191. Innodb_buffer_pool_dump_status  Dumping of buffer pool not started
  192. Innodb_buffer_pool_load_status  Buffer pool(s) load completed at 200215  7:30:05
  193. Innodb_buffer_pool_resize_status    
  194. Innodb_buffer_pool_pages_data   6701
  195. Innodb_buffer_pool_bytes_data   109789184
  196. Innodb_buffer_pool_pages_dirty  0
  197. Innodb_buffer_pool_bytes_dirty  0
  198. Innodb_buffer_pool_pages_flushed    20196
  199. Innodb_buffer_pool_pages_free   1025
  200. Innodb_buffer_pool_pages_misc   465
  201. Innodb_buffer_pool_pages_total  8191
  202. Innodb_buffer_pool_read_ahead_rnd   0
  203. Variable_name   Value    
  204. Innodb_buffer_pool_read_ahead   1047
  205. Innodb_buffer_pool_read_ahead_evicted   0
  206. Innodb_buffer_pool_read_requests    117471735
  207. Innodb_buffer_pool_reads    9486
  208. Innodb_buffer_pool_wait_free    0
  209. Innodb_buffer_pool_write_requests   411646
  210. Innodb_data_fsyncs  2838
  211. Innodb_data_pending_fsyncs  0
  212. Innodb_data_pending_reads   0
  213. Innodb_data_pending_writes  0
  214. Innodb_data_read    176263680
  215. Innodb_data_reads   11024
  216. Innodb_data_writes  22283
  217. Innodb_data_written     390570496
  218. Innodb_dblwr_pages_written  3420
  219. Innodb_dblwr_writes     312
  220. Innodb_log_waits    0
  221. Innodb_log_write_requests   4866
  222. Innodb_log_writes   1307
  223. Innodb_os_log_fsyncs    1696
  224. Innodb_os_log_pending_fsyncs    0
  225. Innodb_os_log_pending_writes    0
  226. Innodb_os_log_written   3446784
  227. Innodb_page_size    16384
  228. Innodb_pages_created    657
  229. Innodb_pages_read   10753
  230. Innodb_pages_written    20196
  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     4
  237. Innodb_rows_inserted    98454
  238. Innodb_rows_read    108520558
  239. Innodb_rows_updated     26175
  240. Innodb_num_open_files   262
  241. Innodb_truncated_status_writes  0
  242. Innodb_available_undo_logs  128
  243. Key_blocks_not_flushed  0
  244. Key_blocks_unused   6696
  245. Key_blocks_used     4
  246. Key_read_requests   98
  247. Key_reads   7
  248. Key_write_requests  0
  249. Key_writes  0
  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    10
  255. Max_used_connections_time   2020-02-15 07:40:48
  256. Not_flushed_delayed_rows    0
  257. Ongoing_anonymous_transaction_count     0
  258. Open_files  2
  259. Open_streams    0
  260. Open_table_definitions  532
  261. Open_tables     2096
  262. Opened_files    799
  263. Opened_table_definitions    532
  264. Opened_tables   8143
  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  52
  297. Qcache_free_memory  189280
  298. Qcache_hits     150572
  299. Qcache_inserts  403025
  300. Qcache_lowmem_prunes    402389
  301. Qcache_not_cached   3695
  302. Qcache_queries_in_cache     369
  303. Qcache_total_blocks     842
  304. Variable_name   Value    
  305. Queries     560188
  306. Questions   560185
  307. Select_full_join    672
  308. Select_full_range_join  276
  309. Select_range    10153
  310. Select_range_check  0
  311. Select_scan     28192
  312. Slave_open_temp_tables  0
  313. Slow_launch_threads     0
  314. Slow_queries    0
  315. Sort_merge_passes   10
  316. Sort_range  10600
  317. Sort_rows   503217
  318. Sort_scan   65490
  319. Ssl_accept_renegotiates     0
  320. Ssl_accepts     0
  321. Ssl_callback_cache_hits     0
  322. Ssl_cipher  
  323. Ssl_cipher_list    
  324. Ssl_client_connects     0
  325. Ssl_connect_renegotiates    0
  326. Ssl_ctx_verify_depth    0
  327. Ssl_ctx_verify_mode     0
  328. Ssl_default_timeout     0
  329. Ssl_finished_accepts    0
  330. Ssl_finished_connects   0
  331. Ssl_server_not_after    
  332. Ssl_server_not_before  
  333. Ssl_session_cache_hits  0
  334. Ssl_session_cache_misses    0
  335. Ssl_session_cache_mode  NONE
  336. Ssl_session_cache_overflows     0
  337. Ssl_session_cache_size  0
  338. Ssl_session_cache_timeouts  0
  339. Ssl_sessions_reused     0
  340. Ssl_used_session_cache_entries  0
  341. Ssl_verify_depth    0
  342. Ssl_verify_mode     0
  343. Ssl_version    
  344. Table_locks_immediate   176
  345. Table_locks_waited  0
  346. Table_open_cache_hits   887713
  347. Table_open_cache_misses     8143
  348. Table_open_cache_overflows  6040
  349. Tc_log_max_pages_used   0
  350. Tc_log_page_size    0
  351. Tc_log_page_waits   0
  352. Threads_cached  7
  353. Threads_connected   3
  354. Threads_created     10
  355. Threads_running     2
  356. Uptime  1297
  357. Uptime_since_flush_status   1297
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