Basic Information
May 14, 2024, 09:43:56 PM
| Operating System: | AlmaLinux release 8.9 (Midnight Oncilla) |
|---|---|
| Processor: | Intel® Xeon® CPU E5-1630 v3 @ 3.70GHz (3799.919MHz) |
| Load averages: | 4.32, 3.89, 3.87 |
| Current processes: | 222 (125 sleeping, 97 running, 0 zombie) |
| Processes by CPU: | nginx (4) 2.1%, httpd (8) 2.0%, mysqld (1) 26.2%, (other) (162) 0.2% |
| Memory usage: |
69.756% (45913660k / 65820104k) Swap: 1.806% (9468k / 524284k) |
MySQL processes
| Total processes: | 4 (1 sleeping, 3 running, 0 locked) |
|---|
Running processes
| State | Time | Query |
|---|---|---|
| waiting for handler commit | 0s | UPDATE smf_log_activity |
| waiting for handler commit | 0s | UPDATE smf_log_online |
MySQL Statistics
MySQL 8.0.x
| Connections per second: | 11.5744 |
|---|---|
| Kilobytes received per second: | 69.6522 |
| Kilobytes sent per second: | 1452.3212 |
| Queries per second: | 274.1369 |
| Percentage of slow queries: | 0 |
|
Opened vs. Open tables: (table_cache) |
1.063 (should be <= 80) |
|
Key buffer read hit rate: (key_buffer_size) |
0.0004 (should be <= 0.01) |
|
Key buffer write hit rate: (key_buffer_size) |
0.9895 (should be <= 0.5) |
|
Thread cache hit rate: (thread_cache_size) |
2106.5455 (should be >= 30 ) |
|
Thread cache usage: (thread_cache_size) |
0.4833 (should be >= 0.7 and <= 0.9) |
|
Temporary table disk usage: (tmp_table_size) |
0 (should be <= 0.5) |
|
Sort merge pass rate: (sort_buffer) |
0 (should be <= 0.001) |
|
Query cache enabled: (query_cache_type) |
0 (should be >= 1 and <= 1) |
MySQL status
| Aborted_clients: | 6 |
|---|---|
| Aborted_connects: | 2 |
| Acl_cache_items_count: | 0 |
| Binlog_cache_disk_use: | 0 |
| Binlog_cache_use: | 0 |
| Binlog_stmt_cache_disk_use: | 0 |
| Binlog_stmt_cache_use: | 0 |
| Bytes_received: | 428370870 |
| Bytes_sent: | 8931984331 |
| Caching_sha2_password_rsa_public_key: | -----BEGIN PUBLIC KEY----- MIIBIjANBgkqhkiG9w0BAQEFAAOCAQ8AMIIBCgKCAQEAudY+WyUvbrOklqttOdHc Jrrmdw1rpk/qPoNlMsmbGkXdGvHoJytWTumQmFeTjCKKbkbWo1osut4rsllW4fCr 7e5upTxW920ViT7vkQpIr7D8XIX1u83H38QPpTP/T/qP8PbmstTns847arK2E/CL bcpCZjKQasDAVGU4x7ngIyM0sl4x8cvODX8Q53xCIzbqiIdwVlcp+oB7YNIWI+xV 4g0lC8Kqhr3VxdY25gVTULGe/qw45aEqjNHHqZV70YA8sFAlUZiKGHT/jC8Qak3A mFhp+SIi5955/Df3u8HlGBqhTE6yBlRztugSiMqJUbd9yFiHAcAQ5ZwcwSEsng+3 wwIDAQAB -----END PUBLIC KEY----- |
| Com_admin_commands: | 1 |
| Com_assign_to_keycache: | 0 |
| Com_alter_db: | 0 |
| Com_alter_event: | 0 |
| Com_alter_function: | 0 |
| Com_alter_instance: | 0 |
| Com_alter_procedure: | 0 |
| Com_alter_resource_group: | 0 |
| Com_alter_server: | 0 |
| Com_alter_table: | 0 |
| Com_alter_tablespace: | 0 |
| Com_alter_user: | 0 |
| Com_alter_user_default_role: | 0 |
| Com_analyze: | 0 |
| Com_begin: | 0 |
| Com_binlog: | 0 |
| Com_call_procedure: | 0 |
| Com_change_db: | 69309 |
| Com_change_master: | 0 |
| Com_change_repl_filter: | 0 |
| Com_change_replication_source: | 0 |
| Com_check: | 0 |
| Com_checksum: | 0 |
| Com_clone: | 0 |
| Com_commit: | 0 |
| Com_create_db: | 1 |
| Com_create_event: | 0 |
| Com_create_function: | 0 |
| Com_create_index: | 0 |
| Com_create_procedure: | 0 |
| Com_create_role: | 0 |
| Com_create_server: | 0 |
| Com_create_table: | 70 |
| Com_create_resource_group: | 0 |
| Com_create_trigger: | 0 |
| Com_create_udf: | 0 |
| Com_create_user: | 0 |
| Com_create_view: | 0 |
| Com_create_spatial_reference_system: | 0 |
| Com_dealloc_sql: | 0 |
| Com_delete: | 135990 |
| Com_delete_multi: | 0 |
| Com_do: | 0 |
| Com_drop_db: | 0 |
| Com_drop_event: | 0 |
| Com_drop_function: | 0 |
| Com_drop_index: | 0 |
| Com_drop_procedure: | 0 |
| Com_drop_resource_group: | 0 |
| Com_drop_role: | 0 |
| Com_drop_server: | 0 |
| Com_drop_spatial_reference_system: | 0 |
| Com_drop_table: | 35 |
| Com_drop_trigger: | 0 |
| Com_drop_user: | 0 |
| Com_drop_view: | 0 |
| Com_empty_query: | 0 |
| Com_execute_sql: | 0 |
| Com_explain_other: | 0 |
| Com_flush: | 1 |
| Com_get_diagnostics: | 0 |
| Com_grant: | 0 |
| Com_grant_roles: | 0 |
| Com_ha_close: | 0 |
| Com_ha_open: | 0 |
| Com_ha_read: | 0 |
| Com_help: | 0 |
| Com_import: | 0 |
| Com_insert: | 60218 |
| Com_insert_select: | 74 |
| Com_install_component: | 0 |
| Com_install_plugin: | 0 |
| Com_kill: | 0 |
| Com_load: | 0 |
| Com_lock_instance: | 0 |
| Com_lock_tables: | 0 |
| Com_optimize: | 0 |
| Com_preload_keys: | 0 |
| Com_prepare_sql: | 0 |
| Com_purge: | 0 |
| Com_purge_before_date: | 0 |
| Com_release_savepoint: | 0 |
| Com_rename_table: | 0 |
| Com_rename_user: | 0 |
| Com_repair: | 0 |
| Com_replace: | 480 |
| Com_replace_select: | 0 |
| Com_reset: | 0 |
| Com_resignal: | 0 |
| Com_restart: | 0 |
| Com_revoke: | 0 |
| Com_revoke_all: | 0 |
| Com_revoke_roles: | 0 |
| Com_rollback: | 0 |
| Com_rollback_to_savepoint: | 0 |
| Com_savepoint: | 0 |
| Com_select: | 943948 |
| Com_set_option: | 189767 |
| Com_set_password: | 0 |
| Com_set_resource_group: | 0 |
| Com_set_role: | 0 |
| Com_signal: | 0 |
| Com_show_binlog_events: | 0 |
| Com_show_binlogs: | 0 |
| Com_show_charsets: | 0 |
| Com_show_collations: | 0 |
| Com_show_create_db: | 0 |
| Com_show_create_event: | 0 |
| Com_show_create_func: | 0 |
| Com_show_create_proc: | 0 |
| Com_show_create_table: | 0 |
| Com_show_create_trigger: | 0 |
| Com_show_databases: | 0 |
| Com_show_engine_logs: | 0 |
| Com_show_engine_mutex: | 0 |
| Com_show_engine_status: | 0 |
| Com_show_events: | 0 |
| Com_show_errors: | 0 |
| Com_show_fields: | 26 |
| Com_show_function_code: | 0 |
| Com_show_function_status: | 0 |
| Com_show_grants: | 0 |
| Com_show_keys: | 0 |
| Com_show_master_status: | 0 |
| Com_show_open_tables: | 0 |
| Com_show_plugins: | 0 |
| Com_show_privileges: | 0 |
| Com_show_procedure_code: | 0 |
| Com_show_procedure_status: | 0 |
| Com_show_processlist: | 21 |
| Com_show_profile: | 0 |
| Com_show_profiles: | 0 |
| Com_show_relaylog_events: | 0 |
| Com_show_replicas: | 0 |
| Com_show_slave_hosts: | 0 |
| Com_show_replica_status: | 0 |
| Com_show_slave_status: | 0 |
| Com_show_status: | 3 |
| Com_show_storage_engines: | 0 |
| Com_show_table_status: | 0 |
| Com_show_tables: | 24 |
| Com_show_triggers: | 0 |
| Com_show_variables: | 2 |
| Com_show_warnings: | 0 |
| Com_show_create_user: | 0 |
| Com_shutdown: | 0 |
| Com_replica_start: | 0 |
| Com_slave_start: | 0 |
| Com_replica_stop: | 0 |
| Com_slave_stop: | 0 |
| Com_group_replication_start: | 0 |
| Com_group_replication_stop: | 0 |
| Com_stmt_execute: | 0 |
| Com_stmt_close: | 0 |
| Com_stmt_fetch: | 0 |
| Com_stmt_prepare: | 0 |
| Com_stmt_reset: | 0 |
| Com_stmt_send_long_data: | 0 |
| Com_truncate: | 0 |
| Com_uninstall_component: | 0 |
| Com_uninstall_plugin: | 0 |
| Com_unlock_instance: | 0 |
| Com_unlock_tables: | 0 |
| Com_update: | 177042 |
| Com_update_multi: | 0 |
| Com_xa_commit: | 0 |
| Com_xa_end: | 0 |
| Com_xa_prepare: | 0 |
| Com_xa_recover: | 0 |
| Com_xa_rollback: | 0 |
| Com_xa_start: | 0 |
| Com_stmt_reprepare: | 0 |
| Connection_errors_accept: | 0 |
| Connection_errors_internal: | 0 |
| Connection_errors_max_connections: | 0 |
| Connection_errors_peer_address: | 0 |
| Connection_errors_select: | 0 |
| Connection_errors_tcpwrap: | 0 |
| Connections: | 69516 |
| Created_tmp_disk_tables: | 0 |
| Created_tmp_files: | 1549 |
| Created_tmp_tables: | 201 |
| Current_tls_ca: | ca.pem |
| Current_tls_capath: | |
| Current_tls_cert: | server-cert.pem |
| Current_tls_cipher: | |
| Current_tls_ciphersuites: | |
| Current_tls_crl: | |
| Current_tls_crlpath: | |
| Current_tls_key: | server-key.pem |
| Current_tls_version: | TLSv1.2,TLSv1.3 |
| Delayed_errors: | 0 |
| Delayed_insert_threads: | 0 |
| Delayed_writes: | 0 |
| Deprecated_use_i_s_processlist_count: | 21 |
| Deprecated_use_i_s_processlist_last_timestamp: | 1715748002105197 |
| Error_log_buffered_bytes: | 5242720 |
| Error_log_buffered_events: | 23405 |
| Error_log_expired_events: | 69106 |
| Error_log_latest_write: | 1715748236429491 |
| Flush_commands: | 3 |
| Global_connection_memory: | 0 |
| Handler_commit: | 1198589 |
| Handler_delete: | 36118 |
| Handler_discover: | 0 |
| Handler_external_lock: | 4235745 |
| Handler_mrr_init: | 0 |
| Handler_prepare: | 0 |
| Handler_read_first: | 496237 |
| Handler_read_key: | 12284253 |
| Handler_read_last: | 4471 |
| Handler_read_next: | 363255806 |
| Handler_read_prev: | 2815666 |
| Handler_read_rnd: | 1334409 |
| Handler_read_rnd_next: | 2760454688 |
| Handler_rollback: | 0 |
| Handler_savepoint: | 0 |
| Handler_savepoint_rollback: | 0 |
| Handler_update: | 191417 |
| Handler_write: | 116749 |
| Innodb_buffer_pool_dump_status: | Dumping of buffer pool not started |
| Innodb_buffer_pool_load_status: | Buffer pool(s) load completed at 240515 3:05:59 |
| Innodb_buffer_pool_resize_status: | |
| Innodb_buffer_pool_resize_status_code: | 0 |
| Innodb_buffer_pool_resize_status_progress: | 0 |
| Innodb_buffer_pool_pages_data: | 150388 |
| Innodb_buffer_pool_bytes_data: | 2463956992 |
| Innodb_buffer_pool_pages_dirty: | 2291 |
| Innodb_buffer_pool_bytes_dirty: | 37535744 |
| Innodb_buffer_pool_pages_flushed: | 93787 |
| Innodb_buffer_pool_pages_free: | 895546 |
| Innodb_buffer_pool_pages_misc: | 2642 |
| Innodb_buffer_pool_pages_total: | 1048576 |
| Innodb_buffer_pool_read_ahead_rnd: | 0 |
| Innodb_buffer_pool_read_ahead: | 67845 |
| Innodb_buffer_pool_read_ahead_evicted: | 0 |
| Innodb_buffer_pool_read_requests: | 270600983 |
| Innodb_buffer_pool_reads: | 81571 |
| Innodb_buffer_pool_wait_free: | 0 |
| Innodb_buffer_pool_write_requests: | 2110898 |
| Innodb_data_fsyncs: | 317226 |
| Innodb_data_pending_fsyncs: | 1 |
| Innodb_data_pending_reads: | 0 |
| Innodb_data_pending_writes: | 0 |
| Innodb_data_read: | 2448771584 |
| Innodb_data_reads: | 149700 |
| Innodb_data_writes: | 467725 |
| Innodb_data_written: | 1995977728 |
| Innodb_dblwr_pages_written: | 93440 |
| Innodb_dblwr_writes: | 92065 |
| Innodb_redo_log_read_only: | OFF |
| Innodb_redo_log_uuid: | 798255033 |
| Innodb_redo_log_checkpoint_lsn: | 49581206428 |
| Innodb_redo_log_current_lsn: | 49595731739 |
| Innodb_redo_log_flushed_to_disk_lsn: | 49595730268 |
| Innodb_redo_log_logical_size: | 14525952 |
| Innodb_redo_log_physical_size: | 536870912 |
| Innodb_redo_log_capacity_resized: | 8589934592 |
| Innodb_redo_log_resize_status: | OK |
| Innodb_log_waits: | 0 |
| Innodb_log_write_requests: | 1419654 |
| Innodb_log_writes: | 284987 |
| Innodb_os_log_fsyncs: | 147216 |
| Innodb_os_log_pending_fsyncs: | 1 |
| Innodb_os_log_pending_writes: | 0 |
| Innodb_os_log_written: | 325875200 |
| Innodb_page_size: | 16384 |
| Innodb_pages_created: | 987 |
| Innodb_pages_read: | 149458 |
| Innodb_pages_written: | 93787 |
| Innodb_redo_log_enabled: | ON |
| Innodb_row_lock_current_waits: | 1 |
| Innodb_row_lock_time: | 117596 |
| Innodb_row_lock_time_avg: | 65 |
| Innodb_row_lock_time_max: | 32152 |
| Innodb_row_lock_waits: | 1785 |
| Innodb_rows_deleted: | 36060 |
| Innodb_rows_inserted: | 63096 |
| Innodb_rows_read: | 3128655259 |
| Innodb_rows_updated: | 147791 |
| Innodb_system_rows_deleted: | 8 |
| Innodb_system_rows_inserted: | 8 |
| Innodb_system_rows_read: | 17746 |
| Innodb_system_rows_updated: | 702 |
| Innodb_sampled_pages_read: | 0 |
| Innodb_sampled_pages_skipped: | 0 |
| Innodb_num_open_files: | 126 |
| Innodb_truncated_status_writes: | 0 |
| Innodb_undo_tablespaces_total: | 2 |
| Innodb_undo_tablespaces_implicit: | 2 |
| Innodb_undo_tablespaces_explicit: | 0 |
| Innodb_undo_tablespaces_active: | 2 |
| Key_blocks_not_flushed: | 0 |
| Key_blocks_unused: | 131502 |
| Key_blocks_used: | 1077 |
| Key_read_requests: | 2682495 |
| Key_reads: | 1074 |
| Key_write_requests: | 190 |
| Key_writes: | 188 |
| Locked_connects: | 0 |
| Max_execution_time_exceeded: | 0 |
| Max_execution_time_set: | 0 |
| Max_execution_time_set_failed: | 0 |
| Max_used_connections: | 33 |
| Max_used_connections_time: | 2024-05-15 03:35:09 |
| Not_flushed_delayed_rows: | 0 |
| Ongoing_anonymous_transaction_count: | 0 |
| Open_files: | 253 |
| Open_streams: | 0 |
| Open_table_definitions: | 291 |
| Open_tables: | 1840 |
| Opened_files: | 253 |
| Opened_table_definitions: | 399 |
| Opened_tables: | 1956 |
| Performance_schema_accounts_lost: | 0 |
| Performance_schema_cond_classes_lost: | 0 |
| Performance_schema_cond_instances_lost: | 0 |
| Performance_schema_digest_lost: | 0 |
| Performance_schema_file_classes_lost: | 0 |
| Performance_schema_file_handles_lost: | 0 |
| Performance_schema_file_instances_lost: | 0 |
| Performance_schema_hosts_lost: | 0 |
| Performance_schema_index_stat_lost: | 0 |
| Performance_schema_locker_lost: | 0 |
| Performance_schema_memory_classes_lost: | 0 |
| Performance_schema_metadata_lock_lost: | 0 |
| Performance_schema_mutex_classes_lost: | 0 |
| Performance_schema_mutex_instances_lost: | 0 |
| Performance_schema_nested_statement_lost: | 0 |
| Performance_schema_prepared_statements_lost: | 0 |
| Performance_schema_program_lost: | 0 |
| Performance_schema_rwlock_classes_lost: | 0 |
| Performance_schema_rwlock_instances_lost: | 0 |
| Performance_schema_session_connect_attrs_longest_seen: | 164 |
| Performance_schema_session_connect_attrs_lost: | 0 |
| Performance_schema_socket_classes_lost: | 0 |
| Performance_schema_socket_instances_lost: | 0 |
| Performance_schema_stage_classes_lost: | 0 |
| Performance_schema_statement_classes_lost: | 0 |
| Performance_schema_table_handles_lost: | 0 |
| Performance_schema_table_instances_lost: | 0 |
| Performance_schema_table_lock_stat_lost: | 0 |
| Performance_schema_thread_classes_lost: | 0 |
| Performance_schema_thread_instances_lost: | 0 |
| Performance_schema_users_lost: | 0 |
| Prepared_stmt_count: | 0 |
| Queries: | 1646468 |
| Questions: | 1646466 |
| Replica_open_temp_tables: | 0 |
| Resource_group_supported: | ON |
| Rsa_public_key: | -----BEGIN PUBLIC KEY----- MIIBIjANBgkqhkiG9w0BAQEFAAOCAQ8AMIIBCgKCAQEAudY+WyUvbrOklqttOdHc Jrrmdw1rpk/qPoNlMsmbGkXdGvHoJytWTumQmFeTjCKKbkbWo1osut4rsllW4fCr 7e5upTxW920ViT7vkQpIr7D8XIX1u83H38QPpTP/T/qP8PbmstTns847arK2E/CL bcpCZjKQasDAVGU4x7ngIyM0sl4x8cvODX8Q53xCIzbqiIdwVlcp+oB7YNIWI+xV 4g0lC8Kqhr3VxdY25gVTULGe/qw45aEqjNHHqZV70YA8sFAlUZiKGHT/jC8Qak3A mFhp+SIi5955/Df3u8HlGBqhTE6yBlRztugSiMqJUbd9yFiHAcAQ5ZwcwSEsng+3 wwIDAQAB -----END PUBLIC KEY----- |
| Secondary_engine_execution_count: | 0 |
| Select_full_join: | 71678 |
| Select_full_range_join: | 8 |
| Select_range: | 230205 |
| Select_range_check: | 0 |
| Select_scan: | 329941 |
| Slave_open_temp_tables: | 0 |
| Slow_launch_threads: | 0 |
| Slow_queries: | 4 |
| Sort_merge_passes: | 1 |
| Sort_range: | 0 |
| Sort_rows: | 1789639 |
| Sort_scan: | 102994 |
| Ssl_accept_renegotiates: | 0 |
| Ssl_accepts: | 0 |
| Ssl_callback_cache_hits: | 0 |
| Ssl_cipher: | |
| Ssl_cipher_list: | |
| Ssl_client_connects: | 0 |
| Ssl_connect_renegotiates: | 0 |
| Ssl_ctx_verify_depth: | 18446744073709551615 |
| Ssl_ctx_verify_mode: | 5 |
| Ssl_default_timeout: | 0 |
| Ssl_finished_accepts: | 0 |
| Ssl_finished_connects: | 0 |
| Ssl_server_not_after: | Apr 27 11:29:38 2034 GMT |
| Ssl_server_not_before: | Apr 29 11:29:38 2024 GMT |
| Ssl_session_cache_hits: | 0 |
| Ssl_session_cache_misses: | 0 |
| Ssl_session_cache_mode: | SERVER |
| Ssl_session_cache_overflows: | 0 |
| Ssl_session_cache_size: | 128 |
| Ssl_session_cache_timeout: | 300 |
| Ssl_session_cache_timeouts: | 0 |
| Ssl_sessions_reused: | 0 |
| Ssl_used_session_cache_entries: | 0 |
| Ssl_verify_depth: | 0 |
| Ssl_verify_mode: | 0 |
| Ssl_version: | |
| Table_locks_immediate: | 248628 |
| Table_locks_waited: | 0 |
| Table_open_cache_hits: | 2104490 |
| Table_open_cache_misses: | 1921 |
| Table_open_cache_overflows: | 0 |
| Tc_log_max_pages_used: | 0 |
| Tc_log_page_size: | 0 |
| Tc_log_page_waits: | 0 |
| Telemetry_traces_supported: | ON |
| Threads_cached: | 29 |
| Threads_connected: | 4 |
| Threads_created: | 33 |
| Threads_running: | 4 |
| Tls_library_version: | OpenSSL 1.1.1k FIPS 25 Mar 2021 |
| Uptime: | 6006 |
| Uptime_since_flush_status: | 6006 |
MySQL variables
| activate_all_roles_on_login: | OFF |
|---|---|
| admin_address: | |
| admin_port: | 33062 |
| admin_ssl_ca: | |
| admin_ssl_capath: | |
| admin_ssl_cert: | |
| admin_ssl_cipher: | |
| admin_ssl_crl: | |
| admin_ssl_crlpath: | |
| admin_ssl_key: | |
| admin_tls_ciphersuites: | |
| admin_tls_version: | TLSv1.2,TLSv1.3 |
| authentication_policy: | *,, |
| auto_generate_certs: | ON |
| auto_increment_increment: | 1 |
| auto_increment_offset: | 1 |
| autocommit: | ON |
| automatic_sp_privileges: | ON |
| avoid_temporal_upgrade: | OFF |
| back_log: | 151 |
| basedir: | /usr/ |
| big_tables: | OFF |
| bind_address: | * |
| binlog_cache_size: | 32768 |
| binlog_checksum: | CRC32 |
| binlog_direct_non_transactional_updates: | OFF |
| binlog_encryption: | OFF |
| binlog_error_action: | ABORT_SERVER |
| binlog_expire_logs_auto_purge: | ON |
| binlog_expire_logs_seconds: | 2592000 |
| binlog_format: | ROW |
| binlog_group_commit_sync_delay: | 0 |
| binlog_group_commit_sync_no_delay_count: | 0 |
| binlog_gtid_simple_recovery: | ON |
| binlog_max_flush_queue_time: | 0 |
| binlog_order_commits: | ON |
| binlog_rotate_encryption_master_key_at_startup: | OFF |
| binlog_row_event_max_size: | 8192 |
| binlog_row_image: | FULL |
| binlog_row_metadata: | MINIMAL |
| binlog_row_value_options: | |
| binlog_rows_query_log_events: | OFF |
| binlog_stmt_cache_size: | 32768 |
| binlog_transaction_compression: | OFF |
| binlog_transaction_compression_level_zstd: | 3 |
| binlog_transaction_dependency_history_size: | 25000 |
| binlog_transaction_dependency_tracking: | COMMIT_ORDER |
| block_encryption_mode: | aes-128-ecb |
| build_id: | 52159473a0b3e6208d16fa21c8f764d0d1194a1a |
| bulk_insert_buffer_size: | 8388608 |
| caching_sha2_password_auto_generate_rsa_keys: | ON |
| caching_sha2_password_digest_rounds: | 5000 |
| caching_sha2_password_private_key_path: | private_key.pem |
| caching_sha2_password_public_key_path: | public_key.pem |
| character_set_client: | utf8mb4 |
| character_set_connection: | utf8mb4 |
| character_set_database: | utf8mb4 |
| character_set_filesystem: | binary |
| character_set_results: | utf8mb4 |
| character_set_server: | utf8mb4 |
| character_set_system: | utf8mb3 |
| character_sets_dir: | /usr/share/mysql-8.0/charsets/ |
| check_proxy_users: | OFF |
| collation_connection: | utf8mb4_0900_ai_ci |
| collation_database: | utf8mb4_0900_ai_ci |
| collation_server: | utf8mb4_0900_ai_ci |
| completion_type: | NO_CHAIN |
| concurrent_insert: | ALWAYS |
| connect_timeout: | 10 |
| connection_memory_chunk_size: | 8192 |
| connection_memory_limit: | 18446744073709551615 |
| core_file: | OFF |
| create_admin_listener_thread: | OFF |
| cte_max_recursion_depth: | 1000 |
| datadir: | /var/lib/mysql/ |
| default_authentication_plugin: | mysql_native_password |
| default_collation_for_utf8mb4: | utf8mb4_0900_ai_ci |
| default_password_lifetime: | 0 |
| default_storage_engine: | InnoDB |
| default_table_encryption: | OFF |
| default_tmp_storage_engine: | InnoDB |
| default_week_format: | 0 |
| delay_key_write: | ON |
| delayed_insert_limit: | 100 |
| delayed_insert_timeout: | 300 |
| delayed_queue_size: | 1000 |
| disabled_storage_engines: | |
| disconnect_on_expired_password: | ON |
| div_precision_increment: | 4 |
| end_markers_in_json: | OFF |
| enforce_gtid_consistency: | OFF |
| eq_range_index_dive_limit: | 200 |
| error_count: | 0 |
| event_scheduler: | ON |
| expire_logs_days: | 0 |
| explain_format: | TRADITIONAL |
| explicit_defaults_for_timestamp: | ON |
| external_user: | |
| flush: | OFF |
| flush_time: | 0 |
| foreign_key_checks: | ON |
| ft_boolean_syntax: | + -><()~*:""&| |
| ft_max_word_len: | 84 |
| ft_min_word_len: | 4 |
| ft_query_expansion_limit: | 20 |
| ft_stopword_file: | (built-in) |
| general_log: | OFF |
| general_log_file: | /var/lib/mysql/server.log |
| generated_random_password_length: | 20 |
| global_connection_memory_limit: | 18446744073709551615 |
| global_connection_memory_tracking: | OFF |
| group_concat_max_len: | 1024 |
| group_replication_consistency: | EVENTUAL |
| gtid_executed: | |
| gtid_executed_compression_period: | 0 |
| gtid_mode: | OFF |
| gtid_next: | AUTOMATIC |
| gtid_owned: | |
| gtid_purged: | |
| have_compress: | YES |
| have_dynamic_loading: | YES |
| have_geometry: | YES |
| have_openssl: | YES |
| have_profiling: | YES |
| have_query_cache: | NO |
| have_rtree_keys: | YES |
| have_ssl: | YES |
| have_statement_timeout: | YES |
| have_symlink: | DISABLED |
| histogram_generation_max_mem_size: | 20000000 |
| host_cache_size: | 279 |
| hostname: | server.perusingtheshelves.com |
| identity: | 0 |
| immediate_server_version: | 999999 |
| information_schema_stats_expiry: | 86400 |
| init_connect: | |
| init_file: | |
| init_replica: | |
| init_slave: | |
| innodb_adaptive_flushing: | ON |
| innodb_adaptive_flushing_lwm: | 10 |
| innodb_adaptive_hash_index: | ON |
| innodb_adaptive_hash_index_parts: | 8 |
| innodb_adaptive_max_sleep_delay: | 150000 |
| innodb_api_bk_commit_interval: | 5 |
| innodb_api_disable_rowlock: | OFF |
| innodb_api_enable_binlog: | OFF |
| innodb_api_enable_mdl: | OFF |
| innodb_api_trx_level: | 0 |
| innodb_autoextend_increment: | 64 |
| innodb_autoinc_lock_mode: | 2 |
| innodb_buffer_pool_chunk_size: | 268435456 |
| innodb_buffer_pool_dump_at_shutdown: | ON |
| innodb_buffer_pool_dump_now: | OFF |
| innodb_buffer_pool_dump_pct: | 25 |
| innodb_buffer_pool_filename: | ib_buffer_pool |
| innodb_buffer_pool_in_core_file: | ON |
| innodb_buffer_pool_instances: | 16 |
| innodb_buffer_pool_load_abort: | OFF |
| innodb_buffer_pool_load_at_startup: | ON |
| innodb_buffer_pool_load_now: | OFF |
| innodb_buffer_pool_size: | 17179869184 |
| innodb_change_buffer_max_size: | 25 |
| innodb_change_buffering: | all |
| innodb_checksum_algorithm: | crc32 |
| innodb_cmp_per_index_enabled: | OFF |
| innodb_commit_concurrency: | 0 |
| innodb_compression_failure_threshold_pct: | 5 |
| innodb_compression_level: | 6 |
| innodb_compression_pad_pct_max: | 50 |
| innodb_concurrency_tickets: | 5000 |
| innodb_data_file_path: | ibdata1:12M:autoextend |
| innodb_data_home_dir: | |
| innodb_ddl_buffer_size: | 1048576 |
| innodb_ddl_threads: | 4 |
| innodb_deadlock_detect: | ON |
| innodb_dedicated_server: | OFF |
| innodb_default_row_format: | dynamic |
| innodb_directories: | |
| innodb_disable_sort_file_cache: | OFF |
| innodb_doublewrite: | ON |
| innodb_doublewrite_batch_size: | 0 |
| innodb_doublewrite_dir: | |
| innodb_doublewrite_files: | 2 |
| innodb_doublewrite_pages: | 4 |
| innodb_extend_and_initialize: | ON |
| innodb_fast_shutdown: | 1 |
| innodb_file_per_table: | ON |
| innodb_fill_factor: | 100 |
| innodb_flush_log_at_timeout: | 1 |
| innodb_flush_log_at_trx_commit: | 1 |
| innodb_flush_method: | fsync |
| innodb_flush_neighbors: | 0 |
| innodb_flush_sync: | ON |
| innodb_flushing_avg_loops: | 30 |
| innodb_force_load_corrupted: | OFF |
| innodb_force_recovery: | 0 |
| innodb_fsync_threshold: | 0 |
| innodb_ft_aux_table: | |
| innodb_ft_cache_size: | 8000000 |
| innodb_ft_enable_diag_print: | OFF |
| innodb_ft_enable_stopword: | ON |
| innodb_ft_max_token_size: | 84 |
| innodb_ft_min_token_size: | 3 |
| innodb_ft_num_word_optimize: | 2000 |
| innodb_ft_result_cache_limit: | 2000000000 |
| innodb_ft_server_stopword_table: | |
| innodb_ft_sort_pll_degree: | 2 |
| innodb_ft_total_cache_size: | 640000000 |
| innodb_ft_user_stopword_table: | |
| innodb_idle_flush_pct: | 100 |
| innodb_io_capacity: | 200 |
| innodb_io_capacity_max: | 2000 |
| innodb_lock_wait_timeout: | 50 |
| innodb_log_buffer_size: | 33554432 |
| innodb_log_checksums: | ON |
| innodb_log_compressed_pages: | ON |
| innodb_log_file_size: | 4294967296 |
| innodb_log_files_in_group: | 2 |
| innodb_log_group_home_dir: | ./ |
| innodb_log_spin_cpu_abs_lwm: | 80 |
| innodb_log_spin_cpu_pct_hwm: | 50 |
| innodb_log_wait_for_flush_spin_hwm: | 400 |
| innodb_log_write_ahead_size: | 8192 |
| innodb_log_writer_threads: | ON |
| innodb_lru_scan_depth: | 1024 |
| innodb_max_dirty_pages_pct: | 90.000000 |
| innodb_max_dirty_pages_pct_lwm: | 10.000000 |
| innodb_max_purge_lag: | 0 |
| innodb_max_purge_lag_delay: | 0 |
| innodb_max_undo_log_size: | 1073741824 |
| innodb_monitor_disable: | |
| innodb_monitor_enable: | |
| innodb_monitor_reset: | |
| innodb_monitor_reset_all: | |
| innodb_numa_interleave: | OFF |
| innodb_old_blocks_pct: | 37 |
| innodb_old_blocks_time: | 1000 |
| innodb_online_alter_log_max_size: | 134217728 |
| innodb_open_files: | 6144 |
| innodb_optimize_fulltext_only: | OFF |
| innodb_page_cleaners: | 4 |
| innodb_page_size: | 16384 |
| innodb_parallel_read_threads: | 4 |
| innodb_print_all_deadlocks: | OFF |
| innodb_print_ddl_logs: | OFF |
| innodb_purge_batch_size: | 300 |
| innodb_purge_rseg_truncate_frequency: | 128 |
| innodb_purge_threads: | 4 |
| innodb_random_read_ahead: | OFF |
| innodb_read_ahead_threshold: | 56 |
| innodb_read_io_threads: | 4 |
| innodb_read_only: | OFF |
| innodb_redo_log_archive_dirs: | |
| innodb_redo_log_capacity: | 104857600 |
| innodb_redo_log_encrypt: | OFF |
| innodb_replication_delay: | 0 |
| innodb_rollback_on_timeout: | OFF |
| innodb_rollback_segments: | 128 |
| innodb_segment_reserve_factor: | 12.500000 |
| innodb_sort_buffer_size: | 16777216 |
| innodb_spin_wait_delay: | 6 |
| innodb_spin_wait_pause_multiplier: | 50 |
| innodb_stats_auto_recalc: | ON |
| innodb_stats_include_delete_marked: | OFF |
| innodb_stats_method: | nulls_equal |
| innodb_stats_on_metadata: | OFF |
| innodb_stats_persistent: | ON |
| innodb_stats_persistent_sample_pages: | 20 |
| innodb_stats_transient_sample_pages: | 8 |
| innodb_status_output: | OFF |
| innodb_status_output_locks: | OFF |
| innodb_strict_mode: | ON |
| innodb_sync_array_size: | 1 |
| innodb_sync_spin_loops: | 30 |
| innodb_table_locks: | ON |
| innodb_temp_data_file_path: | ibtmp1:12M:autoextend |
| innodb_temp_tablespaces_dir: | ./#innodb_temp/ |
| innodb_thread_concurrency: | 0 |
| innodb_thread_sleep_delay: | 10000 |
| innodb_tmpdir: | |
| innodb_undo_directory: | ./ |
| innodb_undo_log_encrypt: | OFF |
| innodb_undo_log_truncate: | ON |
| innodb_undo_tablespaces: | 2 |
| innodb_use_fdatasync: | OFF |
| innodb_use_native_aio: | ON |
| innodb_validate_tablespace_paths: | ON |
| innodb_version: | 8.0.37 |
| innodb_write_io_threads: | 4 |
| insert_id: | 0 |
| interactive_timeout: | 28800 |
| internal_tmp_mem_storage_engine: | TempTable |
| join_buffer_size: | 1048576 |
| keep_files_on_create: | OFF |
| key_buffer_size: | 167772160 |
| key_cache_age_threshold: | 300 |
| key_cache_block_size: | 1024 |
| key_cache_division_limit: | 100 |
| keyring_operations: | ON |
| large_files_support: | ON |
| large_page_size: | 0 |
| large_pages: | OFF |
| last_insert_id: | 0 |
| lc_messages: | en_US |
| lc_messages_dir: | /usr/share/mysql-8.0/ |
| lc_time_names: | en_US |
| license: | GPL |
| local_infile: | OFF |
| lock_wait_timeout: | 31536000 |
| locked_in_memory: | OFF |
| log_bin: | OFF |
| log_bin_basename: | |
| log_bin_index: | |
| log_bin_trust_function_creators: | OFF |
| log_bin_use_v1_row_events: | OFF |
| log_error: | /var/log/mysqld.log |
| log_error_services: | log_filter_internal; log_sink_internal |
| log_error_suppression_list: | |
| log_error_verbosity: | 2 |
| log_output: | FILE |
| log_queries_not_using_indexes: | OFF |
| log_raw: | OFF |
| log_replica_updates: | OFF |
| log_slave_updates: | OFF |
| log_slow_admin_statements: | OFF |
| log_slow_extra: | OFF |
| log_slow_replica_statements: | OFF |
| log_slow_slave_statements: | OFF |
| log_statements_unsafe_for_binlog: | ON |
| log_throttle_queries_not_using_indexes: | 0 |
| log_timestamps: | UTC |
| long_query_time: | 10.000000 |
| low_priority_updates: | OFF |
| lower_case_file_system: | OFF |
| lower_case_table_names: | 0 |
| mandatory_roles: | |
| master_info_repository: | TABLE |
| master_verify_checksum: | OFF |
| max_allowed_packet: | 268435456 |
| max_binlog_cache_size: | 18446744073709547520 |
| max_binlog_size: | 1073741824 |
| max_binlog_stmt_cache_size: | 18446744073709547520 |
| max_connect_errors: | 100 |
| max_connections: | 151 |
| max_delayed_threads: | 20 |
| max_digest_length: | 1024 |
| max_error_count: | 1024 |
| max_execution_time: | 0 |
| max_heap_table_size: | 673185792 |
| max_insert_delayed_threads: | 20 |
| max_join_size: | 18446744073709551615 |
| max_length_for_sort_data: | 4096 |
| max_points_in_geometry: | 65536 |
| max_prepared_stmt_count: | 16382 |
| max_relay_log_size: | 0 |
| max_seeks_for_key: | 18446744073709551615 |
| max_sort_length: | 1024 |
| max_sp_recursion_depth: | 0 |
| max_user_connections: | 0 |
| max_write_lock_count: | 18446744073709551615 |
| min_examined_row_limit: | 0 |
| myisam_data_pointer_size: | 6 |
| myisam_max_sort_file_size: | 9223372036853727232 |
| myisam_mmap_size: | 18446744073709551615 |
| myisam_recover_options: | OFF |
| myisam_sort_buffer_size: | 8388608 |
| myisam_stats_method: | nulls_unequal |
| myisam_use_mmap: | OFF |
| mysql_native_password_proxy_users: | OFF |
| net_buffer_length: | 16384 |
| net_read_timeout: | 30 |
| net_retry_count: | 10 |
| net_write_timeout: | 60 |
| new: | OFF |
| ngram_token_size: | 2 |
| offline_mode: | OFF |
| old: | OFF |
| old_alter_table: | OFF |
| open_files_limit: | 40000 |
| optimizer_max_subgraph_pairs: | 100000 |
| optimizer_prune_level: | 1 |
| optimizer_search_depth: | 5 |
| 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 |
| optimizer_trace: | enabled=off,one_line=off |
| optimizer_trace_features: | greedy_search=on,range_optimizer=on,dynamic_range=on,repeated_subselect=on |
| optimizer_trace_limit: | 1 |
| optimizer_trace_max_mem_size: | 1048576 |
| optimizer_trace_offset: | -1 |
| original_commit_timestamp: | 36028797018963968 |
| original_server_version: | 999999 |
| parser_max_mem_size: | 18446744073709551615 |
| partial_revokes: | OFF |
| password_history: | 0 |
| password_require_current: | OFF |
| password_reuse_interval: | 0 |
| performance_schema: | ON |
| performance_schema_accounts_size: | -1 |
| performance_schema_digests_size: | 10000 |
| performance_schema_error_size: | 5309 |
| performance_schema_events_stages_history_long_size: | 10000 |
| performance_schema_events_stages_history_size: | 10 |
| performance_schema_events_statements_history_long_size: | 10000 |
| performance_schema_events_statements_history_size: | 10 |
| performance_schema_events_transactions_history_long_size: | 10000 |
| performance_schema_events_transactions_history_size: | 10 |
| performance_schema_events_waits_history_long_size: | 10000 |
| performance_schema_events_waits_history_size: | 10 |
| performance_schema_hosts_size: | -1 |
| performance_schema_max_cond_classes: | 150 |
| performance_schema_max_cond_instances: | -1 |
| performance_schema_max_digest_length: | 1024 |
| performance_schema_max_digest_sample_age: | 60 |
| performance_schema_max_file_classes: | 80 |
| performance_schema_max_file_handles: | 32768 |
| performance_schema_max_file_instances: | -1 |
| performance_schema_max_index_stat: | -1 |
| performance_schema_max_memory_classes: | 450 |
| performance_schema_max_metadata_locks: | -1 |
| performance_schema_max_mutex_classes: | 350 |
| performance_schema_max_mutex_instances: | -1 |
| performance_schema_max_prepared_statements_instances: | -1 |
| performance_schema_max_program_instances: | -1 |
| performance_schema_max_rwlock_classes: | 60 |
| performance_schema_max_rwlock_instances: | -1 |
| performance_schema_max_socket_classes: | 10 |
| performance_schema_max_socket_instances: | -1 |
| performance_schema_max_sql_text_length: | 1024 |
| performance_schema_max_stage_classes: | 175 |
| performance_schema_max_statement_classes: | 219 |
| performance_schema_max_statement_stack: | 10 |
| performance_schema_max_table_handles: | -1 |
| performance_schema_max_table_instances: | -1 |
| performance_schema_max_table_lock_stat: | -1 |
| performance_schema_max_thread_classes: | 100 |
| performance_schema_max_thread_instances: | -1 |
| performance_schema_session_connect_attrs_size: | 512 |
| performance_schema_setup_actors_size: | -1 |
| performance_schema_setup_objects_size: | -1 |
| performance_schema_show_processlist: | OFF |
| performance_schema_users_size: | -1 |
| persist_only_admin_x509_subject: | |
| persist_sensitive_variables_in_plaintext: | ON |
| persisted_globals_load: | ON |
| pid_file: | /var/run/mysqld/mysqld.pid |
| plugin_dir: | /usr/lib64/mysql/plugin/ |
| port: | 3306 |
| preload_buffer_size: | 32768 |
| print_identified_with_as_hex: | OFF |
| profiling: | OFF |
| profiling_history_size: | 15 |
| protocol_compression_algorithms: | zlib,zstd,uncompressed |
| protocol_version: | 10 |
| proxy_user: | |
| pseudo_replica_mode: | OFF |
| pseudo_slave_mode: | OFF |
| pseudo_thread_id: | 69516 |
| query_alloc_block_size: | 8192 |
| query_prealloc_size: | 8192 |
| rand_seed1: | 0 |
| rand_seed2: | 0 |
| range_alloc_block_size: | 4096 |
| range_optimizer_max_mem_size: | 8388608 |
| rbr_exec_mode: | STRICT |
| read_buffer_size: | 2097152 |
| read_only: | OFF |
| read_rnd_buffer_size: | 1048576 |
| regexp_stack_limit: | 8000000 |
| regexp_time_limit: | 32 |
| relay_log: | server-relay-bin |
| relay_log_basename: | /var/lib/mysql/server-relay-bin |
| relay_log_index: | /var/lib/mysql/server-relay-bin.index |
| relay_log_info_file: | relay-log.info |
| relay_log_info_repository: | TABLE |
| relay_log_purge: | ON |
| relay_log_recovery: | OFF |
| relay_log_space_limit: | 0 |
| replica_allow_batching: | ON |
| replica_checkpoint_group: | 512 |
| replica_checkpoint_period: | 300 |
| replica_compressed_protocol: | OFF |
| replica_exec_mode: | STRICT |
| replica_load_tmpdir: | /tmp |
| replica_max_allowed_packet: | 1073741824 |
| replica_net_timeout: | 60 |
| replica_parallel_type: | LOGICAL_CLOCK |
| replica_parallel_workers: | 1 |
| replica_pending_jobs_size_max: | 134217728 |
| replica_preserve_commit_order: | ON |
| replica_skip_errors: | OFF |
| replica_sql_verify_checksum: | ON |
| replica_transaction_retries: | 10 |
| replica_type_conversions: | |
| replication_optimize_for_static_plugin_config: | OFF |
| replication_sender_observe_commit_only: | OFF |
| report_host: | |
| report_password: | |
| report_port: | 3306 |
| report_user: | |
| require_row_format: | OFF |
| require_secure_transport: | OFF |
| resultset_metadata: | FULL |
| rpl_read_size: | 8192 |
| rpl_stop_replica_timeout: | 31536000 |
| rpl_stop_slave_timeout: | 31536000 |
| schema_definition_cache: | 256 |
| secondary_engine_cost_threshold: | 100000.000000 |
| secure_file_priv: | /var/lib/mysql-files/ |
| select_into_buffer_size: | 131072 |
| select_into_disk_sync: | OFF |
| select_into_disk_sync_delay: | 0 |
| server_id: | 1 |
| server_id_bits: | 32 |
| server_uuid: | addc8e42-061b-11ef-987e-0cc47aa8935c |
| session_track_gtids: | OFF |
| session_track_schema: | ON |
| session_track_state_change: | OFF |
| session_track_system_variables: | time_zone,autocommit,character_set_client,character_set_results,character_set_connection |
| session_track_transaction_info: | OFF |
| sha256_password_auto_generate_rsa_keys: | ON |
| sha256_password_private_key_path: | private_key.pem |
| sha256_password_proxy_users: | OFF |
| sha256_password_public_key_path: | public_key.pem |
| show_create_table_skip_secondary_engine: | OFF |
| show_create_table_verbosity: | OFF |
| show_gipk_in_create_table_and_information_schema: | ON |
| show_old_temporals: | OFF |
| skip_external_locking: | ON |
| skip_name_resolve: | OFF |
| skip_networking: | OFF |
| skip_replica_start: | OFF |
| skip_show_database: | OFF |
| skip_slave_start: | OFF |
| slave_allow_batching: | ON |
| slave_checkpoint_group: | 512 |
| slave_checkpoint_period: | 300 |
| slave_compressed_protocol: | OFF |
| slave_exec_mode: | STRICT |
| slave_load_tmpdir: | /tmp |
| slave_max_allowed_packet: | 1073741824 |
| slave_net_timeout: | 60 |
| slave_parallel_type: | LOGICAL_CLOCK |
| slave_parallel_workers: | 1 |
| slave_pending_jobs_size_max: | 134217728 |
| slave_preserve_commit_order: | ON |
| slave_rows_search_algorithms: | INDEX_SCAN,HASH_SCAN |
| slave_skip_errors: | OFF |
| slave_sql_verify_checksum: | ON |
| slave_transaction_retries: | 10 |
| slave_type_conversions: | |
| slow_launch_time: | 2 |
| slow_query_log: | OFF |
| slow_query_log_file: | /var/lib/mysql/server-slow.log |
| socket: | /var/lib/mysql/mysql.sock |
| sort_buffer_size: | 2097152 |
| source_verify_checksum: | OFF |
| sql_auto_is_null: | OFF |
| sql_big_selects: | ON |
| sql_buffer_result: | OFF |
| sql_generate_invisible_primary_key: | OFF |
| sql_log_bin: | ON |
| sql_log_off: | OFF |
| sql_mode: | ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION |
| sql_notes: | ON |
| sql_quote_show_create: | ON |
| sql_replica_skip_counter: | 0 |
| sql_require_primary_key: | OFF |
| sql_safe_updates: | OFF |
| sql_select_limit: | 18446744073709551615 |
| sql_slave_skip_counter: | 0 |
| sql_warnings: | OFF |
| ssl_ca: | ca.pem |
| ssl_capath: | |
| ssl_cert: | server-cert.pem |
| ssl_cipher: | |
| ssl_crl: | |
| ssl_crlpath: | |
| ssl_fips_mode: | OFF |
| ssl_key: | server-key.pem |
| ssl_session_cache_mode: | ON |
| ssl_session_cache_timeout: | 300 |
| statement_id: | 1646467 |
| stored_program_cache: | 256 |
| stored_program_definition_cache: | 256 |
| super_read_only: | OFF |
| sync_binlog: | 1 |
| sync_master_info: | 10000 |
| sync_relay_log: | 10000 |
| sync_relay_log_info: | 10000 |
| sync_source_info: | 10000 |
| system_time_zone: | UTC |
| table_definition_cache: | 4096 |
| table_encryption_privilege_check: | OFF |
| table_open_cache: | 6144 |
| table_open_cache_instances: | 16 |
| tablespace_definition_cache: | 256 |
| temptable_max_mmap: | 1073741824 |
| temptable_max_ram: | 1073741824 |
| temptable_use_mmap: | ON |
| terminology_use_previous: | NONE |
| thread_cache_size: | 60 |
| thread_handling: | one-thread-per-connection |
| thread_stack: | 1048576 |
| time_zone: | SYSTEM |
| timestamp: | 1715748236.477458 |
| tls_ciphersuites: | |
| tls_version: | TLSv1.2,TLSv1.3 |
| tmp_table_size: | 673185792 |
| tmpdir: | /tmp |
| transaction_alloc_block_size: | 8192 |
| transaction_allow_batching: | OFF |
| transaction_isolation: | REPEATABLE-READ |
| transaction_prealloc_size: | 4096 |
| transaction_read_only: | OFF |
| transaction_write_set_extraction: | XXHASH64 |
| unique_checks: | ON |
| updatable_views_with_limit: | YES |
| use_secondary_engine: | ON |
| version: | 8.0.37 |
| version_comment: | MySQL Community Server - GPL |
| version_compile_machine: | x86_64 |
| version_compile_os: | Linux |
| version_compile_zlib: | 1.2.13 |
| wait_timeout: | 28800 |
| warning_count: | 0 |
| windowing_use_high_precision: | ON |
| xa_detach_on_prepare: | ON |