API tools faq
paste
Advertisement
Guest User

dba.stackexchange.com/questions/339659 (2)

a guest
May 26th, 2024
97
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 151.77 KB | None | 0 0
raw download clone embed print report
  1. =========================MySQL 5.7=========================
  2. mysql> SHOW GLOBAL STATUS;
  3. +--------------------------------------------------------------+
  4. | Variable_name | Value
  5. +--------------------------------------------------------------+
  6. | Aborted_clients | 0
  7. | Aborted_connects | 0
  8. | Binlog_snapshot_file |
  9. | Binlog_snapshot_position | 0
  10. | Binlog_cache_disk_use | 0
  11. | Binlog_cache_use | 0
  12. | Binlog_snapshot_gtid_executed |
  13. | Binlog_stmt_cache_disk_use | 0
  14. | Binlog_stmt_cache_use | 0
  15. | Bytes_received | 1769
  16. | Bytes_sent | 36591
  17. | Com_admin_commands | 0
  18. | Com_assign_to_keycache | 0
  19. | Com_alter_db | 0
  20. | Com_alter_db_upgrade | 0
  21. | Com_alter_event | 0
  22. | Com_alter_function | 0
  23. | Com_alter_instance | 0
  24. | Com_alter_procedure | 0
  25. | Com_alter_server | 0
  26. | Com_alter_table | 0
  27. | Com_alter_tablespace | 0
  28. | Com_alter_user | 0
  29. | Com_analyze | 0
  30. | Com_begin | 0
  31. | Com_binlog | 0
  32. | Com_call_procedure | 0
  33. | Com_change_db | 0
  34. | Com_change_master | 0
  35. | Com_change_repl_filter | 0
  36. | Com_check | 0
  37. | Com_checksum | 0
  38. | Com_commit | 0
  39. | Com_create_compression_dictionary | 0
  40. | Com_create_db | 1
  41. | Com_create_event | 0
  42. | Com_create_function | 0
  43. | Com_create_index | 0
  44. | Com_create_procedure | 0
  45. | Com_create_server | 0
  46. | Com_create_table | 1
  47. | Com_create_trigger | 0
  48. | Com_create_udf | 0
  49. | Com_create_user | 0
  50. | Com_create_view | 0
  51. | Com_dealloc_sql | 0
  52. | Com_delete | 0
  53. | Com_delete_multi | 0
  54. | Com_do | 0
  55. | Com_drop_compression_dictionary | 0
  56. | Com_drop_db | 0
  57. | Com_drop_event | 0
  58. | Com_drop_function | 0
  59. | Com_drop_index | 0
  60. | Com_drop_procedure | 0
  61. | Com_drop_server | 0
  62. | Com_drop_table | 0
  63. | Com_drop_trigger | 0
  64. | Com_drop_user | 0
  65. | Com_drop_view | 0
  66. | Com_empty_query | 0
  67. | Com_execute_sql | 0
  68. | Com_explain_other | 0
  69. | Com_flush | 0
  70. | Com_get_diagnostics | 0
  71. | Com_grant | 0
  72. | Com_ha_close | 0
  73. | Com_ha_open | 0
  74. | Com_ha_read | 0
  75. | Com_help | 0
  76. | Com_insert | 1
  77. | Com_insert_select | 0
  78. | Com_install_plugin | 0
  79. | Com_kill | 0
  80. | Com_load | 0
  81. | Com_lock_tables | 0
  82. | Com_lock_tables_for_backup | 0
  83. | Com_lock_binlog_for_backup | 0
  84. | Com_optimize | 0
  85. | Com_preload_keys | 0
  86. | Com_prepare_sql | 0
  87. | Com_purge | 0
  88. | Com_purge_before_date | 0
  89. | Com_release_savepoint | 0
  90. | Com_rename_table | 0
  91. | Com_rename_user | 0
  92. | Com_repair | 0
  93. | Com_replace | 0
  94. | Com_replace_select | 0
  95. | Com_reset | 0
  96. | Com_resignal | 0
  97. | Com_revoke | 0
  98. | Com_revoke_all | 0
  99. | Com_rollback | 0
  100. | Com_rollback_to_savepoint | 0
  101. | Com_savepoint | 0
  102. | Com_select | 6
  103. | Com_set_option | 1
  104. | Com_signal | 0
  105. | Com_show_binlog_events | 0
  106. | Com_show_binlogs | 0
  107. | Com_show_charsets | 0
  108. | Com_show_client_statistics | 0
  109. | Com_show_collations | 0
  110. | Com_show_create_db | 1
  111. | Com_show_create_event | 0
  112. | Com_show_create_func | 0
  113. | Com_show_create_proc | 0
  114. | Com_show_create_table | 1
  115. | Com_show_create_trigger | 0
  116. | Com_show_databases | 0
  117. | Com_show_engine_logs | 0
  118. | Com_show_engine_mutex | 0
  119. | Com_show_engine_status | 0
  120. | Com_show_events | 0
  121. | Com_show_errors | 0
  122. | Com_show_fields | 0
  123. | Com_show_function_code | 0
  124. | Com_show_function_status | 0
  125. | Com_show_grants | 0
  126. | Com_show_index_statistics | 0
  127. | Com_show_keys | 0
  128. | Com_show_master_status | 0
  129. | Com_show_open_tables | 0
  130. | Com_show_plugins | 0
  131. | Com_show_privileges | 0
  132. | Com_show_procedure_code | 0
  133. | Com_show_procedure_status | 0
  134. | Com_show_processlist | 0
  135. | Com_show_profile | 0
  136. | Com_show_profiles | 0
  137. | Com_show_relaylog_events | 0
  138. | Com_show_slave_hosts | 0
  139. | Com_show_slave_status | 0
  140. | Com_show_status | 4
  141. | Com_show_storage_engines | 0
  142. | Com_show_table_statistics | 0
  143. | Com_show_table_status | 0
  144. | Com_show_tables | 0
  145. | Com_show_thread_statistics | 0
  146. | Com_show_triggers | 0
  147. | Com_show_user_statistics | 0
  148. | Com_show_variables | 4
  149. | Com_show_warnings | 1
  150. | Com_show_create_user | 0
  151. | Com_shutdown | 0
  152. | Com_slave_start | 0
  153. | Com_slave_stop | 0
  154. | Com_group_replication_start | 0
  155. | Com_group_replication_stop | 0
  156. | Com_stmt_execute | 0
  157. | Com_stmt_close | 0
  158. | Com_stmt_fetch | 0
  159. | Com_stmt_prepare | 0
  160. | Com_stmt_reset | 0
  161. | Com_stmt_send_long_data | 0
  162. | Com_truncate | 0
  163. | Com_uninstall_plugin | 0
  164. | Com_unlock_binlog | 0
  165. | Com_unlock_tables | 0
  166. | Com_update | 0
  167. | Com_update_multi | 0
  168. | Com_xa_commit | 0
  169. | Com_xa_end | 0
  170. | Com_xa_prepare | 0
  171. | Com_xa_recover | 0
  172. | Com_xa_rollback | 0
  173. | Com_xa_start | 0
  174. | Com_stmt_reprepare | 0
  175. | Connection_errors_accept | 0
  176. | Connection_errors_internal | 0
  177. | Connection_errors_max_connections | 0
  178. | Connection_errors_peer_address | 0
  179. | Connection_errors_select | 0
  180. | Connection_errors_tcpwrap | 0
  181. | Connections | 7
  182. | Created_tmp_disk_tables | 0
  183. | Created_tmp_files | 6
  184. | Created_tmp_tables | 8
  185. | Delayed_errors | 0
  186. | Delayed_insert_threads | 0
  187. | Delayed_writes | 0
  188. | Flush_commands | 1
  189. | Handler_commit | 7
  190. | Handler_delete | 0
  191. | Handler_discover | 0
  192. | Handler_external_lock | 61
  193. | Handler_mrr_init | 0
  194. | Handler_prepare | 0
  195. | Handler_read_first | 9
  196. | Handler_read_key | 7
  197. | Handler_read_last | 0
  198. | Handler_read_next | 2
  199. | Handler_read_prev | 0
  200. | Handler_read_rnd | 0
  201. | Handler_read_rnd_next | 7288
  202. | Handler_rollback | 0
  203. | Handler_savepoint | 0
  204. | Handler_savepoint_rollback | 0
  205. | Handler_update | 0
  206. | Handler_write | 3623
  207. | Innodb_background_log_sync | 93641
  208. | Innodb_buffer_pool_dump_status | Dumping of buffer pool not started
  209. | Innodb_buffer_pool_load_status | Buffer pool(s) load completed at 240525 8:48:23
  210. | Innodb_buffer_pool_resize_status |
  211. | Innodb_buffer_pool_pages_data | 442
  212. | Innodb_buffer_pool_bytes_data | 7241728
  213. | Innodb_buffer_pool_pages_dirty | 0
  214. | Innodb_buffer_pool_bytes_dirty | 0
  215. | Innodb_buffer_pool_pages_flushed | 59
  216. | Innodb_buffer_pool_pages_free | 7749
  217. | Innodb_buffer_pool_pages_LRU_flushed | 0
  218. | Innodb_buffer_pool_pages_made_not_young | 0
  219. | Innodb_buffer_pool_pages_made_young | 0
  220. | Innodb_buffer_pool_pages_misc | 0
  221. | Innodb_buffer_pool_pages_old | 0
  222. | Innodb_buffer_pool_pages_total | 8191
  223. | Innodb_buffer_pool_read_ahead_rnd | 0
  224. | Innodb_buffer_pool_read_ahead | 0
  225. | Innodb_buffer_pool_read_ahead_evicted | 0
  226. | Innodb_buffer_pool_read_requests | 95042
  227. | Innodb_buffer_pool_reads | 404
  228. | Innodb_buffer_pool_wait_free | 0
  229. | Innodb_buffer_pool_write_requests | 386
  230. | Innodb_checkpoint_age | 9
  231. | Innodb_checkpoint_max_age | 80826164
  232. | Innodb_data_fsyncs | 32
  233. | Innodb_data_pending_fsyncs | 0
  234. | Innodb_data_pending_reads | 0
  235. | Innodb_data_pending_writes | 0
  236. | Innodb_data_read | 6689792
  237. | Innodb_data_reads | 429
  238. | Innodb_data_writes | 98
  239. | Innodb_data_written | 980480
  240. | Innodb_dblwr_pages_written | 25
  241. | Innodb_dblwr_writes | 3
  242. | Innodb_ibuf_free_list | 0
  243. | Innodb_ibuf_segment_size | 2
  244. | Innodb_log_waits | 0
  245. | Innodb_log_write_requests | 11
  246. | Innodb_log_writes | 11
  247. | Innodb_lsn_current | 12448124
  248. | Innodb_lsn_flushed | 12448124
  249. | Innodb_lsn_last_checkpoint | 12448115
  250. | Innodb_master_thread_active_loops | 3
  251. | Innodb_master_thread_idle_loops | 93638
  252. | Innodb_max_trx_id | 1800
  253. | Innodb_mem_adaptive_hash | 2252736
  254. | Innodb_mem_dictionary | 698669
  255. | Innodb_oldest_view_low_limit_trx_id | 0
  256. | Innodb_os_log_fsyncs | 17
  257. | Innodb_os_log_pending_fsyncs | 0
  258. | Innodb_os_log_pending_writes | 0
  259. | Innodb_os_log_written | 10752
  260. | Innodb_page_size | 16384
  261. | Innodb_pages_created | 39
  262. | Innodb_pages_read | 403
  263. | Innodb_pages0_read | 13
  264. | Innodb_pages_written | 59
  265. | Innodb_purge_trx_id | 0
  266. | Innodb_purge_undo_no | 0
  267. | Innodb_row_lock_current_waits | 0
  268. | Innodb_row_lock_time | 0
  269. | Innodb_row_lock_time_avg | 0
  270. | Innodb_row_lock_time_max | 0
  271. | Innodb_row_lock_waits | 0
  272. | Innodb_rows_deleted | 0
  273. | Innodb_rows_inserted | 1
  274. | Innodb_rows_read | 9
  275. | Innodb_rows_updated | 0
  276. | Innodb_num_open_files | 17
  277. | Innodb_truncated_status_writes | 0
  278. | Innodb_available_undo_logs | 128
  279. | Innodb_secondary_index_triggered_cluster_reads | 0
  280. | Innodb_secondary_index_triggered_cluster_reads_avoided | 0
  281. | Innodb_buffered_aio_submitted | 0
  282. | Innodb_scan_pages_contiguous | 0
  283. | Innodb_scan_pages_disjointed | 0
  284. | Innodb_scan_pages_total_seek_distance | 0
  285. | Innodb_scan_data_size | 0
  286. | Innodb_scan_deleted_recs_size | 0
  287. | Innodb_scrub_background_page_reorganizations | 0
  288. | Innodb_scrub_background_page_splits | 0
  289. | Innodb_scrub_background_page_split_failures_underflow | 0
  290. | Innodb_scrub_background_page_split_failures_out_of_filespace | 0
  291. | Innodb_scrub_background_page_split_failures_missing_index | 0
  292. | Innodb_scrub_background_page_split_failures_unknown | 0
  293. | Innodb_scrub_log | 0
  294. | Innodb_encryption_rotation_pages_read_from_cache | 0
  295. | Innodb_encryption_rotation_pages_read_from_disk | 0
  296. | Innodb_encryption_rotation_pages_modified | 0
  297. | Innodb_encryption_rotation_pages_flushed | 0
  298. | Innodb_encryption_rotation_estimated_iops | 0
  299. | Innodb_encryption_key_rotation_list_length | 0
  300. | Innodb_encryption_n_merge_blocks_encrypted | 0
  301. | Innodb_encryption_n_merge_blocks_decrypted | 0
  302. | Innodb_encryption_n_rowlog_blocks_encrypted | 0
  303. | Innodb_encryption_n_rowlog_blocks_decrypted | 0
  304. | Innodb_num_pages_encrypted | 0
  305. | Innodb_num_pages_decrypted | 0
  306. | Innodb_encryption_redo_key_version | 0
  307. | Key_blocks_not_flushed | 0
  308. | Key_blocks_unused | 6695
  309. | Key_blocks_used | 3
  310. | Key_read_requests | 6
  311. | Key_reads | 3
  312. | Key_write_requests | 0
  313. | Key_writes | 0
  314. | Locked_connects | 0
  315. | Max_execution_time_exceeded | 0
  316. | Max_execution_time_set | 0
  317. | Max_execution_time_set_failed | 0
  318. | Max_used_connections | 2
  319. | Max_used_connections_time | 2024-05-26 10:24:54
  320. | Not_flushed_delayed_rows | 0
  321. | Ongoing_anonymous_transaction_count | 0
  322. | Open_files | 14
  323. | Open_streams | 0
  324. | Open_table_definitions | 107
  325. | Open_tables | 104
  326. | Opened_files | 145
  327. | Opened_table_definitions | 108
  328. | Opened_tables | 111
  329. | Performance_schema_accounts_lost | 0
  330. | Performance_schema_cond_classes_lost | 0
  331. | Performance_schema_cond_instances_lost | 0
  332. | Performance_schema_digest_lost | 0
  333. | Performance_schema_file_classes_lost | 0
  334. | Performance_schema_file_handles_lost | 0
  335. | Performance_schema_file_instances_lost | 0
  336. | Performance_schema_hosts_lost | 0
  337. | Performance_schema_index_stat_lost | 0
  338. | Performance_schema_locker_lost | 0
  339. | Performance_schema_memory_classes_lost | 0
  340. | Performance_schema_metadata_lock_lost | 0
  341. | Performance_schema_mutex_classes_lost | 0
  342. | Performance_schema_mutex_instances_lost | 0
  343. | Performance_schema_nested_statement_lost | 0
  344. | Performance_schema_prepared_statements_lost | 0
  345. | Performance_schema_program_lost | 0
  346. | Performance_schema_rwlock_classes_lost | 0
  347. | Performance_schema_rwlock_instances_lost | 0
  348. | Performance_schema_session_connect_attrs_lost | 0
  349. | Performance_schema_socket_classes_lost | 0
  350. | Performance_schema_socket_instances_lost | 0
  351. | Performance_schema_stage_classes_lost | 0
  352. | Performance_schema_statement_classes_lost | 0
  353. | Performance_schema_table_handles_lost | 0
  354. | Performance_schema_table_instances_lost | 0
  355. | Performance_schema_table_lock_stat_lost | 0
  356. | Performance_schema_thread_classes_lost | 0
  357. | Performance_schema_thread_instances_lost | 0
  358. | Performance_schema_users_lost | 0
  359. | Prepared_stmt_count | 0
  360. | Qcache_free_blocks | 1
  361. | Qcache_free_memory | 1031832
  362. | Qcache_hits | 0
  363. | Qcache_inserts | 0
  364. | Qcache_lowmem_prunes | 0
  365. | Qcache_not_cached | 6
  366. | Qcache_queries_in_cache | 0
  367. | Qcache_total_blocks | 1
  368. | Queries | 26
  369. | Questions | 25
  370. | Rsa_public_key | -----BEGIN PUBLIC KEY-----
  371. MIIBIjANBgkqhkiG9w0BAQEFAAOCAQ8AMIIBCgKCAQEAmG/Jsu65tk7XXj6Mm/a5
  372. MUVHbSaJFUNwk3daKv9UvmYUPIXKF2LB92wIIM0a8GxL+GQP5ucU5DIxs8E5HFbi
  373. JXbH0MEg1RmDTdhvpsV0JMTuSWl/nXvUhg+xYXsJexWbnzkdcTA+a3I3aTeo3xBi
  374. tKYB3y4xroi69WPbtST3AxKv8HtwMzE2xhQn+CJlU+NxxTTuAAQUsNUMlc0nVu1m
  375. wJ3wHbxJbAo0+YIL11zvppliHlyIejUlCBjyN0Reh31hGAfibde/SeQAQ+IhG0mc
  376. qY9mahmW1IPbCGtVsI8GmgPtm9z3k3yPF5F7NWW4ausW0c+nP6CWDmPxvAnQcz4d
  377. uQIDAQAB
  378. -----END PUBLIC KEY-----
  379.  
  380. | Select_full_join | 0
  381. | Select_full_range_join | 0
  382. | Select_range | 0
  383. | Select_range_check | 0
  384. | Select_scan | 17
  385. | Slave_open_temp_tables | 0
  386. | Slow_launch_threads | 0
  387. | Slow_queries | 0
  388. | Sort_merge_passes | 0
  389. | Sort_range | 0
  390. | Sort_rows | 0
  391. | Sort_scan | 0
  392. | Ssl_accept_renegotiates | 0
  393. | Ssl_accepts | 0
  394. | Ssl_callback_cache_hits | 0
  395. | Ssl_cipher |
  396. | Ssl_cipher_list |
  397. | Ssl_client_connects | 0
  398. | Ssl_connect_renegotiates | 0
  399. | Ssl_ctx_verify_depth | 18446744073709551615
  400. | Ssl_ctx_verify_mode | 5
  401. | Ssl_default_timeout | 0
  402. | Ssl_finished_accepts | 0
  403. | Ssl_finished_connects | 0
  404. | Ssl_server_not_after | May 23 08:48:16 2034 GMT
  405. | Ssl_server_not_before | May 25 08:48:16 2024 GMT
  406. | Ssl_session_cache_hits | 0
  407. | Ssl_session_cache_misses | 0
  408. | Ssl_session_cache_mode | SERVER
  409. | Ssl_session_cache_overflows | 0
  410. | Ssl_session_cache_size | 128
  411. | Ssl_session_cache_timeouts | 0
  412. | Ssl_sessions_reused | 0
  413. | Ssl_used_session_cache_entries | 0
  414. | Ssl_verify_depth | 0
  415. | Ssl_verify_mode | 0
  416. | Ssl_version |
  417. | Table_locks_immediate | 19
  418. | Table_locks_waited | 0
  419. | Table_open_cache_hits | 9
  420. | Table_open_cache_misses | 111
  421. | Table_open_cache_overflows | 0
  422. | Tc_log_max_pages_used | 0
  423. | Tc_log_page_size | 0
  424. | Tc_log_page_waits | 0
  425. | Threadpool_idle_threads | 0
  426. | Threadpool_threads | 0
  427. | Threads_cached | 1
  428. | Threads_connected | 1
  429. | Threads_created | 2
  430. | Threads_running | 1
  431. | Uptime | 93655
  432. | Uptime_since_flush_status | 93655
  433. +--------------------------------------------------------------+
  434. 418 rows in set (0.00 sec)
  435.  
  436. mysql> SHOW VARIABLES;
  437. +----------------------------------------------------------+
  438. | Variable_name | Value
  439. +----------------------------------------------------------+
  440. | auto_generate_certs | ON
  441. | auto_increment_increment | 1
  442. | auto_increment_offset | 1
  443. | autocommit | ON
  444. | automatic_sp_privileges | ON
  445. | avoid_temporal_upgrade | OFF
  446. | back_log | 80
  447. | basedir | /usr/
  448. | big_tables | OFF
  449. | bind_address | *
  450. | binlog_cache_size | 32768
  451. | binlog_checksum | CRC32
  452. | binlog_direct_non_transactional_updates | OFF
  453. | binlog_error_action | ABORT_SERVER
  454. | binlog_format | ROW
  455. | binlog_group_commit_sync_delay | 0
  456. | binlog_group_commit_sync_no_delay_count | 0
  457. | binlog_gtid_simple_recovery | ON
  458. | binlog_max_flush_queue_time | 0
  459. | binlog_order_commits | ON
  460. | binlog_row_image | FULL
  461. | binlog_rows_query_log_events | OFF
  462. | binlog_skip_flush_commands | OFF
  463. | binlog_space_limit | 0
  464. | binlog_stmt_cache_size | 32768
  465. | binlog_transaction_dependency_history_size | 25000
  466. | binlog_transaction_dependency_tracking | COMMIT_ORDER
  467. | block_encryption_mode | aes-128-ecb
  468. | bulk_insert_buffer_size | 8388608
  469. | character_set_client | utf8mb4
  470. | character_set_connection | utf8mb4
  471. | character_set_database | utf8mb4
  472. | character_set_filesystem | binary
  473. | character_set_results | utf8mb4
  474. | character_set_server | utf8mb4
  475. | character_set_system | utf8
  476. | character_sets_dir | /usr/share/percona-server/charsets/
  477. | check_proxy_users | OFF
  478. | collation_connection | utf8mb4_general_ci
  479. | collation_database | utf8mb4_general_ci
  480. | collation_server | utf8mb4_general_ci
  481. | completion_type | NO_CHAIN
  482. | concurrent_insert | AUTO
  483. | connect_timeout | 10
  484. | core_file | OFF
  485. | csv_mode |
  486. | datadir | /var/lib/mysql/
  487. | date_format | %Y-%m-%d
  488. | datetime_format | %Y-%m-%d %H:%i:%s
  489. | default_authentication_plugin | mysql_native_password
  490. | default_password_lifetime | 0
  491. | default_storage_engine | InnoDB
  492. | default_tmp_storage_engine | InnoDB
  493. | default_week_format | 0
  494. | delay_key_write | ON
  495. | delayed_insert_limit | 100
  496. | delayed_insert_timeout | 300
  497. | delayed_queue_size | 1000
  498. | disabled_storage_engines |
  499. | disconnect_on_expired_password | ON
  500. | div_precision_increment | 4
  501. | encrypt_binlog | OFF
  502. | encrypt_tmp_files | OFF
  503. | end_markers_in_json | OFF
  504. | enforce_gtid_consistency | OFF
  505. | enforce_storage_engine |
  506. | eq_range_index_dive_limit | 200
  507. | error_count | 0
  508. | event_scheduler | OFF
  509. | expand_fast_index_creation | OFF
  510. | expire_logs_days | 0
  511. | explicit_defaults_for_timestamp | OFF
  512. | external_user |
  513. | extra_max_connections | 1
  514. | extra_port | 0
  515. | flush | OFF
  516. | flush_time | 0
  517. | foreign_key_checks | ON
  518. | ft_boolean_syntax | + -><()~*:""&|
  519. | ft_max_word_len | 84
  520. | ft_min_word_len | 4
  521. | ft_query_expansion_limit | 20
  522. | ft_query_extra_word_chars | OFF
  523. | ft_stopword_file | (built-in)
  524. | general_log | OFF
  525. | general_log_file | /var/lib/mysql/a38866324763.log
  526. | group_concat_max_len | 1024
  527. | gtid_executed_compression_period | 1000
  528. | gtid_mode | OFF
  529. | gtid_next | AUTOMATIC
  530. | gtid_owned |
  531. | gtid_purged |
  532. | have_backup_locks | YES
  533. | have_backup_safe_binlog_info | YES
  534. | have_compress | YES
  535. | have_crypt | YES
  536. | have_dynamic_loading | YES
  537. | have_geometry | YES
  538. | have_openssl | YES
  539. | have_profiling | YES
  540. | have_query_cache | YES
  541. | have_rtree_keys | YES
  542. | have_snapshot_cloning | YES
  543. | have_ssl | YES
  544. | have_statement_timeout | YES
  545. | have_symlink | DISABLED
  546. | host_cache_size | 279
  547. | hostname | a38866324763
  548. | identity | 0
  549. | ignore_builtin_innodb | OFF
  550. | ignore_db_dirs |
  551. | init_connect |
  552. | init_file |
  553. | init_slave |
  554. | innodb_adaptive_flushing | ON
  555. | innodb_adaptive_flushing_lwm | 10
  556. | innodb_adaptive_hash_index | ON
  557. | innodb_adaptive_hash_index_parts | 8
  558. | innodb_adaptive_max_sleep_delay | 150000
  559. | innodb_api_bk_commit_interval | 5
  560. | innodb_api_disable_rowlock | OFF
  561. | innodb_api_enable_binlog | OFF
  562. | innodb_api_enable_mdl | OFF
  563. | innodb_api_trx_level | 0
  564. | innodb_autoextend_increment | 64
  565. | innodb_autoinc_lock_mode | 1
  566. | innodb_background_scrub_data_check_interval | 3600
  567. | innodb_background_scrub_data_compressed | OFF
  568. | innodb_background_scrub_data_interval | 604800
  569. | innodb_background_scrub_data_uncompressed | OFF
  570. | innodb_buffer_pool_chunk_size | 134217728
  571. | innodb_buffer_pool_dump_at_shutdown | ON
  572. | innodb_buffer_pool_dump_now | OFF
  573. | innodb_buffer_pool_dump_pct | 25
  574. | innodb_buffer_pool_filename | ib_buffer_pool
  575. | innodb_buffer_pool_in_core_file | ON
  576. | innodb_buffer_pool_instances | 1
  577. | innodb_buffer_pool_load_abort | OFF
  578. | innodb_buffer_pool_load_at_startup | ON
  579. | innodb_buffer_pool_load_now | OFF
  580. | innodb_buffer_pool_size | 134217728
  581. | innodb_change_buffer_max_size | 25
  582. | innodb_change_buffering | all
  583. | innodb_checksum_algorithm | crc32
  584. | innodb_checksums | ON
  585. | innodb_cleaner_lsn_age_factor | high_checkpoint
  586. | innodb_cmp_per_index_enabled | OFF
  587. | innodb_commit_concurrency | 0
  588. | innodb_compressed_columns_threshold | 96
  589. | innodb_compressed_columns_zip_level | 6
  590. | innodb_compression_failure_threshold_pct | 5
  591. | innodb_compression_level | 6
  592. | innodb_compression_pad_pct_max | 50
  593. | innodb_concurrency_tickets | 5000
  594. | innodb_corrupt_table_action | assert
  595. | innodb_data_file_path | ibdata1:12M:autoextend
  596. | innodb_data_home_dir |
  597. | innodb_deadlock_detect | ON
  598. | innodb_default_encryption_key_id | 0
  599. | innodb_default_row_format | dynamic
  600. | innodb_disable_sort_file_cache | OFF
  601. | innodb_doublewrite | ON
  602. | innodb_empty_free_list_algorithm | backoff
  603. | innodb_encrypt_online_alter_logs | OFF
  604. | innodb_encrypt_tables | OFF
  605. | innodb_encryption_rotate_key_age | 1
  606. | innodb_encryption_rotation_iops | 100
  607. | innodb_encryption_threads | 0
  608. | innodb_fast_shutdown | 1
  609. | innodb_file_format | Barracuda
  610. | innodb_file_format_check | ON
  611. | innodb_file_format_max | Barracuda
  612. | innodb_file_per_table | ON
  613. | innodb_fill_factor | 100
  614. | innodb_flush_log_at_timeout | 1
  615. | innodb_flush_log_at_trx_commit | 1
  616. | innodb_flush_method |
  617. | innodb_flush_neighbors | 1
  618. | innodb_flush_sync | ON
  619. | innodb_flushing_avg_loops | 30
  620. | innodb_force_index_records_in_range | 0
  621. | innodb_force_load_corrupted | OFF
  622. | innodb_force_recovery | 0
  623. | innodb_ft_aux_table |
  624. | innodb_ft_cache_size | 8000000
  625. | innodb_ft_enable_diag_print | OFF
  626. | innodb_ft_enable_stopword | ON
  627. | innodb_ft_ignore_stopwords | OFF
  628. | innodb_ft_max_token_size | 84
  629. | innodb_ft_min_token_size | 3
  630. | innodb_ft_num_word_optimize | 2000
  631. | innodb_ft_result_cache_limit | 2000000000
  632. | innodb_ft_server_stopword_table |
  633. | innodb_ft_sort_pll_degree | 2
  634. | innodb_ft_total_cache_size | 640000000
  635. | innodb_ft_user_stopword_table |
  636. | innodb_immediate_scrub_data_uncompressed | OFF
  637. | innodb_io_capacity | 200
  638. | innodb_io_capacity_max | 2000
  639. | innodb_kill_idle_transaction | 0
  640. | innodb_large_prefix | ON
  641. | innodb_lock_wait_timeout | 50
  642. | innodb_locks_unsafe_for_binlog | OFF
  643. | innodb_log_buffer_size | 16777216
  644. | innodb_log_checksums | ON
  645. | innodb_log_compressed_pages | ON
  646. | innodb_log_file_size | 50331648
  647. | innodb_log_files_in_group | 2
  648. | innodb_log_group_home_dir | ./
  649. | innodb_log_write_ahead_size | 8192
  650. | innodb_lru_scan_depth | 1024
  651. | innodb_max_bitmap_file_size | 104857600
  652. | innodb_max_changed_pages | 1000000
  653. | innodb_max_dirty_pages_pct | 75.000000
  654. | innodb_max_dirty_pages_pct_lwm | 0.000000
  655. | innodb_max_purge_lag | 0
  656. | innodb_max_purge_lag_delay | 0
  657. | innodb_max_undo_log_size | 1073741824
  658. | innodb_monitor_disable |
  659. | innodb_monitor_enable |
  660. | innodb_monitor_reset |
  661. | innodb_monitor_reset_all |
  662. | innodb_numa_interleave | OFF
  663. | innodb_old_blocks_pct | 37
  664. | innodb_old_blocks_time | 1000
  665. | innodb_online_alter_log_max_size | 134217728
  666. | innodb_open_files | 2000
  667. | innodb_optimize_fulltext_only | OFF
  668. | innodb_page_cleaners | 1
  669. | innodb_page_size | 16384
  670. | innodb_parallel_dblwr_encrypt | OFF
  671. | innodb_parallel_doublewrite_path | xb_doublewrite
  672. | innodb_print_all_deadlocks | OFF
  673. | innodb_print_lock_wait_timeout_info | OFF
  674. | innodb_purge_batch_size | 300
  675. | innodb_purge_rseg_truncate_frequency | 128
  676. | innodb_purge_threads | 4
  677. | innodb_random_read_ahead | OFF
  678. | innodb_read_ahead_threshold | 56
  679. | innodb_read_io_threads | 4
  680. | innodb_read_only | OFF
  681. | innodb_records_in_range | 0
  682. | innodb_redo_log_encrypt | OFF
  683. | innodb_replication_delay | 0
  684. | innodb_rollback_on_timeout | OFF
  685. | innodb_rollback_segments | 128
  686. | innodb_scrub_log | OFF
  687. | innodb_scrub_log_speed | 256
  688. | innodb_show_locks_held | 10
  689. | innodb_show_verbose_locks | 0
  690. | innodb_sort_buffer_size | 1048576
  691. | innodb_spin_wait_delay | 6
  692. | innodb_stats_auto_recalc | ON
  693. | innodb_stats_include_delete_marked | OFF
  694. | innodb_stats_method | nulls_equal
  695. | innodb_stats_on_metadata | OFF
  696. | innodb_stats_persistent | ON
  697. | innodb_stats_persistent_sample_pages | 20
  698. | innodb_stats_sample_pages | 8
  699. | innodb_stats_transient_sample_pages | 8
  700. | innodb_status_output | OFF
  701. | innodb_status_output_locks | OFF
  702. | innodb_strict_mode | ON
  703. | innodb_support_xa | ON
  704. | innodb_sync_array_size | 1
  705. | innodb_sync_spin_loops | 30
  706. | innodb_sys_tablespace_encrypt | OFF
  707. | innodb_table_locks | ON
  708. | innodb_temp_data_file_path | ibtmp1:12M:autoextend
  709. | innodb_temp_tablespace_encrypt | OFF
  710. | innodb_thread_concurrency | 0
  711. | innodb_thread_sleep_delay | 10000
  712. | innodb_tmpdir |
  713. | innodb_track_changed_pages | OFF
  714. | innodb_undo_directory | ./
  715. | innodb_undo_log_encrypt | OFF
  716. | innodb_undo_log_truncate | OFF
  717. | innodb_undo_logs | 128
  718. | innodb_undo_tablespaces | 0
  719. | innodb_use_global_flush_log_at_trx_commit | ON
  720. | innodb_use_native_aio | ON
  721. | innodb_version | 5.7.44-48
  722. | innodb_write_io_threads | 4
  723. | insert_id | 0
  724. | interactive_timeout | 28800
  725. | internal_tmp_disk_storage_engine | InnoDB
  726. | join_buffer_size | 262144
  727. | keep_files_on_create | OFF
  728. | key_buffer_size | 8388608
  729. | key_cache_age_threshold | 300
  730. | key_cache_block_size | 1024
  731. | key_cache_division_limit | 100
  732. | keyring_operations | ON
  733. | kill_idle_transaction | 0
  734. | large_files_support | ON
  735. | large_page_size | 0
  736. | large_pages | OFF
  737. | last_insert_id | 0
  738. | lc_messages | en_US
  739. | lc_messages_dir | /usr/share/percona-server/
  740. | lc_time_names | en_US
  741. | license | GPL
  742. | local_infile | ON
  743. | lock_wait_timeout | 31536000
  744. | locked_in_memory | OFF
  745. | log_bin | OFF
  746. | log_bin_basename |
  747. | log_bin_index |
  748. | log_bin_trust_function_creators | OFF
  749. | log_bin_use_v1_row_events | OFF
  750. | log_builtin_as_identified_by_password | OFF
  751. | log_error | stderr
  752. | log_error_verbosity | 3
  753. | log_output | FILE
  754. | log_queries_not_using_indexes | OFF
  755. | log_slave_updates | OFF
  756. | log_slow_admin_statements | OFF
  757. | log_slow_filter |
  758. | log_slow_rate_limit | 1
  759. | log_slow_rate_type | session
  760. | log_slow_slave_statements | OFF
  761. | log_slow_sp_statements | ON
  762. | log_slow_verbosity |
  763. | log_statements_unsafe_for_binlog | ON
  764. | log_syslog | OFF
  765. | log_syslog_facility | daemon
  766. | log_syslog_include_pid | ON
  767. | log_syslog_tag |
  768. | log_throttle_queries_not_using_indexes | 0
  769. | log_timestamps | UTC
  770. | log_warnings | 2
  771. | long_query_time | 10.000000
  772. | low_priority_updates | OFF
  773. | lower_case_file_system | OFF
  774. | lower_case_table_names | 0
  775. | master_info_repository | FILE
  776. | master_verify_checksum | OFF
  777. | max_allowed_packet | 4194304
  778. | max_binlog_cache_size | 18446744073709547520
  779. | max_binlog_files | 0
  780. | max_binlog_size | 1073741824
  781. | max_binlog_stmt_cache_size | 18446744073709547520
  782. | max_connect_errors | 100
  783. | max_connections | 151
  784. | max_delayed_threads | 20
  785. | max_digest_length | 1024
  786. | max_error_count | 64
  787. | max_execution_time | 0
  788. | max_heap_table_size | 16777216
  789. | max_insert_delayed_threads | 20
  790. | max_join_size | 18446744073709551615
  791. | max_length_for_sort_data | 1024
  792. | max_points_in_geometry | 65536
  793. | max_prepared_stmt_count | 16382
  794. | max_relay_log_size | 0
  795. | max_seeks_for_key | 18446744073709551615
  796. | max_slowlog_files | 0
  797. | max_slowlog_size | 0
  798. | max_sort_length | 1024
  799. | max_sp_recursion_depth | 0
  800. | max_tmp_tables | 32
  801. | max_user_connections | 0
  802. | max_write_lock_count | 18446744073709551615
  803. | metadata_locks_cache_size | 1024
  804. | metadata_locks_hash_instances | 8
  805. | min_examined_row_limit | 0
  806. | multi_range_count | 256
  807. | myisam_data_pointer_size | 6
  808. | myisam_max_sort_file_size | 9223372036853727232
  809. | myisam_mmap_size | 18446744073709551615
  810. | myisam_recover_options | OFF
  811. | myisam_sort_buffer_size | 8388608
  812. | myisam_stats_method | nulls_unequal
  813. | myisam_use_mmap | OFF
  814. | mysql_native_password_proxy_users | OFF
  815. | net_buffer_length | 16384
  816. | net_read_timeout | 30
  817. | net_retry_count | 10
  818. | net_write_timeout | 60
  819. | new | OFF
  820. | ngram_token_size | 2
  821. | offline_mode | OFF
  822. | old | OFF
  823. | old_alter_table | OFF
  824. | old_passwords | 0
  825. | open_files_limit | 1048576
  826. | optimizer_prune_level | 1
  827. | optimizer_search_depth | 62
  828. | optimizer_switch | index_merge=on,index_merge_union=on,index_merge_sort_union=on,index_merge_intersection=on,engine_condition_pushdown=on,index_condition_pushdown=on,mrr=on,mrr_cost_based=on,block_nested_loop=on,batched_key_access=off,materialization=on,semijoin=on,loosescan=on,firstmatch=on,duplicateweedout=on,subquery_materialization_cost_based=on,use_index_extensions=on,condition_fanout_filter=on,derived_merge=on,prefer_ordering_index=on,favor_range_scan=off
  829. | optimizer_trace | enabled=off,one_line=off
  830. | optimizer_trace_features | greedy_search=on,range_optimizer=on,dynamic_range=on,repeated_subselect=on
  831. | optimizer_trace_limit | 1
  832. | optimizer_trace_max_mem_size | 16384
  833. | optimizer_trace_offset | -1
  834. | parser_max_mem_size | 18446744073709551615
  835. | performance_schema | ON
  836. | performance_schema_accounts_size | -1
  837. | performance_schema_digests_size | 10000
  838. | performance_schema_events_stages_history_long_size | 10000
  839. | performance_schema_events_stages_history_size | 10
  840. | performance_schema_events_statements_history_long_size | 10000
  841. | performance_schema_events_statements_history_size | 10
  842. | performance_schema_events_transactions_history_long_size | 10000
  843. | performance_schema_events_transactions_history_size | 10
  844. | performance_schema_events_waits_history_long_size | 10000
  845. | performance_schema_events_waits_history_size | 10
  846. | performance_schema_hosts_size | -1
  847. | performance_schema_max_cond_classes | 80
  848. | performance_schema_max_cond_instances | -1
  849. | performance_schema_max_digest_length | 1024
  850. | performance_schema_max_file_classes | 80
  851. | performance_schema_max_file_handles | 32768
  852. | performance_schema_max_file_instances | -1
  853. | performance_schema_max_index_stat | -1
  854. | performance_schema_max_memory_classes | 400
  855. | performance_schema_max_metadata_locks | -1
  856. | performance_schema_max_mutex_classes | 250
  857. | performance_schema_max_mutex_instances | -1
  858. | performance_schema_max_prepared_statements_instances | -1
  859. | performance_schema_max_program_instances | -1
  860. | performance_schema_max_rwlock_classes | 50
  861. | performance_schema_max_rwlock_instances | -1
  862. | performance_schema_max_socket_classes | 10
  863. | performance_schema_max_socket_instances | -1
  864. | performance_schema_max_sql_text_length | 1024
  865. | performance_schema_max_stage_classes | 150
  866. | performance_schema_max_statement_classes | 203
  867. | performance_schema_max_statement_stack | 10
  868. | performance_schema_max_table_handles | -1
  869. | performance_schema_max_table_instances | -1
  870. | performance_schema_max_table_lock_stat | -1
  871. | performance_schema_max_thread_classes | 50
  872. | performance_schema_max_thread_instances | -1
  873. | performance_schema_session_connect_attrs_size | 512
  874. | performance_schema_setup_actors_size | -1
  875. | performance_schema_setup_objects_size | -1
  876. | performance_schema_show_processlist | OFF
  877. | performance_schema_users_size | -1
  878. | pid_file | /var/run/mysqld/mysqld.pid
  879. | plugin_dir | /usr/lib64/mysql/plugin/
  880. | port | 3306
  881. | preload_buffer_size | 32768
  882. | profiling | OFF
  883. | profiling_history_size | 15
  884. | protocol_version | 10
  885. | proxy_protocol_networks |
  886. | proxy_user |
  887. | pseudo_server_id | 0
  888. | pseudo_slave_mode | OFF
  889. | pseudo_thread_id | 6
  890. | query_alloc_block_size | 8192
  891. | query_cache_limit | 1048576
  892. | query_cache_min_res_unit | 4096
  893. | query_cache_size | 1048576
  894. | query_cache_strip_comments | OFF
  895. | query_cache_type | OFF
  896. | query_cache_wlock_invalidate | OFF
  897. | query_prealloc_size | 8192
  898. | rand_seed1 | 0
  899. | rand_seed2 | 0
  900. | range_alloc_block_size | 4096
  901. | range_optimizer_max_mem_size | 8388608
  902. | rbr_exec_mode | STRICT
  903. | read_buffer_size | 131072
  904. | read_only | OFF
  905. | read_rnd_buffer_size | 262144
  906. | relay_log |
  907. | relay_log_basename | /var/lib/mysql/a38866324763-relay-bin
  908. | relay_log_index | /var/lib/mysql/a38866324763-relay-bin.index
  909. | relay_log_info_file | relay-log.info
  910. | relay_log_info_repository | FILE
  911. | relay_log_purge | ON
  912. | relay_log_recovery | OFF
  913. | relay_log_space_limit | 0
  914. | replication_optimize_for_static_plugin_config | OFF
  915. | replication_sender_observe_commit_only | OFF
  916. | report_host |
  917. | report_password |
  918. | report_port | 3306
  919. | report_user |
  920. | require_secure_transport | OFF
  921. | rpl_stop_slave_timeout | 31536000
  922. | secure_auth | ON
  923. | secure_file_priv | /var/lib/mysql-files/
  924. | server_id | 0
  925. | server_id_bits | 32
  926. | server_uuid | 86165195-1a73-11ef-a171-0242ac110002
  927. | session_track_gtids | OFF
  928. | session_track_schema | ON
  929. | session_track_state_change | OFF
  930. | session_track_system_variables | time_zone,autocommit,character_set_client,character_set_results,character_set_connection
  931. | session_track_transaction_info | OFF
  932. | sha256_password_auto_generate_rsa_keys | ON
  933. | sha256_password_private_key_path | private_key.pem
  934. | sha256_password_proxy_users | OFF
  935. | sha256_password_public_key_path | public_key.pem
  936. | show_compatibility_56 | OFF
  937. | show_create_table_verbosity | OFF
  938. | show_old_temporals | OFF
  939. | skip_external_locking | ON
  940. | skip_name_resolve | ON
  941. | skip_networking | OFF
  942. | skip_show_database | OFF
  943. | slave_allow_batching | OFF
  944. | slave_checkpoint_group | 512
  945. | slave_checkpoint_period | 300
  946. | slave_compressed_protocol | OFF
  947. | slave_exec_mode | STRICT
  948. | slave_load_tmpdir | /tmp
  949. | slave_max_allowed_packet | 1073741824
  950. | slave_net_timeout | 60
  951. | slave_parallel_type | DATABASE
  952. | slave_parallel_workers | 0
  953. | slave_pending_jobs_size_max | 16777216
  954. | slave_preserve_commit_order | OFF
  955. | slave_rows_search_algorithms | TABLE_SCAN,INDEX_SCAN
  956. | slave_skip_errors | OFF
  957. | slave_sql_verify_checksum | ON
  958. | slave_transaction_retries | 10
  959. | slave_type_conversions |
  960. | slow_launch_time | 2
  961. | slow_query_log | OFF
  962. | slow_query_log_always_write_time | 10.000000
  963. | slow_query_log_file | /var/lib/mysql/a38866324763-slow.log
  964. | slow_query_log_use_global_control |
  965. | socket | /var/lib/mysql/mysql.sock
  966. | sort_buffer_size | 262144
  967. | sql_auto_is_null | OFF
  968. | sql_big_selects | ON
  969. | sql_buffer_result | OFF
  970. | sql_log_bin | ON
  971. | sql_log_off | OFF
  972. | sql_mode | ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION
  973. | sql_notes | ON
  974. | sql_quote_show_create | ON
  975. | sql_safe_updates | OFF
  976. | sql_select_limit | 18446744073709551615
  977. | sql_slave_skip_counter | 0
  978. | sql_warnings | OFF
  979. | ssl_ca | ca.pem
  980. | ssl_capath |
  981. | ssl_cert | server-cert.pem
  982. | ssl_cipher |
  983. | ssl_crl |
  984. | ssl_crlpath |
  985. | ssl_key | server-key.pem
  986. | stored_program_cache | 256
  987. | super_read_only | OFF
  988. | sync_binlog | 1
  989. | sync_frm | ON
  990. | sync_master_info | 10000
  991. | sync_relay_log | 10000
  992. | sync_relay_log_info | 10000
  993. | system_time_zone | UTC
  994. | table_definition_cache | 1400
  995. | table_open_cache | 2000
  996. | table_open_cache_instances | 16
  997. | thread_cache_size | 9
  998. | thread_handling | one-thread-per-connection
  999. | thread_pool_high_prio_mode | transactions
  1000. | thread_pool_high_prio_tickets | 4294967295
  1001. | thread_pool_idle_timeout | 60
  1002. | thread_pool_max_threads | 100000
  1003. | thread_pool_oversubscribe | 3
  1004. | thread_pool_size | 4
  1005. | thread_pool_stall_limit | 500
  1006. | thread_stack | 262144
  1007. | thread_statistics | OFF
  1008. | time_format | %H:%i:%s
  1009. | time_zone | SYSTEM
  1010. | timestamp | 1716720571.091529
  1011. | tls_version | TLSv1,TLSv1.1,TLSv1.2
  1012. | tmp_table_size | 16777216
  1013. | tmpdir | /tmp
  1014. | transaction_alloc_block_size | 8192
  1015. | transaction_allow_batching | OFF
  1016. | transaction_isolation | REPEATABLE-READ
  1017. | transaction_prealloc_size | 4096
  1018. | transaction_read_only | OFF
  1019. | transaction_write_set_extraction | OFF
  1020. | tx_isolation | REPEATABLE-READ
  1021. | tx_read_only | OFF
  1022. | unique_checks | ON
  1023. | updatable_views_with_limit | YES
  1024. | userstat | OFF
  1025. | version | 5.7.44-48
  1026. | version_comment | Percona Server (GPL), Release 48, Revision 497f936a373
  1027. | version_compile_machine | x86_64
  1028. | version_compile_os | Linux
  1029. | version_suffix |
  1030. | wait_timeout | 28800
  1031. | warning_count | 0
  1032. +----------------------------------------------------------+
  1033. 592 rows in set (0.00 sec)
  1034.  
  1035.  
  1036.  
  1037.  
  1038.  
  1039.  
  1040.  
  1041. =========================MySQL 8.0=========================
  1042. mysql> SHOW GLOBAL STATUS;
  1043. +--------------------------------------------------------+
  1044. | Variable_name | Value
  1045. +--------------------------------------------------------+
  1046. | Aborted_clients | 0
  1047. | Aborted_connects | 0
  1048. | Acl_cache_items_count | 0
  1049. | Binlog_snapshot_file | binlog.000002
  1050. | Binlog_snapshot_position | 719
  1051. | Binlog_cache_disk_use | 0
  1052. | Binlog_cache_use | 2
  1053. | Binlog_snapshot_gtid_executed | not-in-consistent-snapshot
  1054. | Binlog_stmt_cache_disk_use | 0
  1055. | Binlog_stmt_cache_use | 0
  1056. | Bytes_received | 1127
  1057. | Bytes_sent | 44652
  1058. | Caching_sha2_password_rsa_public_key | -----BEGIN PUBLIC KEY-----
  1059. MIIBIjANBgkqhkiG9w0BAQEFAAOCAQ8AMIIBCgKCAQEA013AeNMmIX5Kb8k4hbZK
  1060. HedeP2Glq8uDbkp//tx3kITmEoCNeDqcLFzLjLlly5tkq90Z4Ng1jlAg+EUVzUIz
  1061. 0xJ2JXmFU1OiKOkh8inn2gpg5nZMLDpd8ytpxP7f9zo5xBBNQozJWqgoiyV98HuI
  1062. tJO1c/QFeo3jMqMpWcjABFhT2ZDtXGsImZHfmpvHulfbQQ1R0sETOVjRwlMXykvu
  1063. rW19w135ojHmH6lcudyUssZ3wutbHw1U9RRtFRWanKonKhHH6lp+Edj2qNYRYw2m
  1064. KT2LNSerrm9jZWhbS+s2fH7IisXhUtb3NGHy4W3CJveolhNr9kRBJXst2H5y11Ms
  1065. YwIDAQAB
  1066. -----END PUBLIC KEY-----
  1067.  
  1068. | Com_admin_commands | 0
  1069. | Com_assign_to_keycache | 0
  1070. | Com_alter_db | 0
  1071. | Com_alter_event | 0
  1072. | Com_alter_function | 0
  1073. | Com_alter_instance | 0
  1074. | Com_alter_procedure | 0
  1075. | Com_alter_resource_group | 0
  1076. | Com_alter_server | 0
  1077. | Com_alter_table | 0
  1078. | Com_alter_tablespace | 0
  1079. | Com_alter_user | 0
  1080. | Com_alter_user_default_role | 0
  1081. | Com_analyze | 0
  1082. | Com_begin | 0
  1083. | Com_binlog | 0
  1084. | Com_call_procedure | 0
  1085. | Com_change_db | 1
  1086. | Com_change_master | 0
  1087. | Com_change_repl_filter | 0
  1088. | Com_change_replication_source | 0
  1089. | Com_check | 0
  1090. | Com_checksum | 0
  1091. | Com_clone | 0
  1092. | Com_commit | 0
  1093. | Com_create_compression_dictionary | 0
  1094. | Com_create_db | 2
  1095. | Com_create_event | 0
  1096. | Com_create_function | 0
  1097. | Com_create_index | 0
  1098. | Com_create_procedure | 0
  1099. | Com_create_role | 0
  1100. | Com_create_server | 0
  1101. | Com_create_table | 36
  1102. | Com_create_resource_group | 0
  1103. | Com_create_trigger | 0
  1104. | Com_create_udf | 0
  1105. | Com_create_user | 0
  1106. | Com_create_view | 0
  1107. | Com_create_spatial_reference_system | 0
  1108. | Com_dealloc_sql | 0
  1109. | Com_delete | 0
  1110. | Com_delete_multi | 0
  1111. | Com_do | 0
  1112. | Com_drop_compression_dictionary | 0
  1113. | Com_drop_db | 0
  1114. | Com_drop_event | 0
  1115. | Com_drop_function | 0
  1116. | Com_drop_index | 0
  1117. | Com_drop_procedure | 0
  1118. | Com_drop_resource_group | 0
  1119. | Com_drop_role | 0
  1120. | Com_drop_server | 0
  1121. | Com_drop_spatial_reference_system | 0
  1122. | Com_drop_table | 0
  1123. | Com_drop_trigger | 0
  1124. | Com_drop_user | 0
  1125. | Com_drop_view | 0
  1126. | Com_empty_query | 0
  1127. | Com_execute_sql | 0
  1128. | Com_explain_other | 0
  1129. | Com_flush | 1
  1130. | Com_get_diagnostics | 0
  1131. | Com_grant | 0
  1132. | Com_grant_roles | 0
  1133. | Com_ha_close | 0
  1134. | Com_ha_open | 0
  1135. | Com_ha_read | 0
  1136. | Com_help | 0
  1137. | Com_import | 0
  1138. | Com_insert | 1
  1139. | Com_insert_select | 0
  1140. | Com_install_component | 0
  1141. | Com_install_plugin | 0
  1142. | Com_kill | 0
  1143. | Com_load | 0
  1144. | Com_lock_instance | 0
  1145. | Com_lock_tables | 0
  1146. | Com_lock_tables_for_backup | 0
  1147. | Com_optimize | 0
  1148. | Com_preload_keys | 0
  1149. | Com_prepare_sql | 0
  1150. | Com_purge | 0
  1151. | Com_purge_before_date | 0
  1152. | Com_release_savepoint | 0
  1153. | Com_rename_table | 0
  1154. | Com_rename_user | 0
  1155. | Com_repair | 0
  1156. | Com_replace | 0
  1157. | Com_replace_select | 0
  1158. | Com_reset | 0
  1159. | Com_resignal | 0
  1160. | Com_restart | 0
  1161. | Com_revoke | 0
  1162. | Com_revoke_all | 0
  1163. | Com_revoke_roles | 0
  1164. | Com_rollback | 0
  1165. | Com_rollback_to_savepoint | 0
  1166. | Com_savepoint | 0
  1167. | Com_select | 3
  1168. | Com_set_option | 5
  1169. | Com_set_password | 0
  1170. | Com_set_resource_group | 0
  1171. | Com_set_role | 0
  1172. | Com_signal | 0
  1173. | Com_show_binlog_events | 0
  1174. | Com_show_binlogs | 0
  1175. | Com_show_charsets | 0
  1176. | Com_show_client_statistics | 0
  1177. | Com_show_collations | 0
  1178. | Com_show_create_db | 1
  1179. | Com_show_create_event | 0
  1180. | Com_show_create_func | 0
  1181. | Com_show_create_proc | 0
  1182. | Com_show_create_table | 1
  1183. | Com_show_create_trigger | 0
  1184. | Com_show_databases | 0
  1185. | Com_show_engine_logs | 0
  1186. | Com_show_engine_mutex | 0
  1187. | Com_show_engine_status | 0
  1188. | Com_show_events | 0
  1189. | Com_show_errors | 0
  1190. | Com_show_fields | 0
  1191. | Com_show_function_code | 0
  1192. | Com_show_function_status | 0
  1193. | Com_show_grants | 0
  1194. | Com_show_index_statistics | 0
  1195. | Com_show_keys | 0
  1196. | Com_show_master_status | 0
  1197. | Com_show_open_tables | 0
  1198. | Com_show_plugins | 0
  1199. | Com_show_privileges | 0
  1200. | Com_show_procedure_code | 0
  1201. | Com_show_procedure_status | 0
  1202. | Com_show_processlist | 0
  1203. | Com_show_profile | 0
  1204. | Com_show_profiles | 0
  1205. | Com_show_relaylog_events | 0
  1206. | Com_show_replicas | 0
  1207. | Com_show_slave_hosts | 0
  1208. | Com_show_replica_status | 0
  1209. | Com_show_slave_status | 0
  1210. | Com_show_status | 2
  1211. | Com_show_storage_engines | 0
  1212. | Com_show_table_statistics | 0
  1213. | Com_show_table_status | 0
  1214. | Com_show_tables | 0
  1215. | Com_show_thread_statistics | 0
  1216. | Com_show_triggers | 0
  1217. | Com_show_user_statistics | 0
  1218. | Com_show_variables | 4
  1219. | Com_show_warnings | 1
  1220. | Com_show_create_user | 0
  1221. | Com_shutdown | 0
  1222. | Com_replica_start | 0
  1223. | Com_slave_start | 0
  1224. | Com_replica_stop | 0
  1225. | Com_slave_stop | 0
  1226. | Com_group_replication_start | 0
  1227. | Com_group_replication_stop | 0
  1228. | Com_stmt_execute | 0
  1229. | Com_stmt_close | 0
  1230. | Com_stmt_fetch | 0
  1231. | Com_stmt_prepare | 0
  1232. | Com_stmt_reset | 0
  1233. | Com_stmt_send_long_data | 0
  1234. | Com_truncate | 0
  1235. | Com_uninstall_component | 0
  1236. | Com_uninstall_plugin | 0
  1237. | Com_unlock_instance | 0
  1238. | Com_unlock_tables | 0
  1239. | Com_update | 0
  1240. | Com_update_multi | 0
  1241. | Com_xa_commit | 0
  1242. | Com_xa_end | 0
  1243. | Com_xa_prepare | 0
  1244. | Com_xa_recover | 0
  1245. | Com_xa_rollback | 0
  1246. | Com_xa_start | 0
  1247. | Com_stmt_reprepare | 0
  1248. | Connection_errors_accept | 0
  1249. | Connection_errors_internal | 0
  1250. | Connection_errors_max_connections | 0
  1251. | Connection_errors_peer_address | 0
  1252. | Connection_errors_select | 0
  1253. | Connection_errors_tcpwrap | 0
  1254. | Connections | 9
  1255. | Created_tmp_disk_tables | 0
  1256. | Created_tmp_files | 5
  1257. | Created_tmp_tables | 6
  1258. | Current_tls_ca | ca.pem
  1259. | Current_tls_capath |
  1260. | Current_tls_cert | server-cert.pem
  1261. | Current_tls_cipher |
  1262. | Current_tls_ciphersuites |
  1263. | Current_tls_crl |
  1264. | Current_tls_crlpath |
  1265. | Current_tls_key | server-key.pem
  1266. | Current_tls_version | TLSv1.2,TLSv1.3
  1267. | Delayed_errors | 0
  1268. | Delayed_insert_threads | 0
  1269. | Delayed_writes | 0
  1270. | Deprecated_use_i_s_processlist_count | 0
  1271. | Deprecated_use_i_s_processlist_last_timestamp | 0
  1272. | Error_log_buffered_bytes | 1360
  1273. | Error_log_buffered_events | 9
  1274. | Error_log_expired_events | 0
  1275. | Error_log_latest_write | 1716626907607263
  1276. | Flush_commands | 3
  1277. | Global_connection_memory | 0
  1278. | Handler_commit | 620
  1279. | Handler_delete | 8
  1280. | Handler_discover | 0
  1281. | Handler_external_lock | 6865
  1282. | Handler_mrr_init | 0
  1283. | Handler_prepare | 8
  1284. | Handler_read_first | 42
  1285. | Handler_read_key | 1823
  1286. | Handler_read_last | 0
  1287. | Handler_read_next | 4203
  1288. | Handler_read_prev | 0
  1289. | Handler_read_rnd | 0
  1290. | Handler_read_rnd_next | 4862
  1291. | Handler_rollback | 1
  1292. | Handler_savepoint | 0
  1293. | Handler_savepoint_rollback | 0
  1294. | Handler_update | 341
  1295. | Handler_write | 1290
  1296. | Innodb_background_log_sync | 0
  1297. | Innodb_buffer_pool_dump_status | Dumping of buffer pool not started
  1298. | Innodb_buffer_pool_load_status | Buffer pool(s) load completed at 240525 8:48:27
  1299. | Innodb_buffer_pool_resize_status |
  1300. | Innodb_buffer_pool_resize_status_code | 0
  1301. | Innodb_buffer_pool_resize_status_progress | 0
  1302. | Innodb_buffer_pool_pages_data | 1149
  1303. | Innodb_buffer_pool_bytes_data | 18825216
  1304. | Innodb_buffer_pool_pages_dirty | 0
  1305. | Innodb_buffer_pool_bytes_dirty | 0
  1306. | Innodb_buffer_pool_pages_flushed | 260
  1307. | Innodb_buffer_pool_pages_free | 7038
  1308. | Innodb_buffer_pool_pages_LRU_flushed | 0
  1309. | Innodb_buffer_pool_pages_made_not_young | 0
  1310. | Innodb_buffer_pool_pages_made_young | 0
  1311. | Innodb_buffer_pool_pages_misc | 5
  1312. | Innodb_buffer_pool_pages_old | 442
  1313. | Innodb_buffer_pool_pages_total | 8192
  1314. | Innodb_buffer_pool_read_ahead_rnd | 0
  1315. | Innodb_buffer_pool_read_ahead | 0
  1316. | Innodb_buffer_pool_read_ahead_evicted | 0
  1317. | Innodb_buffer_pool_read_requests | 16653
  1318. | Innodb_buffer_pool_reads | 998
  1319. | Innodb_buffer_pool_wait_free | 0
  1320. | Innodb_buffer_pool_write_requests | 2176
  1321. | Innodb_checkpoint_age | 0
  1322. | Innodb_checkpoint_max_age | 87417344
  1323. | Innodb_data_fsyncs | 191
  1324. | Innodb_data_pending_fsyncs | 0
  1325. | Innodb_data_pending_reads | 0
  1326. | Innodb_data_pending_writes | 0
  1327. | Innodb_data_read | 16419840
  1328. | Innodb_data_reads | 1021
  1329. | Innodb_data_writes | 391
  1330. | Innodb_data_written | 4389888
  1331. | Innodb_dblwr_pages_written | 119
  1332. | Innodb_dblwr_writes | 36
  1333. | Innodb_ibuf_free_list | 0
  1334. | Innodb_ibuf_segment_size | 2
  1335. | Innodb_redo_log_read_only | OFF
  1336. | Innodb_redo_log_uuid | 3913677192
  1337. | Innodb_redo_log_checkpoint_lsn | 32256424
  1338. | Innodb_redo_log_current_lsn | 32256424
  1339. | Innodb_redo_log_flushed_to_disk_lsn | 32256424
  1340. | Innodb_redo_log_logical_size | 512
  1341. | Innodb_redo_log_physical_size | 3276800
  1342. | Innodb_redo_log_capacity_resized | 104857600
  1343. | Innodb_redo_log_resize_status | OK
  1344. | Innodb_log_waits | 0
  1345. | Innodb_log_write_requests | 1004
  1346. | Innodb_log_writes | 61
  1347. | Innodb_lsn_current | 32256424
  1348. | Innodb_lsn_flushed | 32256424
  1349. | Innodb_lsn_last_checkpoint | 32256424
  1350. | Innodb_master_thread_active_loops | 4
  1351. | Innodb_master_thread_idle_loops | 93634
  1352. | Innodb_max_trx_id | 2071
  1353. | Innodb_oldest_view_low_limit_trx_id | 0
  1354. | Innodb_os_log_fsyncs | 57
  1355. | Innodb_os_log_pending_fsyncs | 0
  1356. | Innodb_os_log_pending_writes | 0
  1357. | Innodb_os_log_written | 85504
  1358. | Innodb_page_size | 16384
  1359. | Innodb_pages_created | 152
  1360. | Innodb_pages_read | 997
  1361. | Innodb_pages0_read | 7
  1362. | Innodb_pages_written | 260
  1363. | Innodb_purge_trx_id | 2070
  1364. | Innodb_purge_undo_no | 0
  1365. | Innodb_redo_log_enabled | ON
  1366. | Innodb_row_lock_current_waits | 0
  1367. | Innodb_row_lock_time | 0
  1368. | Innodb_row_lock_time_avg | 0
  1369. | Innodb_row_lock_time_max | 0
  1370. | Innodb_row_lock_waits | 0
  1371. | Innodb_rows_deleted | 0
  1372. | Innodb_rows_inserted | 0
  1373. | Innodb_rows_read | 0
  1374. | Innodb_rows_updated | 0
  1375. | Innodb_system_rows_deleted | 8
  1376. | Innodb_system_rows_inserted | 23
  1377. | Innodb_system_rows_read | 4980
  1378. | Innodb_system_rows_updated | 341
  1379. | Innodb_sampled_pages_read | 0
  1380. | Innodb_sampled_pages_skipped | 0
  1381. | Innodb_num_open_files | 16
  1382. | Innodb_truncated_status_writes | 0
  1383. | Innodb_undo_tablespaces_total | 2
  1384. | Innodb_undo_tablespaces_implicit | 2
  1385. | Innodb_undo_tablespaces_explicit | 0
  1386. | Innodb_undo_tablespaces_active | 2
  1387. | Innodb_secondary_index_triggered_cluster_reads | 2116
  1388. | Innodb_secondary_index_triggered_cluster_reads_avoided | 0
  1389. | Innodb_buffered_aio_submitted | 0
  1390. | Innodb_scan_pages_contiguous | 0
  1391. | Innodb_scan_pages_disjointed | 0
  1392. | Innodb_scan_pages_total_seek_distance | 0
  1393. | Innodb_scan_data_size | 0
  1394. | Innodb_scan_deleted_recs_size | 0
  1395. | Innodb_encryption_n_merge_blocks_encrypted | 0
  1396. | Innodb_encryption_n_merge_blocks_decrypted | 0
  1397. | Innodb_encryption_n_rowlog_blocks_encrypted | 0
  1398. | Innodb_encryption_n_rowlog_blocks_decrypted | 0
  1399. | Key_blocks_not_flushed | 0
  1400. | Key_blocks_unused | 6698
  1401. | Key_blocks_used | 0
  1402. | Key_read_requests | 0
  1403. | Key_reads | 0
  1404. | Key_write_requests | 0
  1405. | Key_writes | 0
  1406. | Locked_connects | 0
  1407. | Max_execution_time_exceeded | 0
  1408. | Max_execution_time_set | 0
  1409. | Max_execution_time_set_failed | 0
  1410. | Max_used_connections | 1
  1411. | Max_used_connections_time | 2024-05-25 08:48:35
  1412. | Mysqlx_aborted_clients | 0
  1413. | Mysqlx_address | ::
  1414. | Mysqlx_bytes_received | 0
  1415. | Mysqlx_bytes_received_compressed_payload | 0
  1416. | Mysqlx_bytes_received_uncompressed_frame | 0
  1417. | Mysqlx_bytes_sent | 0
  1418. | Mysqlx_bytes_sent_compressed_payload | 0
  1419. | Mysqlx_bytes_sent_uncompressed_frame | 0
  1420. | Mysqlx_compression_algorithm |
  1421. | Mysqlx_compression_level |
  1422. | Mysqlx_connection_accept_errors | 0
  1423. | Mysqlx_connection_errors | 0
  1424. | Mysqlx_connections_accepted | 0
  1425. | Mysqlx_connections_closed | 0
  1426. | Mysqlx_connections_rejected | 0
  1427. | Mysqlx_crud_create_view | 0
  1428. | Mysqlx_crud_delete | 0
  1429. | Mysqlx_crud_drop_view | 0
  1430. | Mysqlx_crud_find | 0
  1431. | Mysqlx_crud_insert | 0
  1432. | Mysqlx_crud_modify_view | 0
  1433. | Mysqlx_crud_update | 0
  1434. | Mysqlx_cursor_close | 0
  1435. | Mysqlx_cursor_fetch | 0
  1436. | Mysqlx_cursor_open | 0
  1437. | Mysqlx_errors_sent | 0
  1438. | Mysqlx_errors_unknown_message_type | 0
  1439. | Mysqlx_expect_close | 0
  1440. | Mysqlx_expect_open | 0
  1441. | Mysqlx_init_error | 0
  1442. | Mysqlx_messages_sent | 0
  1443. | Mysqlx_notice_global_sent | 0
  1444. | Mysqlx_notice_other_sent | 0
  1445. | Mysqlx_notice_warning_sent | 0
  1446. | Mysqlx_notified_by_group_replication | 0
  1447. | Mysqlx_port | 33060
  1448. | Mysqlx_prep_deallocate | 0
  1449. | Mysqlx_prep_execute | 0
  1450. | Mysqlx_prep_prepare | 0
  1451. | Mysqlx_rows_sent | 0
  1452. | Mysqlx_sessions | 0
  1453. | Mysqlx_sessions_accepted | 0
  1454. | Mysqlx_sessions_closed | 0
  1455. | Mysqlx_sessions_fatal_error | 0
  1456. | Mysqlx_sessions_killed | 0
  1457. | Mysqlx_sessions_rejected | 0
  1458. | Mysqlx_socket | /var/lib/mysql/mysqlx.sock
  1459. | Mysqlx_ssl_accepts | 0
  1460. | Mysqlx_ssl_active |
  1461. | Mysqlx_ssl_cipher |
  1462. | Mysqlx_ssl_cipher_list |
  1463. | Mysqlx_ssl_ctx_verify_depth | 18446744073709551615
  1464. | Mysqlx_ssl_ctx_verify_mode | 5
  1465. | Mysqlx_ssl_finished_accepts | 0
  1466. | Mysqlx_ssl_server_not_after | May 23 08:48:19 2034 GMT
  1467. | Mysqlx_ssl_server_not_before | May 25 08:48:19 2024 GMT
  1468. | Mysqlx_ssl_verify_depth |
  1469. | Mysqlx_ssl_verify_mode |
  1470. | Mysqlx_ssl_version |
  1471. | Mysqlx_stmt_create_collection | 0
  1472. | Mysqlx_stmt_create_collection_index | 0
  1473. | Mysqlx_stmt_disable_notices | 0
  1474. | Mysqlx_stmt_drop_collection | 0
  1475. | Mysqlx_stmt_drop_collection_index | 0
  1476. | Mysqlx_stmt_enable_notices | 0
  1477. | Mysqlx_stmt_ensure_collection | 0
  1478. | Mysqlx_stmt_execute_mysqlx | 0
  1479. | Mysqlx_stmt_execute_sql | 0
  1480. | Mysqlx_stmt_execute_xplugin | 0
  1481. | Mysqlx_stmt_get_collection_options | 0
  1482. | Mysqlx_stmt_kill_client | 0
  1483. | Mysqlx_stmt_list_clients | 0
  1484. | Mysqlx_stmt_list_notices | 0
  1485. | Mysqlx_stmt_list_objects | 0
  1486. | Mysqlx_stmt_modify_collection_options | 0
  1487. | Mysqlx_stmt_ping | 0
  1488. | Mysqlx_worker_threads | 2
  1489. | Mysqlx_worker_threads_active | 0
  1490. | Net_buffer_length | 16384
  1491. | Not_flushed_delayed_rows | 0
  1492. | Ongoing_anonymous_transaction_count | 0
  1493. | Open_files | 2
  1494. | Open_streams | 0
  1495. | Open_table_definitions | 48
  1496. | Open_tables | 60
  1497. | Open_tables_with_triggers | 0
  1498. | Opened_files | 2
  1499. | Opened_table_definitions | 78
  1500. | Opened_tables | 141
  1501. | Performance_schema_accounts_lost | 0
  1502. | Performance_schema_cond_classes_lost | 0
  1503. | Performance_schema_cond_instances_lost | 0
  1504. | Performance_schema_digest_lost | 0
  1505. | Performance_schema_file_classes_lost | 0
  1506. | Performance_schema_file_handles_lost | 0
  1507. | Performance_schema_file_instances_lost | 0
  1508. | Performance_schema_hosts_lost | 0
  1509. | Performance_schema_index_stat_lost | 0
  1510. | Performance_schema_locker_lost | 0
  1511. | Performance_schema_memory_classes_lost | 0
  1512. | Performance_schema_metadata_lock_lost | 0
  1513. | Performance_schema_mutex_classes_lost | 0
  1514. | Performance_schema_mutex_instances_lost | 0
  1515. | Performance_schema_nested_statement_lost | 0
  1516. | Performance_schema_prepared_statements_lost | 0
  1517. | Performance_schema_program_lost | 0
  1518. | Performance_schema_rwlock_classes_lost | 0
  1519. | Performance_schema_rwlock_instances_lost | 0
  1520. | Performance_schema_session_connect_attrs_longest_seen | 116
  1521. | Performance_schema_session_connect_attrs_lost | 0
  1522. | Performance_schema_socket_classes_lost | 0
  1523. | Performance_schema_socket_instances_lost | 0
  1524. | Performance_schema_stage_classes_lost | 0
  1525. | Performance_schema_statement_classes_lost | 0
  1526. | Performance_schema_table_handles_lost | 0
  1527. | Performance_schema_table_instances_lost | 0
  1528. | Performance_schema_table_lock_stat_lost | 0
  1529. | Performance_schema_thread_classes_lost | 0
  1530. | Performance_schema_thread_instances_lost | 0
  1531. | Performance_schema_users_lost | 0
  1532. | Prepared_stmt_count | 0
  1533. | Queries | 18
  1534. | Questions | 17
  1535. | Replica_open_temp_tables | 0
  1536. | Resource_group_supported | ON
  1537. | Rsa_public_key | -----BEGIN PUBLIC KEY-----
  1538. MIIBIjANBgkqhkiG9w0BAQEFAAOCAQ8AMIIBCgKCAQEA013AeNMmIX5Kb8k4hbZK
  1539. HedeP2Glq8uDbkp//tx3kITmEoCNeDqcLFzLjLlly5tkq90Z4Ng1jlAg+EUVzUIz
  1540. 0xJ2JXmFU1OiKOkh8inn2gpg5nZMLDpd8ytpxP7f9zo5xBBNQozJWqgoiyV98HuI
  1541. tJO1c/QFeo3jMqMpWcjABFhT2ZDtXGsImZHfmpvHulfbQQ1R0sETOVjRwlMXykvu
  1542. rW19w135ojHmH6lcudyUssZ3wutbHw1U9RRtFRWanKonKhHH6lp+Edj2qNYRYw2m
  1543. KT2LNSerrm9jZWhbS+s2fH7IisXhUtb3NGHy4W3CJveolhNr9kRBJXst2H5y11Ms
  1544. YwIDAQAB
  1545. -----END PUBLIC KEY-----
  1546.  
  1547. | Secondary_engine_execution_count | 0
  1548. | Select_full_join | 0
  1549. | Select_full_range_join | 0
  1550. | Select_range | 0
  1551. | Select_range_check | 0
  1552. | Select_scan | 13
  1553. | Slave_open_temp_tables | 0
  1554. | Slow_launch_threads | 0
  1555. | Slow_queries | 0
  1556. | Sort_merge_passes | 0
  1557. | Sort_range | 0
  1558. | Sort_rows | 0
  1559. | Sort_scan | 0
  1560. | Ssl_accept_renegotiates | 0
  1561. | Ssl_accepts | 0
  1562. | Ssl_callback_cache_hits | 0
  1563. | Ssl_cipher |
  1564. | Ssl_cipher_list |
  1565. | Ssl_client_connects | 0
  1566. | Ssl_connect_renegotiates | 0
  1567. | Ssl_ctx_verify_depth | 18446744073709551615
  1568. | Ssl_ctx_verify_mode | 5
  1569. | Ssl_default_timeout | 0
  1570. | Ssl_finished_accepts | 0
  1571. | Ssl_finished_connects | 0
  1572. | Ssl_server_not_after | May 23 08:48:19 2034 GMT
  1573. | Ssl_server_not_before | May 25 08:48:19 2024 GMT
  1574. | Ssl_session_cache_hits | 0
  1575. | Ssl_session_cache_misses | 0
  1576. | Ssl_session_cache_mode | SERVER
  1577. | Ssl_session_cache_overflows | 0
  1578. | Ssl_session_cache_size | 128
  1579. | Ssl_session_cache_timeout | 300
  1580. | Ssl_session_cache_timeouts | 0
  1581. | Ssl_sessions_reused | 0
  1582. | Ssl_used_session_cache_entries | 0
  1583. | Ssl_verify_depth | 0
  1584. | Ssl_verify_mode | 0
  1585. | Ssl_version |
  1586. | Table_locks_immediate | 6
  1587. | Table_locks_waited | 0
  1588. | Table_open_cache_hits | 3293
  1589. | Table_open_cache_misses | 141
  1590. | Table_open_cache_overflows | 0
  1591. | Table_open_cache_triggers_hits | 0
  1592. | Table_open_cache_triggers_misses | 0
  1593. | Table_open_cache_triggers_overflows | 0
  1594. | Tc_log_max_pages_used | 0
  1595. | Tc_log_page_size | 0
  1596. | Tc_log_page_waits | 0
  1597. | Telemetry_traces_supported | ON
  1598. | Threadpool_idle_threads | 0
  1599. | Threadpool_threads | 0
  1600. | Threads_cached | 0
  1601. | Threads_connected | 1
  1602. | Threads_created | 1
  1603. | Threads_running | 2
  1604. | Tls_library_version | OpenSSL 3.0.7 1 Nov 2022
  1605. | Uptime | 93654
  1606. | Uptime_since_flush_status | 93654
  1607. +--------------------------------------------------------+
  1608. 543 rows in set (0.00 sec)
  1609.  
  1610. mysql> SHOW VARIABLES;
  1611. +----------------------------------------------------------+
  1612. | Variable_name | Value
  1613. +----------------------------------------------------------+
  1614. | activate_all_roles_on_login | OFF
  1615. | admin_address |
  1616. | admin_port | 33062
  1617. | admin_ssl_ca |
  1618. | admin_ssl_capath |
  1619. | admin_ssl_cert |
  1620. | admin_ssl_cipher |
  1621. | admin_ssl_crl |
  1622. | admin_ssl_crlpath |
  1623. | admin_ssl_key |
  1624. | admin_tls_ciphersuites |
  1625. | admin_tls_version | TLSv1.2,TLSv1.3
  1626. | authentication_policy | *,,
  1627. | auto_generate_certs | ON
  1628. | auto_increment_increment | 1
  1629. | auto_increment_offset | 1
  1630. | autocommit | ON
  1631. | automatic_sp_privileges | ON
  1632. | avoid_temporal_upgrade | OFF
  1633. | back_log | 151
  1634. | basedir | /usr/
  1635. | big_tables | OFF
  1636. | bind_address | *
  1637. | binlog_cache_size | 32768
  1638. | binlog_checksum | CRC32
  1639. | binlog_ddl_skip_rewrite | OFF
  1640. | binlog_direct_non_transactional_updates | OFF
  1641. | binlog_encryption | OFF
  1642. | binlog_error_action | ABORT_SERVER
  1643. | binlog_expire_logs_auto_purge | ON
  1644. | binlog_expire_logs_seconds | 2592000
  1645. | binlog_format | ROW
  1646. | binlog_group_commit_sync_delay | 0
  1647. | binlog_group_commit_sync_no_delay_count | 0
  1648. | binlog_gtid_simple_recovery | ON
  1649. | binlog_max_flush_queue_time | 0
  1650. | binlog_order_commits | ON
  1651. | binlog_rotate_encryption_master_key_at_startup | OFF
  1652. | binlog_row_event_max_size | 8192
  1653. | binlog_row_image | FULL
  1654. | binlog_row_metadata | MINIMAL
  1655. | binlog_row_value_options |
  1656. | binlog_rows_query_log_events | OFF
  1657. | binlog_skip_flush_commands | OFF
  1658. | binlog_space_limit | 0
  1659. | binlog_stmt_cache_size | 32768
  1660. | binlog_transaction_compression | OFF
  1661. | binlog_transaction_compression_level_zstd | 3
  1662. | binlog_transaction_dependency_history_size | 25000
  1663. | binlog_transaction_dependency_tracking | COMMIT_ORDER
  1664. | block_encryption_mode | aes-128-ecb
  1665. | buffered_error_log_filename |
  1666. | buffered_error_log_size | 0
  1667. | build_id | d18f29188cae66133efa80e6eb798f0bc921812c
  1668. | bulk_insert_buffer_size | 8388608
  1669. | caching_sha2_password_auto_generate_rsa_keys | ON
  1670. | caching_sha2_password_digest_rounds | 5000
  1671. | caching_sha2_password_private_key_path | private_key.pem
  1672. | caching_sha2_password_public_key_path | public_key.pem
  1673. | character_set_client | utf8mb4
  1674. | character_set_connection | utf8mb4
  1675. | character_set_database | utf8mb4
  1676. | character_set_filesystem | binary
  1677. | character_set_results | utf8mb4
  1678. | character_set_server | utf8mb4
  1679. | character_set_system | utf8mb3
  1680. | character_sets_dir | /usr/share/percona-server/charsets/
  1681. | check_proxy_users | OFF
  1682. | collation_connection | utf8mb4_0900_ai_ci
  1683. | collation_database | utf8mb4_general_ci
  1684. | collation_server | utf8mb4_general_ci
  1685. | completion_type | NO_CHAIN
  1686. | concurrent_insert | AUTO
  1687. | connect_timeout | 10
  1688. | connection_memory_chunk_size | 8192
  1689. | connection_memory_limit | 18446744073709551615
  1690. | core_file | OFF
  1691. | create_admin_listener_thread | OFF
  1692. | cte_max_recursion_depth | 1000
  1693. | datadir | /var/lib/mysql/
  1694. | default_authentication_plugin | caching_sha2_password
  1695. | default_collation_for_utf8mb4 | utf8mb4_0900_ai_ci
  1696. | default_password_lifetime | 0
  1697. | default_storage_engine | InnoDB
  1698. | default_table_encryption | OFF
  1699. | default_tmp_storage_engine | InnoDB
  1700. | default_week_format | 0
  1701. | delay_key_write | ON
  1702. | delayed_insert_limit | 100
  1703. | delayed_insert_timeout | 300
  1704. | delayed_queue_size | 1000
  1705. | disabled_storage_engines |
  1706. | disconnect_on_expired_password | ON
  1707. | div_precision_increment | 4
  1708. | encrypt_tmp_files | OFF
  1709. | end_markers_in_json | OFF
  1710. | enforce_gtid_consistency | OFF
  1711. | enforce_storage_engine |
  1712. | eq_range_index_dive_limit | 200
  1713. | error_count | 0
  1714. | event_scheduler | ON
  1715. | expand_fast_index_creation | OFF
  1716. | expire_logs_days | 0
  1717. | explain_format | TRADITIONAL
  1718. | explicit_defaults_for_timestamp | ON
  1719. | external_user |
  1720. | flush | OFF
  1721. | flush_time | 0
  1722. | foreign_key_checks | ON
  1723. | ft_boolean_syntax | + -><()~*:""&|
  1724. | ft_max_word_len | 84
  1725. | ft_min_word_len | 4
  1726. | ft_query_expansion_limit | 20
  1727. | ft_query_extra_word_chars | OFF
  1728. | ft_stopword_file | (built-in)
  1729. | general_log | OFF
  1730. | general_log_file | /var/lib/mysql/dc279959a518.log
  1731. | generated_random_password_length | 20
  1732. | global_connection_memory_limit | 18446744073709551615
  1733. | global_connection_memory_tracking | OFF
  1734. | group_concat_max_len | 1024
  1735. | group_replication_consistency | EVENTUAL
  1736. | gtid_executed |
  1737. | gtid_executed_compression_period | 0
  1738. | gtid_mode | OFF
  1739. | gtid_next | AUTOMATIC
  1740. | gtid_owned |
  1741. | gtid_purged |
  1742. | have_backup_locks | YES
  1743. | have_backup_safe_binlog_info | YES
  1744. | have_compress | YES
  1745. | have_dynamic_loading | YES
  1746. | have_geometry | YES
  1747. | have_openssl | YES
  1748. | have_profiling | YES
  1749. | have_query_cache | NO
  1750. | have_rtree_keys | YES
  1751. | have_snapshot_cloning | YES
  1752. | have_ssl | YES
  1753. | have_statement_timeout | YES
  1754. | have_symlink | DISABLED
  1755. | histogram_generation_max_mem_size | 20000000
  1756. | host_cache_size | 279
  1757. | hostname | dc279959a518
  1758. | identity | 0
  1759. | immediate_server_version | 999999
  1760. | information_schema_stats_expiry | 86400
  1761. | init_connect |
  1762. | init_file |
  1763. | init_replica |
  1764. | init_slave |
  1765. | innodb_adaptive_flushing | ON
  1766. | innodb_adaptive_flushing_lwm | 10
  1767. | innodb_adaptive_hash_index | ON
  1768. | innodb_adaptive_hash_index_parts | 8
  1769. | innodb_adaptive_max_sleep_delay | 150000
  1770. | innodb_api_bk_commit_interval | 5
  1771. | innodb_api_disable_rowlock | OFF
  1772. | innodb_api_enable_binlog | OFF
  1773. | innodb_api_enable_mdl | OFF
  1774. | innodb_api_trx_level | 0
  1775. | innodb_autoextend_increment | 64
  1776. | innodb_autoinc_lock_mode | 2
  1777. | innodb_buffer_pool_chunk_size | 134217728
  1778. | innodb_buffer_pool_dump_at_shutdown | ON
  1779. | innodb_buffer_pool_dump_now | OFF
  1780. | innodb_buffer_pool_dump_pct | 25
  1781. | innodb_buffer_pool_filename | ib_buffer_pool
  1782. | innodb_buffer_pool_in_core_file | ON
  1783. | innodb_buffer_pool_instances | 1
  1784. | innodb_buffer_pool_load_abort | OFF
  1785. | innodb_buffer_pool_load_at_startup | ON
  1786. | innodb_buffer_pool_load_now | OFF
  1787. | innodb_buffer_pool_size | 134217728
  1788. | innodb_change_buffer_max_size | 25
  1789. | innodb_change_buffering | all
  1790. | innodb_checksum_algorithm | crc32
  1791. | innodb_cleaner_lsn_age_factor | high_checkpoint
  1792. | innodb_cmp_per_index_enabled | OFF
  1793. | innodb_commit_concurrency | 0
  1794. | innodb_compressed_columns_threshold | 96
  1795. | innodb_compressed_columns_zip_level | 6
  1796. | innodb_compression_failure_threshold_pct | 5
  1797. | innodb_compression_level | 6
  1798. | innodb_compression_pad_pct_max | 50
  1799. | innodb_concurrency_tickets | 5000
  1800. | innodb_corrupt_table_action | assert
  1801. | innodb_data_file_path | ibdata1:12M:autoextend
  1802. | innodb_data_home_dir |
  1803. | innodb_ddl_buffer_size | 1048576
  1804. | innodb_ddl_threads | 4
  1805. | innodb_deadlock_detect | ON
  1806. | innodb_dedicated_server | OFF
  1807. | innodb_default_row_format | dynamic
  1808. | innodb_directories |
  1809. | innodb_disable_sort_file_cache | OFF
  1810. | innodb_doublewrite | ON
  1811. | innodb_doublewrite_batch_size | 0
  1812. | innodb_doublewrite_dir |
  1813. | innodb_doublewrite_files | 2
  1814. | innodb_doublewrite_pages | 4
  1815. | innodb_empty_free_list_algorithm | legacy
  1816. | innodb_encrypt_online_alter_logs | OFF
  1817. | innodb_extend_and_initialize | ON
  1818. | innodb_fast_shutdown | 1
  1819. | innodb_file_per_table | ON
  1820. | innodb_fill_factor | 100
  1821. | innodb_flush_log_at_timeout | 1
  1822. | innodb_flush_log_at_trx_commit | 1
  1823. | innodb_flush_method | fsync
  1824. | innodb_flush_neighbors | 0
  1825. | innodb_flush_sync | ON
  1826. | innodb_flushing_avg_loops | 30
  1827. | innodb_force_index_records_in_range | 0
  1828. | innodb_force_load_corrupted | OFF
  1829. | innodb_force_recovery | 0
  1830. | innodb_fsync_threshold | 0
  1831. | innodb_ft_aux_table |
  1832. | innodb_ft_cache_size | 8000000
  1833. | innodb_ft_enable_diag_print | OFF
  1834. | innodb_ft_enable_stopword | ON
  1835. | innodb_ft_ignore_stopwords | OFF
  1836. | innodb_ft_max_token_size | 84
  1837. | innodb_ft_min_token_size | 3
  1838. | innodb_ft_num_word_optimize | 2000
  1839. | innodb_ft_result_cache_limit | 2000000000
  1840. | innodb_ft_server_stopword_table |
  1841. | innodb_ft_sort_pll_degree | 2
  1842. | innodb_ft_total_cache_size | 640000000
  1843. | innodb_ft_user_stopword_table |
  1844. | innodb_idle_flush_pct | 100
  1845. | innodb_io_capacity | 200
  1846. | innodb_io_capacity_max | 2000
  1847. | innodb_lock_wait_timeout | 50
  1848. | innodb_log_buffer_size | 16777216
  1849. | innodb_log_checksums | ON
  1850. | innodb_log_compressed_pages | ON
  1851. | innodb_log_file_size | 50331648
  1852. | innodb_log_files_in_group | 2
  1853. | innodb_log_group_home_dir | ./
  1854. | innodb_log_spin_cpu_abs_lwm | 80
  1855. | innodb_log_spin_cpu_pct_hwm | 50
  1856. | innodb_log_wait_for_flush_spin_hwm | 400
  1857. | innodb_log_write_ahead_size | 8192
  1858. | innodb_log_writer_threads | ON
  1859. | innodb_lru_scan_depth | 1024
  1860. | innodb_max_dirty_pages_pct | 90.000000
  1861. | innodb_max_dirty_pages_pct_lwm | 10.000000
  1862. | innodb_max_purge_lag | 0
  1863. | innodb_max_purge_lag_delay | 0
  1864. | innodb_max_undo_log_size | 1073741824
  1865. | innodb_monitor_disable |
  1866. | innodb_monitor_enable |
  1867. | innodb_monitor_reset |
  1868. | innodb_monitor_reset_all |
  1869. | innodb_numa_interleave | OFF
  1870. | innodb_old_blocks_pct | 37
  1871. | innodb_old_blocks_time | 1000
  1872. | innodb_online_alter_log_max_size | 134217728
  1873. | innodb_open_files | 4000
  1874. | innodb_optimize_fulltext_only | OFF
  1875. | innodb_page_cleaners | 1
  1876. | innodb_page_size | 16384
  1877. | innodb_parallel_dblwr_encrypt | OFF
  1878. | innodb_parallel_doublewrite_path | xb_doublewrite
  1879. | innodb_parallel_read_threads | 4
  1880. | innodb_print_all_deadlocks | OFF
  1881. | innodb_print_ddl_logs | OFF
  1882. | innodb_print_lock_wait_timeout_info | OFF
  1883. | innodb_purge_batch_size | 300
  1884. | innodb_purge_rseg_truncate_frequency | 128
  1885. | innodb_purge_threads | 4
  1886. | innodb_random_read_ahead | OFF
  1887. | innodb_read_ahead_threshold | 56
  1888. | innodb_read_io_threads | 4
  1889. | innodb_read_only | OFF
  1890. | innodb_records_in_range | 0
  1891. | innodb_redo_log_archive_dirs |
  1892. | innodb_redo_log_capacity | 104857600
  1893. | innodb_redo_log_encrypt | OFF
  1894. | innodb_replication_delay | 0
  1895. | innodb_rollback_on_timeout | OFF
  1896. | innodb_rollback_segments | 128
  1897. | innodb_segment_reserve_factor | 12.500000
  1898. | innodb_show_locks_held | 10
  1899. | innodb_sort_buffer_size | 1048576
  1900. | innodb_spin_wait_delay | 6
  1901. | innodb_spin_wait_pause_multiplier | 50
  1902. | innodb_stats_auto_recalc | ON
  1903. | innodb_stats_include_delete_marked | OFF
  1904. | innodb_stats_method | nulls_equal
  1905. | innodb_stats_on_metadata | OFF
  1906. | innodb_stats_persistent | ON
  1907. | innodb_stats_persistent_sample_pages | 20
  1908. | innodb_stats_transient_sample_pages | 8
  1909. | innodb_status_output | OFF
  1910. | innodb_status_output_locks | OFF
  1911. | innodb_strict_mode | ON
  1912. | innodb_sync_array_size | 1
  1913. | innodb_sync_spin_loops | 30
  1914. | innodb_sys_tablespace_encrypt | OFF
  1915. | innodb_table_locks | ON
  1916. | innodb_temp_data_file_path | ibtmp1:12M:autoextend
  1917. | innodb_temp_tablespace_encrypt | OFF
  1918. | innodb_temp_tablespaces_dir | ./#innodb_temp/
  1919. | innodb_thread_concurrency | 0
  1920. | innodb_thread_sleep_delay | 10000
  1921. | innodb_tmpdir |
  1922. | innodb_undo_directory | ./
  1923. | innodb_undo_log_encrypt | OFF
  1924. | innodb_undo_log_truncate | ON
  1925. | innodb_undo_tablespaces | 2
  1926. | innodb_use_fdatasync | OFF
  1927. | innodb_use_native_aio | ON
  1928. | innodb_validate_tablespace_paths | ON
  1929. | innodb_version | 8.0.36-28
  1930. | innodb_write_io_threads | 4
  1931. | insert_id | 0
  1932. | interactive_timeout | 28800
  1933. | internal_tmp_mem_storage_engine | TempTable
  1934. | jemalloc_detected | OFF
  1935. | jemalloc_profiling | OFF
  1936. | join_buffer_size | 262144
  1937. | keep_files_on_create | OFF
  1938. | key_buffer_size | 8388608
  1939. | key_cache_age_threshold | 300
  1940. | key_cache_block_size | 1024
  1941. | key_cache_division_limit | 100
  1942. | keyring_operations | ON
  1943. | kill_idle_transaction | 0
  1944. | large_files_support | ON
  1945. | large_page_size | 0
  1946. | large_pages | OFF
  1947. | last_insert_id | 0
  1948. | lc_messages | en_US
  1949. | lc_messages_dir | /usr/share/percona-server/
  1950. | lc_time_names | en_US
  1951. | license | GPL
  1952. | local_infile | OFF
  1953. | lock_wait_timeout | 31536000
  1954. | locked_in_memory | OFF
  1955. | log_bin | ON
  1956. | log_bin_basename | /var/lib/mysql/binlog
  1957. | log_bin_index | /var/lib/mysql/binlog.index
  1958. | log_bin_trust_function_creators | OFF
  1959. | log_bin_use_v1_row_events | OFF
  1960. | log_error | stderr
  1961. | log_error_services | log_filter_internal; log_sink_internal
  1962. | log_error_suppression_list |
  1963. | log_error_verbosity | 2
  1964. | log_output | FILE
  1965. | log_queries_not_using_indexes | OFF
  1966. | log_query_errors |
  1967. | log_raw | OFF
  1968. | log_replica_updates | ON
  1969. | log_slave_updates | ON
  1970. | log_slow_admin_statements | OFF
  1971. | log_slow_extra | OFF
  1972. | log_slow_filter |
  1973. | log_slow_rate_limit | 1
  1974. | log_slow_rate_type | session
  1975. | log_slow_replica_statements | OFF
  1976. | log_slow_slave_statements | OFF
  1977. | log_slow_sp_statements | ON
  1978. | log_slow_verbosity |
  1979. | log_statements_unsafe_for_binlog | ON
  1980. | log_throttle_queries_not_using_indexes | 0
  1981. | log_timestamps | UTC
  1982. | long_query_time | 10.000000
  1983. | low_priority_updates | OFF
  1984. | lower_case_file_system | OFF
  1985. | lower_case_table_names | 0
  1986. | mandatory_roles |
  1987. | master_info_repository | TABLE
  1988. | master_verify_checksum | OFF
  1989. | max_allowed_packet | 67108864
  1990. | max_binlog_cache_size | 18446744073709547520
  1991. | max_binlog_size | 1073741824
  1992. | max_binlog_stmt_cache_size | 18446744073709547520
  1993. | max_connect_errors | 100
  1994. | max_connections | 151
  1995. | max_delayed_threads | 20
  1996. | max_digest_length | 1024
  1997. | max_error_count | 1024
  1998. | max_execution_time | 0
  1999. | max_heap_table_size | 16777216
  2000. | max_insert_delayed_threads | 20
  2001. | max_join_size | 18446744073709551615
  2002. | max_length_for_sort_data | 4096
  2003. | max_points_in_geometry | 65536
  2004. | max_prepared_stmt_count | 16382
  2005. | max_relay_log_size | 0
  2006. | max_seeks_for_key | 18446744073709551615
  2007. | max_slowlog_files | 0
  2008. | max_slowlog_size | 0
  2009. | max_sort_length | 1024
  2010. | max_sp_recursion_depth | 0
  2011. | max_user_connections | 0
  2012. | max_write_lock_count | 18446744073709551615
  2013. | min_examined_row_limit | 0
  2014. | myisam_data_pointer_size | 6
  2015. | myisam_max_sort_file_size | 9223372036853727232
  2016. | myisam_mmap_size | 18446744073709551615
  2017. | myisam_recover_options | OFF
  2018. | myisam_sort_buffer_size | 8388608
  2019. | myisam_stats_method | nulls_unequal
  2020. | myisam_use_mmap | OFF
  2021. | mysql_native_password_proxy_users | OFF
  2022. | mysqlx_bind_address | *
  2023. | mysqlx_compression_algorithms | DEFLATE_STREAM,LZ4_MESSAGE,ZSTD_STREAM
  2024. | mysqlx_connect_timeout | 30
  2025. | mysqlx_deflate_default_compression_level | 3
  2026. | mysqlx_deflate_max_client_compression_level | 5
  2027. | mysqlx_document_id_unique_prefix | 0
  2028. | mysqlx_enable_hello_notice | ON
  2029. | mysqlx_idle_worker_thread_timeout | 60
  2030. | mysqlx_interactive_timeout | 28800
  2031. | mysqlx_lz4_default_compression_level | 2
  2032. | mysqlx_lz4_max_client_compression_level | 8
  2033. | mysqlx_max_allowed_packet | 67108864
  2034. | mysqlx_max_connections | 100
  2035. | mysqlx_min_worker_threads | 2
  2036. | mysqlx_port | 33060
  2037. | mysqlx_port_open_timeout | 0
  2038. | mysqlx_read_timeout | 30
  2039. | mysqlx_socket | /var/lib/mysql/mysqlx.sock
  2040. | mysqlx_ssl_ca |
  2041. | mysqlx_ssl_capath |
  2042. | mysqlx_ssl_cert |
  2043. | mysqlx_ssl_cipher |
  2044. | mysqlx_ssl_crl |
  2045. | mysqlx_ssl_crlpath |
  2046. | mysqlx_ssl_key |
  2047. | mysqlx_wait_timeout | 28800
  2048. | mysqlx_write_timeout | 60
  2049. | mysqlx_zstd_default_compression_level | 3
  2050. | mysqlx_zstd_max_client_compression_level | 11
  2051. | net_buffer_length | 16384
  2052. | net_buffer_shrink_interval | 0
  2053. | net_read_timeout | 30
  2054. | net_retry_count | 10
  2055. | net_write_timeout | 60
  2056. | new | OFF
  2057. | ngram_token_size | 2
  2058. | offline_mode | OFF
  2059. | old | OFF
  2060. | old_alter_table | OFF
  2061. | open_files_limit | 1048576
  2062. | optimizer_max_subgraph_pairs | 100000
  2063. | optimizer_prune_level | 1
  2064. | optimizer_search_depth | 62
  2065. | optimizer_switch | index_merge=on,index_merge_union=on,index_merge_sort_union=on,index_merge_intersection=on,engine_condition_pushdown=on,index_condition_pushdown=on,mrr=on,mrr_cost_based=on,block_nested_loop=on,batched_key_access=off,materialization=on,semijoin=on,loosescan=on,firstmatch=on,duplicateweedout=on,subquery_materialization_cost_based=on,use_index_extensions=on,condition_fanout_filter=on,derived_merge=on,use_invisible_indexes=off,skip_scan=on,hash_join=on,subquery_to_derived=off,prefer_ordering_index=on,hypergraph_optimizer=off,derived_condition_pushdown=on,favor_range_scan=off
  2066. | optimizer_trace | enabled=off,one_line=off
  2067. | optimizer_trace_features | greedy_search=on,range_optimizer=on,dynamic_range=on,repeated_subselect=on
  2068. | optimizer_trace_limit | 1
  2069. | optimizer_trace_max_mem_size | 1048576
  2070. | optimizer_trace_offset | -1
  2071. | original_commit_timestamp | 36028797018963968
  2072. | original_server_version | 999999
  2073. | parser_max_mem_size | 18446744073709551615
  2074. | partial_revokes | OFF
  2075. | password_history | 0
  2076. | password_require_current | OFF
  2077. | password_reuse_interval | 0
  2078. | performance_schema | ON
  2079. | performance_schema_accounts_size | -1
  2080. | performance_schema_digests_size | 10000
  2081. | performance_schema_error_size | 5410
  2082. | performance_schema_events_stages_history_long_size | 10000
  2083. | performance_schema_events_stages_history_size | 10
  2084. | performance_schema_events_statements_history_long_size | 10000
  2085. | performance_schema_events_statements_history_size | 10
  2086. | performance_schema_events_transactions_history_long_size | 10000
  2087. | performance_schema_events_transactions_history_size | 10
  2088. | performance_schema_events_waits_history_long_size | 10000
  2089. | performance_schema_events_waits_history_size | 10
  2090. | performance_schema_hosts_size | -1
  2091. | performance_schema_max_cond_classes | 150
  2092. | performance_schema_max_cond_instances | -1
  2093. | performance_schema_max_digest_length | 1024
  2094. | performance_schema_max_digest_sample_age | 60
  2095. | performance_schema_max_file_classes | 80
  2096. | performance_schema_max_file_handles | 32768
  2097. | performance_schema_max_file_instances | -1
  2098. | performance_schema_max_index_stat | -1
  2099. | performance_schema_max_memory_classes | 530
  2100. | performance_schema_max_metadata_locks | -1
  2101. | performance_schema_max_mutex_classes | 350
  2102. | performance_schema_max_mutex_instances | -1
  2103. | performance_schema_max_prepared_statements_instances | -1
  2104. | performance_schema_max_program_instances | -1
  2105. | performance_schema_max_rwlock_classes | 70
  2106. | performance_schema_max_rwlock_instances | -1
  2107. | performance_schema_max_socket_classes | 10
  2108. | performance_schema_max_socket_instances | -1
  2109. | performance_schema_max_sql_text_length | 1024
  2110. | performance_schema_max_stage_classes | 175
  2111. | performance_schema_max_statement_classes | 227
  2112. | performance_schema_max_statement_stack | 10
  2113. | performance_schema_max_table_handles | -1
  2114. | performance_schema_max_table_instances | -1
  2115. | performance_schema_max_table_lock_stat | -1
  2116. | performance_schema_max_thread_classes | 100
  2117. | performance_schema_max_thread_instances | -1
  2118. | performance_schema_session_connect_attrs_size | 512
  2119. | performance_schema_setup_actors_size | -1
  2120. | performance_schema_setup_objects_size | -1
  2121. | performance_schema_show_processlist | OFF
  2122. | performance_schema_users_size | -1
  2123. | persist_only_admin_x509_subject |
  2124. | persist_sensitive_variables_in_plaintext | ON
  2125. | persisted_globals_load | ON
  2126. | pid_file | /var/run/mysqld/mysqld.pid
  2127. | plugin_dir | /usr/lib64/mysql/plugin/
  2128. | port | 3306
  2129. | preload_buffer_size | 32768
  2130. | print_identified_with_as_hex | OFF
  2131. | profiling | OFF
  2132. | profiling_history_size | 15
  2133. | protocol_compression_algorithms | zlib,zstd,uncompressed
  2134. | protocol_version | 10
  2135. | proxy_protocol_networks |
  2136. | proxy_user |
  2137. | pseudo_replica_mode | OFF
  2138. | pseudo_slave_mode | OFF
  2139. | pseudo_thread_id | 9
  2140. | query_alloc_block_size | 8192
  2141. | query_prealloc_size | 8192
  2142. | rand_seed1 | 0
  2143. | rand_seed2 | 0
  2144. | range_alloc_block_size | 4096
  2145. | range_optimizer_max_mem_size | 8388608
  2146. | rbr_exec_mode | STRICT
  2147. | read_buffer_size | 131072
  2148. | read_only | OFF
  2149. | read_rnd_buffer_size | 262144
  2150. | regexp_stack_limit | 8000000
  2151. | regexp_time_limit | 32
  2152. | relay_log | dc279959a518-relay-bin
  2153. | relay_log_basename | /var/lib/mysql/dc279959a518-relay-bin
  2154. | relay_log_index | /var/lib/mysql/dc279959a518-relay-bin.index
  2155. | relay_log_info_file | relay-log.info
  2156. | relay_log_info_repository | TABLE
  2157. | relay_log_purge | ON
  2158. | relay_log_recovery | OFF
  2159. | relay_log_space_limit | 0
  2160. | replica_allow_batching | ON
  2161. | replica_checkpoint_group | 512
  2162. | replica_checkpoint_period | 300
  2163. | replica_compressed_protocol | OFF
  2164. | replica_enable_event |
  2165. | replica_exec_mode | STRICT
  2166. | replica_load_tmpdir | /tmp
  2167. | replica_max_allowed_packet | 1073741824
  2168. | replica_net_timeout | 60
  2169. | replica_parallel_type | LOGICAL_CLOCK
  2170. | replica_parallel_workers | 4
  2171. | replica_pending_jobs_size_max | 134217728
  2172. | replica_preserve_commit_order | ON
  2173. | replica_skip_errors | OFF
  2174. | replica_sql_verify_checksum | ON
  2175. | replica_transaction_retries | 10
  2176. | replica_type_conversions |
  2177. | replication_optimize_for_static_plugin_config | OFF
  2178. | replication_sender_observe_commit_only | OFF
  2179. | report_host |
  2180. | report_password |
  2181. | report_port | 3306
  2182. | report_user |
  2183. | require_row_format | OFF
  2184. | require_secure_transport | OFF
  2185. | resultset_metadata | FULL
  2186. | rpl_read_size | 8192
  2187. | rpl_stop_replica_timeout | 31536000
  2188. | rpl_stop_slave_timeout | 31536000
  2189. | schema_definition_cache | 256
  2190. | secondary_engine_cost_threshold | 100000.000000
  2191. | secure_file_priv | /var/lib/mysql-files/
  2192. | secure_log_path |
  2193. | select_into_buffer_size | 131072
  2194. | select_into_disk_sync | OFF
  2195. | select_into_disk_sync_delay | 0
  2196. | server_id | 1
  2197. | server_id_bits | 32
  2198. | server_uuid | 882f90c3-1a73-11ef-b322-0242ac110003
  2199. | session_track_gtids | OFF
  2200. | session_track_schema | ON
  2201. | session_track_state_change | OFF
  2202. | session_track_system_variables | time_zone,autocommit,character_set_client,character_set_results,character_set_connection
  2203. | session_track_transaction_info | OFF
  2204. | sha256_password_auto_generate_rsa_keys | ON
  2205. | sha256_password_private_key_path | private_key.pem
  2206. | sha256_password_proxy_users | OFF
  2207. | sha256_password_public_key_path | public_key.pem
  2208. | show_create_table_skip_secondary_engine | OFF
  2209. | show_create_table_verbosity | OFF
  2210. | show_gipk_in_create_table_and_information_schema | ON
  2211. | show_old_temporals | OFF
  2212. | skip_external_locking | ON
  2213. | skip_name_resolve | ON
  2214. | skip_networking | OFF
  2215. | skip_replica_start | OFF
  2216. | skip_show_database | OFF
  2217. | skip_slave_start | OFF
  2218. | slave_allow_batching | ON
  2219. | slave_checkpoint_group | 512
  2220. | slave_checkpoint_period | 300
  2221. | slave_compressed_protocol | OFF
  2222. | slave_exec_mode | STRICT
  2223. | slave_load_tmpdir | /tmp
  2224. | slave_max_allowed_packet | 1073741824
  2225. | slave_net_timeout | 60
  2226. | slave_parallel_type | LOGICAL_CLOCK
  2227. | slave_parallel_workers | 4
  2228. | slave_pending_jobs_size_max | 134217728
  2229. | slave_preserve_commit_order | ON
  2230. | slave_rows_search_algorithms | INDEX_SCAN,HASH_SCAN
  2231. | slave_skip_errors | OFF
  2232. | slave_sql_verify_checksum | ON
  2233. | slave_transaction_retries | 10
  2234. | slave_type_conversions |
  2235. | slow_launch_time | 2
  2236. | slow_query_log | OFF
  2237. | slow_query_log_always_write_time | 10.000000
  2238. | slow_query_log_file | /var/lib/mysql/dc279959a518-slow.log
  2239. | slow_query_log_use_global_control |
  2240. | socket | /var/lib/mysql/mysql.sock
  2241. | sort_buffer_size | 262144
  2242. | source_verify_checksum | OFF
  2243. | sql_auto_is_null | OFF
  2244. | sql_big_selects | ON
  2245. | sql_buffer_result | OFF
  2246. | sql_generate_invisible_primary_key | OFF
  2247. | sql_log_bin | ON
  2248. | sql_log_off | OFF
  2249. | sql_mode | ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION
  2250. | sql_notes | ON
  2251. | sql_quote_show_create | ON
  2252. | sql_replica_skip_counter | 0
  2253. | sql_require_primary_key | OFF
  2254. | sql_safe_updates | OFF
  2255. | sql_select_limit | 18446744073709551615
  2256. | sql_slave_skip_counter | 0
  2257. | sql_warnings | OFF
  2258. | ssl_ca | ca.pem
  2259. | ssl_capath |
  2260. | ssl_cert | server-cert.pem
  2261. | ssl_cipher |
  2262. | ssl_crl |
  2263. | ssl_crlpath |
  2264. | ssl_fips_mode | OFF
  2265. | ssl_key | server-key.pem
  2266. | ssl_session_cache_mode | ON
  2267. | ssl_session_cache_timeout | 300
  2268. | statement_id | 19
  2269. | stored_program_cache | 256
  2270. | stored_program_definition_cache | 256
  2271. | super_read_only | OFF
  2272. | sync_binlog | 1
  2273. | sync_master_info | 10000
  2274. | sync_relay_log | 10000
  2275. | sync_relay_log_info | 10000
  2276. | sync_source_info | 10000
  2277. | system_time_zone | UTC
  2278. | table_definition_cache | 2000
  2279. | table_encryption_privilege_check | OFF
  2280. | table_open_cache | 4000
  2281. | table_open_cache_instances | 16
  2282. | table_open_cache_triggers | 524288
  2283. | tablespace_definition_cache | 256
  2284. | temptable_max_mmap | 1073741824
  2285. | temptable_max_ram | 1073741824
  2286. | temptable_use_mmap | ON
  2287. | terminology_use_previous | NONE
  2288. | tf_sequence_table_max_upper_bound | 1048576
  2289. | thread_cache_size | 9
  2290. | thread_handling | one-thread-per-connection
  2291. | thread_pool_high_prio_mode | transactions
  2292. | thread_pool_high_prio_tickets | 4294967295
  2293. | thread_pool_idle_timeout | 60
  2294. | thread_pool_max_threads | 100000
  2295. | thread_pool_oversubscribe | 3
  2296. | thread_pool_size | 4
  2297. | thread_pool_stall_limit | 500
  2298. | thread_stack | 1048576
  2299. | thread_statistics | OFF
  2300. | time_zone | SYSTEM
  2301. | timestamp | 1716720573.179868
  2302. | tls_ciphersuites |
  2303. | tls_version | TLSv1.2,TLSv1.3
  2304. | tmp_table_size | 16777216
  2305. | tmpdir | /tmp
  2306. | transaction_alloc_block_size | 8192
  2307. | transaction_allow_batching | OFF
  2308. | transaction_isolation | REPEATABLE-READ
  2309. | transaction_prealloc_size | 4096
  2310. | transaction_read_only | OFF
  2311. | transaction_write_set_extraction | XXHASH64
  2312. | unique_checks | ON
  2313. | updatable_views_with_limit | YES
  2314. | use_secondary_engine | ON
  2315. | userstat | OFF
  2316. | version | 8.0.36-28
  2317. | version_comment | Percona Server (GPL), Release 28, Revision 47601f19
  2318. | version_compile_machine | x86_64
  2319. | version_compile_os | Linux
  2320. | version_compile_zlib | 1.2.13
  2321. | version_suffix |
  2322. | wait_timeout | 28800
  2323. | warning_count | 0
  2324. | windowing_use_high_precision | ON
  2325. | xa_detach_on_prepare | ON
  2326. +----------------------------------------------------------+
  2327. 712 rows in set (0.00 sec)
  2328.  
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
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!