Advertisement
supp85

Untitled

Jan 13th, 2021
161
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 14.79 KB | None | 0 0
  1. Variable_name Value
  2. Aborted_clients 0
  3. Aborted_connects 0
  4. Aborted_connects_preauth 0
  5. Access_denied_errors 0
  6. Acl_column_grants 0
  7. Acl_database_grants 0
  8. Acl_function_grants 0
  9. Acl_procedure_grants 0
  10. Acl_package_spec_grants 0
  11. Acl_package_body_grants 0
  12. Acl_proxy_users 2
  13. Acl_role_grants 0
  14. Acl_roles 0
  15. Acl_table_grants 1
  16. Acl_users 3
  17. Aria_pagecache_blocks_not_flushed 0
  18. Aria_pagecache_blocks_unused 15635
  19. Aria_pagecache_blocks_used 14
  20. Aria_pagecache_read_requests 31
  21. Aria_pagecache_reads 17
  22. Aria_pagecache_write_requests 4
  23. Aria_pagecache_writes 4
  24. Aria_transaction_log_syncs 0
  25. Binlog_commits 0
  26. Binlog_group_commits 0
  27. Binlog_group_commit_trigger_count 0
  28. Binlog_group_commit_trigger_lock_wait 0
  29. Binlog_group_commit_trigger_timeout 0
  30. Binlog_snapshot_file
  31. Binlog_snapshot_position 0
  32. Binlog_bytes_written 0
  33. Binlog_cache_disk_use 0
  34. Binlog_cache_use 0
  35. Binlog_stmt_cache_disk_use 0
  36. Binlog_stmt_cache_use 0
  37. Busy_time 0.000000
  38. Bytes_received 4320057854
  39. Bytes_sent 7688590061
  40. Column_compressions 0
  41. Column_decompressions 0
  42. Com_admin_commands 0
  43. Com_alter_db 0
  44. Com_alter_db_upgrade 0
  45. Com_alter_event 0
  46. Com_alter_function 0
  47. Com_alter_procedure 0
  48. Com_alter_server 0
  49. Com_alter_sequence 0
  50. Com_alter_table 0
  51. Com_alter_tablespace 0
  52. Com_alter_user 0
  53. Com_analyze 0
  54. Com_assign_to_keycache 0
  55. Com_backup 0
  56. Com_backup_lock 0
  57. Com_begin 0
  58. Com_binlog 0
  59. Com_call_procedure 0
  60. Com_change_db 49
  61. Com_change_master 0
  62. Com_check 0
  63. Com_checksum 0
  64. Com_commit 0
  65. Com_compound_sql 0
  66. Com_create_db 0
  67. Com_create_event 0
  68. Com_create_function 0
  69. Com_create_index 0
  70. Com_create_package 0
  71. Com_create_package_body 0
  72. Com_create_procedure 0
  73. Com_create_role 0
  74. Com_create_sequence 0
  75. Com_create_server 0
  76. Com_create_table 0
  77. Com_create_temporary_table 0
  78. Com_create_trigger 0
  79. Com_create_udf 0
  80. Com_create_user 0
  81. Com_create_view 0
  82. Com_dealloc_sql 0
  83. Com_delete 0
  84. Com_delete_multi 0
  85. Com_do 0
  86. Com_drop_db 0
  87. Com_drop_event 0
  88. Com_drop_function 0
  89. Com_drop_index 0
  90. Com_drop_procedure 0
  91. Com_drop_package 0
  92. Com_drop_package_body 0
  93. Com_drop_role 0
  94. Com_drop_server 0
  95. Com_drop_sequence 0
  96. Com_drop_table 0
  97. Com_drop_temporary_table 0
  98. Com_drop_trigger 0
  99. Com_drop_user 0
  100. Com_drop_view 0
  101. Com_empty_query 0
  102. Com_execute_immediate 0
  103. Com_execute_sql 0
  104. Com_flush 0
  105. Com_get_diagnostics 0
  106. Com_grant 0
  107. Com_grant_role 0
  108. Com_ha_close 0
  109. Com_ha_open 0
  110. Com_ha_read 0
  111. Com_help 0
  112. Com_insert 69613
  113. Com_insert_select 0
  114. Com_install_plugin 0
  115. Com_kill 0
  116. Com_load 0
  117. Com_lock_tables 0
  118. Com_multi 0
  119. Com_optimize 0
  120. Com_preload_keys 0
  121. Com_prepare_sql 0
  122. Com_purge 0
  123. Com_purge_before_date 0
  124. Com_release_savepoint 0
  125. Com_rename_table 0
  126. Com_rename_user 0
  127. Com_repair 0
  128. Com_replace 0
  129. Com_replace_select 0
  130. Com_reset 0
  131. Com_resignal 0
  132. Com_revoke 0
  133. Com_revoke_all 0
  134. Com_revoke_role 0
  135. Com_rollback 0
  136. Com_rollback_to_savepoint 0
  137. Com_savepoint 0
  138. Com_select 61300252
  139. Com_set_option 3289440
  140. Com_show_authors 0
  141. Com_show_binlog_events 0
  142. Com_show_binlogs 0
  143. Com_show_charsets 0
  144. Com_show_collations 0
  145. Com_show_contributors 0
  146. Com_show_create_db 0
  147. Com_show_create_event 0
  148. Com_show_create_func 0
  149. Com_show_create_package 0
  150. Com_show_create_package_body 0
  151. Com_show_create_proc 0
  152. Com_show_create_table 0
  153. Com_show_create_trigger 0
  154. Com_show_create_user 0
  155. Com_show_databases 0
  156. Com_show_engine_logs 0
  157. Com_show_engine_mutex 0
  158. Com_show_engine_status 0
  159. Com_show_errors 0
  160. Com_show_events 0
  161. Com_show_explain 0
  162. Com_show_fields 0
  163. Com_show_function_status 0
  164. Com_show_generic 0
  165. Com_show_grants 0
  166. Com_show_keys 0
  167. Com_show_binlog_status 35
  168. Com_show_open_tables 0
  169. Com_show_package_status 0
  170. Com_show_package_body_status 0
  171. Com_show_plugins 0
  172. Com_show_privileges 0
  173. Com_show_procedure_status 0
  174. Com_show_processlist 1
  175. Com_show_profile 0
  176. Com_show_profiles 0
  177. Com_show_relaylog_events 0
  178. Com_show_slave_hosts 0
  179. Com_show_slave_status 35
  180. Com_show_status 41
  181. Com_show_storage_engines 0
  182. Com_show_table_status 0
  183. Com_show_tables 0
  184. Com_show_triggers 0
  185. Com_show_variables 92
  186. Com_show_warnings 6
  187. Com_shutdown 0
  188. Com_signal 0
  189. Com_start_all_slaves 0
  190. Com_start_slave 0
  191. Com_stmt_close 0
  192. Com_stmt_execute 0
  193. Com_stmt_fetch 0
  194. Com_stmt_prepare 0
  195. Com_stmt_reprepare 0
  196. Com_stmt_reset 0
  197. Com_stmt_send_long_data 0
  198. Com_stop_all_slaves 0
  199. Com_stop_slave 0
  200. Com_truncate 0
  201. Com_uninstall_plugin 0
  202. Com_unlock_tables 0
  203. Com_update 654
  204. Com_update_multi 0
  205. Com_xa_commit 0
  206. Com_xa_end 0
  207. Com_xa_prepare 0
  208. Com_xa_recover 0
  209. Com_xa_rollback 0
  210. Com_xa_start 0
  211. Compression OFF
  212. Connection_errors_accept 0
  213. Connection_errors_internal 0
  214. Connection_errors_max_connections 0
  215. Connection_errors_peer_address 0
  216. Connection_errors_select 0
  217. Connection_errors_tcpwrap 0
  218. Connections 3289327
  219. Cpu_time 0.000000
  220. Created_tmp_disk_tables 3
  221. Created_tmp_files 5
  222. Created_tmp_tables 2497985
  223. Delayed_errors 0
  224. Delayed_insert_threads 0
  225. Delayed_writes 0
  226. Delete_scan 0
  227. Empty_queries 473956
  228. Executed_events 0
  229. Executed_triggers 0
  230. Feature_application_time_periods 0
  231. Feature_check_constraint 1
  232. Feature_custom_aggregate_functions 0
  233. Feature_delay_key_write 0
  234. Feature_dynamic_columns 0
  235. Feature_fulltext 0
  236. Feature_gis 0
  237. Feature_insert_returning 0
  238. Feature_invisible_columns 0
  239. Feature_json 1
  240. Feature_locale 115
  241. Feature_subquery 462
  242. Feature_system_versioning 0
  243. Feature_timezone 0
  244. Feature_trigger 0
  245. Feature_window_functions 0
  246. Feature_xml 0
  247. Handler_commit 61369590
  248. Handler_delete 0
  249. Handler_discover 0
  250. Handler_external_lock 0
  251. Handler_icp_attempts 729209609
  252. Handler_icp_match 729175354
  253. Handler_mrr_init 0
  254. Handler_mrr_key_refills 0
  255. Handler_mrr_rowid_refills 0
  256. Handler_prepare 0
  257. Handler_read_first 18
  258. Handler_read_key 61518871
  259. Handler_read_last 9
  260. Handler_read_next 871112962
  261. Handler_read_prev 955
  262. Handler_read_retry 0
  263. Handler_read_rnd 2496801
  264. Handler_read_rnd_deleted 0
  265. Handler_read_rnd_next 400490097
  266. Handler_rollback 508
  267. Handler_savepoint 0
  268. Handler_savepoint_rollback 0
  269. Handler_tmp_delete 0
  270. Handler_tmp_update 0
  271. Handler_tmp_write 395914570
  272. Handler_update 202
  273. Handler_write 69613
  274. Innodb_adaptive_hash_hash_searches 0
  275. Innodb_adaptive_hash_non_hash_searches 802600265
  276. Innodb_background_log_sync 24785
  277. Innodb_buffered_aio_submitted 1
  278. Innodb_buffer_pool_dump_status
  279. Innodb_buffer_pool_load_status Buffer pool(s) load completed at 210113  9:29:50
  280. Innodb_buffer_pool_resize_status
  281. Innodb_buffer_pool_load_incomplete OFF
  282. Innodb_buffer_pool_pages_data 227914
  283. Innodb_buffer_pool_bytes_data 3734142976
  284. Innodb_buffer_pool_pages_dirty 6450
  285. Innodb_buffer_pool_bytes_dirty 105676800
  286. Innodb_buffer_pool_pages_flushed 38605
  287. Innodb_buffer_pool_pages_free 1191526
  288. Innodb_buffer_pool_pages_made_not_young 0
  289. Innodb_buffer_pool_pages_made_young 90
  290. Innodb_buffer_pool_pages_misc 0
  291. Innodb_buffer_pool_pages_old 84152
  292. Innodb_buffer_pool_pages_total 1419440
  293. Innodb_buffer_pool_pages_lru_flushed 0
  294. Innodb_buffer_pool_read_ahead_rnd 0
  295. Innodb_buffer_pool_read_ahead 0
  296. Innodb_buffer_pool_read_ahead_evicted 0
  297. Innodb_buffer_pool_read_requests 2390172896
  298. Innodb_buffer_pool_reads 201053
  299. Innodb_buffer_pool_wait_free 0
  300. Innodb_buffer_pool_write_requests 633272
  301. Innodb_checkpoint_age 33416061
  302. Innodb_checkpoint_max_age 434155992
  303. Innodb_data_fsyncs 21308
  304. Innodb_data_pending_fsyncs 0
  305. Innodb_data_pending_reads 0
  306. Innodb_data_pending_writes 0
  307. Innodb_data_read 3294052352
  308. Innodb_data_reads 201200
  309. Innodb_data_writes 54636
  310. Innodb_data_written 602451169
  311. Innodb_dblwr_pages_written 11489
  312. Innodb_dblwr_writes 222
  313. Innodb_deadlocks 0
  314. Innodb_history_list_length 0
  315. Innodb_ibuf_discarded_delete_marks 0
  316. Innodb_ibuf_discarded_deletes 0
  317. Innodb_ibuf_discarded_inserts 0
  318. Innodb_ibuf_free_list 2226
  319. Innodb_ibuf_merged_delete_marks 0
  320. Innodb_ibuf_merged_deletes 0
  321. Innodb_ibuf_merged_inserts 0
  322. Innodb_ibuf_merges 0
  323. Innodb_ibuf_segment_size 2228
  324. Innodb_ibuf_size 1
  325. Innodb_log_waits 0
  326. Innodb_log_write_requests 42724
  327. Innodb_log_writes 17644
  328. Innodb_lsn_current 19150598561
  329. Innodb_lsn_flushed 19150598561
  330. Innodb_lsn_last_checkpoint 19117182500
  331. Innodb_master_thread_active_loops 0
  332. Innodb_master_thread_idle_loops 24785
  333. Innodb_max_trx_id 1721689
  334. Innodb_mem_adaptive_hash 0
  335. Innodb_mem_dictionary 140459880
  336. Innodb_os_log_fsyncs 17644
  337. Innodb_os_log_pending_fsyncs 0
  338. Innodb_os_log_pending_writes 0
  339. Innodb_os_log_written 352526848
  340. Innodb_page_size 16384
  341. Innodb_pages_created 26861
  342. Innodb_pages_read 201053
  343. Innodb_pages_written 36770
  344. Innodb_row_lock_current_waits 0
  345. Innodb_row_lock_time 0
  346. Innodb_row_lock_time_avg 0
  347. Innodb_row_lock_time_max 0
  348. Innodb_row_lock_waits 0
  349. Innodb_rows_deleted 0
  350. Innodb_rows_inserted 69105
  351. Innodb_rows_read 931424581
  352. Innodb_rows_updated 12
  353. Innodb_system_rows_deleted 0
  354. Innodb_system_rows_inserted 0
  355. Innodb_system_rows_read 0
  356. Innodb_system_rows_updated 0
  357. Innodb_num_open_files 138
  358. Innodb_truncated_status_writes 0
  359. Innodb_available_undo_logs 128
  360. Innodb_undo_truncations 0
  361. Innodb_page_compression_saved 0
  362. Innodb_num_index_pages_written 0
  363. Innodb_num_non_index_pages_written 0
  364. Innodb_num_pages_page_compressed 0
  365. Innodb_num_page_compressed_trim_op 0
  366. Innodb_num_pages_page_decompressed 0
  367. Innodb_num_pages_page_compression_error 0
  368. Innodb_num_pages_encrypted 0
  369. Innodb_num_pages_decrypted 0
  370. Innodb_have_lz4 OFF
  371. Innodb_have_lzo OFF
  372. Innodb_have_lzma ON
  373. Innodb_have_bzip2 OFF
  374. Innodb_have_snappy OFF
  375. Innodb_have_punch_hole ON
  376. Innodb_defragment_compression_failures 0
  377. Innodb_defragment_failures 0
  378. Innodb_defragment_count 0
  379. Innodb_instant_alter_column 0
  380. Innodb_onlineddl_rowlog_rows 0
  381. Innodb_onlineddl_rowlog_pct_used 0
  382. Innodb_onlineddl_pct_progress 0
  383. Innodb_secondary_index_triggered_cluster_reads 718135797
  384. Innodb_secondary_index_triggered_cluster_reads_avo... 0
  385. Innodb_encryption_rotation_pages_read_from_cache 0
  386. Innodb_encryption_rotation_pages_read_from_disk 0
  387. Innodb_encryption_rotation_pages_modified 0
  388. Innodb_encryption_rotation_pages_flushed 0
  389. Innodb_encryption_rotation_estimated_iops 0
  390. Innodb_encryption_key_rotation_list_length 0
  391. Innodb_encryption_n_merge_blocks_encrypted 0
  392. Innodb_encryption_n_merge_blocks_decrypted 0
  393. Innodb_encryption_n_rowlog_blocks_encrypted 0
  394. Innodb_encryption_n_rowlog_blocks_decrypted 0
  395. Innodb_encryption_n_temp_blocks_encrypted 0
  396. Innodb_encryption_n_temp_blocks_decrypted 0
  397. Innodb_encryption_num_key_requests 0
  398. Key_blocks_not_flushed 0
  399. Key_blocks_unused 214334
  400. Key_blocks_used 0
  401. Key_blocks_warm 0
  402. Key_read_requests 0
  403. Key_reads 0
  404. Key_write_requests 0
  405. Key_writes 0
  406. Last_query_cost 0.000000
  407. Master_gtid_wait_count 0
  408. Master_gtid_wait_time 0
  409. Master_gtid_wait_timeouts 0
  410. Max_statement_time_exceeded 0
  411. Max_used_connections 297
  412. Memory_used 110929136
  413. Memory_used_initial 60586560
  414. Not_flushed_delayed_rows 0
  415. Open_files 31
  416. Open_streams 4
  417. Open_table_definitions 154
  418. Open_tables 605
  419. Opened_files 237
  420. Opened_plugin_libraries 0
  421. Opened_table_definitions 153
  422. Opened_tables 611
  423. Opened_views 0
  424. Performance_schema_accounts_lost 0
  425. Performance_schema_cond_classes_lost 0
  426. Performance_schema_cond_instances_lost 0
  427. Performance_schema_digest_lost 0
  428. Performance_schema_file_classes_lost 0
  429. Performance_schema_file_handles_lost 0
  430. Performance_schema_file_instances_lost 0
  431. Performance_schema_hosts_lost 0
  432. Performance_schema_index_stat_lost 0
  433. Performance_schema_locker_lost 0
  434. Performance_schema_memory_classes_lost 0
  435. Performance_schema_metadata_lock_lost 0
  436. Performance_schema_mutex_classes_lost 0
  437. Performance_schema_mutex_instances_lost 0
  438. Performance_schema_nested_statement_lost 0
  439. Performance_schema_prepared_statements_lost 0
  440. Performance_schema_program_lost 0
  441. Performance_schema_rwlock_classes_lost 0
  442. Performance_schema_rwlock_instances_lost 0
  443. Performance_schema_session_connect_attrs_lost 0
  444. Performance_schema_socket_classes_lost 0
  445. Performance_schema_socket_instances_lost 0
  446. Performance_schema_stage_classes_lost 0
  447. Performance_schema_statement_classes_lost 0
  448. Performance_schema_table_handles_lost 0
  449. Performance_schema_table_instances_lost 0
  450. Performance_schema_table_lock_stat_lost 0
  451. Performance_schema_thread_classes_lost 0
  452. Performance_schema_thread_instances_lost 0
  453. Performance_schema_users_lost 0
  454. Prepared_stmt_count 0
  455. Qcache_free_blocks 0
  456. Qcache_free_memory 0
  457. Qcache_hits 0
  458. Qcache_inserts 0
  459. Qcache_lowmem_prunes 0
  460. Qcache_not_cached 0
  461. Qcache_queries_in_cache 0
  462. Qcache_total_blocks 0
  463. Queries 67949445
  464. Questions 67949445
  465. Rows_read 931423414
  466. Rows_sent 60873778
  467. Rows_tmp_read 398411371
  468. Rpl_semi_sync_master_clients 0
  469. Rpl_semi_sync_master_get_ack 0
  470. Rpl_semi_sync_master_net_avg_wait_time 0
  471. Rpl_semi_sync_master_net_wait_time 0
  472. Rpl_semi_sync_master_net_waits 0
  473. Rpl_semi_sync_master_no_times 0
  474. Rpl_semi_sync_master_no_tx 0
  475. Rpl_semi_sync_master_request_ack 0
  476. Rpl_semi_sync_master_status OFF
  477. Rpl_semi_sync_master_timefunc_failures 0
  478. Rpl_semi_sync_master_tx_avg_wait_time 0
  479. Rpl_semi_sync_master_tx_wait_time 0
  480. Rpl_semi_sync_master_tx_waits 0
  481. Rpl_semi_sync_master_wait_pos_backtraverse 0
  482. Rpl_semi_sync_master_wait_sessions 0
  483. Rpl_semi_sync_master_yes_tx 0
  484. Rpl_semi_sync_slave_send_ack 0
  485. Rpl_semi_sync_slave_status OFF
  486. Rpl_status AUTH_MASTER
  487. Rpl_transactions_multi_engine 0
  488. Select_full_join 21
  489. Select_full_range_join 0
  490. Select_range 3867377
  491. Select_range_check 0
  492. Select_scan 578
  493. Slave_connections 0
  494. Slave_heartbeat_period 0.000
  495. Slave_open_temp_tables 0
  496. Slave_received_heartbeats 0
  497. Slave_retried_transactions 0
  498. Slave_running OFF
  499. Slave_skipped_errors 0
  500. Slaves_connected 0
  501. Slaves_running 0
  502. Variable_name Value
  503. Slow_launch_threads 0
  504. Slow_queries 370
  505. Sort_merge_passes 0
  506. Sort_priority_queue_sorts 2497354
  507. Sort_range 0
  508. Sort_rows 2496801
  509. Sort_scan 2497397
  510. Ssl_accept_renegotiates 0
  511. Ssl_accepts 0
  512. Ssl_callback_cache_hits 0
  513. Ssl_cipher
  514. Ssl_cipher_list
  515. Ssl_client_connects 0
  516. Ssl_connect_renegotiates 0
  517. Ssl_ctx_verify_depth 0
  518. Ssl_ctx_verify_mode 0
  519. Ssl_default_timeout 0
  520. Ssl_finished_accepts 0
  521. Ssl_finished_connects 0
  522. Ssl_server_not_after
  523. Ssl_server_not_before
  524. Ssl_session_cache_hits 0
  525. Ssl_session_cache_misses 0
  526. Ssl_session_cache_mode NONE
  527. Ssl_session_cache_overflows 0
  528. Ssl_session_cache_size 0
  529. Ssl_session_cache_timeouts 0
  530. Ssl_sessions_reused 0
  531. Ssl_used_session_cache_entries 0
  532. Ssl_verify_depth 0
  533. Ssl_verify_mode 0
  534. Ssl_version
  535. Subquery_cache_hit 0
  536. Subquery_cache_miss 0
  537. Syncs 15
  538. Table_locks_immediate 262
  539. Table_locks_waited 0
  540. Table_open_cache_active_instances 2
  541. Table_open_cache_hits 61370711
  542. Table_open_cache_misses 911982
  543. Table_open_cache_overflows 0
  544. Tc_log_max_pages_used 0
  545. Tc_log_page_size 0
  546. Tc_log_page_waits 0
  547. Threadpool_idle_threads 0
  548. Threadpool_threads 0
  549. Threads_cached 185
  550. Threads_connected 112
  551. Threads_created 297
  552. Threads_running 1
  553. Transactions_gtid_foreign_engine 0
  554. Transactions_multi_engine 0
  555. Update_scan 0
  556. Uptime 26144
  557. Uptime_since_flush_status 26144
  558. wsrep 0
  559. wsrep_applier_thread_count 0
  560. wsrep_cluster_capabilities
  561. wsrep_cluster_conf_id 1,84467E+19
  562. wsrep_cluster_size 0
  563. wsrep_cluster_state_uuid
  564. wsrep_cluster_status Disconnected
  565. wsrep_connected OFF
  566. wsrep_local_bf_aborts 0
  567. wsrep_local_index 1,84467E+19
  568. wsrep_provider_capabilities
  569. wsrep_provider_name
  570. wsrep_provider_vendor
  571. wsrep_provider_version
  572. wsrep_ready OFF
  573. wsrep_rollbacker_thread_count 0
  574. wsrep_thread_count 0
  575.  
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement