Platform | Linux Release | Ubuntu 16.04.4 LTS (xenial) Kernel | 3.14.32-xxxx-grs-ipv6-64 Architecture | CPU = 64-bit, OS = 64-bit Threading | NPTL 2.23 SELinux | No SELinux detected Virtualized | No virtualization detected Processors | physical = 1, cores = 6, virtual = 12, hyperthreading = yes Models | 12xIntel(R) Xeon(R) CPU E5-1650 0 @ 3.20GHz Memory Total | 62.9G # Instances ################################################## Port Data Directory Nice OOM Socket ===== ========================== ==== === ====== # MySQL Executable ########################################### Path to executable | /usr/sbin/mysqld Has symbols | No # Report On Port 3306 ######################################## User | root@localhost Time | 2018-07-20 16:12:40 (+00:00) Hostname | fr1db3 Version | 10.1.32-MariaDB-1~xenial mariadb.org binary distribution Built On | debian-linux-gnu x86_64 Started | 2018-07-20 14:17 (up 0+01:55:30) Databases | 17 Datadir | /var/lib/mysql/ Processes | 70 connected, 2 running Replication | Is a slave, has 1 slaves connected Pidfile | /var/run/mysqld/mysqld.pid (exists) # Processlist ################################################ Command COUNT(*) Working SUM(Time) MAX(Time) ------------------------------ -------- ------- --------- --------- Binlog Dump 1 1 5000 5000 Connect 15 15 100000 7000 Query 1 1 0 0 Sleep 70 0 12500 4500 User COUNT(*) Working SUM(Time) MAX(Time) ------------------------------ -------- ------- --------- --------- api 15 0 0 0 connexcs 1 0 0 0 connexcs-node 15 0 0 0 lookup 4 0 0 0 proxysql 15 0 0 0 repl 1 1 5000 5000 root 2 1 0 0 routing-engine 10 0 0 0 system user 15 15 100000 7000 web 8 0 0 0 Host COUNT(*) Working SUM(Time) MAX(Time) ------------------------------ -------- ------- --------- --------- 10.1.131.61 2 0 0 0 10.1.131.62 2 0 0 0 10.1.143.209 1 1 5000 5000 10.1.143.61 2 0 0 0 10.1.143.62 2 0 0 0 10.1.201.50 3 0 0 0 10.1.31.61 2 0 0 0 10.1.31.62 2 0 0 0 10.1.34.209 3 0 0 0 10.1.34.218 2 0 0 0 10.1.34.52 6 0 0 0 10.1.34.61 25 0 0 0 10.1.34.63 2 0 0 0 10.1.34.64 2 0 0 0 10.1.34.65 3 0 0 0 10.1.34.66 2 0 0 0 10.1.44.50 3 0 0 0 10.1.44.51 6 0 0 0 10.1.5.254 1 0 0 0 15 15 100000 7000 localhost 1 1 0 0 db COUNT(*) Working SUM(Time) MAX(Time) ------------------------------ -------- ------- --------- --------- connex_cdr 20 1 0 0 connex_sdr 6 0 0 0 lookup 30 0 0 0 NULL 30 15 100000 7000 State COUNT(*) Working SUM(Time) MAX(Time) ------------------------------ -------- ------- --------- --------- 70 0 0 0 init 1 1 0 0 Master has sent all binlog to 1 1 5000 5000 Slave has read all relay log; 1 1 7000 7000 Waiting for master to send eve 1 1 7000 7000 Waiting for work from SQL thre 10 10 80000 7000 # Status Counters (Wait 10 Seconds) ########################## Variable Per day Per second 11 secs Aborted_clients 20000 Acl_database_grants 300 Acl_table_grants 35 Acl_users 225 Aria_pagecache_blocks_unused 200000 2 Aria_pagecache_blocks_used 25 Aria_pagecache_read_requests 8000000 90 100 Aria_pagecache_reads 175000 1 2 Aria_pagecache_write_requests 350000 3 4 Binlog_commits 175000 1 Binlog_group_commits 175000 1 Binlog_snapshot_position 1250000000 12500 Binlog_bytes_written 17500000000 200000 Binlog_cache_disk_use 50000 Binlog_cache_use 175000 1 Bytes_received 22500000000 250000 6000 Bytes_sent 17500000000 200000 15000 Com_admin_commands 175000 1 1 Com_change_db 175000 2 Com_insert 175000 1 Com_replace_select 3500 Com_select 1750000 20 30 Com_set_option 50000 Com_show_collations 6000 Com_show_databases 6000 Com_show_processlist 35 Com_show_slave_status 3000 Com_show_status 3000 Com_show_tables 7000 Com_show_variables 6000 Com_stmt_close 175000 1 1 Com_stmt_execute 175000 1 1 Com_stmt_prepare 175000 1 1 Connections 100000 1 2 Created_tmp_disk_tables 350000 3 4 Created_tmp_files 450 Created_tmp_tables 400000 4 4 Empty_queries 800000 9 15 Feature_dynamic_columns 3500 Feature_subquery 50000 Feature_timezone 10 Feature_trigger 400 1 Flush_commands 10 Handler_commit 1750000 20 25 Handler_delete 10 Handler_prepare 350000 3 Handler_read_first 17500 Handler_read_key 125000000 1500 125 Handler_read_last 8000000 100 Handler_read_next 12500000000 150000 Handler_read_prev 250000000 3000 Handler_read_rnd 70000000 800 Handler_read_rnd_deleted 35 Handler_read_rnd_next 12500000 150 175 Handler_rollback 250 Handler_tmp_update 125000000 1250 Handler_tmp_write 17500000 200 175 Handler_update 150000 1 Handler_write 60000000 700 Innodb_available_undo_logs 1500 Innodb_background_log_sync 90000 1 Innodb_buffer_pool_bytes_data 125000000 1500 Innodb_buffer_pool_pages_flushed 200 Innodb_buffer_pool_read_requests 70000000 800 Innodb_buffer_pool_reads 8000 Innodb_buffer_pool_write_requests 600 Innodb_checkpoint_max_age 1000000000 12500 Innodb_data_fsyncs 125 Innodb_data_read 125000000 1500 Innodb_data_reads 12500 Innodb_data_writes 350 Innodb_data_written 30000000 350 Innodb_history_list_length 600 Innodb_ibuf_free_list 700000 7 Innodb_ibuf_segment_size 700000 7 Innodb_ibuf_size 10 Innodb_log_write_requests 70 Innodb_log_writes 60 Innodb_lsn_current 15000000000000 175000000 Innodb_lsn_flushed 15000000000000 175000000 Innodb_lsn_last_checkpoint 15000000000000 175000000 Innodb_master_thread_active_loops 25 Innodb_master_thread_idle_loops 90000 1 Innodb_max_trx_id 12500000000 125000 Innodb_mem_adaptive_hash 6000000000 70000 Innodb_mem_dictionary 1500000000 17500 Innodb_mem_total 400000000000 4500000 Innodb_mutex_os_waits 70 Innodb_mutex_spin_rounds 3000 Innodb_mutex_spin_waits 1000 Innodb_os_log_fsyncs 60 Innodb_os_log_written 70000 Innodb_pages_created 10 Innodb_pages_read 8000 Innodb_pages0_read 5000 Innodb_pages_written 200 Innodb_purge_trx_id 12500000000 125000 Innodb_read_views_memory 1000 Innodb_rows_read 200000000 2500 Innodb_system_rows_deleted 10 Innodb_system_rows_inserted 10 Innodb_system_rows_read 25 Innodb_s_lock_os_waits 50 Innodb_s_lock_spin_rounds 1750 Innodb_s_lock_spin_waits 60 Innodb_x_lock_os_waits 10 Innodb_x_lock_spin_rounds 350 Innodb_x_lock_spin_waits 10 Innodb_num_index_pages_written 50 Innodb_num_non_index_pages_written 300 Key_read_requests 100 Key_reads 50 Memory_used 20000000000 225000 22500 Open_table_definitions 2500 Opened_files 1500000 15 80 Opened_plugin_libraries 10 Opened_table_definitions 2500 Opened_tables 4000 Qcache_hits 60000 2 Qcache_inserts 1250000 15 25 Qcache_lowmem_prunes 400000 4 30 Qcache_not_cached 175000 1 1 Queries 2500000 30 35 Questions 2250000 25 35 Rows_read 12500000000 150000 1 Rows_sent 15000000 175 225 Rows_tmp_read 125000000 1500 175 Select_range 1250000 15 25 Select_scan 200000 2 2 Slave_connections 25 Slave_received_heartbeats 35 Slaves_connected 10 Slaves_running 10 Sort_merge_passes 100 Sort_priority_queue_sorts 1250000 15 25 Sort_range 1250000 15 25 Sort_rows 60000000 700 9 Sort_scan 3500 Syncs 1250 Table_locks_immediate 15000000 150 250 Threads_created 1250 Tokudb_db_opens 80000 Tokudb_db_open_current 80000 Tokudb_db_open_max 80000 Tokudb_leaf_entry_max_committed_xr 50 Tokudb_leaf_entry_max_provisional_xr 25 Tokudb_leaf_entry_max_memsize 12500 Tokudb_leaf_entry_apply_gc_bytes_in 80000000000 1000000 Tokudb_leaf_entry_apply_gc_bytes_out 60000000000 700000 Tokudb_checkpoint_period 700 Tokudb_checkpoint_duration 60000 Tokudb_checkpoint_duration_last 450 Tokudb_checkpoint_last_lsn 350000000000 4000000 Tokudb_checkpoint_taken 1500 Tokudb_checkpoint_client_wait_on_mo 200 Tokudb_checkpoint_begin_time 22500000 250 Tokudb_checkpoint_end_time 60000000000 700000 Tokudb_checkpoint_long_end_time 7000000000 80000 Tokudb_checkpoint_long_end_count 90 Tokudb_cachetable_miss 1750000 20 Tokudb_cachetable_miss_time 10000000000 125000 1250 Tokudb_cachetable_prefetches 20000 Tokudb_cachetable_size_current 400000000000 5000000 500000 Tokudb_cachetable_size_limit 450000000000 5000000 Tokudb_cachetable_size_nonleaf 45000000000 500000 Tokudb_cachetable_size_leaf 350000000000 4500000 500000 Tokudb_cachetable_size_rollback 15000 Tokudb_cachetable_size_cachepressure 40000000000 500000 Tokudb_cachetable_cleaner_executions 125000 1 1 Tokudb_cachetable_cleaner_period 10 Tokudb_cachetable_cleaner_iterations 60 Tokudb_cachetable_pool_client_num_threads 150 Tokudb_cachetable_pool_client_max_queue_size 10 Tokudb_cachetable_pool_client_total_items_processed 4500 Tokudb_cachetable_pool_client_total_execution_time 600000 6 Tokudb_cachetable_pool_cachetable_num_threads 300 Tokudb_cachetable_pool_cachetable_max_queue_size 90 Tokudb_cachetable_pool_cachetable_total_items_processed 40000 Tokudb_cachetable_pool_cachetable_total_execution_time 1250000 15 Tokudb_cachetable_pool_checkpoint_num_threads 35 Tokudb_cachetable_pool_checkpoint_max_queue_size 500 Tokudb_cachetable_pool_checkpoint_total_items_processed 175000 2 Tokudb_cachetable_pool_checkpoint_total_execution_time 6000000 70 Tokudb_locktree_memory_size_limit 50000000000 600000 Tokudb_locktree_open_current 80000 Tokudb_locktree_sto_ended_num 15000 Tokudb_locktree_wait_count 150 Tokudb_locktree_wait_time 600000000 7000 Tokudb_locktree_long_wait_count 150 Tokudb_locktree_long_wait_time 600000000 7000 Tokudb_locktree_timeout_count 125 Tokudb_messages_ignored_by_leaf_due_to_msn 1750000 20 Tokudb_total_search_retries 6000000 70 4 Tokudb_search_tries_gt_height 450 Tokudb_search_tries_gt_heightplus3 225 Tokudb_leaf_nodes_flushed_not_checkpoint 1750 Tokudb_leaf_nodes_flushed_not_checkpoint_bytes 700000000 8000 Tokudb_leaf_nodes_flushed_not_checkpoint_uncompressed_bytes 3000000000 30000 Tokudb_nonleaf_nodes_flushed_to_disk_not_checkpoint 1500 Tokudb_nonleaf_nodes_flushed_to_disk_not_checkpoint_bytes 700000000 8000 Tokudb_nonleaf_nodes_flushed_to_disk_not_checkpoint_uncompresse 2500000000 30000 Tokudb_leaf_nodes_flushed_checkpoint 250000 3 Tokudb_leaf_nodes_flushed_checkpoint_bytes 100000000000 1250000 Tokudb_leaf_nodes_flushed_checkpoint_uncompressed_bytes 450000000000 5000000 Tokudb_nonleaf_nodes_flushed_to_disk_checkpoint 250000 2 Tokudb_nonleaf_nodes_flushed_to_disk_checkpoint_bytes 100000000000 1250000 Tokudb_nonleaf_nodes_flushed_to_disk_checkpoint_uncompressed_by 400000000000 4500000 Tokudb_leaf_nodes_created 7000 Tokudb_nonleaf_nodes_created 900 Tokudb_messages_injected_at_root_bytes 8000000000 90000 Tokudb_messages_flushed_from_h1_to_leaves_bytes 9000000000 100000 Tokudb_messages_in_trees_estimate_bytes 225000000000000000000 2500000000000000 Tokudb_messages_injected_at_root 100000000 1250 Tokudb_basements_decompressed_target_query 200 Tokudb_basements_decompressed_prelocked_range 1250 Tokudb_basements_decompressed_for_write 700 Tokudb_buffers_decompressed_target_query 1250000 15 Tokudb_buffers_decompressed_prelocked_range 2000 Tokudb_buffers_decompressed_for_write 90000 1 Tokudb_pivots_fetched_for_query 1500000 15 Tokudb_pivots_fetched_for_query_bytes 4000000000 50000 3000 Tokudb_pivots_fetched_for_prefetch 20000 Tokudb_pivots_fetched_for_prefetch_bytes 700000000 8000 Tokudb_pivots_fetched_for_write 7000 Tokudb_pivots_fetched_for_write_bytes 125000000 1500 Tokudb_basements_fetched_target_query 2250000 25 4 Tokudb_basements_fetched_target_query_bytes 20000000000 225000 100000 Tokudb_basements_fetched_prelocked_range 200000 2 Tokudb_basements_fetched_prelocked_range_bytes 1000000000 12500 Tokudb_basements_fetched_prefetch 1500000 15 Tokudb_basements_fetched_prefetch_bytes 8000000000 90000 Tokudb_basements_fetched_for_write 1250000 15 Tokudb_basements_fetched_for_write_bytes 25000000000 300000 Tokudb_buffers_fetched_target_query 5000 Tokudb_buffers_fetched_target_query_bytes 80000000 900 Tokudb_buffers_fetched_prelocked_range 800 Tokudb_buffers_fetched_prelocked_range_bytes 600000 6 Tokudb_buffers_fetched_for_write 150000 1 Tokudb_buffers_fetched_for_write_bytes 8000000000 90000 Tokudb_promotion_leaf_roots_injected_into 350000 4 Tokudb_promotion_h1_roots_injected_into 1250000 15 Tokudb_promotion_injections_at_depth_0 50000000 600 Tokudb_promotion_injections_at_depth_1 40000000 500 Tokudb_promotion_injections_at_depth_2 17500000 200 Tokudb_promotion_injections_at_depth_3 6000000 70 Tokudb_promotion_injections_lower_than_depth_3 5000000 60 Tokudb_promotion_stopped_nonempty_buffer 100000000 1250 Tokudb_promotion_stopped_at_height_1 2000 Tokudb_promotion_stopped_child_locked_or_not_in_memory 4500 Tokudb_promotion_stopped_child_not_fully_in_memory 50 Tokudb_promotion_stopped_after_locking_child 2000 Tokudb_basement_deserialization_fixed_key 3000000 35 4 Tokudb_basement_deserialization_variable_key 2000000 25 Tokudb_pro_rightmost_leaf_shortcut_success 70000000 900 Tokudb_pro_rightmost_leaf_shortcut_fail_pos 5000 Tokudb_rightmost_leaf_shortcut_fail_reactive 3500000 40 Tokudb_cursor_skip_deleted_leaf_entry 1000000 10 Tokudb_flusher_cleaner_total_nodes 45000 Tokudb_flusher_cleaner_h1_nodes 35000 Tokudb_flusher_cleaner_hgt1_nodes 10000 Tokudb_flusher_cleaner_empty_nodes 5000 Tokudb_flusher_cleaner_nodes_dirtied 70000 Tokudb_flusher_cleaner_max_buffer_size 50000000 600 Tokudb_flusher_cleaner_min_buffer_size 1250 Tokudb_flusher_cleaner_total_buffer_size 10000000000 125000 Tokudb_flusher_cleaner_max_buffer_workdone 15000000 175 Tokudb_flusher_cleaner_total_buffer_workdone 90000000 1000 Tokudb_flusher_flush_total 45000 Tokudb_flusher_flush_in_memory 45000 Tokudb_flusher_flush_cascades 2250 Tokudb_flusher_flush_cascades_1 2000 Tokudb_flusher_flush_cascades_2 350 Tokudb_flusher_flush_cascades_3 35 Tokudb_flusher_split_leaf 7000 Tokudb_flusher_split_nonleaf 900 Tokudb_txn_begin 900000 10 Tokudb_txn_begin_read_only 1250000 15 25 Tokudb_txn_commits 2000000 25 25 Tokudb_txn_aborts 150000 1 Tokudb_logger_next_lsn 350000000000 4000000 Tokudb_logger_writes 175000 2 Tokudb_logger_writes_bytes 20000000000 250000 Tokudb_logger_writes_uncompressed_bytes 20000000000 250000 Tokudb_logger_wait_long 35 Tokudb_memory_mmap_threshold 50000000 600 Tokudb_filesystem_fsync_time 60000000000 700000 Tokudb_filesystem_fsync_num 900000 10 Tokudb_filesystem_long_fsync_time 200000000 2500 Tokudb_filesystem_long_fsync_num 150 Uptime 90000 1 1 # Table cache ################################################ Size | 2014 Usage | 15% # Key Percona Server features ################################ Table & Index Stats | Disabled 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 | Disabled Response Time Hist. | Not Supported Smooth Flushing | Not Supported HandlerSocket NoSQL | Not Supported Fast Hash UDFs | Unknown # Percona XtraDB Cluster ##################################### wsrep_on | OFF # Plugins #################################################### InnoDB compression | ACTIVE # Query cache ################################################ query_cache_type | ON Size | 64.0M Usage | 100% HitToInsertRatio | 4% # Schema ##################################################### Specify --databases or --all-databases to dump and summarize schemas # Noteworthy Technologies #################################### SSL | No Explicit LOCK TABLES | No Delayed Insert | No XA Transactions | No NDB Cluster | No Prepared Statements | Yes Prepared statement count | 0 # InnoDB ##################################################### Version | 5.6.38-83.0 Buffer Pool Size | 28.0G Buffer Pool Fill | 0% Buffer Pool Dirty | 0% File Per Table | ON Page Size | 16k Log File Size | 2 * 48.0M = 96.0M Log Buffer Size | 8M Flush Method | O_DIRECT Flush Log At Commit | 2 XA Support | ON Checksums | ON Doublewrite | OFF R/W I/O Threads | 4 4 I/O Capacity | 400 Thread Concurrency | 4 Concurrency Tickets | 5000 Commit Concurrency | 0 Txn Isolation Level | REPEATABLE-READ Adaptive Flushing | ON Adaptive Checkpoint | Checkpoint Age | 0 InnoDB Queue | 0 queries inside InnoDB, 0 queries in queue Oldest Transaction | 0 Seconds History List Len | 45 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 | 3xnot started # MyISAM ##################################################### Key Cache | 1.0G Pct Used | 20% Unflushed | 0% # Security ################################################### Users | 18 users, 0 anon, 0 w/o pw, 0 old pw Old Passwords | OFF # Binary Logging ############################################# Binlogs | 700 Zero-Sized | 0 Total Size | 67.9G binlog_format | ROW expire_logs_days | 10 sync_binlog | 0 server_id | 1 binlog_do_db | binlog_ignore_db | # Noteworthy Variables ####################################### Auto-Inc Incr/Offset | 2/1 default_storage_engine | InnoDB flush_time | 0 init_connect | init_file | sql_mode | NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION join_buffer_size | 256k sort_buffer_size | 256M read_buffer_size | 2M read_rnd_buffer_size | 1M bulk_insert_buffer | 0.00 max_heap_table_size | 1G tmp_table_size | 1G max_allowed_packet | 64M thread_stack | 289k log | log_error | /var/log/mysql/error.log log_warnings | 2 log_slow_queries | log_queries_not_using_indexes | OFF log_slave_updates | OFF # Configuration File ######################################### Config File | /etc/mysql/my.cnf [client] port = 3306 socket = /var/run/mysqld/mysqld.sock [mysqld_safe] socket = /var/run/mysqld/mysqld.sock nice = 0 [mysqld] user = mysql pid-file = /var/run/mysqld/mysqld.pid socket = /var/run/mysqld/mysqld.sock port = 3306 basedir = /usr datadir = /var/lib/mysql tmpdir = /tmp lc_messages_dir = /usr/share/mysql lc_messages = en_US skip-external-locking bind-address = 10.1.34.209 max_connections = 100 connect_timeout = 5 wait_timeout = 600 max_allowed_packet = 64M thread_cache_size = 128 sort_buffer_size = 256M bulk_insert_buffer_size = 64M tmp_table_size = 1G max_heap_table_size = 1G default-time-zone = "+00:00" table_cache = 1024 myisam_recover_options = BACKUP key_buffer_size = 1G open_files_limit = 100000 table_open_cache = 2014 myisam_sort_buffer_size = 512M concurrent_insert = 2 read_buffer_size = 2M read_rnd_buffer_size = 1M myisam_max_sort_file_size = 16GB query_cache_limit = 128K query_cache_size = 64M query_cache_type = OFF log_warnings = 2 log_error = /var/log/mysql/error.log slow_query_log_file = /var/log/mysql/mariadb-slow.log long_query_time = 10 log_slow_verbosity = query_plan server-id = 1 auto_increment_increment = 2 auto_increment_offset = 1 log_bin = /var/log/mysql/mariadb-bin log_bin_index = /var/log/mysql/mariadb-bin.index expire_logs_days = 10 max_binlog_size = 100M binlog_format = ROW slave_exec_mode = IDEMPOTENT slave_parallel_threads = 12 default_storage_engine = InnoDB innodb_buffer_pool_size = 28GB innodb_log_buffer_size = 8M innodb_file_per_table = 1 innodb_open_files = 400 innodb_io_capacity = 400 innodb_flush_method = O_DIRECT innodb_doublewrite = OFF innodb_flush_log_at_trx_commit = 2 innodb_thread_concurrency = 4 [galera] [mysqldump] quick quote-names max_allowed_packet = 16M [mysql] [isamchk] key_buffer = 16M