# Status Counters (Wait 10 Seconds) ########################## Variable Per day Per second 11 secs Aborted_connects 2 Binlog_snapshot_position 20000000 225 2500000 Binlog_cache_use 10000000 100 3 Binlog_stmt_cache_use 200 Bytes_received 500000000 6000 1500 Bytes_sent 3500000000 45000 22500 Com_admin_commands 25000 Com_begin 10000000 100 4 Com_call_procedure 17500 Com_change_db 3500 Com_commit 50 Com_create_table 300 Com_delete 4500000 50 Com_drop_table 500 Com_flush 2 Com_insert 50000000 600 3000 Com_replace 1 Com_select 800000 9 5 Com_set_option 500000 6 Com_show_binlogs 1500 Com_show_engine_status 9000 Com_show_grants 800 Com_show_plugins 1500 Com_show_replica_status 9000 Com_show_slave_status 9000 Com_show_status 17500 Com_show_storage_engines 100 Com_show_tables 6000 Com_show_triggers 3500 Com_show_variables 4500 Com_truncate 450 Com_update 10000000 125 7 Connections 22500 2 Created_tmp_disk_tables 10000 Created_tmp_tables 80000 1 Error_log_buffered_bytes 70000 Error_log_buffered_events 175 Error_log_latest_write 175000000000000 2250000000 Handler_commit 150000000 1750 6000 Handler_delete 40000000 450 1000 Handler_external_lock 150000000 1500 6000 Handler_prepare 150000000 1750 6000 Handler_read_first 40000 1 Handler_read_key 70000000 900 1000 Handler_read_next 500000000 6000 2 Handler_read_rnd 70000000 800 1000 Handler_read_rnd_next 2000000000 22500 500 Handler_rollback 15 Handler_update 30000000 350 8 Handler_write 100000000 1250 4500 Innodb_buffer_pool_bytes_data 3500000000 40000 -205544 Innodb_buffer_pool_bytes_dirty 175000000 2250 3000000 Innodb_buffer_pool_pages_flushed 10000000 125 175 Innodb_buffer_pool_pages_made_not_young 300000000 3500 30 Innodb_buffer_pool_pages_made_young 1250000 15 20 Innodb_buffer_pool_pages_old 70000 -4 Innodb_buffer_pool_read_ahead 125000 1 Innodb_buffer_pool_read_requests 4500000000 50000 150000 Innodb_buffer_pool_reads 450000 5 2 Innodb_buffer_pool_write_requests 1750000000 20000 60000 Innodb_checkpoint_age 150000000 1750 5000000 Innodb_checkpoint_max_age 1500000000 17500 -186 Innodb_data_fsyncs 25000000 300 400 Innodb_data_read 10000000000 125000 35000 Innodb_data_reads 700000 7 2 Innodb_data_writes 60000000 700 1500 Innodb_data_written 300000000000 3500000 9000000 Innodb_ibuf_free_list 70000 Innodb_ibuf_segment_size 70000 Innodb_redo_log_uuid 125000000 1250 Innodb_redo_log_checkpoint_lsn 10000000000000 125000000 350000 Innodb_redo_log_current_lsn 10000000000000 125000000 5000000 Innodb_redo_log_flushed_to_disk_lsn 10000000000000 125000000 5000000 Innodb_redo_log_logical_size 150000000 1750 5000000 Innodb_redo_log_physical_size 1750000000 20000 Innodb_redo_log_capacity_resized 2000000000 22500 Innodb_log_write_requests 1250000000 12500 45000 Innodb_log_writes 50000000 600 1250 Innodb_lsn_current 10000000000000 125000000 5000000 Innodb_lsn_flushed 10000000000000 125000000 5000000 Innodb_lsn_last_checkpoint 10000000000000 125000000 350000 Innodb_master_thread_active_loops 80000 Innodb_master_thread_idle_loops 3000 Innodb_max_trx_id 1250000000 15000 10 Innodb_os_log_fsyncs 25000000 300 350 Innodb_os_log_written 125000000000 1500000 5000000 Innodb_pages_created 900000 9 2 Innodb_pages_read 700000 7 2 Innodb_pages0_read 125 Innodb_pages_written 9000000 100 150 Innodb_purge_trx_id 1250000000 15000 10 Innodb_rows_deleted 70000000 800 4000 Innodb_rows_inserted 90000000 1000 4000 Innodb_rows_read 600000000 7000 1000 Innodb_rows_updated 30000000 350 8 Innodb_system_rows_deleted 17500 Innodb_system_rows_inserted 20000 Innodb_system_rows_read 2000000 25 60 Innodb_system_rows_updated 60000 Innodb_num_open_files 125 Innodb_secondary_index_triggered_cluster_reads 15000000 175 2 Innodb_buffered_aio_submitted 125000 1 Mysqlx_port 3500 Net_buffer_length 7000 Open_table_definitions 50 Opened_table_definitions 1250 Opened_tables 5000 Performance_schema_session_connect_attrs_longest_seen 15 Queries 80000000 900 3000 Questions 1500000 15 9 Select_full_join 2 Select_range 500000 5 Select_scan 200000 2 2 Slow_queries 10000000 125 15 Sort_rows 350000 4 4 Sort_scan 30000 Ssl_session_cache_timeout 35 Table_locks_immediate 250000 3 2 Table_open_cache_hits 70000000 800 3000 Table_open_cache_misses 5000 Table_open_cache_triggers_hits 400000 4 Table_open_cache_triggers_misses 60 Uptime 90000 1 1 wsrep_protocol_version 1 wsrep_last_applied 800000000 10000 3 wsrep_last_committed 800000000 10000 3 wsrep_replicated 25 wsrep_replicated_bytes 7000000 80 wsrep_repl_keys 30000 wsrep_repl_keys_bytes 225000 2 wsrep_repl_data_bytes 2500000 30 wsrep_received 10000000 125 4 wsrep_received_bytes 60000000000 700000 2500000 wsrep_local_commits 25 wsrep_local_recv_queue_max 45000 wsrep_local_cached_downto 800000000 10000 450 wsrep_flow_control_paused_ns 900000000000 10000000 wsrep_flow_control_sent 70 wsrep_flow_control_recv 900 wsrep_flow_control_interval_low 250 wsrep_flow_control_interval_high 250 wsrep_apply_waits 800000 9 1 wsrep_cert_index_size 50 2000 wsrep_cert_bucket_count 500000 5 wsrep_gcache_pool_size 1750000000 20000 wsrep_cluster_conf_id 100 wsrep_thread_count 5 # Table cache ################################################ Size | 7677 Usage | 90% # Key Percona Server features ################################ Table & Index Stats | Enabled Multiple I/O Threads | Enabled Corruption Resilient | Enabled Durable Replication | Not Supported Import InnoDB Tables | Not Supported Fast Server Restarts | Not Supported Enhanced Logging | Enabled Replica Perf Logging | Enabled Response Time Hist. | Not Supported Smooth Flushing | Not Supported HandlerSocket NoSQL | Not Supported Fast Hash UDFs | Unknown # Percona XtraDB Cluster ##################################### # Plugins #################################################### InnoDB compression | ACTIVE # Schema ##################################################### Specify --databases or --all-databases to dump and summarize schemas # Noteworthy Technologies #################################### SSL | Yes Explicit LOCK TABLES | No Delayed Insert | No XA Transactions | No NDB Cluster | No Prepared Statements | No Prepared statement count | 0 # InnoDB ##################################################### Version | 8.0.33-25 Buffer Pool Size | 30.0G Buffer Pool Fill | 100% Buffer Pool Dirty | 5% File Per Table | ON Page Size | 16k Log File Size | 8 * 2.0G = 16.0G Log Buffer Size | 16M Flush Method | O_DIRECT Flush Log At Commit | 1 XA Support | Checksums | Doublewrite | OFF R/W I/O Threads | 64 62 I/O Capacity | 200 Thread Concurrency | 0 Concurrency Tickets | 5000 Commit Concurrency | 0 Txn Isolation Level | Adaptive Flushing | ON Adaptive Checkpoint | Checkpoint Age | 1G InnoDB Queue | 0 queries inside InnoDB, 0 queries in queue Oldest Transaction | 0 Seconds History List Len | 32 Read Views | 0 Undo Log Entries | 0 transactions, 0 total undo, 0 max undo Pending I/O Reads | 0 buf pool reads, 0 normal AIO, 0 ibuf AIO, 0 preads Pending I/O Writes | 0 buf pool (0 LRU, 0 flush list, 0 page); 0 AIO, 0 sync, 0 log IO (0 log, 0 chkp); 0 pwrites Pending I/O Flushes | 0 buf pool, 0 log Transaction States | 53xnot started # MyISAM ##################################################### Key Cache | 8.0M Pct Used | 20% Unflushed | 0% # Security ################################################### Users | 122 users, 0 anon, 0 w/o pw, 27 old pw Old Passwords | # Roles ###################################################### *************************** 1. row *************************** Role Name: mysql.pxc.sst.role Active: 0 # Encryption ################################################# No keyring plugins found # Binary Logging ############################################# Binlogs | 60 Zero-Sized | 0 Total Size | 58.9G binlog_format | ROW expire_logs_days | 1 sync_binlog | 1 server_id | 444 binlog_do_db | binlog_ignore_db | # Noteworthy Variables ####################################### Auto-Inc Incr/Offset | 5/1 default_storage_engine | InnoDB flush_time | 0 init_connect | set default_collation_for_utf8mb4 = utf8mb4_general_ci init_file | sql_mode | STRICT_TRANS_TABLES,NO_ENGINE_SUBSTITUTION join_buffer_size | 256k sort_buffer_size | 3M read_buffer_size | 256k read_rnd_buffer_size | 256k bulk_insert_buffer | 0.00 max_heap_table_size | 800M tmp_table_size | 16M max_allowed_packet | 800M thread_stack | 512k log | log_error | /app/mysql/data/mysqld.log log_warnings | log_slow_queries | log_queries_not_using_indexes | OFF log_slave_updates | ON # Configuration File ######################################### Config File | /etc/my.cnf [client] socket = /var/lib/mysql/mysql.sock [mysqld] secure_file_priv = "" back-log = 250 event-scheduler = 1 ssl-ca = /app/mysql/certs/ca.pem ssl-cert = /app/mysql/certs/server-cert.pem ssl-key = /app/mysql/certs/server-key.pem tls-version = TLSv1.2 default-password-lifetime = 20000 default-time-zone = 'America/New_York' log-timestamps = SYSTEM audit-log-format = json audit-log-policy = "queries" audit-log-rotate-on-size = 104857600 audit-log-rotations = 2 audit-log-file = /app/mysql/data/audit.log log_error_verbosity = 3 log_error_services = "log_filter_internal; log_sink_json" audit-log-exclude-accounts = "GSSKeepAlive@%,pmm@localhost,sandbox@localhost,guest@%,%@localhost" audit-log-include-commands = "call_procedure,select,insert,update,delete,kill,alter_db,alter_event,alter_function,alter_procedure,alter_table,alter_user,create_db,create_event,create_function,create_index,create_procedure,create_table,create_trigger,create_user,create_view,drop_db,drop_event,drop_function,drop_index,drop_procedure,drop_table,drop_trigger,drop_user,drop_view,grant,grant_roles,install_plugin,rename_table,rename_user,restart,revoke,revoke_all,revoke_roles,show_grants,shutdown,lock_tables" userstat = 1 performance_schema = ON performance-schema-instrument = 'statement/%=ON' performance-schema-consumer-statements-digest = ON innodb_monitor_enable = all performance-schema = 1 slow-query-log = ON log-output = FILE long-query-time = 0 log-slow-admin-statements = ON log-slow-slave-statements = ON log-slow-rate-limit = 100 log-slow-rate-type = 'query' slow-query-log-always-write-time = 1 log-slow-verbosity = 'full' slow-query-log-use-global-control = 'all' character_set_client_handshake = FALSE character_set_server = utf8mb4 collation_server = utf8mb4_general_ci init-connect = 'SET collation_connection = utf8mb4_general_ci' init-connect = 'SET NAMES utf8mb4' init-connect = 'set default_collation_for_utf8mb4 = utf8mb4_general_ci' log-bin-trust-function-creators = 1 performance-schema = 1 server-id = 444 datadir = /app/mysql/data socket = /var/lib/mysql/mysql.sock log-error = /app/mysql/data/mysqld.log pid-file = /var/run/mysqld/mysqld.pid log-bin binlog_cache_size = 256M log_slave_updates expire_logs_days = 1 userstat = 1 max_connect_errors = 18446744073709551615 max-allowed-packet = 800M max-connect-errors = 1000000 max-heap-table-size = 800M max-connections = 1000 max-user-connections = 200 thread-pool-size = 32 thread-cache-size = 512 interactive-timeout = 900 wait-timeout = 900 innodb-sort-buffer-size = 3145725 sort-buffer-size = 3145725 read-buffer-size = 256k thread-stack = 512k sql_mode = STRICT_TRANS_TABLES,NO_ENGINE_SUBSTITUTION innodb_buffer_pool_dump_at_shutdown = on innodb_buffer_pool_load_at_startup = on innodb_flush_method = O_DIRECT innodb_temp_data_file_path = ibtmp1:12M:autoextend:max:5G innodb-thread-sleep-delay = 0 innodb-doublewrite = 0 innodb_thread_concurrency = 0 innodb_read_io_threads = 64 innodb_write_io_threads = 62 innodb_purge_threads = 32 innodb-log-files-in-group = 8 innodb-log-file-size = 2048M innodb-file-per-table = 1 innodb_io_capacity_max = 60000 innodb-buffer-pool-size = 30G innodb_buffer_pool_instances = 12 innodb_stats_on_metadata = 0 innodb_lock_wait_timeout = 6 max-connections = 1000 table-definition-cache = 10000 table-open-cache = 80000 slave_load_tmpdir = /app/mysql/data/ tmpdir = /app/mysql/data/ symbolic-links = 0 wsrep_provider = /usr/lib64/galera4/libgalera_smm.so wsrep_notify_cmd = '/app/mysql/support.sh'; binlog_format = ROW wsrep_slave_threads = 48 wsrep_retry_autocommit = 1 pxc_strict_mode = PERMISSIVE wsrep_sst_method = xtrabackup-v2 wsrep_provider_options = "gcs.fc_limit=500;evs.send_window=1024;evs.user_send_window=1024;gcache.size=14G; wsrep_gmcast_segment=1" # Memory management library ################################## jemalloc enabled in mysql config for process with id 43492 Using jemalloc from /usr/lib64/libjemalloc.so.1