Guest User

Untitled

a guest
Jan 24th, 2020
375
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 10.27 KB | None | 0 0
  1. Aborted_clients 12
  2. Aborted_connects 0
  3. Binlog_cache_disk_use 8216
  4. Binlog_cache_use 1142015
  5. Binlog_stmt_cache_disk_use 0
  6. Binlog_stmt_cache_use 132781
  7. Bytes_received 32850234262
  8. Bytes_sent 184571642034
  9. Com_admin_commands 8903
  10. Com_assign_to_keycache 0
  11. Com_alter_db 0
  12. Com_alter_db_upgrade 0
  13. Com_alter_event 0
  14. Com_alter_function 0
  15. Com_alter_instance 0
  16. Com_alter_procedure 0
  17. Com_alter_server 0
  18. Com_alter_table 128989
  19. Com_alter_tablespace 0
  20. Com_alter_user 0
  21. Com_analyze 0
  22. Com_begin 1532273
  23. Com_binlog 0
  24. Com_call_procedure 0
  25. Com_change_db 1384
  26. Com_change_master 0
  27. Com_change_repl_filter 0
  28. Com_check 0
  29. Com_checksum 0
  30. Com_commit 1531493
  31. Com_create_db 0
  32. Com_create_event 0
  33. Com_create_function 0
  34. Com_create_index 0
  35. Com_create_procedure 0
  36. Com_create_server 0
  37. Com_create_table 3759
  38. Com_create_trigger 0
  39. Com_create_udf 0
  40. Com_create_user 0
  41. Com_create_view 0
  42. Com_dealloc_sql 0
  43. Com_delete 851271
  44. Com_delete_multi 7749
  45. Com_do 0
  46. Com_drop_db 0
  47. Com_drop_event 0
  48. Com_drop_function 0
  49. Com_drop_index 0
  50. Com_drop_procedure 0
  51. Com_drop_server 0
  52. Com_drop_table 3715
  53. Com_drop_trigger 0
  54. Com_drop_user 0
  55. Com_drop_view 0
  56. Com_empty_query 0
  57. Com_execute_sql 0
  58. Com_explain_other 0
  59. Com_flush 2
  60. Com_get_diagnostics 0
  61. Com_grant 0
  62. Com_ha_close 0
  63. Com_ha_open 0
  64. Com_ha_read 0
  65. Com_help 0
  66. Com_insert 1208540
  67. Com_insert_select 110571
  68. Com_install_plugin 0
  69. Com_kill 0
  70. Com_load 0
  71. Com_lock_tables 6
  72. Com_optimize 0
  73. Com_preload_keys 0
  74. Com_prepare_sql 0
  75. Com_purge 0
  76. Com_purge_before_date 2
  77. Com_release_savepoint 0
  78. Com_rename_table 0
  79. Com_rename_user 0
  80. Com_repair 0
  81. Com_replace 0
  82. Com_replace_select 0
  83. Com_reset 0
  84. Com_resignal 0
  85. Com_revoke 0
  86. Com_revoke_all 0
  87. Com_rollback 780
  88. Com_rollback_to_savepoint 0
  89. Com_savepoint 0
  90. Com_select 82178609
  91. Com_set_option 888399
  92. Com_signal 0
  93. Com_show_binlog_events 0
  94. Com_show_binlogs 0
  95. Com_show_charsets 19
  96. Com_show_collations 3
  97. Com_show_create_db 2
  98. Com_show_create_event 0
  99. Com_show_create_func 0
  100. Com_show_create_proc 0
  101. Com_show_create_table 2736
  102. Com_show_create_trigger 0
  103. Com_show_databases 3
  104. Com_show_engine_logs 0
  105. Com_show_engine_mutex 0
  106. Com_show_engine_status 5704
  107. Com_show_events 0
  108. Com_show_errors 0
  109. Com_show_fields 5639
  110. Com_show_function_code 0
  111. Com_show_function_status 3
  112. Com_show_grants 0
  113. Com_show_keys 8
  114. Com_show_master_status 4
  115. Com_show_open_tables 0
  116. Com_show_plugins 0
  117. Com_show_privileges 0
  118. Com_show_procedure_code 0
  119. Com_show_procedure_status 3
  120. Com_show_processlist 4
  121. Com_show_profile 0
  122. Com_show_profiles 0
  123. Com_show_relaylog_events 0
  124. Com_show_slave_hosts 0
  125. Com_show_slave_status 5704
  126. Com_show_status 17121
  127. Com_show_storage_engines 3
  128. Com_show_table_status 4387
  129. Com_show_tables 13238
  130. Com_show_triggers 0
  131. Com_show_variables 11477
  132. Com_show_warnings 0
  133. Com_show_create_user 0
  134. Com_shutdown 0
  135. Com_slave_start 0
  136. Com_slave_stop 0
  137. Com_group_replication_start 0
  138. Com_group_replication_stop 0
  139. Com_stmt_execute 0
  140. Com_stmt_close 0
  141. Com_stmt_fetch 0
  142. Com_stmt_prepare 0
  143. Com_stmt_reset 0
  144. Com_stmt_send_long_data 0
  145. Com_truncate 14
  146. Com_uninstall_plugin 0
  147. Com_unlock_tables 6
  148. Com_update 757829
  149. Com_update_multi 3411442
  150. Com_xa_commit 0
  151. Com_xa_end 0
  152. Com_xa_prepare 0
  153. Com_xa_recover 0
  154. Com_xa_rollback 0
  155. Com_xa_start 0
  156. Com_stmt_reprepare 0
  157. Connection_errors_accept 0
  158. Connection_errors_internal 0
  159. Connection_errors_max_connections 0
  160. Connection_errors_peer_address 0
  161. Connection_errors_select 0
  162. Connection_errors_tcpwrap 0
  163. Connections 457452
  164. Created_tmp_disk_tables 3453524
  165. Created_tmp_files 6066
  166. Created_tmp_tables 8764521
  167. Delayed_errors 0
  168. Delayed_insert_threads 0
  169. Delayed_writes 0
  170. Flush_commands 1
  171. Handler_commit 92599369
  172. Handler_delete 33545505
  173. Handler_discover 0
  174. Handler_external_lock 281657951
  175. Handler_mrr_init 0
  176. Handler_prepare 6742836
  177. Handler_read_first 24062590
  178. Handler_read_key 18204304110
  179. Handler_read_last 1954
  180. Handler_read_next 84321539269
  181. Handler_read_prev 21835451
  182. Handler_read_rnd 334349919
  183. Handler_read_rnd_next 51325451439
  184. Handler_rollback 2002
  185. Handler_savepoint 0
  186. Handler_savepoint_rollback 0
  187. Handler_update 32583895
  188. Handler_write 269879920
  189. Innodb_buffer_pool_dump_status Dumping of buffer pool not started
  190. Innodb_buffer_pool_load_status Buffer pool(s) load completed at 200122 10:52:31
  191. Innodb_buffer_pool_resize_status
  192. Innodb_buffer_pool_pages_data 914364
  193. Innodb_buffer_pool_bytes_data 14980939776
  194. Innodb_buffer_pool_pages_dirty 5539
  195. Innodb_buffer_pool_bytes_dirty 90750976
  196. Innodb_buffer_pool_pages_flushed 2557135
  197. Innodb_buffer_pool_pages_free 498768
  198. Innodb_buffer_pool_pages_misc 28484
  199. Innodb_buffer_pool_pages_total 1441616
  200. Innodb_buffer_pool_read_ahead_rnd 0
  201. Innodb_buffer_pool_read_ahead 371882
  202. Innodb_buffer_pool_read_ahead_evicted 0
  203. Innodb_buffer_pool_read_requests 118795640972
  204. Innodb_buffer_pool_reads 621425
  205. Innodb_buffer_pool_wait_free 0
  206. Innodb_buffer_pool_write_requests 792936339
  207. Innodb_data_fsyncs 1785864
  208. Innodb_data_pending_fsyncs 0
  209. Innodb_data_pending_reads 0
  210. Innodb_data_pending_writes 0
  211. Innodb_data_read 16525054464
  212. Innodb_data_reads 1009309
  213. Innodb_data_writes 4076203
  214. Innodb_data_written 74180770304
  215. Innodb_dblwr_pages_written 1256471
  216. Innodb_dblwr_writes 160442
  217. Innodb_log_waits 0
  218. Innodb_log_write_requests 22674052
  219. Innodb_log_writes 1346366
  220. Innodb_os_log_fsyncs 1353130
  221. Innodb_os_log_pending_fsyncs 0
  222. Innodb_os_log_pending_writes 0
  223. Innodb_os_log_written 11698601984
  224. Innodb_page_size 16384
  225. Innodb_pages_created 197597
  226. Innodb_pages_read 1008605
  227. Innodb_pages_written 2557135
  228. Innodb_row_lock_current_waits 9
  229. Innodb_row_lock_time 1045817
  230. Innodb_row_lock_time_avg 5
  231. Innodb_row_lock_time_max 51973
  232. Innodb_row_lock_waits 198338
  233. Innodb_rows_deleted 33546625
  234. Innodb_rows_inserted 396717996
  235. Innodb_rows_read 138681312834
  236. Innodb_rows_updated 1916328
  237. Innodb_num_open_files 697
  238. Innodb_truncated_status_writes 0
  239. Innodb_available_undo_logs 128
  240. Key_blocks_not_flushed 0
  241. Key_blocks_unused 6698
  242. Key_blocks_used 3
  243. Key_read_requests 30
  244. Key_reads 9
  245. Key_write_requests 0
  246. Key_writes 0
  247. Locked_connects 0
  248. Max_execution_time_exceeded 0
  249. Max_execution_time_set 12
  250. Max_execution_time_set_failed 0
  251. Max_used_connections 138
  252. Max_used_connections_time 2020-01-23 13:20:25
  253. Not_flushed_delayed_rows 0
  254. Ongoing_anonymous_transaction_count 0
  255. Open_files 3
  256. Open_streams 0
  257. Open_table_definitions 795
  258. Open_tables 2000
  259. Opened_files 278365
  260. Opened_table_definitions 137226
  261. Opened_tables 1720443
  262. Performance_schema_accounts_lost 0
  263. Performance_schema_cond_classes_lost 0
  264. Performance_schema_cond_instances_lost 0
  265. Performance_schema_digest_lost 0
  266. Performance_schema_file_classes_lost 0
  267. Performance_schema_file_handles_lost 0
  268. Performance_schema_file_instances_lost 0
  269. Performance_schema_hosts_lost 0
  270. Performance_schema_index_stat_lost 0
  271. Performance_schema_locker_lost 0
  272. Performance_schema_memory_classes_lost 0
  273. Performance_schema_metadata_lock_lost 0
  274. Performance_schema_mutex_classes_lost 0
  275. Performance_schema_mutex_instances_lost 0
  276. Performance_schema_nested_statement_lost 0
  277. Performance_schema_prepared_statements_lost 0
  278. Performance_schema_program_lost 0
  279. Performance_schema_rwlock_classes_lost 0
  280. Performance_schema_rwlock_instances_lost 0
  281. Performance_schema_session_connect_attrs_lost 0
  282. Performance_schema_socket_classes_lost 0
  283. Performance_schema_socket_instances_lost 0
  284. Performance_schema_stage_classes_lost 0
  285. Performance_schema_statement_classes_lost 0
  286. Performance_schema_table_handles_lost 0
  287. Performance_schema_table_instances_lost 0
  288. Performance_schema_table_lock_stat_lost 0
  289. Performance_schema_thread_classes_lost 0
  290. Performance_schema_thread_instances_lost 0
  291. Performance_schema_users_lost 0
  292. Prepared_stmt_count 0
  293. Qcache_free_blocks 1
  294. Qcache_free_memory 127982656
  295. Qcache_hits 0
  296. Qcache_inserts 0
  297. Qcache_lowmem_prunes 0
  298. Qcache_not_cached 82025512
  299. Qcache_queries_in_cache 0
  300. Qcache_total_blocks 1
  301. Queries 93149226
  302. Questions 93140323
  303. Rpl_semi_sync_master_clients 0
  304. Rpl_semi_sync_master_estimated_slave_lag 0
  305. Rpl_semi_sync_master_net_avg_wait_time 0
  306. Rpl_semi_sync_master_net_wait_time 0
  307. Rpl_semi_sync_master_net_waits 50002
  308. Rpl_semi_sync_master_no_times 2
  309. Rpl_semi_sync_master_no_tx 1207697
  310. Rpl_semi_sync_master_status OFF
  311. Rpl_semi_sync_master_timefunc_failures 0
  312. Rpl_semi_sync_master_tx_avg_wait_time 503
  313. Rpl_semi_sync_master_tx_wait_time 22622447
  314. Rpl_semi_sync_master_tx_waits 44925
  315. Rpl_semi_sync_master_wait_pos_backtraverse 0
  316. Rpl_semi_sync_master_wait_sessions 0
  317. Rpl_semi_sync_master_yes_tx 44963
  318. Rpl_semi_sync_slave_status OFF
  319. Rsa_public_key -----BEGIN PUBLIC KEY-----
  320. MIIBIjANBgkqhkiG9w0BAQEFAAOCAQ8AMIIBCgKCAQEA1hg3MJ+FnIdhI0tsaR9f
  321. Pf4t/CB4UiT1RwTFeU7oTxvRkemYGflPMoAQCcZBEsfUspRZmCWqRBmTkwl4pZFo
  322. OIjGpDQCztJ+U+OrsR0E12DcMLSxBz3hh3+8ZnL5syakVAfq3ShSAcjbkxxGDSBo
  323. AhaOH+qb/lGdyt/8BkVLLj2Fc5YZZDZpQmGzy9yWzZ5GcUosTjhzo7RHKIO7E3+2
  324. uY3+zc+zhk9SEAcsbyxbcnJXJl6iOl2Rzv2t9V2dELmwbRAHNsOYf0dc+dD0awzd
  325. 9bvMOHPto5OS8RXqQlWl7UlW4feg5efW/e4MQ3qWv4h+W0gzSUm7cw2D5WOxqqwl
  326. NwIDAQAB
  327. -----END PUBLIC KEY-----
  328.  
  329. Select_full_join 495583
  330. Select_full_range_join 26126
  331. Select_range 8034821
  332. Select_range_check 38014
  333. Select_scan 22996850
  334. Slave_open_temp_tables 0
  335. Slow_launch_threads 0
  336. Slow_queries 35
  337. Sort_merge_passes 10147
  338. Sort_range 2661015
  339. Sort_rows 298580395
  340. Sort_scan 9086752
  341. Ssl_accept_renegotiates 0
  342. Ssl_accepts 0
  343. Ssl_callback_cache_hits 0
  344. Ssl_cipher ECDHE-RSA-AES128-GCM-SHA256
  345. Ssl_cipher_list ECDHE-ECDSA-AES128-GCM-SHA256:ECDHE-RSA-AES128-GCM-SHA256:ECDHE-ECDSA-AES128-SHA:ECDHE-RSA-AES128-SHA:ECDHE-ECDSA-AES256-SHA:ECDHE-RSA-AES256-SHA:AES128-GCM-SHA256:AES128-SHA:AES256-SHA:DES-CBC3-SHA
  346. Ssl_client_connects 0
  347. Ssl_connect_renegotiates 0
  348. Ssl_ctx_verify_depth 18446744073709551615
  349. Ssl_ctx_verify_mode 1
  350. Ssl_default_timeout 7200
  351. Ssl_finished_accepts 0
  352. Ssl_finished_connects 0
  353. Ssl_server_not_after Nov 30 09:34:21 2028 GMT
  354. Ssl_server_not_before Dec 3 09:33:21 2018 GMT
  355. Ssl_session_cache_hits 0
  356. Ssl_session_cache_misses 0
  357. Ssl_session_cache_mode SERVER
  358. Ssl_session_cache_overflows 0
  359. Ssl_session_cache_size 128
  360. Ssl_session_cache_timeouts 0
  361. Ssl_sessions_reused 0
  362. Ssl_used_session_cache_entries 0
  363. Ssl_verify_depth 18446744073709551615
  364. Ssl_verify_mode 1
  365. Ssl_version TLSv1.2
  366. Table_locks_immediate 34452
  367. Table_locks_waited 0
  368. Table_open_cache_hits 138919689
  369. Table_open_cache_misses 1716728
  370. Table_open_cache_overflows 1490458
  371. Tc_log_max_pages_used 0
  372. Tc_log_page_size 0
  373. Tc_log_page_waits 0
  374. Threads_cached 44
  375. Threads_connected 7
  376. Threads_created 163
  377. Threads_running 2
  378. Uptime 171155
  379. Uptime_since_flush_status 171155
Advertisement
Add Comment
Please, Sign In to add comment