Tomas Kucera added a comment - 2020-11-26 22:35 Additional information Slave status MariaDB [(none)]> show slave status \G; *************************** 1. row *************************** Slave_IO_State: Waiting for master to send event Master_Host: xxx Master_User: xxx Master_Port: 3306 Connect_Retry: 60 Master_Log_File: bin.000106 Read_Master_Log_Pos: 603755911 Relay_Log_File: xxx-relay-bin.000040 Relay_Log_Pos: 109931312 Relay_Master_Log_File: bin.000016 Slave_IO_Running: Yes Slave_SQL_Running: Yes Replicate_Do_DB: Replicate_Ignore_DB: Replicate_Do_Table: Replicate_Ignore_Table: Replicate_Wild_Do_Table: Replicate_Wild_Ignore_Table: Last_Errno: 0 Last_Error: Skip_Counter: 0 Exec_Master_Log_Pos: 902554004 Relay_Log_Space: 97769824386 Until_Condition: None Until_Log_File: Until_Log_Pos: 0 Master_SSL_Allowed: Yes Master_SSL_CA_File: xxx Master_SSL_CA_Path: Master_SSL_Cert: xxx Master_SSL_Cipher: Master_SSL_Key: xxx Seconds_Behind_Master: 2097439 Master_SSL_Verify_Server_Cert: No Last_IO_Errno: 0 Last_IO_Error: Last_SQL_Errno: 0 Last_SQL_Error: Replicate_Ignore_Server_Ids: Master_Server_Id: 71 Master_SSL_Crl: xxx Master_SSL_Crlpath: Using_Gtid: No Gtid_IO_Pos: Replicate_Do_Domain_Ids: Replicate_Ignore_Domain_Ids: Parallel_Mode: conservative SQL_Delay: 0 SQL_Remaining_Delay: NULL Slave_SQL_Running_State: Update_rows_log_event::find_row(-1) Slave_DDL_Groups: 0 Slave_Non_Transactional_Groups: 0 Slave_Transactional_Groups: 3 1 row in set (0.000 sec)   ERROR: No query specified   MariaDB [(none)]> processlist MariaDB [(none)]> show processlist; +------+-------------+-----------+------+-----------+--------+-------------------------------------+------------------+----------+ | Id | User | Host | db | Command | Time | State | Info | Progress | +------+-------------+-----------+------+-----------+--------+-------------------------------------+------------------+----------+ | 3 | system user | | NULL | Daemon | NULL | InnoDB purge worker | NULL | 0.000 | | 2 | system user | | NULL | Daemon | NULL | InnoDB purge worker | NULL | 0.000 | | 1 | system user | | NULL | Daemon | NULL | InnoDB purge coordinator | NULL | 0.000 | | 4 | system user | | NULL | Daemon | NULL | InnoDB purge worker | NULL | 0.000 | | 5 | system user | | NULL | Daemon | NULL | InnoDB shutdown handler | NULL | 0.000 | | 7970 | system user | | NULL | Slave_IO | 139005 | Waiting for master to send event | NULL | 0.000 | | 7971 | system user | | NULL | Slave_SQL | 20 | Update_rows_log_event::find_row(-1) | NULL | 0.000 | | 9446 | root | localhost | NULL | Query | 0 | Init | show processlist | 0.000 | +------+-------------+-----------+------+-----------+--------+-------------------------------------+------------------+----------+ 8 rows in set (0.000 sec)   MariaDB [(none)]> show innodb status MariaDB [(none)]> SHOW ENGINE INNODB STATUS \G; *************************** 1. row *************************** Type: InnoDB Name: Status: ===================================== 2020-11-26 23:32:52 0x7f3be80c8700 INNODB MONITOR OUTPUT ===================================== Per second averages calculated from the last 9 seconds ----------------- BACKGROUND THREAD ----------------- srv_master_thread loops: 83765 srv_active, 0 srv_shutdown, 799851 srv_idle srv_master_thread log flush and writes: 883590 ---------- SEMAPHORES ---------- OS WAIT ARRAY INFO: reservation count 611926 OS WAIT ARRAY INFO: signal count 611777 RW-shared spins 0, rounds 1163439, OS waits 565726 RW-excl spins 0, rounds 1097141, OS waits 36520 RW-sx spins 8589, rounds 161143, OS waits 1702 Spin rounds per wait: 1163439.00 RW-shared, 1097141.00 RW-excl, 18.76 RW-sx ------------ TRANSACTIONS ------------ Trx id counter 2820359 Purge done for trx's n:o < 2820359 undo n:o < 0 state: running History list length 10 LIST OF TRANSACTIONS FOR EACH SESSION: ---TRANSACTION 421370022671000, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421370022666744, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 2820350, ACTIVE 139106 sec mysql tables in use 1, locked 1 3291 lock struct(s), heap size 467152, 840999 row lock(s), undo log entries 840999 MySQL thread id 7971, OS thread handle 139895273547520, query id 15969 Update_rows_log_event::find_row(-1) ---TRANSACTION 421370022658232, not started 0 lock struct(s), heap size 1136, 0 row lock(s) -------- FILE I/O -------- I/O thread 0 state: waiting for completed aio requests (insert buffer thread) I/O thread 1 state: waiting for completed aio requests (log thread) I/O thread 2 state: waiting for completed aio requests (read thread) I/O thread 3 state: waiting for completed aio requests (read thread) I/O thread 4 state: waiting for completed aio requests (read thread) I/O thread 5 state: waiting for completed aio requests (read thread) I/O thread 6 state: waiting for completed aio requests (write thread) I/O thread 7 state: waiting for completed aio requests (write thread) I/O thread 8 state: waiting for completed aio requests (write thread) I/O thread 9 state: waiting for completed aio requests (write thread) Pending normal aio reads: [0, 0, 0, 0] , aio writes: [0, 0, 0, 0] , ibuf aio reads:, log i/o's:, sync i/o's: Pending flushes (fsync) log: 0; buffer pool: 0 440139 OS file reads, 4932468 OS file writes, 4895964 OS fsyncs 0.00 reads/s, 0 avg bytes/read, 7.78 writes/s, 7.78 fsyncs/s ------------------------------------- INSERT BUFFER AND ADAPTIVE HASH INDEX ------------------------------------- Ibuf: size 1, free list len 18704, seg size 18706, 0 merges merged operations: insert 0, delete mark 0, delete 0 discarded operations: insert 0, delete mark 0, delete 0 Hash table size 4563583, node heap has 0 buffer(s) Hash table size 4563583, node heap has 2 buffer(s) Hash table size 4563583, node heap has 11876 buffer(s) Hash table size 4563583, node heap has 3 buffer(s) Hash table size 4563583, node heap has 3 buffer(s) Hash table size 4563583, node heap has 131 buffer(s) Hash table size 4563583, node heap has 1 buffer(s) Hash table size 4563583, node heap has 0 buffer(s) 0.00 hash searches/s, 0.11 non-hash searches/s --- LOG --- Log sequence number 16427443796127 Log flushed up to 16427443795983 Pages flushed up to 16427443795983 Last checkpoint at 16427443795491 0 pending log flushes, 0 pending chkp writes 2125902 log i/o's done, 3.33 log i/o's/second ---------------------- BUFFER POOL AND MEMORY ---------------------- Total large memory allocated 17884512256 Dictionary memory allocated 659984 Buffer pool size 1057980 Free buffers 600442 Database pages 445494 Old database pages 164326 Modified db pages 2 Percent of dirty pages(LRU & free pages): 0.000 Max dirty pages percent: 75.000 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 0, not young 0 0.00 youngs/s, 0.00 non-youngs/s Pages read 439889, created 5605, written 1472093 0.00 reads/s, 0.00 creates/s, 2.22 writes/s Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000 Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s LRU len: 445494, unzip_LRU len: 0 I/O sum[0]:cur[0], unzip sum[0]:cur[0] ---------------------- INDIVIDUAL BUFFER POOL INFO ---------------------- ---BUFFER POOL 0 Buffer pool size 176330 Free buffers 99234 Database pages 75087 Old database pages 27697 Modified db pages 0 Percent of dirty pages(LRU & free pages): 0.000 Max dirty pages percent: 75.000 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 0, not young 0 0.00 youngs/s, 0.00 non-youngs/s Pages read 74057, created 1030, written 256353 0.00 reads/s, 0.00 creates/s, 0.00 writes/s Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000 Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s LRU len: 75087, unzip_LRU len: 0 I/O sum[0]:cur[0], unzip sum[0]:cur[0] ---BUFFER POOL 1 Buffer pool size 176330 Free buffers 101822 Database pages 72500 Old database pages 26742 Modified db pages 1 Percent of dirty pages(LRU & free pages): 0.001 Max dirty pages percent: 75.000 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 0, not young 0 0.00 youngs/s, 0.00 non-youngs/s Pages read 71510, created 990, written 257831 0.00 reads/s, 0.00 creates/s, 1.11 writes/s Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000 Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s LRU len: 72500, unzip_LRU len: 0 I/O sum[0]:cur[0], unzip sum[0]:cur[0] ---BUFFER POOL 2 Buffer pool size 176330 Free buffers 100523 Database pages 73801 Old database pages 27222 Modified db pages 1 Percent of dirty pages(LRU & free pages): 0.001 Max dirty pages percent: 75.000 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 0, not young 0 0.00 youngs/s, 0.00 non-youngs/s Pages read 72916, created 885, written 261691 0.00 reads/s, 0.00 creates/s, 1.11 writes/s Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000 Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s LRU len: 73801, unzip_LRU len: 0 I/O sum[0]:cur[0], unzip sum[0]:cur[0] ---BUFFER POOL 3 Buffer pool size 176330 Free buffers 100491 Database pages 73833 Old database pages 27234 Modified db pages 0 Percent of dirty pages(LRU & free pages): 0.000 Max dirty pages percent: 75.000 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 0, not young 0 0.00 youngs/s, 0.00 non-youngs/s Pages read 72906, created 927, written 241950 0.00 reads/s, 0.00 creates/s, 0.00 writes/s Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000 Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s LRU len: 73833, unzip_LRU len: 0 I/O sum[0]:cur[0], unzip sum[0]:cur[0] ---BUFFER POOL 4 Buffer pool size 176330 Free buffers 99337 Database pages 74986 Old database pages 27660 Modified db pages 0 Percent of dirty pages(LRU & free pages): 0.000 Max dirty pages percent: 75.000 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 0, not young 0 0.00 youngs/s, 0.00 non-youngs/s Pages read 74062, created 924, written 228573 0.00 reads/s, 0.00 creates/s, 0.00 writes/s Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000 Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s LRU len: 74986, unzip_LRU len: 0 I/O sum[0]:cur[0], unzip sum[0]:cur[0] ---BUFFER POOL 5 Buffer pool size 176330 Free buffers 99035 Database pages 75287 Old database pages 27771 Modified db pages 0 Percent of dirty pages(LRU & free pages): 0.000 Max dirty pages percent: 75.000 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 0, not young 0 0.00 youngs/s, 0.00 non-youngs/s Pages read 74438, created 849, written 225695 0.00 reads/s, 0.00 creates/s, 0.00 writes/s Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000 Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s LRU len: 75287, unzip_LRU len: 0 I/O sum[0]:cur[0], unzip sum[0]:cur[0] -------------- ROW OPERATIONS -------------- 0 queries inside InnoDB, 0 queries in queue 0 read views open inside InnoDB Process ID=28050, Main thread ID=139876649383680, state: sleeping Number of rows inserted 0, updated 2799762, deleted 0, read 1623070235949 0.00 inserts/s, 3.11 updates/s, 0.00 deletes/s, 2624384.18 reads/s Number of system rows inserted 4, updated 0, deleted 2, read 5 0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.00 reads/s ---------------------------- END OF INNODB MONITOR OUTPUT ============================   1 row in set (0.000 sec)   ERROR: No query specified   MariaDB [(none)]>

Tomas Kucera added a comment - 2020-11-27 00:04 Additional info II stuck within executing SQL on this table | values | CREATE TABLE `values` ( `id` decimal(10,0) NOT NULL, `node` varchar(9) NOT NULL, `bex` double NOT NULL, `computation_type` varchar(25) NOT NULL, `hour` int(10) unsigned NOT NULL, `type` varchar(25) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8 | global variables Variable_name Value alter_algorithm DEFAULT analyze_sample_percentage 100.000000 aria_block_size 8192 aria_checkpoint_interval 30 aria_checkpoint_log_activity 1048576 aria_encrypt_tables OFF aria_force_start_after_recovery_failures 0 aria_group_commit none aria_group_commit_interval 0 aria_log_file_size 1073741824 aria_log_purge_type immediate aria_max_sort_file_size 9223372036853727232 aria_page_checksum ON aria_pagecache_age_threshold 300 aria_pagecache_buffer_size 134217728 aria_pagecache_division_limit 100 aria_pagecache_file_hash_size 512 aria_recover_options BACKUP,QUICK aria_repair_threads 1 aria_sort_buffer_size 268434432 aria_stats_method nulls_unequal aria_sync_log_dir NEWFILE aria_used_for_temp_tables ON auto_increment_increment 1 auto_increment_offset 1 autocommit ON automatic_sp_privileges ON back_log 250 basedir /usr/ big_tables OFF bind_address binlog_annotate_row_events ON binlog_cache_size 32768 binlog_checksum CRC32 binlog_commit_wait_count 0 binlog_commit_wait_usec 100000 binlog_direct_non_transactional_updates OFF binlog_file_cache_size 16384 binlog_format MIXED binlog_optimize_thread_scheduling ON binlog_row_image FULL binlog_stmt_cache_size 32768 bulk_insert_buffer_size 8388608 character_set_client latin1 character_set_connection latin1 character_set_database latin1 character_set_filesystem binary character_set_results latin1 character_set_server latin1 character_set_system utf8 character_sets_dir /usr/share/mysql/charsets/ check_constraint_checks ON collation_connection latin1_swedish_ci collation_database latin1_swedish_ci collation_server latin1_swedish_ci column_compression_threshold 100 column_compression_zlib_level 6 column_compression_zlib_strategy DEFAULT_STRATEGY column_compression_zlib_wrap OFF completion_type NO_CHAIN concurrent_insert AUTO connect_timeout 15 core_file OFF datadir /opt/mysqldb/data/ date_format %Y-%m-%d datetime_format %Y-%m-%d %H:%i:%s deadlock_search_depth_long 15 deadlock_search_depth_short 4 deadlock_timeout_long 50000000 deadlock_timeout_short 10000 debug_no_thread_alarm OFF default_password_lifetime 0 default_regex_flags default_storage_engine InnoDB default_tmp_storage_engine default_week_format 0 delay_key_write ON delayed_insert_limit 100 delayed_insert_timeout 300 delayed_queue_size 1000 disconnect_on_expired_password OFF div_precision_increment 4 encrypt_binlog OFF encrypt_tmp_disk_tables OFF encrypt_tmp_files OFF enforce_storage_engine eq_range_index_dive_limit 200 event_scheduler OFF expensive_subquery_limit 100 expire_logs_days 20 explicit_defaults_for_timestamp OFF extra_max_connections 1 extra_port 0 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 p2fbadb01.log group_concat_max_len 1048576 gtid_binlog_pos 0-72-4115 gtid_binlog_state 0-72-4115 gtid_cleanup_batch_size 64 gtid_current_pos 0-71-10767 gtid_domain_id 0 gtid_ignore_duplicates OFF gtid_pos_auto_engines gtid_slave_pos 0-71-10767 gtid_strict_mode OFF have_compress YES have_crypt YES have_dynamic_loading YES have_geometry YES have_openssl YES have_profiling YES have_query_cache YES have_rtree_keys YES have_ssl YES have_symlink YES histogram_size 254 histogram_type DOUBLE_PREC_HB host_cache_size 653 hostname p2fbadb01 idle_readonly_transaction_timeout 0 idle_transaction_timeout 0 idle_write_transaction_timeout 0 ignore_builtin_innodb OFF ignore_db_dirs in_predicate_conversion_threshold 1000 init_connect init_file init_slave innodb_adaptive_flushing ON innodb_adaptive_flushing_lwm 10.000000 innodb_adaptive_hash_index ON innodb_adaptive_hash_index_parts 8 innodb_adaptive_max_sleep_delay 150000 innodb_autoextend_increment 64 innodb_autoinc_lock_mode 1 innodb_background_scrub_data_check_interval 3600 innodb_background_scrub_data_compressed OFF innodb_background_scrub_data_interval 604800 innodb_background_scrub_data_uncompressed OFF innodb_buf_dump_status_frequency 0 innodb_buffer_pool_chunk_size 134217728 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_instances 6 innodb_buffer_pool_load_abort OFF innodb_buffer_pool_load_at_startup ON innodb_buffer_pool_load_now OFF innodb_buffer_pool_size 17716740096 innodb_change_buffer_max_size 25 innodb_change_buffering all innodb_checksum_algorithm crc32 innodb_checksums ON innodb_cmp_per_index_enabled OFF innodb_commit_concurrency 0 innodb_compression_algorithm zlib innodb_compression_default OFF 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_deadlock_detect ON innodb_default_encryption_key_id 1 innodb_default_row_format dynamic innodb_defragment OFF innodb_defragment_fill_factor 0.900000 innodb_defragment_fill_factor_n_recs 20 innodb_defragment_frequency 40 innodb_defragment_n_pages 7 innodb_defragment_stats_accuracy 0 innodb_disable_sort_file_cache OFF innodb_disallow_writes OFF innodb_doublewrite ON innodb_encrypt_log OFF innodb_encrypt_tables OFF innodb_encrypt_temporary_tables OFF innodb_encryption_rotate_key_age 1 innodb_encryption_rotation_iops 100 innodb_encryption_threads 0 innodb_fast_shutdown 0 innodb_fatal_semaphore_wait_threshold 600 innodb_file_format 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 1 innodb_flush_sync ON innodb_flushing_avg_loops 30 innodb_force_load_corrupted OFF innodb_force_primary_key OFF innodb_force_recovery 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_immediate_scrub_data_uncompressed OFF innodb_io_capacity 200 innodb_io_capacity_max 2000 innodb_large_prefix innodb_lock_schedule_algorithm fcfs innodb_lock_wait_timeout 10000 innodb_locks_unsafe_for_binlog OFF innodb_log_buffer_size 83886080 innodb_log_checksums ON innodb_log_compressed_pages ON innodb_log_file_size 536870912 innodb_log_files_in_group 2 innodb_log_group_home_dir ./ innodb_log_optimize_ddl ON innodb_log_write_ahead_size 8192 innodb_lru_scan_depth 1024 innodb_max_dirty_pages_pct 75.000000 innodb_max_dirty_pages_pct_lwm 0.000000 innodb_max_purge_lag 0 innodb_max_purge_lag_delay 0 innodb_max_undo_log_size 10485760 innodb_monitor_disable innodb_monitor_enable innodb_monitor_reset innodb_monitor_reset_all innodb_old_blocks_pct 37 innodb_old_blocks_time 1000 innodb_online_alter_log_max_size 134217728 innodb_open_files 4096 innodb_optimize_fulltext_only OFF innodb_page_cleaners 4 innodb_page_size 16384 innodb_prefix_index_cluster_optimization OFF innodb_print_all_deadlocks 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_replication_delay 0 innodb_rollback_on_timeout OFF innodb_rollback_segments 128 innodb_scrub_log OFF innodb_scrub_log_speed 256 innodb_sort_buffer_size 1048576 innodb_spin_wait_delay 4 innodb_stats_auto_recalc ON innodb_stats_include_delete_marked OFF innodb_stats_method nulls_equal innodb_stats_modified_counter 0 innodb_stats_on_metadata OFF innodb_stats_persistent ON innodb_stats_persistent_sample_pages 20 innodb_stats_sample_pages 8 innodb_stats_traditional ON 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_thread_concurrency 0 innodb_thread_sleep_delay 10000 innodb_tmpdir innodb_undo_directory ./ innodb_undo_log_truncate OFF innodb_undo_logs 128 innodb_undo_tablespaces 0 innodb_use_atomic_writes ON innodb_use_native_aio ON innodb_version 10.4.12 innodb_write_io_threads 4 interactive_timeout 28800 join_buffer_size 262144 join_buffer_space_limit 2097152 join_cache_level 2 keep_files_on_create OFF key_buffer_size 67108864 key_cache_age_threshold 300 key_cache_block_size 1024 key_cache_division_limit 100 key_cache_file_hash_size 512 key_cache_segments 0 large_files_support ON large_page_size 0 large_pages OFF lc_messages en_US lc_messages_dir lc_time_names en_US license GPL local_infile ON lock_wait_timeout 86400 locked_in_memory OFF log_bin ON log_bin_basename /opt/mysqldb/binlogs/bin log_bin_compress OFF log_bin_compress_min_len 256 log_bin_index /opt/mysqldb/binlogs/bin.index log_bin_trust_function_creators OFF log_disabled_statements sp log_error /opt/logs/mysql/mysqld.log log_output FILE log_queries_not_using_indexes OFF log_slave_updates OFF log_slow_admin_statements ON log_slow_disabled_statements sp log_slow_filter admin,filesort,filesort_on_disk,filesort_priority_queue,full_join,full_scan,query_cache,query_cache_miss,tmp_table,tmp_table_on_disk log_slow_rate_limit 1 log_slow_slave_statements ON log_slow_verbosity log_tc_size 24576 log_warnings 2 long_query_time 10.000000 low_priority_updates OFF lower_case_file_system OFF lower_case_table_names 1 master_verify_checksum OFF max_allowed_packet 1073741824 max_binlog_cache_size 18446744073709547520 max_binlog_size 1073741824 max_binlog_stmt_cache_size 18446744073709547520 max_connect_errors 10000 max_connections 1000 max_delayed_threads 20 max_digest_length 1024 max_error_count 64 max_heap_table_size 67108864 max_insert_delayed_threads 20 max_join_size 18446744073709551615 max_length_for_sort_data 1024 max_long_data_size 1073741824 max_password_errors 4294967295 max_prepared_stmt_count 16382 max_recursive_iterations 4294967295 max_relay_log_size 1073741824 max_rowid_filter_size 131072 max_seeks_for_key 4294967295 max_session_mem_used 9223372036854775807 max_sort_length 1024 max_sp_recursion_depth 0 max_statement_time 0.000000 max_tmp_tables 32 max_user_connections 0 max_write_lock_count 4294967295 metadata_locks_cache_size 1024 metadata_locks_hash_instances 8 min_examined_row_limit 0 mrr_buffer_size 262144 multi_range_count 256 myisam_block_size 1024 myisam_data_pointer_size 6 myisam_max_sort_file_size 9223372036853727232 myisam_mmap_size 18446744073709551615 myisam_recover_options BACKUP,FORCE myisam_repair_threads 1 myisam_sort_buffer_size 134216704 myisam_stats_method NULLS_UNEQUAL myisam_use_mmap OFF mysql56_temporal_format ON net_buffer_length 16384 net_read_timeout 30 net_retry_count 10 net_write_timeout 60 old OFF old_alter_table DEFAULT old_mode old_passwords OFF open_files_limit 65535 optimizer_prune_level 1 optimizer_search_depth 62 optimizer_selectivity_sampling_limit 100 optimizer_switch index_merge=on,index_merge_union=on,index_merge_sort_union=on,index_merge_intersection=on,index_merge_sort_intersection=off,engine_condition_pushdown=off,index_condition_pushdown=on,derived_merge=on,derived_with_keys=on,firstmatch=on,loosescan=on,materialization=on,in_to_exists=on,semijoin=on,partial_match_rowid_merge=on,partial_match_table_scan=on,subquery_cache=on,mrr=off,mrr_cost_based=off,mrr_sort_keys=off,outer_join_with_cache=on,semijoin_with_cache=on,join_cache_incremental=on,join_cache_hashed=on,join_cache_bka=on,optimize_join_buffer_size=on,table_elimination=on,extended_keys=on,exists_to_in=on,orderby_uses_equalities=on,condition_pushdown_for_derived=on,split_materialized=on,condition_pushdown_for_subquery=on,rowid_filter=on,condition_pushdown_from_having=on optimizer_trace enabled=off optimizer_trace_max_mem_size 1048576 optimizer_use_condition_selectivity 4 performance_schema OFF performance_schema_accounts_size -1 performance_schema_digests_size -1 performance_schema_events_stages_history_long_size -1 performance_schema_events_stages_history_size -1 performance_schema_events_statements_history_long_size -1 performance_schema_events_statements_history_size -1 performance_schema_events_waits_history_long_size -1 performance_schema_events_waits_history_size -1 performance_schema_hosts_size -1 performance_schema_max_cond_classes 90 performance_schema_max_cond_instances -1 performance_schema_max_digest_length 1024 performance_schema_max_file_classes 50 performance_schema_max_file_handles 32768 performance_schema_max_file_instances -1 performance_schema_max_mutex_classes 200 performance_schema_max_mutex_instances -1 performance_schema_max_rwlock_classes 40 performance_schema_max_rwlock_instances -1 performance_schema_max_socket_classes 10 performance_schema_max_socket_instances -1 performance_schema_max_stage_classes 160 performance_schema_max_statement_classes 202 performance_schema_max_table_handles -1 performance_schema_max_table_instances -1 performance_schema_max_thread_classes 50 performance_schema_max_thread_instances -1 performance_schema_session_connect_attrs_size -1 performance_schema_setup_actors_size 100 performance_schema_setup_objects_size 100 performance_schema_users_size -1 pid_file /opt/mysqldb/data/p2fbadb01.pid plugin_dir /usr/lib64/mysql/plugin/ plugin_maturity gamma port 3306 preload_buffer_size 32768 profiling OFF profiling_history_size 15 progress_report_time 5 protocol_version 10 proxy_protocol_networks query_alloc_block_size 16384 query_cache_limit 1048576 query_cache_min_res_unit 4096 query_cache_size 536870912 query_cache_strip_comments OFF query_cache_type DEMAND query_cache_wlock_invalidate OFF query_prealloc_size 24576 range_alloc_block_size 4096 read_binlog_speed_limit 0 read_buffer_size 131072 read_only OFF read_rnd_buffer_size 262144 relay_log relay_log_basename relay_log_index relay_log_info_file relay-log.info relay_log_purge ON relay_log_recovery OFF relay_log_space_limit 0 replicate_annotate_row_events ON replicate_do_db replicate_do_table replicate_events_marked_for_skip REPLICATE replicate_ignore_db replicate_ignore_table replicate_wild_do_table replicate_wild_ignore_table report_host report_password report_port 3306 report_user rowid_merge_buff_size 8388608 rpl_semi_sync_master_enabled OFF rpl_semi_sync_master_timeout 10000 rpl_semi_sync_master_trace_level 32 rpl_semi_sync_master_wait_no_slave ON rpl_semi_sync_master_wait_point AFTER_COMMIT rpl_semi_sync_slave_delay_master OFF rpl_semi_sync_slave_enabled OFF rpl_semi_sync_slave_kill_conn_timeout 5 rpl_semi_sync_slave_trace_level 32 secure_auth ON secure_file_priv secure_timestamp NO server_id 72 session_track_schema ON session_track_state_change OFF session_track_system_variables autocommit,character_set_client,character_set_connection,character_set_results,time_zone session_track_transaction_info OFF skip_external_locking ON skip_name_resolve ON skip_networking OFF skip_show_database OFF slave_compressed_protocol OFF slave_ddl_exec_mode IDEMPOTENT slave_domain_parallel_threads 0 slave_exec_mode STRICT slave_load_tmpdir /opt/mysqldb/temp slave_max_allowed_packet 1073741824 slave_net_timeout 60 slave_parallel_max_queued 131072 slave_parallel_mode conservative slave_parallel_threads 0 slave_parallel_workers 0 slave_run_triggers_for_rbr NO slave_skip_errors OFF slave_sql_verify_checksum ON slave_transaction_retries 10 slave_transaction_retry_errors 1158,1159,1160,1161,1205,1213,1429,2013,12701 slave_transaction_retry_interval 0 slave_type_conversions slow_launch_time 2 slow_query_log OFF slow_query_log_file p2fbadb01-slow.log socket /opt/mysqldb/data/mysql.sock sort_buffer_size 2097152 sql_auto_is_null OFF sql_big_selects ON sql_buffer_result OFF sql_log_bin ON sql_log_off OFF sql_mode STRICT_TRANS_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION sql_notes ON sql_quote_show_create ON sql_safe_updates OFF sql_select_limit 18446744073709551615 sql_slave_skip_counter 0 sql_warnings OFF ssl_ca /etc/mysql/ca-crt.pem ssl_capath ssl_cert /etc/mysql/server-crt.pem ssl_cipher ssl_crl ssl_crlpath ssl_key /etc/mysql/server-key.pem standard_compliant_cte ON storage_engine InnoDB stored_program_cache 256 strict_password_validation ON sync_binlog 0 sync_frm ON sync_master_info 10000 sync_relay_log 10000 sync_relay_log_info 10000 system_time_zone CET system_versioning_alter_history ERROR system_versioning_asof DEFAULT table_definition_cache 2048 table_open_cache 4096 table_open_cache_instances 8 tcp_keepalive_interval 0 tcp_keepalive_probes 0 tcp_keepalive_time 0 tcp_nodelay ON thread_cache_size 100 thread_concurrency 10 thread_handling one-thread-per-connection thread_pool_idle_timeout 60 thread_pool_max_threads 65536 thread_pool_oversubscribe 3 thread_pool_prio_kickup_timer 1000 thread_pool_priority auto thread_pool_size 8 thread_pool_stall_limit 500 thread_stack 299008 time_format %H:%i:%s time_zone +00:00 timed_mutexes OFF tls_version TLSv1.1,TLSv1.2,TLSv1.3 tmp_disk_table_size 18446744073709551615 tmp_memory_table_size 1073741824 tmp_table_size 1073741824 tmpdir /opt/mysqldb/temp transaction_alloc_block_size 8192 transaction_prealloc_size 4096 tx_isolation READ-COMMITTED tx_read_only OFF unique_checks ON updatable_views_with_limit YES use_stat_tables PREFERABLY_FOR_QUERIES userstat OFF version 10.4.12-MariaDB-log version_comment MariaDB Server version_compile_machine x86_64 version_compile_os Linux version_malloc_library system version_source_revision ba6bfc402c352372cc1a9ec20b5dc50b2204549f version_ssl_library OpenSSL 1.0.2k-fips 26 Jan 2017 wait_timeout 28800 wsrep_osu_method TOI wsrep_sr_store table wsrep_auto_increment_control ON wsrep_causal_reads OFF wsrep_certification_rules strict wsrep_certify_nonpk ON wsrep_cluster_address wsrep_cluster_name my_wsrep_cluster wsrep_convert_lock_to_trx OFF wsrep_data_home_dir /opt/mysqldb/data/ wsrep_dbug_option wsrep_debug NONE wsrep_desync OFF wsrep_dirty_reads OFF wsrep_drupal_282555_workaround OFF wsrep_forced_binlog_format NONE wsrep_gtid_domain_id 0 wsrep_gtid_mode OFF wsrep_ignore_apply_errors 7 wsrep_load_data_splitting OFF wsrep_log_conflicts OFF wsrep_max_ws_rows 0 wsrep_max_ws_size 2147483647 wsrep_mysql_replication_bundle 0 wsrep_node_address wsrep_node_incoming_address AUTO wsrep_node_name p2fbadb01 wsrep_notify_cmd wsrep_on OFF wsrep_patch_version wsrep_26.22 wsrep_provider none wsrep_provider_options wsrep_recover OFF wsrep_reject_queries NONE wsrep_replicate_myisam OFF wsrep_restart_slave OFF wsrep_retry_autocommit 1 wsrep_slave_fk_checks ON wsrep_slave_uk_checks OFF wsrep_slave_threads 1 wsrep_sst_auth wsrep_sst_donor wsrep_sst_donor_rejects_queries OFF wsrep_sst_method rsync wsrep_sst_receive_address AUTO wsrep_start_position 00000000-0000-0000-0000-000000000000:-1 wsrep_sync_wait 0 wsrep_trx_fragment_size 0 wsrep_trx_fragment_unit bytes global status Variable_name Value Aborted_clients 2 Aborted_connects 0 Aborted_connects_preauth 0 Access_denied_errors 0 Acl_column_grants 0 Acl_database_grants 103 Acl_function_grants 0 Acl_procedure_grants 0 Acl_package_spec_grants 0 Acl_package_body_grants 0 Acl_proxy_users 0 Acl_role_grants 0 Acl_roles 0 Acl_table_grants 0 Acl_users 80 Aria_pagecache_blocks_not_flushed 0 Aria_pagecache_blocks_unused 15694 Aria_pagecache_blocks_used 13 Aria_pagecache_read_requests 16 Aria_pagecache_reads 16 Aria_pagecache_write_requests 0 Aria_pagecache_writes 0 Aria_transaction_log_syncs 0 Binlog_commits 0 Binlog_group_commits 0 Binlog_group_commit_trigger_count 0 Binlog_group_commit_trigger_lock_wait 0 Binlog_group_commit_trigger_timeout 0 Binlog_snapshot_file bin.000079 Binlog_snapshot_position 336 Binlog_bytes_written 0 Binlog_cache_disk_use 0 Binlog_cache_use 0 Binlog_stmt_cache_disk_use 0 Binlog_stmt_cache_use 0 Busy_time 0.000000 Bytes_received 44794471959 Bytes_sent 26289467 Column_compressions 0 Column_decompressions 0 Com_admin_commands 0 Com_alter_db 0 Com_alter_db_upgrade 0 Com_alter_event 0 Com_alter_function 0 Com_alter_procedure 0 Com_alter_server 0 Com_alter_sequence 0 Com_alter_table 0 Com_alter_tablespace 0 Com_alter_user 0 Com_analyze 0 Com_assign_to_keycache 0 Com_backup 0 Com_backup_lock 0 Com_begin 3 Com_binlog 0 Com_call_procedure 0 Com_change_db 1 Com_change_master 0 Com_check 0 Com_checksum 0 Com_commit 0 Com_compound_sql 0 Com_create_db 0 Com_create_event 0 Com_create_function 0 Com_create_index 0 Com_create_package 0 Com_create_package_body 0 Com_create_procedure 0 Com_create_role 0 Com_create_sequence 0 Com_create_server 0 Com_create_table 0 Com_create_temporary_table 0 Com_create_trigger 0 Com_create_udf 0 Com_create_user 0 Com_create_view 0 Com_dealloc_sql 0 Com_delete 0 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_package 0 Com_drop_package_body 0 Com_drop_role 0 Com_drop_server 0 Com_drop_sequence 0 Com_drop_table 0 Com_drop_temporary_table 0 Com_drop_trigger 0 Com_drop_user 0 Com_drop_view 0 Com_empty_query 0 Com_execute_immediate 0 Com_execute_sql 0 Com_flush 0 Com_get_diagnostics 0 Com_grant 0 Com_grant_role 0 Com_ha_close 0 Com_ha_open 0 Com_ha_read 0 Com_help 0 Com_insert 0 Com_insert_select 0 Com_install_plugin 0 Com_kill 2 Com_load 0 Com_lock_tables 0 Com_multi 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 0 Com_replace_select 0 Com_reset 0 Com_resignal 0 Com_revoke 0 Com_revoke_all 0 Com_revoke_role 0 Com_rollback 0 Com_rollback_to_savepoint 0 Com_savepoint 0 Com_select 60 Com_set_option 6 Com_show_authors 0 Com_show_binlog_events 0 Com_show_binlogs 0 Com_show_charsets 1 Com_show_collations 1 Com_show_contributors 0 Com_show_create_db 0 Com_show_create_event 0 Com_show_create_func 0 Com_show_create_package 0 Com_show_create_package_body 0 Com_show_create_proc 0 Com_show_create_table 0 Com_show_create_trigger 0 Com_show_create_user 0 Com_show_databases 1 Com_show_engine_logs 0 Com_show_engine_mutex 0 Com_show_engine_status 2 Com_show_errors 0 Com_show_events 0 Com_show_explain 0 Com_show_fields 0 Com_show_function_status 0 Com_show_generic 0 Com_show_grants 0 Com_show_keys 0 Com_show_master_status 0 Com_show_open_tables 0 Com_show_package_status 0 Com_show_package_body_status 0 Com_show_plugins 0 Com_show_privileges 0 Com_show_procedure_status 0 Com_show_processlist 10 Com_show_profile 0 Com_show_profiles 0 Com_show_relaylog_events 0 Com_show_slave_hosts 0 Com_show_slave_status 9478 Com_show_status 1 Com_show_storage_engines 1 Com_show_table_status 0 Com_show_tables 0 Com_show_triggers 0 Com_show_variables 5 Com_show_warnings 0 Com_shutdown 0 Com_signal 0 Com_start_all_slaves 0 Com_start_slave 3 Com_stmt_close 0 Com_stmt_execute 0 Com_stmt_fetch 0 Com_stmt_prepare 0 Com_stmt_reprepare 0 Com_stmt_reset 0 Com_stmt_send_long_data 0 Com_stop_all_slaves 0 Com_stop_slave 2 Com_truncate 0 Com_uninstall_plugin 0 Com_unlock_tables 0 Com_update 0 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 Compression OFF 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 9503 Cpu_time 0.000000 Created_tmp_disk_tables 134 Created_tmp_files 5 Created_tmp_tables 878 Delayed_errors 0 Delayed_insert_threads 0 Delayed_writes 0 Delete_scan 0 Empty_queries 2 Executed_events 0 Executed_triggers 0 Feature_application_time_periods 0 Feature_check_constraint 1 Feature_custom_aggregate_functions 0 Feature_delay_key_write 0 Feature_dynamic_columns 0 Feature_fulltext 0 Feature_gis 0 Feature_invisible_columns 0 Feature_json 496 Feature_locale 0 Feature_subquery 0 Feature_system_versioning 0 Feature_timezone 1 Feature_trigger 0 Feature_window_functions 0 Feature_xml 0 Flush_commands 1 Handler_commit 22 Handler_delete 0 Handler_discover 52 Handler_external_lock 0 Handler_icp_attempts 0 Handler_icp_match 0 Handler_mrr_init 0 Handler_mrr_key_refills 0 Handler_mrr_rowid_refills 0 Handler_prepare 0 Handler_read_first 4 Handler_read_key 3222590 Handler_read_last 2 Handler_read_next 27311952 Handler_read_prev 0 Handler_read_retry 0 Handler_read_rnd 106 Handler_read_rnd_deleted 0 Handler_read_rnd_next 1635247104397 Handler_rollback 5 Handler_savepoint 0 Handler_savepoint_rollback 0 Handler_tmp_delete 0 Handler_tmp_update 433021 Handler_tmp_write 7708 Handler_update 2814153 Handler_write 4 Innodb_buffer_pool_dump_status Innodb_buffer_pool_load_status Buffer pool(s) load completed at 201116 16:49:49 Innodb_buffer_pool_resize_status Innodb_buffer_pool_load_incomplete OFF Innodb_buffer_pool_pages_data 445527 Innodb_buffer_pool_bytes_data 7299514368 Innodb_buffer_pool_pages_dirty 2 Innodb_buffer_pool_bytes_dirty 32768 Innodb_buffer_pool_pages_flushed 1482901 Innodb_buffer_pool_pages_free 600410 Innodb_buffer_pool_pages_misc 12043 Innodb_buffer_pool_pages_total 1057980 Innodb_buffer_pool_read_ahead_rnd 0 Innodb_buffer_pool_read_ahead 109974 Innodb_buffer_pool_read_ahead_evicted 0 Innodb_buffer_pool_read_requests 1641715578454 Innodb_buffer_pool_reads 329916 Innodb_buffer_pool_wait_free 0 Innodb_buffer_pool_write_requests 7712099 Innodb_data_fsyncs 4927011 Innodb_data_pending_fsyncs 0 Innodb_data_pending_reads 0 Innodb_data_pending_writes 0 Innodb_data_read 7207225856 Innodb_data_reads 440139 Innodb_data_writes 4963685 Innodb_data_written 50803233280 Innodb_dblwr_pages_written 1482770 Innodb_dblwr_writes 1340850 Innodb_log_waits 0 Innodb_log_write_requests 1385861 Innodb_log_writes 1574793 Innodb_os_log_fsyncs 2140102 Innodb_os_log_pending_fsyncs 0 Innodb_os_log_pending_writes 0 Innodb_os_log_written 1925289472 Innodb_page_size 16384 Innodb_pages_created 5638 Innodb_pages_read 439889 Innodb_pages_written 1482901 Innodb_row_lock_current_waits 0 Innodb_row_lock_time 0 Innodb_row_lock_time_avg 0 Innodb_row_lock_time_max 0 Innodb_row_lock_waits 0 Innodb_rows_deleted 0 Innodb_rows_inserted 0 Innodb_rows_read 1635277209135 Innodb_rows_updated 2814153 Innodb_system_rows_deleted 2 Innodb_system_rows_inserted 4 Innodb_system_rows_read 5 Innodb_system_rows_updated 0 Innodb_num_open_files 242 Innodb_truncated_status_writes 0 Innodb_available_undo_logs 128 Innodb_undo_truncations 0 Innodb_page_compression_saved 0 Innodb_num_index_pages_written 0 Innodb_num_non_index_pages_written 0 Innodb_num_pages_page_compressed 0 Innodb_num_page_compressed_trim_op 0 Innodb_num_pages_page_decompressed 0 Innodb_num_pages_page_compression_error 0 Innodb_num_pages_encrypted 0 Innodb_num_pages_decrypted 0 Innodb_have_lz4 OFF Innodb_have_lzo OFF Innodb_have_lzma ON Innodb_have_bzip2 OFF Innodb_have_snappy OFF Innodb_have_punch_hole ON Innodb_defragment_compression_failures 0 Innodb_defragment_failures 0 Innodb_defragment_count 0 Innodb_instant_alter_column 0 Innodb_onlineddl_rowlog_rows 0 Innodb_onlineddl_rowlog_pct_used 0 Innodb_onlineddl_pct_progress 0 Innodb_secondary_index_triggered_cluster_reads 27311924 Innodb_secondary_index_triggered_cluster_reads_avoided 0 Innodb_encryption_rotation_pages_read_from_cache 0 Innodb_encryption_rotation_pages_read_from_disk 0 Innodb_encryption_rotation_pages_modified 0 Innodb_encryption_rotation_pages_flushed 0 Innodb_encryption_rotation_estimated_iops 0 Innodb_encryption_key_rotation_list_length 0 Innodb_encryption_n_merge_blocks_encrypted 0 Innodb_encryption_n_merge_blocks_decrypted 0 Innodb_encryption_n_rowlog_blocks_encrypted 0 Innodb_encryption_n_rowlog_blocks_decrypted 0 Innodb_encryption_n_temp_blocks_encrypted 0 Innodb_encryption_n_temp_blocks_decrypted 0 Innodb_scrub_background_page_reorganizations 0 Innodb_scrub_background_page_splits 0 Innodb_scrub_background_page_split_failures_underflow 0 Innodb_scrub_background_page_split_failures_out_of_filespace 0 Innodb_scrub_background_page_split_failures_missing_index 0 Innodb_scrub_background_page_split_failures_unknown 0 Innodb_scrub_log 0 Innodb_encryption_num_key_requests 0 Key_blocks_not_flushed 0 Key_blocks_unused 53578 Key_blocks_used 0 Key_blocks_warm 0 Key_read_requests 0 Key_reads 0 Key_write_requests 0 Key_writes 0 Last_query_cost 0.000000 Master_gtid_wait_count 0 Master_gtid_wait_time 0 Master_gtid_wait_timeouts 0 Max_statement_time_exceeded 0 Max_used_connections 3 Memory_used 752076240 Memory_used_initial 743757776 Not_flushed_delayed_rows 0 Open_files 63 Open_streams 0 Open_table_definitions 348 Open_tables 326 Opened_files 1456 Opened_plugin_libraries 0 Opened_table_definitions 315 Opened_tables 332 Opened_views 473 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_locker_lost 0 Performance_schema_mutex_classes_lost 0 Performance_schema_mutex_instances_lost 0 Performance_schema_rwlock_classes_lost 0 Performance_schema_rwlock_instances_lost 0 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_thread_classes_lost 0 Performance_schema_thread_instances_lost 0 Performance_schema_users_lost 0 Prepared_stmt_count 0 Qcache_free_blocks 1 Qcache_free_memory 536852776 Qcache_hits 0 Qcache_inserts 0 Qcache_lowmem_prunes 0 Qcache_not_cached 60 Qcache_queries_in_cache 0 Qcache_total_blocks 1 Queries 19066 Questions 19060 Rows_read 1269429975533 Rows_sent 3083 Rows_tmp_read 440835 Rpl_semi_sync_master_clients 0 Rpl_semi_sync_master_get_ack 0 Rpl_semi_sync_master_net_avg_wait_time 0 Rpl_semi_sync_master_net_wait_time 0 Rpl_semi_sync_master_net_waits 0 Rpl_semi_sync_master_no_times 0 Rpl_semi_sync_master_no_tx 0 Rpl_semi_sync_master_request_ack 0 Rpl_semi_sync_master_status OFF Rpl_semi_sync_master_timefunc_failures 0 Rpl_semi_sync_master_tx_avg_wait_time 0 Rpl_semi_sync_master_tx_wait_time 0 Rpl_semi_sync_master_tx_waits 0 Rpl_semi_sync_master_wait_pos_backtraverse 0 Rpl_semi_sync_master_wait_sessions 0 Rpl_semi_sync_master_yes_tx 0 Rpl_semi_sync_slave_send_ack 0 Rpl_semi_sync_slave_status OFF Rpl_status AUTH_MASTER Rpl_transactions_multi_engine 0 Select_full_join 0 Select_full_range_join 0 Select_range 0 Select_range_check 0 Select_scan 34 Slave_connections 0 Slave_heartbeat_period 30.000 Slave_open_temp_tables 0 Slave_received_heartbeats 20865 Slave_retried_transactions 0 Slave_running ON Slave_skipped_errors 0 Slaves_connected 0 Slaves_running 1 Slow_launch_threads 0 Slow_queries 4 Sort_merge_passes 0 Sort_priority_queue_sorts 0 Sort_range 0 Sort_rows 106 Sort_scan 8 Ssl_accept_renegotiates 0 Ssl_accepts 9486 Ssl_callback_cache_hits 0 Ssl_cipher DHE-RSA-AES256-GCM-SHA384 Ssl_cipher_list ECDHE-RSA-AES256-GCM-SHA384:ECDHE-ECDSA-AES256-GCM-SHA384:ECDHE-RSA-AES256-SHA384:ECDHE-ECDSA-AES256-SHA384:ECDHE-RSA-AES256-SHA:ECDHE-ECDSA-AES256-SHA:DH-DSS-AES256-GCM-SHA384:DHE-DSS-AES256-GCM-SHA384:DH-RSA-AES256-GCM-SHA384:DHE-RSA-AES256-GCM-SHA384:DHE-RSA-AES256-SHA256:DHE-DSS-AES256-SHA256:DH-RSA-AES256-SHA256:DH-DSS-AES256-SHA256:DHE-RSA-AES256-SHA:DHE-DSS-AES256-SHA:DH-RSA-AES256-SHA:DH-DSS-AES256-SHA:DHE-RSA-CAMELLIA256-SHA:DHE-DSS-CAMELLIA256-SHA:DH-RSA-CAMELLIA256-SHA:DH-DSS-CAMELLIA256-SHA:ECDH-RSA-AES256-GCM-SHA384:ECDH-ECDSA-AES256-GCM-SHA384:ECDH-RSA-AES256-SHA384:ECDH-ECDSA-AES256-SHA384:ECDH-RSA-AES256-SHA:ECDH-ECDSA-AES256-SHA:AES256-GCM-SHA384:AES256-SHA256:AES256-SHA:CAMELLIA256-SHA:PSK-AES256-CBC-SHA:ECDHE-RSA-AES128-GCM-SHA256:ECDHE-ECDSA-AES128-GCM-SHA256:ECDHE-RSA-AES128-SHA256:ECDHE-ECDSA-AES128-SHA256:ECDHE-RSA-AES128-SHA:ECDHE-ECDSA-AES128-SHA:DH-DSS-AES128-GCM-SHA256:DHE-DSS-AES128-GCM-SHA256:DH-RSA-AES128-GCM-SHA256:DHE-RSA-AES128-GCM-SHA256:DHE-RSA-AES128-SHA256:DHE-DSS-AES128-SHA256:DH-RSA-AES128-SHA256:DH-DSS-AES128-SHA256:DHE-RSA-AES128-SHA:DHE-DSS-AES128-SHA:DH-RSA-AES128-SHA:DH-DSS-AES128-SHA:DHE-RSA-SEED-SHA:DHE-DSS-SEED-SHA:DH-RSA-SEED-SHA:DH-DSS-SEED-SHA:DHE-RSA-CAMELLIA128-SHA:DHE-DSS-CAMELLIA128-SHA:DH-RSA-CAMELLIA128-SHA:DH-DSS-CAMELLIA128-SHA:ECDH-RSA-AES128-GCM-SHA256:ECDH-ECDSA-AES128-GCM-SHA256:ECDH-RSA-AES128-SHA256:ECDH-ECDSA-AES128-SHA256:ECDH-RSA-AES128-SHA:ECDH-ECDSA-AES128-SHA:AES128-GCM-SHA256:AES128-SHA256:AES128-SHA:SEED-SHA:CAMELLIA128-SHA:PSK-AES128-CBC-SHA:ECDHE-RSA-DES-CBC3-SHA:ECDHE-ECDSA-DES-CBC3-SHA:EDH-RSA-DES-CBC3-SHA:EDH-DSS-DES-CBC3-SHA:DH-RSA-DES-CBC3-SHA:DH-DSS-DES-CBC3-SHA:ECDH-RSA-DES-CBC3-SHA:ECDH-ECDSA-DES-CBC3-SHA:DES-CBC3-SHA:IDEA-CBC-SHA:PSK-3DES-EDE-CBC-SHA:KRB5-IDEA-CBC-SHA:KRB5-DES-CBC3-SHA:KRB5-IDEA-CBC-MD5:KRB5-DES-CBC3-MD5:ECDHE-RSA-RC4-SHA:ECDHE-ECDSA-RC4-SHA:ECDH-RSA-RC4-SHA:ECDH-ECDSA-RC4-SHA:RC4-SHA:RC4-MD5:PSK-RC4-SHA:KRB5-RC4-SHA:KRB5-RC4-MD5 Ssl_client_connects 0 Ssl_connect_renegotiates 0 Ssl_ctx_verify_depth 18446744073709551615 Ssl_ctx_verify_mode 5 Ssl_default_timeout 7200 Ssl_finished_accepts 9486 Ssl_finished_connects 0 Ssl_server_not_after May 22 09:11:36 2032 GMT Ssl_server_not_before May 27 09:11:36 2012 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_timeouts 0 Ssl_sessions_reused 0 Ssl_used_session_cache_entries 0 Ssl_verify_depth 18446744073709551615 Ssl_verify_mode 5 Ssl_version TLSv1.2 Subquery_cache_hit 0 Subquery_cache_miss 0 Syncs 12248 Table_locks_immediate 23 Table_locks_waited 0 Table_open_cache_active_instances 1 Table_open_cache_hits 3907 Table_open_cache_misses 805 Table_open_cache_overflows 0 Tc_log_max_pages_used 0 Tc_log_page_size 0 Tc_log_page_waits 0 Threadpool_idle_threads 0 Threadpool_threads 0 Threads_cached 0 Threads_connected 1 Threads_created 1065 Threads_running 8 Transactions_gtid_foreign_engine 0 Transactions_multi_engine 0 Update_scan 0 Uptime 893055 Uptime_since_flush_status 893055 wsrep 58502558202168 wsrep_applier_thread_count 0 wsrep_cluster_capabilities wsrep_cluster_conf_id 18446744073709551615 wsrep_cluster_size 0 wsrep_cluster_state_uuid wsrep_cluster_status Disconnected wsrep_connected OFF wsrep_local_bf_aborts 0 wsrep_local_index 18446744073709551615 wsrep_provider_capabilities wsrep_provider_name wsrep_provider_vendor wsrep_provider_version wsrep_ready OFF wsrep_rollbacker_thread_count 0 wsrep_thread_count 0

Tomas Kucera added a comment - 2020-11-27 21:57 Additional info III GNU Debugger output gdb -ex "set pagination 0" -ex "thread apply all bt" --batch -p $(pidof mysqld) [New LWP 25833] [New LWP 25832] [New LWP 28091] [New LWP 28090] [New LWP 28085] [New LWP 28084] [New LWP 28083] [New LWP 28082] [New LWP 28081] [New LWP 28080] [New LWP 28079] [New LWP 28078] [New LWP 28077] [New LWP 28076] [New LWP 28075] [New LWP 28074] [New LWP 28073] [New LWP 28072] [New LWP 28071] [New LWP 28068] [New LWP 28067] [New LWP 28066] [New LWP 28064] [New LWP 28063] [New LWP 28062] [New LWP 28061] [New LWP 28060] [New LWP 28059] [New LWP 28058] [New LWP 28057] [New LWP 28056] [New LWP 28055] [New LWP 28054] [New LWP 28053] [New LWP 28052] [Thread debugging using libthread_db enabled] Using host libthread_db library "/lib64/libthread_db.so.1". 0x00007f3c0eec620d in poll () from /lib64/libc.so.6   Thread 36 (Thread 0x7f3bec07c700 (LWP 28052)): #0 0x00007f3c10b31d12 in pthread_cond_timedwait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x000055b6f5bcc027 in timer_handler () #2 0x00007f3c10b2ddd5 in start_thread () from /lib64/libpthread.so.0 #3 0x00007f3c0eed0ead in clone () from /lib64/libc.so.6   Thread 35 (Thread 0x7f3bdb450700 (LWP 28053)): #0 0x00007f3c10b31d12 in pthread_cond_timedwait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x000055b6f5aa6706 in my_service_thread_sleep () #2 0x000055b6f5a9e05e in ma_checkpoint_background () #3 0x00007f3c10b2ddd5 in start_thread () from /lib64/libpthread.so.0 #4 0x00007f3c0eed0ead in clone () from /lib64/libc.so.6   Thread 34 (Thread 0x7f377f57f700 (LWP 28054)): #0 0x00007f3c106fe644 in __io_getevents_0_4 () from /lib64/libaio.so.1 #1 0x000055b6f5876bca in LinuxAIOHandler::collect() () #2 0x000055b6f58771f2 in LinuxAIOHandler::poll(fil_node_t**, void**, IORequest*) () #3 0x000055b6f587ed79 in os_aio_handler(unsigned long, fil_node_t**, void**, IORequest*) () #4 0x000055b6f59fd661 in fil_aio_wait(unsigned long) () #5 0x000055b6f590bdd8 in io_handler_thread () #6 0x00007f3c10b2ddd5 in start_thread () from /lib64/libpthread.so.0 #7 0x00007f3c0eed0ead in clone () from /lib64/libc.so.6   Thread 33 (Thread 0x7f377ed7e700 (LWP 28055)): #0 0x00007f3c106fe644 in __io_getevents_0_4 () from /lib64/libaio.so.1 #1 0x000055b6f5876bca in LinuxAIOHandler::collect() () #2 0x000055b6f58771f2 in LinuxAIOHandler::poll(fil_node_t**, void**, IORequest*) () #3 0x000055b6f587ed79 in os_aio_handler(unsigned long, fil_node_t**, void**, IORequest*) () #4 0x000055b6f59fd661 in fil_aio_wait(unsigned long) () #5 0x000055b6f590bdd8 in io_handler_thread () #6 0x00007f3c10b2ddd5 in start_thread () from /lib64/libpthread.so.0 #7 0x00007f3c0eed0ead in clone () from /lib64/libc.so.6   Thread 32 (Thread 0x7f377e57d700 (LWP 28056)): #0 0x00007f3c106fe644 in __io_getevents_0_4 () from /lib64/libaio.so.1 #1 0x000055b6f5876bca in LinuxAIOHandler::collect() () #2 0x000055b6f58771f2 in LinuxAIOHandler::poll(fil_node_t**, void**, IORequest*) () #3 0x000055b6f587ed79 in os_aio_handler(unsigned long, fil_node_t**, void**, IORequest*) () #4 0x000055b6f59fd661 in fil_aio_wait(unsigned long) () #5 0x000055b6f590bdd8 in io_handler_thread () #6 0x00007f3c10b2ddd5 in start_thread () from /lib64/libpthread.so.0 #7 0x00007f3c0eed0ead in clone () from /lib64/libc.so.6   Thread 31 (Thread 0x7f377dd7c700 (LWP 28057)): #0 0x00007f3c106fe644 in __io_getevents_0_4 () from /lib64/libaio.so.1 #1 0x000055b6f5876bca in LinuxAIOHandler::collect() () #2 0x000055b6f58771f2 in LinuxAIOHandler::poll(fil_node_t**, void**, IORequest*) () #3 0x000055b6f587ed79 in os_aio_handler(unsigned long, fil_node_t**, void**, IORequest*) () #4 0x000055b6f59fd661 in fil_aio_wait(unsigned long) () #5 0x000055b6f590bdd8 in io_handler_thread () #6 0x00007f3c10b2ddd5 in start_thread () from /lib64/libpthread.so.0 #7 0x00007f3c0eed0ead in clone () from /lib64/libc.so.6   Thread 30 (Thread 0x7f377d57b700 (LWP 28058)): #0 0x00007f3c106fe644 in __io_getevents_0_4 () from /lib64/libaio.so.1 #1 0x000055b6f5876bca in LinuxAIOHandler::collect() () #2 0x000055b6f58771f2 in LinuxAIOHandler::poll(fil_node_t**, void**, IORequest*) () #3 0x000055b6f587ed79 in os_aio_handler(unsigned long, fil_node_t**, void**, IORequest*) () #4 0x000055b6f59fd661 in fil_aio_wait(unsigned long) () #5 0x000055b6f590bdd8 in io_handler_thread () #6 0x00007f3c10b2ddd5 in start_thread () from /lib64/libpthread.so.0 #7 0x00007f3c0eed0ead in clone () from /lib64/libc.so.6   Thread 29 (Thread 0x7f377cd7a700 (LWP 28059)): #0 0x00007f3c106fe644 in __io_getevents_0_4 () from /lib64/libaio.so.1 #1 0x000055b6f5876bca in LinuxAIOHandler::collect() () #2 0x000055b6f58771f2 in LinuxAIOHandler::poll(fil_node_t**, void**, IORequest*) () #3 0x000055b6f587ed79 in os_aio_handler(unsigned long, fil_node_t**, void**, IORequest*) () #4 0x000055b6f59fd661 in fil_aio_wait(unsigned long) () #5 0x000055b6f590bdd8 in io_handler_thread () #6 0x00007f3c10b2ddd5 in start_thread () from /lib64/libpthread.so.0 #7 0x00007f3c0eed0ead in clone () from /lib64/libc.so.6   Thread 28 (Thread 0x7f377c579700 (LWP 28060)): #0 0x00007f3c106fe644 in __io_getevents_0_4 () from /lib64/libaio.so.1 #1 0x000055b6f5876bca in LinuxAIOHandler::collect() () #2 0x000055b6f58771f2 in LinuxAIOHandler::poll(fil_node_t**, void**, IORequest*) () #3 0x000055b6f587ed79 in os_aio_handler(unsigned long, fil_node_t**, void**, IORequest*) () #4 0x000055b6f59fd661 in fil_aio_wait(unsigned long) () #5 0x000055b6f590bdd8 in io_handler_thread () #6 0x00007f3c10b2ddd5 in start_thread () from /lib64/libpthread.so.0 #7 0x00007f3c0eed0ead in clone () from /lib64/libc.so.6   Thread 27 (Thread 0x7f377bd78700 (LWP 28061)): #0 0x00007f3c106fe644 in __io_getevents_0_4 () from /lib64/libaio.so.1 #1 0x000055b6f5876bca in LinuxAIOHandler::collect() () #2 0x000055b6f58771f2 in LinuxAIOHandler::poll(fil_node_t**, void**, IORequest*) () #3 0x000055b6f587ed79 in os_aio_handler(unsigned long, fil_node_t**, void**, IORequest*) () #4 0x000055b6f59fd661 in fil_aio_wait(unsigned long) () #5 0x000055b6f590bdd8 in io_handler_thread () #6 0x00007f3c10b2ddd5 in start_thread () from /lib64/libpthread.so.0 #7 0x00007f3c0eed0ead in clone () from /lib64/libc.so.6   Thread 26 (Thread 0x7f377b577700 (LWP 28062)): #0 0x00007f3c106fe644 in __io_getevents_0_4 () from /lib64/libaio.so.1 #1 0x000055b6f5876bca in LinuxAIOHandler::collect() () #2 0x000055b6f58771f2 in LinuxAIOHandler::poll(fil_node_t**, void**, IORequest*) () #3 0x000055b6f587ed79 in os_aio_handler(unsigned long, fil_node_t**, void**, IORequest*) () #4 0x000055b6f59fd661 in fil_aio_wait(unsigned long) () #5 0x000055b6f590bdd8 in io_handler_thread () #6 0x00007f3c10b2ddd5 in start_thread () from /lib64/libpthread.so.0 #7 0x00007f3c0eed0ead in clone () from /lib64/libc.so.6   Thread 25 (Thread 0x7f377ad76700 (LWP 28063)): #0 0x00007f3c106fe644 in __io_getevents_0_4 () from /lib64/libaio.so.1 #1 0x000055b6f5876bca in LinuxAIOHandler::collect() () #2 0x000055b6f58771f2 in LinuxAIOHandler::poll(fil_node_t**, void**, IORequest*) () #3 0x000055b6f587ed79 in os_aio_handler(unsigned long, fil_node_t**, void**, IORequest*) () #4 0x000055b6f59fd661 in fil_aio_wait(unsigned long) () #5 0x000055b6f590bdd8 in io_handler_thread () #6 0x00007f3c10b2ddd5 in start_thread () from /lib64/libpthread.so.0 #7 0x00007f3c0eed0ead in clone () from /lib64/libc.so.6   Thread 24 (Thread 0x7f377a575700 (LWP 28064)): #0 0x00007f3c10b31d12 in pthread_cond_timedwait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x000055b6f587fda3 in os_event::timed_wait(timespec const*) () #2 0x000055b6f587ffb1 in os_event::wait_time_low(unsigned long, long) () #3 0x000055b6f59a698d in buf_flush_page_cleaner_coordinator () #4 0x00007f3c10b2ddd5 in start_thread () from /lib64/libpthread.so.0 #5 0x00007f3c0eed0ead in clone () from /lib64/libc.so.6   Thread 23 (Thread 0x7f3771573700 (LWP 28066)): #0 0x00007f3c10b31965 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x000055b6f58802b1 in os_event_wait_low(os_event*, long) () #2 0x000055b6f59a5713 in buf_flush_page_cleaner_worker () #3 0x00007f3c10b2ddd5 in start_thread () from /lib64/libpthread.so.0 #4 0x00007f3c0eed0ead in clone () from /lib64/libc.so.6   Thread 22 (Thread 0x7f3779573700 (LWP 28067)): #0 0x00007f3c10b31965 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x000055b6f58802b1 in os_event_wait_low(os_event*, long) () #2 0x000055b6f59a5713 in buf_flush_page_cleaner_worker () #3 0x00007f3c10b2ddd5 in start_thread () from /lib64/libpthread.so.0 #4 0x00007f3c0eed0ead in clone () from /lib64/libc.so.6   Thread 21 (Thread 0x7f3778d72700 (LWP 28068)): #0 0x00007f3c10b31965 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x000055b6f58802b1 in os_event_wait_low(os_event*, long) () #2 0x000055b6f59a5713 in buf_flush_page_cleaner_worker () #3 0x00007f3c10b2ddd5 in start_thread () from /lib64/libpthread.so.0 #4 0x00007f3c0eed0ead in clone () from /lib64/libc.so.6   Thread 20 (Thread 0x7f3793fff700 (LWP 28071)): #0 0x00007f3c10b31d12 in pthread_cond_timedwait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x000055b6f587fda3 in os_event::timed_wait(timespec const*) () #2 0x000055b6f587ffb1 in os_event::wait_time_low(unsigned long, long) () #3 0x000055b6f5855ccf in lock_wait_timeout_thread () #4 0x00007f3c10b2ddd5 in start_thread () from /lib64/libpthread.so.0 #5 0x00007f3c0eed0ead in clone () from /lib64/libc.so.6   Thread 19 (Thread 0x7f379896f700 (LWP 28072)): #0 0x00007f3c10b31d12 in pthread_cond_timedwait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x000055b6f587fda3 in os_event::timed_wait(timespec const*) () #2 0x000055b6f587ffb1 in os_event::wait_time_low(unsigned long, long) () #3 0x000055b6f5908d5c in srv_error_monitor_thread () #4 0x00007f3c10b2ddd5 in start_thread () from /lib64/libpthread.so.0 #5 0x00007f3c0eed0ead in clone () from /lib64/libc.so.6   Thread 18 (Thread 0x7f37937fe700 (LWP 28073)): #0 0x00007f3c10b31d12 in pthread_cond_timedwait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x000055b6f587fda3 in os_event::timed_wait(timespec const*) () #2 0x000055b6f587ffb1 in os_event::wait_time_low(unsigned long, long) () #3 0x000055b6f5908650 in srv_monitor_thread () #4 0x00007f3c10b2ddd5 in start_thread () from /lib64/libpthread.so.0 #5 0x00007f3c0eed0ead in clone () from /lib64/libc.so.6   Thread 17 (Thread 0x7f3792ffd700 (LWP 28074)): #0 0x00007f3c10b31d12 in pthread_cond_timedwait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x000055b6f587fda3 in os_event::timed_wait(timespec const*) () #2 0x000055b6f587ffb1 in os_event::wait_time_low(unsigned long, long) () #3 0x000055b6f59ece27 in dict_stats_thread () #4 0x00007f3c10b2ddd5 in start_thread () from /lib64/libpthread.so.0 #5 0x00007f3c0eed0ead in clone () from /lib64/libc.so.6   Thread 16 (Thread 0x7f37927fc700 (LWP 28075)): #0 0x00007f3c10b31d12 in pthread_cond_timedwait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x000055b6f587fda3 in os_event::timed_wait(timespec const*) () #2 0x000055b6f587ffb1 in os_event::wait_time_low(unsigned long, long) () #3 0x000055b6f5951d2e in ib_wqueue_timedwait(ib_wqueue_t*, unsigned long) () #4 0x000055b6f5a35c32 in fts_optimize_thread(void*) () #5 0x00007f3c10b2ddd5 in start_thread () from /lib64/libpthread.so.0 #6 0x00007f3c0eed0ead in clone () from /lib64/libc.so.6   Thread 15 (Thread 0x7f3791ffb700 (LWP 28076)): #0 0x00007f3c10b34e3d in nanosleep () from /lib64/libpthread.so.0 #1 0x000055b6f58804f0 in os_thread_sleep(unsigned long) () #2 0x000055b6f5909789 in srv_master_thread () #3 0x00007f3c10b2ddd5 in start_thread () from /lib64/libpthread.so.0 #4 0x00007f3c0eed0ead in clone () from /lib64/libc.so.6   Thread 14 (Thread 0x7f37917fa700 (LWP 28077)): #0 0x00007f3c10b31965 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x000055b6f58802b1 in os_event_wait_low(os_event*, long) () #2 0x000055b6f590ae1a in srv_purge_coordinator_thread () #3 0x00007f3c10b2ddd5 in start_thread () from /lib64/libpthread.so.0 #4 0x00007f3c0eed0ead in clone () from /lib64/libc.so.6   Thread 13 (Thread 0x7f3790ff9700 (LWP 28078)): #0 0x00007f3c10b31965 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x000055b6f58802b1 in os_event_wait_low(os_event*, long) () #2 0x000055b6f59045db in srv_resume_thread(srv_slot_t*, long, bool, unsigned long) [clone .constprop.71] () #3 0x000055b6f590a137 in srv_worker_thread () #4 0x00007f3c10b2ddd5 in start_thread () from /lib64/libpthread.so.0 #5 0x00007f3c0eed0ead in clone () from /lib64/libc.so.6   Thread 12 (Thread 0x7f378bfff700 (LWP 28079)): #0 0x00007f3c10b31965 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x000055b6f58802b1 in os_event_wait_low(os_event*, long) () #2 0x000055b6f59045db in srv_resume_thread(srv_slot_t*, long, bool, unsigned long) [clone .constprop.71] () #3 0x000055b6f590a137 in srv_worker_thread () #4 0x00007f3c10b2ddd5 in start_thread () from /lib64/libpthread.so.0 #5 0x00007f3c0eed0ead in clone () from /lib64/libc.so.6   Thread 11 (Thread 0x7f378b7fe700 (LWP 28080)): #0 0x00007f3c10b31965 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x000055b6f58802b1 in os_event_wait_low(os_event*, long) () #2 0x000055b6f59045db in srv_resume_thread(srv_slot_t*, long, bool, unsigned long) [clone .constprop.71] () #3 0x000055b6f590a137 in srv_worker_thread () #4 0x00007f3c10b2ddd5 in start_thread () from /lib64/libpthread.so.0 #5 0x00007f3c0eed0ead in clone () from /lib64/libc.so.6   Thread 10 (Thread 0x7f378affd700 (LWP 28081)): #0 0x00007f3c10b31965 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x000055b6f58802b1 in os_event_wait_low(os_event*, long) () #2 0x000055b6f59a0ef7 in buf_dump_thread () #3 0x00007f3c10b2ddd5 in start_thread () from /lib64/libpthread.so.0 #4 0x00007f3c0eed0ead in clone () from /lib64/libc.so.6   Thread 9 (Thread 0x7f378a7fc700 (LWP 28082)): #0 0x00007f3c10b34e3d in nanosleep () from /lib64/libpthread.so.0 #1 0x000055b6f58804f0 in os_thread_sleep(unsigned long) () #2 0x000055b6f598978a in btr_defragment_thread () #3 0x00007f3c10b2ddd5 in start_thread () from /lib64/libpthread.so.0 #4 0x00007f3c0eed0ead in clone () from /lib64/libc.so.6   Thread 8 (Thread 0x7f3789ffb700 (LWP 28083)): #0 0x00007f3c10b31965 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x000055b6f58802b1 in os_event_wait_low(os_event*, long) () #2 0x000055b6f5999112 in buf_resize_thread () #3 0x00007f3c10b2ddd5 in start_thread () from /lib64/libpthread.so.0 #4 0x00007f3c0eed0ead in clone () from /lib64/libc.so.6   Thread 7 (Thread 0x7f37897fa700 (LWP 28084)): #0 0x00007f3c10b31965 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x000055b6f57fc363 in thd_destructor_proxy () #2 0x00007f3c10b2ddd5 in start_thread () from /lib64/libpthread.so.0 #3 0x00007f3c0eed0ead in clone () from /lib64/libc.so.6   Thread 6 (Thread 0x7f3c10dae700 (LWP 28085)): #0 0x00007f3c10b31965 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x000055b6f574744f in binlog_background_thread () #2 0x00007f3c10b2ddd5 in start_thread () from /lib64/libpthread.so.0 #3 0x00007f3c0eed0ead in clone () from /lib64/libc.so.6   Thread 5 (Thread 0x7f3be823f700 (LWP 28090)): #0 0x00007f3c0ee0a40a in sigwaitinfo () from /lib64/libc.so.6 #1 0x000055b6f5380be3 in signal_hand () #2 0x00007f3c10b2ddd5 in start_thread () from /lib64/libpthread.so.0 #3 0x00007f3c0eed0ead in clone () from /lib64/libc.so.6   Thread 4 (Thread 0x7f3be81f4700 (LWP 28091)): #0 0x00007f3c10b31965 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x000055b6f539d9ab in handle_slave_background () #2 0x00007f3c10b2ddd5 in start_thread () from /lib64/libpthread.so.0 #3 0x00007f3c0eed0ead in clone () from /lib64/libc.so.6   Thread 3 (Thread 0x7f3be8113700 (LWP 25832)): #0 0x00007f3c0eec620d in poll () from /lib64/libc.so.6 #1 0x000055b6f5c2725e in vio_io_wait () #2 0x000055b6f5c27358 in vio_socket_io_wait () #3 0x000055b6f5c27d6a in vio_ssl_read () #4 0x000055b6f576e6db in my_real_read(st_net*, unsigned long*, char) () #5 0x000055b6f576f548 in my_net_read_packet_reallen () #6 0x000055b6f562f737 in cli_safe_read_reallen () #7 0x000055b6f53aa440 in handle_slave_io () #8 0x00007f3c10b2ddd5 in start_thread () from /lib64/libpthread.so.0 #9 0x00007f3c0eed0ead in clone () from /lib64/libc.so.6   Thread 2 (Thread 0x7f3be815e700 (LWP 25833)): #0 0x000055b6f5993180 in buf_page_optimistic_get(unsigned long, buf_block_t*, unsigned long, char const*, unsigned int, mtr_t*) () #1 0x000055b6f5969d35 in btr_cur_optimistic_latch_leaves(buf_block_t*, unsigned long, unsigned long*, btr_cur_t*, char const*, unsigned int, mtr_t*) () #2 0x000055b6f5979633 in btr_pcur_restore_position_func(unsigned long, btr_pcur_t*, char const*, unsigned int, mtr_t*) () #3 0x000055b6f534db38 in sel_restore_position_for_mysql(unsigned long*, unsigned long, btr_pcur_t*, unsigned long, mtr_t*) [clone .constprop.81] () #4 0x000055b6f58ed1a7 in row_search_mvcc(unsigned char*, page_cur_mode_t, row_prebuilt_t*, unsigned long, unsigned long) () #5 0x000055b6f580ad80 in ha_innobase::general_fetch(unsigned char*, unsigned int, unsigned int) () #6 0x000055b6f566088f in handler::ha_rnd_next(unsigned char*) () #7 0x000055b6f57655be in Rows_log_event::find_row(rpl_group_info*) () #8 0x000055b6f5765a54 in Update_rows_log_event::do_exec_row(rpl_group_info*) () #9 0x000055b6f5757cb5 in Rows_log_event::do_apply_event(rpl_group_info*) () #10 0x000055b6f539c560 in apply_event_and_update_pos_apply(Log_event*, THD*, rpl_group_info*, int) () #11 0x000055b6f53a6152 in handle_slave_sql () #12 0x00007f3c10b2ddd5 in start_thread () from /lib64/libpthread.so.0 #13 0x00007f3c0eed0ead in clone () from /lib64/libc.so.6   Thread 1 (Thread 0x7f3c10f4a8c0 (LWP 28050)): #0 0x00007f3c0eec620d in poll () from /lib64/libc.so.6 #1 0x000055b6f5389d9f in handle_connections_sockets() () #2 0x000055b6f538b024 in mysqld_main(int, char**) () #3 0x00007f3c0edf53d5 in __libc_start_main () from /lib64/libc.so.6 #4 0x000055b6f537e3f4 in _start () [Inferior 1 (process 28050) detached]

Alice Sherepa added a comment - 2020-12-01 11:14 Is it possible that that table was corrupted? Maybe you could send us a dump of this table (from the slave - or maybe from the backup of the slave) - then I will try to repeat the issue on my side

Tomas Kucera added a comment - 2020-12-02 10:47 Dear Alice, Thank you for the reaction and your time. Unfortunately the slave DB was re-imported by the export from master DB due to the replication repair. Before the occured issue and before the stopping of the DB replication the data was being inserted to the discussed table properly so I suppose that the tables was working ok. I did not create the backup of the slave database and I did not try to perform the mysqlcheck command. If the mysqlcheck command would be finished ok, I suppose that the table corruption reason can be excluded? There is planned the maintenance on the master environment soon so I will stop the slave DB for several hours again. I will inform if everything is ok after the replication re-start or if the issue is repeated. Did you see any issue in the provided information relating the DB slave state? Best regards Tomas

Tomas Kucera added a comment - 2020-12-04 09:42 Dear Alice, The small note. There was a maintenance yesterday and the DB replication was stopped for several hours and then started and everything is ok now and the DB replication works properly. It means that the issue was not reproduced by new stop and start of the replication. Best regards Tomas

Alice Sherepa added a comment - 2020-12-04 10:22 Dear Tomas, Excellent news! I tried to come up with theories of what might have been wrong and glad that replication works now. Also with rbr it is important to have PK/unique indexes on every table, otherwise, it could be very slow. Best regards, Alice

Tomas Kucera added a comment - 2020-12-10 13:31 Dear Alice, We will see if during the future structure changes of the DB tables on the master side, everthing will stay ok. The changes are planned after 3 months. Regarding the PK/unique indexes so the MariaDB service recommends in the log file to add the PK/unique indexes for two tables due to the performance improving. One of this table is the table where the replication process was stucked. I will inform here if the issue is appeared after the PK/unique indexes creation and after the scheduled master DB structure changes. Best regards Tomas