2019-04-23 16:09:44 47291578124032 [Warning] Aborted connection 17189 to db: 'mydb' user: 'APPDBA' host: '1.2.3.4' (The table 'modification' is full)
2019-04-23 16:09:44 47291578124032 [ERROR] WSREP: failed to initialize io-cache
2019-04-23 16:09:44 47291578124032 [Warning] WSREP: binlog trx cache not empty (0 bytes) @ connection close 17189
2019-04-23 16:09:44 47291578124032 [Warning] WSREP: binlog stmt cache not empty (0 bytes) @ connection close 17189

2019-04-24 13:33:24 47292002281216 [Warning]
Aborted connection 18175 to db: 'mydb' user: 'service_user_a' host: '1.2.3.4' (Got an error reading communication packets)

CREATE TABLE old_mod (
  id INT UNSIGNED NOT NULL AUTO_INCREMENT,
  username CHAR(30) NOT NULL,
  epochTime BIGINT NOT NULL,
  forecastId INT UNSIGNED NOT NULL,
  description CHAR(12) NOT NULL,
  auxText TEXT NULL,
  auxDate DATE NULL,
  CONSTRAINT pk_modification PRIMARY KEY (id),
  CONSTRAINT fk_modification_forecast_id FOREIGN KEY(forecastId)
    REFERENCES forecast(id)
) ENGINE=InnoDB
  DEFAULT CHARSET=utf8mb4
  COLLATE=utf8mb4_unicode_ci
  MAX_ROWS 12345678;

CREATE TABLE modification (
  id INT UNSIGNED NOT NULL AUTO_INCREMENT,
  username CHAR(30) NOT NULL,
  display_name VARCHAR(255) NULL,
  epoch_time BIGINT NOT NULL,
  forecast_id INT UNSIGNED NOT NULL,
  forecast_symbol VARCHAR(255) NOT NULL,
  group_id INT UNSIGNED NOT NULL,
  group_name CHAR(100) NOT NULL,
  description CHAR(12) NOT NULL,
  aux_text TEXT NULL,
  aux_date DATE NULL,
  CONSTRAINT pk_modification PRIMARY KEY (id),
  KEY ix_modification_query_by_user_and_forecast
    (username, forecast_id, description, aux_date, epoch_time),
  KEY ix_modification_last_save_query
    (forecast_id, description, aux_date),
  KEY ix_modification_forecast_symbol (forecast_symbol)
) ENGINE=InnoDB
  DEFAULT CHARSET=utf8mb4
  COLLATE=utf8mb4_unicode_ci
  MAX_ROWS 500123123;


-- add username to modification via userid
INSERT INTO modification (username, epoch_time, forecast_id, forecast_symbol,
                          group_id, group_name,
                          description, aux_text, aux_date)
    SELECT u.name, m.epochTime, m.forecastId, f.name, 1, 'Not recorded',
           m.description, m.auxText, m.auxDate
    FROM old_mod m
    LEFT JOIN `user` u ON u.id = m.userId
    LEFT JOIN forecast f ON f.id = m.forecastId;

Variable_name       Value
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     9.22337E+18
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        558
basedir     /rdsdbbin/mysql/
big_tables      OFF
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_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      /rdsdbbin/mariadb-10.2.12.R1/share/charsets/
check_constraint_checks     ON
collation_connection        latin1_swedish_ci
collation_database      latin1_swedish_ci
collation_server        latin1_swedish_ci
completion_type     NO_CHAIN
concurrent_insert       AUTO
connect_timeout     10
datadir     /rdsdbdata/db/
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_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
div_precision_increment     4
encrypt_binlog      OFF
encrypt_tmp_disk_tables     OFF
encrypt_tmp_files       OFF
enforce_storage_engine
event_scheduler     OFF
expensive_subquery_limit        100
expire_logs_days        0
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        /rdsdbdata/log/general/mysql-general.log
group_concat_max_len        1048576
gtid_binlog_pos     0-1853500884-31081711
gtid_binlog_state       0-1853500884-31081711
gtid_current_pos        0-1853500884-31081711
gtid_domain_id      0
gtid_ignore_duplicates      OFF
gtid_slave_pos
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      0
histogram_type      SINGLE_PREC_HB
host_cache_size     730
hostname        ip-172-20-2-15
ignore_builtin_innodb       OFF
ignore_db_dirs
init_connect
init_file
init_slave
innodb_adaptive_flushing        ON
innodb_adaptive_flushing_lwm        10
innodb_adaptive_hash_index      ON
innodb_adaptive_hash_index_partitions       8
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        8
innodb_buffer_pool_load_abort       OFF
innodb_buffer_pool_load_at_startup      ON
innodb_buffer_pool_load_now     OFF
innodb_buffer_pool_populate     OFF
innodb_buffer_pool_size     24696061952
innodb_change_buffer_max_size       25
innodb_change_buffering     all
innodb_checksum_algorithm       crc32
innodb_checksums        ON
innodb_cleaner_lsn_age_factor       DEPRECATED
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_corrupt_table_action     deprecated
innodb_data_file_path       ibdata1:12M:autoextend
innodb_data_home_dir        /rdsdbdata/db/innodb
innodb_deadlock_detect      ON
innodb_default_encryption_key_id        1
innodb_default_row_format       dynamic
innodb_defragment       OFF
innodb_defragment_fill_factor       0.9
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_empty_free_list_algorithm        DEPRECATED
innodb_encrypt_log      OFF
innodb_encrypt_tables       OFF
innodb_encryption_rotate_key_age        1
innodb_encryption_rotation_iops     100
innodb_encryption_threads       0
innodb_fake_changes     OFF
innodb_fast_shutdown        1
innodb_fatal_semaphore_wait_threshold       600
innodb_file_format      Barracuda
innodb_file_format_check        ON
innodb_file_format_max      Barracuda
innodb_file_per_table       ON
innodb_fill_factor      100
innodb_flush_log_at_timeout     1
innodb_flush_log_at_trx_commit      0
innodb_flush_method     O_DIRECT
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_foreground_preflush      DEPRECATED
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_instrument_semaphores        OFF
innodb_io_capacity      200
innodb_io_capacity_max      2000
innodb_kill_idle_transaction        0
innodb_large_prefix     ON
innodb_lock_schedule_algorithm      vats
innodb_lock_wait_timeout        50
innodb_locking_fake_changes     OFF
innodb_locks_unsafe_for_binlog      OFF
innodb_log_arch_dir
innodb_log_arch_expire_sec      0
innodb_log_archive      OFF
innodb_log_block_size       0
innodb_log_buffer_size      8388608
innodb_log_checksum_algorithm       DEPRECATED
innodb_log_checksums        ON
innodb_log_compressed_pages     ON
innodb_log_file_size        134217728
innodb_log_files_in_group       2
innodb_log_group_home_dir       /rdsdbdata/log/innodb
innodb_log_write_ahead_size     8192
innodb_lru_scan_depth       1024
innodb_max_bitmap_file_size     0
innodb_max_changed_pages        0
innodb_max_dirty_pages_pct      75
innodb_max_dirty_pages_pct_lwm      0
innodb_max_purge_lag        0
innodb_max_purge_lag_delay      0
innodb_max_undo_log_size        10485760
innodb_mirrored_log_groups      0
innodb_monitor_disable
innodb_monitor_enable
innodb_monitor_reset
innodb_monitor_reset_all
innodb_mtflush_threads      8
innodb_numa_interleave      OFF
innodb_old_blocks_pct       37
innodb_old_blocks_time      1000
innodb_online_alter_log_max_size        134217728
innodb_open_files       2000
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_sched_priority_cleaner       0
innodb_scrub_log        OFF
innodb_scrub_log_speed      256
innodb_show_locks_held      0
innodb_show_verbose_locks       0
innodb_sort_buffer_size     1048576
innodb_spin_wait_delay      6
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_support_xa       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_track_changed_pages      OFF
innodb_track_redo_log_now       OFF
innodb_undo_directory       ./
innodb_undo_log_truncate        OFF
innodb_undo_logs        128
innodb_undo_tablespaces     0
innodb_use_atomic_writes        ON
innodb_use_fallocate        OFF
innodb_use_global_flush_log_at_trx_commit       OFF
innodb_use_mtflush      OFF
innodb_use_native_aio       ON
innodb_use_stacktrace       OFF
innodb_use_trim     ON
innodb_version      5.7.20
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     16777216
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        /rdsdbdata/log/binlog/mysql-bin-changelog
log_bin_compress        OFF
log_bin_compress_min_len        256
log_bin_index       /rdsdbdata/log/binlog/mysql-bin-changelog.index
log_bin_trust_function_creators     ON
log_error       /rdsdbdata/log/error/mysql-error.log
log_output      TABLE
log_queries_not_using_indexes       OFF
log_slave_updates       ON
log_slow_admin_statements       ON
log_slow_filter     admin,filesort,filesort_on_disk,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
low_priority_updates        OFF
lower_case_file_system      OFF
lower_case_table_names      0
master_verify_checksum      OFF
max_allowed_packet      562036736