Advertisement
Guest User

Untitled

a guest
Jul 11th, 2022
387
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 15.08 KB | None | 0 0
  1. Variable_name,Value
  2. Aborted_clients,156
  3. Aborted_connects,0
  4. Aborted_connects_preauth,0
  5. Access_denied_errors,0
  6. Acl_column_grants,6
  7. Acl_database_grants,9
  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,1
  13. Acl_role_grants,0
  14. Acl_roles,0
  15. Acl_table_grants,37
  16. Acl_users,16
  17. Aria_pagecache_blocks_not_flushed,1
  18. Aria_pagecache_blocks_unused,15559
  19. Aria_pagecache_blocks_used,15647
  20. Aria_pagecache_read_requests,525599284
  21. Aria_pagecache_reads,13879
  22. Aria_pagecache_write_requests,183951524
  23. Aria_pagecache_writes,1343994
  24. Aria_transaction_log_syncs,185
  25. Binlog_commits,3713783
  26. Binlog_group_commits,3711646
  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,mysql-bin-changelog.1267097
  31. Binlog_snapshot_position,43837957
  32. Binlog_bytes_written,4565924444
  33. Binlog_cache_disk_use,3301
  34. Binlog_cache_use,3713782
  35. Binlog_stmt_cache_disk_use,0
  36. Binlog_stmt_cache_use,0
  37. Busy_time,141851.611065
  38. Bytes_received,45398387884
  39. Bytes_sent,201942688516
  40. Column_compressions,0
  41. Column_decompressions,0
  42. Com_admin_commands,16688
  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,113876
  58. Com_binlog,0
  59. Com_call_procedure,1
  60. Com_change_db,25098
  61. Com_change_master,0
  62. Com_check,0
  63. Com_checksum,0
  64. Com_commit,113883
  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,1096
  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,21
  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,534665
  113. Com_insert_select,0
  114. Com_install_plugin,0
  115. Com_kill,4
  116. Com_load,0
  117. Com_lock_tables,0
  118. Com_optimize,0
  119. Com_preload_keys,0
  120. Com_prepare_sql,0
  121. Com_purge,21
  122. Com_purge_before_date,0
  123. Com_release_savepoint,0
  124. Com_rename_table,0
  125. Com_rename_user,0
  126. Com_repair,0
  127. Com_replace,328
  128. Com_replace_select,0
  129. Com_reset,0
  130. Com_resignal,0
  131. Com_revoke,0
  132. Com_revoke_all,0
  133. Com_revoke_role,0
  134. Com_rollback,0
  135. Com_rollback_to_savepoint,0
  136. Com_savepoint,0
  137. Com_select,39746850
  138. Com_set_option,50291
  139. Com_show_authors,0
  140. Com_show_binlog_events,0
  141. Com_show_binlogs,0
  142. Com_show_charsets,40
  143. Com_show_collations,2
  144. Com_show_contributors,0
  145. Com_show_create_db,0
  146. Com_show_create_event,0
  147. Com_show_create_func,0
  148. Com_show_create_package,0
  149. Com_show_create_package_body,0
  150. Com_show_create_proc,0
  151. Com_show_create_table,2
  152. Com_show_create_trigger,0
  153. Com_show_create_user,0
  154. Com_show_databases,2
  155. Com_show_engine_logs,0
  156. Com_show_engine_mutex,0
  157. Com_show_engine_status,0
  158. Com_show_errors,0
  159. Com_show_events,0
  160. Com_show_explain,0
  161. Com_show_fields,570
  162. Com_show_function_status,2
  163. Com_show_generic,0
  164. Com_show_grants,0
  165. Com_show_keys,44
  166. Com_show_binlog_status,0
  167. Com_show_open_tables,0
  168. Com_show_package_status,0
  169. Com_show_package_body_status,0
  170. Com_show_plugins,0
  171. Com_show_privileges,0
  172. Com_show_procedure_status,2
  173. Com_show_processlist,10
  174. Com_show_profile,0
  175. Com_show_profiles,0
  176. Com_show_relaylog_events,0
  177. Com_show_slave_hosts,0
  178. Com_show_slave_status,0
  179. Com_show_status,160
  180. Com_show_storage_engines,2
  181. Com_show_table_status,3
  182. Com_show_tables,3
  183. Com_show_triggers,0
  184. Com_show_variables,161
  185. Com_show_warnings,0
  186. Com_shutdown,0
  187. Com_signal,0
  188. Com_start_all_slaves,0
  189. Com_start_slave,0
  190. Com_stmt_close,45513985
  191. Com_stmt_execute,45520726
  192. Com_stmt_fetch,0
  193. Com_stmt_prepare,45514116
  194. Com_stmt_reprepare,0
  195. Com_stmt_reset,0
  196. Com_stmt_send_long_data,0
  197. Com_stop_all_slaves,0
  198. Com_stop_slave,0
  199. Com_truncate,0
  200. Com_uninstall_plugin,0
  201. Com_unlock_tables,0
  202. Com_update,6362676
  203. Com_update_multi,175
  204. Com_xa_commit,0
  205. Com_xa_end,0
  206. Com_xa_prepare,0
  207. Com_xa_recover,0
  208. Com_xa_rollback,0
  209. Com_xa_start,0
  210. Compression,OFF
  211. Connection_errors_accept,0
  212. Connection_errors_internal,0
  213. Connection_errors_max_connections,0
  214. Connection_errors_peer_address,0
  215. Connection_errors_select,0
  216. Connection_errors_tcpwrap,0
  217. Connections,1195411
  218. Cpu_time,116094.495752
  219. Created_tmp_disk_tables,3313811
  220. Created_tmp_files,1571
  221. Created_tmp_tables,7269073
  222. Delayed_errors,0
  223. Delayed_insert_threads,0
  224. Delayed_writes,0
  225. Delete_scan,390
  226. Empty_queries,3200960
  227. Executed_events,0
  228. Executed_triggers,0
  229. Feature_application_time_periods,0
  230. Feature_check_constraint,1
  231. Feature_custom_aggregate_functions,0
  232. Feature_delay_key_write,0
  233. Feature_dynamic_columns,0
  234. Feature_fulltext,0
  235. Feature_gis,0
  236. Feature_insert_returning,0
  237. Feature_invisible_columns,0
  238. Feature_json,25
  239. Feature_locale,0
  240. Feature_subquery,715806
  241. Feature_system_versioning,0
  242. Feature_timezone,131327504
  243. Feature_trigger,5
  244. Feature_window_functions,0
  245. Feature_xml,0
  246. Handler_commit,49299916
  247. Handler_delete,4535
  248. Handler_discover,2
  249. Handler_external_lock,0
  250. Handler_icp_attempts,19808135292
  251. Handler_icp_match,9720760433
  252. Handler_mrr_init,0
  253. Handler_mrr_key_refills,0
  254. Handler_mrr_rowid_refills,0
  255. Handler_prepare,7497682
  256. Handler_read_first,26098
  257. Handler_read_key,1572295654
  258. Handler_read_last,118
  259. Handler_read_next,25144767855
  260. Handler_read_prev,36693
  261. Handler_read_retry,1879
  262. Handler_read_rnd,197513476
  263. Handler_read_rnd_deleted,51505
  264. Handler_read_rnd_next,11750126556
  265. Handler_rollback,40
  266. Handler_savepoint,0
  267. Handler_savepoint_rollback,0
  268. Handler_tmp_delete,0
  269. Handler_tmp_update,433936305
  270. Handler_tmp_write,501690115
  271. Handler_update,10251684
  272. Handler_write,194641487
  273. Innodb_adaptive_hash_hash_searches,0
  274. Innodb_adaptive_hash_non_hash_searches,0
  275. Innodb_background_log_sync,6361
  276. Innodb_buffer_pool_dump_status,
  277. Innodb_buffer_pool_load_status,"Buffer pool(s) load completed at 220711 13:46:50"
  278. Innodb_buffer_pool_resize_status,
  279. Innodb_buffer_pool_load_incomplete,OFF
  280. Innodb_buffer_pool_pages_data,12171145
  281. Innodb_buffer_pool_bytes_data,146726150144
  282. Innodb_buffer_pool_pages_dirty,53936
  283. Innodb_buffer_pool_bytes_dirty,640688128
  284. Innodb_buffer_pool_pages_flushed,714721
  285. Innodb_buffer_pool_pages_free,0
  286. Innodb_buffer_pool_pages_made_not_young,252307450
  287. Innodb_buffer_pool_pages_made_young,12779377
  288. Innodb_buffer_pool_pages_misc,18446744073706336119
  289. Innodb_buffer_pool_pages_old,4492844
  290. Innodb_buffer_pool_pages_total,8955648
  291. Innodb_buffer_pool_pages_lru_flushed,0
  292. Innodb_buffer_pool_pages_lru_freed,0
  293. Innodb_buffer_pool_read_ahead_rnd,0
  294. Innodb_buffer_pool_read_ahead,1050
  295. Innodb_buffer_pool_read_ahead_evicted,0
  296. Innodb_buffer_pool_read_requests,75636573206
  297. Innodb_buffer_pool_reads,12111528
  298. Innodb_buffer_pool_wait_free,0
  299. Innodb_buffer_pool_write_requests,866128357
  300. Innodb_checkpoint_age,1698793234
  301. Innodb_checkpoint_max_age,6957137573
  302. Innodb_data_fsyncs,41177
  303. Innodb_data_pending_fsyncs,0
  304. Innodb_data_pending_reads,0
  305. Innodb_data_pending_writes,0
  306. Innodb_data_read,113747501056
  307. Innodb_data_reads,12170152
  308. Innodb_data_writes,727258
  309. Innodb_data_written,6969337293
  310. Innodb_dblwr_pages_written,615885
  311. Innodb_dblwr_writes,4918
  312. Innodb_deadlocks,0
  313. Innodb_history_list_length,12393
  314. Innodb_ibuf_discarded_delete_marks,0
  315. Innodb_ibuf_discarded_deletes,0
  316. Innodb_ibuf_discarded_inserts,0
  317. Innodb_ibuf_free_list,2525903
  318. Innodb_ibuf_merged_delete_marks,0
  319. Innodb_ibuf_merged_deletes,0
  320. Innodb_ibuf_merged_inserts,0
  321. Innodb_ibuf_merges,0
  322. Innodb_ibuf_segment_size,2525905
  323. Innodb_ibuf_size,1
  324. Innodb_log_waits,0
  325. Innodb_log_write_requests,29835824
  326. Innodb_log_writes,7619
  327. Innodb_lsn_current,461969500542765
  328. Innodb_lsn_flushed,461969498168489
  329. Innodb_lsn_last_checkpoint,461967801749531
  330. Innodb_master_thread_active_loops,0
  331. Innodb_master_thread_idle_loops,6361
  332. Innodb_max_trx_id,276735445076
  333. Innodb_mem_adaptive_hash,0
  334. Innodb_mem_dictionary,880408440
  335. Innodb_os_log_fsyncs,6978
  336. Innodb_os_log_pending_fsyncs,0
  337. Innodb_os_log_pending_writes,0
  338. Innodb_os_log_written,61427831296
  339. Innodb_page_size,16384
  340. Innodb_pages_created,139415
  341. Innodb_pages_read,12130916
  342. Innodb_pages_written,714721
  343. Innodb_row_lock_current_waits,1
  344. Innodb_row_lock_time,9021
  345. Innodb_row_lock_time_avg,0
  346. Innodb_row_lock_time_max,17
  347. Innodb_row_lock_waits,10170
  348. Innodb_rows_deleted,4535
  349. Innodb_rows_inserted,496669
  350. Innodb_rows_read,37060256398
  351. Innodb_rows_updated,10251663
  352. Innodb_system_rows_deleted,0
  353. Innodb_system_rows_inserted,0
  354. Innodb_system_rows_read,726
  355. Innodb_system_rows_updated,21
  356. Innodb_num_open_files,286
  357. Innodb_truncated_status_writes,0
  358. Innodb_available_undo_logs,128
  359. Innodb_undo_truncations,0
  360. Innodb_page_compression_saved,0
  361. Innodb_num_pages_page_compressed,0
  362. Innodb_num_page_compressed_trim_op,0
  363. Innodb_num_pages_page_decompressed,0
  364. Innodb_num_pages_page_compression_error,0
  365. Innodb_num_pages_encrypted,0
  366. Innodb_num_pages_decrypted,0
  367. Innodb_have_lz4,OFF
  368. Innodb_have_lzo,OFF
  369. Innodb_have_lzma,ON
  370. Innodb_have_bzip2,OFF
  371. Innodb_have_snappy,OFF
  372. Innodb_have_punch_hole,ON
  373. Innodb_defragment_compression_failures,0
  374. Innodb_defragment_failures,0
  375. Innodb_defragment_count,0
  376. Innodb_instant_alter_column,0
  377. Innodb_onlineddl_rowlog_rows,0
  378. Innodb_onlineddl_rowlog_pct_used,0
  379. Innodb_onlineddl_pct_progress,0
  380. Innodb_secondary_index_triggered_cluster_reads,13922463720
  381. Innodb_secondary_index_triggered_cluster_reads_avoided,0
  382. Innodb_encryption_rotation_pages_read_from_cache,0
  383. Innodb_encryption_rotation_pages_read_from_disk,0
  384. Innodb_encryption_rotation_pages_modified,0
  385. Innodb_encryption_rotation_pages_flushed,0
  386. Innodb_encryption_rotation_estimated_iops,0
  387. Innodb_encryption_n_merge_blocks_encrypted,0
  388. Innodb_encryption_n_merge_blocks_decrypted,0
  389. Innodb_encryption_n_rowlog_blocks_encrypted,0
  390. Innodb_encryption_n_rowlog_blocks_decrypted,0
  391. Innodb_encryption_n_temp_blocks_encrypted,0
  392. Innodb_encryption_n_temp_blocks_decrypted,0
  393. Innodb_encryption_num_key_requests,0
  394. Key_blocks_not_flushed,0
  395. Key_blocks_unused,13389
  396. Key_blocks_used,0
  397. Key_blocks_warm,0
  398. Key_read_requests,0
  399. Key_reads,0
  400. Key_write_requests,0
  401. Key_writes,0
  402. Last_query_cost,0.000000
  403. Master_gtid_wait_count,0
  404. Master_gtid_wait_time,0
  405. Master_gtid_wait_timeouts,0
  406. Max_statement_time_exceeded,0
  407. Max_used_connections,267
  408. Memory_used,150838448
  409. Memory_used_initial,16343792
  410. Not_flushed_delayed_rows,0
  411. Open_files,67
  412. Open_streams,4
  413. Open_table_definitions,309
  414. Open_tables,1822
  415. Opened_files,13256652
  416. Opened_plugin_libraries,1
  417. Opened_table_definitions,303
  418. Opened_tables,1828
  419. Opened_views,35
  420. Performance_schema_accounts_lost,0
  421. Performance_schema_cond_classes_lost,0
  422. Performance_schema_cond_instances_lost,0
  423. Performance_schema_digest_lost,0
  424. Performance_schema_file_classes_lost,0
  425. Performance_schema_file_handles_lost,0
  426. Performance_schema_file_instances_lost,0
  427. Performance_schema_hosts_lost,0
  428. Performance_schema_index_stat_lost,0
  429. Performance_schema_locker_lost,0
  430. Performance_schema_memory_classes_lost,0
  431. Performance_schema_metadata_lock_lost,0
  432. Performance_schema_mutex_classes_lost,0
  433. Performance_schema_mutex_instances_lost,0
  434. Performance_schema_nested_statement_lost,0
  435. Performance_schema_prepared_statements_lost,0
  436. Performance_schema_program_lost,0
  437. Performance_schema_rwlock_classes_lost,0
  438. Performance_schema_rwlock_instances_lost,0
  439. Performance_schema_session_connect_attrs_lost,0
  440. Performance_schema_socket_classes_lost,0
  441. Performance_schema_socket_instances_lost,0
  442. Performance_schema_stage_classes_lost,0
  443. Performance_schema_statement_classes_lost,0
  444. Performance_schema_table_handles_lost,0
  445. Performance_schema_table_instances_lost,0
  446. Performance_schema_table_lock_stat_lost,0
  447. Performance_schema_thread_classes_lost,0
  448. Performance_schema_thread_instances_lost,0
  449. Performance_schema_users_lost,0
  450. Prepared_stmt_count,50
  451. Qcache_free_blocks,0
  452. Qcache_free_memory,0
  453. Qcache_hits,0
  454. Qcache_inserts,0
  455. Qcache_lowmem_prunes,0
  456. Qcache_not_cached,0
  457. Qcache_queries_in_cache,0
  458. Qcache_total_blocks,0
  459. Queries,139173070
  460. Questions,48144946
  461. Resultset_metadata_skipped,0
  462. Rows_read,30468152136
  463. Rows_sent,422017119
  464. Rows_tmp_read,993110125
  465. Rpl_semi_sync_master_clients,0
  466. Rpl_semi_sync_master_get_ack,0
  467. Rpl_semi_sync_master_net_avg_wait_time,0
  468. Rpl_semi_sync_master_net_wait_time,0
  469. Rpl_semi_sync_master_net_waits,0
  470. Rpl_semi_sync_master_no_times,0
  471. Rpl_semi_sync_master_no_tx,0
  472. Rpl_semi_sync_master_request_ack,0
  473. Rpl_semi_sync_master_status,OFF
  474. Rpl_semi_sync_master_timefunc_failures,0
  475. Rpl_semi_sync_master_tx_avg_wait_time,0
  476. Rpl_semi_sync_master_tx_wait_time,0
  477. Rpl_semi_sync_master_tx_waits,0
  478. Rpl_semi_sync_master_wait_pos_backtraverse,0
  479. Rpl_semi_sync_master_wait_sessions,0
  480. Rpl_semi_sync_master_yes_tx,0
  481. Rpl_semi_sync_slave_send_ack,0
  482. Rpl_semi_sync_slave_status,OFF
  483. Rpl_status,AUTH_MASTER
  484. Rpl_transactions_multi_engine,0
  485. Select_full_join,3866
  486. Select_full_range_join,2006
  487. Select_range,652623
  488. Select_range_check,0
  489. Select_scan,1870691
  490. Slave_connections,0
  491. Slave_heartbeat_period,0.000
  492. Slave_open_temp_tables,0
  493. Slave_received_heartbeats,0
  494. Slave_retried_transactions,0
  495. Slave_running,OFF
  496. Slave_skipped_errors,0
  497. Slaves_connected,0
  498. Slaves_running,0
  499. Slow_launch_threads,0
  500. Slow_queries,627
  501. Sort_merge_passes,306
  502. Sort_priority_queue_sorts,2308340
  503. Sort_range,127831
  504. Sort_rows,106890152
  505. Sort_scan,6236241
  506. Ssl_accept_renegotiates,0
  507. Ssl_accepts,40
  508. Ssl_callback_cache_hits,0
  509. Ssl_cipher,TLS_AES_256_GCM_SHA384
  510. Ssl_cipher_list,TLS_AES_256_GCM_SHA384:TLS_CHACHA20_POLY1305_SHA256:TLS_AES_128_GCM_SHA256:ECDHE-RSA-AES256-GCM-SHA384:ECDHE-RSA-AES128-GCM-SHA256:ECDHE-RSA-AES256-SHA384:ECDHE-RSA-AES128-SHA256:ECDHE-RSA-AES256-SHA:ECDHE-RSA-AES128-SHA:AES256-GCM-SHA384:AES128-GCM-SHA256:AES256-SHA:AES128-SHA:DHE-RSA-AES128-SHA:DHE-RSA-AES256-SHA:DHE-DSS-AES128-SHA:DHE-DSS-AES256-SHA
  511. Ssl_client_connects,0
  512. Ssl_connect_renegotiates,0
  513. Ssl_ctx_verify_depth,18446744073709551615
  514. Ssl_ctx_verify_mode,5
  515. Ssl_default_timeout,7200
  516. Ssl_finished_accepts,40
  517. Ssl_finished_connects,0
  518. Ssl_server_not_after,"Aug 22 17:08:50 2024 GMT"
  519. Ssl_server_not_before,"Jul 5 21:41:56 2022 GMT"
  520. Ssl_session_cache_hits,0
  521. Ssl_session_cache_misses,0
  522. Ssl_session_cache_mode,SERVER
  523. Ssl_session_cache_overflows,0
  524. Ssl_session_cache_size,128
  525. Ssl_session_cache_timeouts,0
  526. Ssl_sessions_reused,0
  527. Ssl_used_session_cache_entries,0
  528. Ssl_verify_depth,18446744073709551615
  529. Ssl_verify_mode,5
  530. Ssl_version,TLSv1.3
  531. Subquery_cache_hit,0
  532. Subquery_cache_miss,4869
  533. Syncs,659
  534. Table_locks_immediate,1016
  535. Table_locks_waited,0
  536. Table_open_cache_active_instances,2
  537. Table_open_cache_hits,118753112
  538. Table_open_cache_misses,109408
  539. Table_open_cache_overflows,0
  540. Tc_log_max_pages_used,0
  541. Tc_log_page_size,0
  542. Tc_log_page_waits,0
  543. Threadpool_idle_threads,0
  544. Threadpool_threads,0
  545. Threads_cached,14
  546. Threads_connected,253
  547. Threads_created,267
  548. Threads_running,8
  549. Transactions_gtid_foreign_engine,0
  550. Transactions_multi_engine,0
  551. Update_scan,23903
  552. Uptime,6521
  553. Uptime_since_flush_status,6521
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement