High CPU utilization and can't figure out why

New to this forum but wanted to run this by you guys and see if you see something I am missing. I have been charged with administering our Ecommerce site that utilizes MySQL on RDS as it’s backend. I am fairly new to MySQL and have been up and down the config file and can’t find any other config that may help. The issue is we have an average of 3-5 K users on the site that generates on average 500-700+ connection threads to the DB, at the peak times the CPU on the DB instance pushes 90+%. I think something is misconfigured that is causing the CPU spikes. The DB instance specs are below and attached are the configs on the MySQL instance. Any guidance would be appreciated, even if it’s ‘That’s normal’

Amazon RDS 4xLarge instance
16 vcpu
122 GB RAM
MySQL 5.6
75 GB DB

Many thanks in advance!!!

[TABLE=“border: 0, cellpadding: 0, cellspacing: 0, width: 600”]
[TR]
[TD]Variable_name[/TD]
[TD]Value[/TD]
[/TR]
[TR]
[TD]auto_increment_increment[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]auto_increment_offset[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]autocommit[/TD]
[TD]ON[/TD]
[/TR]
[TR]
[TD]automatic_sp_privileges[/TD]
[TD]ON[/TD]
[/TR]
[TR]
[TD]avoid_temporal_upgrade[/TD]
[TD]OFF[/TD]
[/TR]
[TR]
[TD]back_log[/TD]
[TD]900[/TD]
[/TR]
[TR]
[TD]basedir[/TD]
[TD]/rdsdbbin/mysql/[/TD]
[/TR]
[TR]
[TD]big_tables[/TD]
[TD]OFF[/TD]
[/TR]
[TR]
[TD]bind_address[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]binlog_cache_size[/TD]
[TD]32768[/TD]
[/TR]
[TR]
[TD]binlog_checksum[/TD]
[TD]CRC32[/TD]
[/TR]
[TR]
[TD]binlog_direct_non_transactional_updates[/TD]
[TD]OFF[/TD]
[/TR]
[TR]
[TD]binlog_error_action[/TD]
[TD]IGNORE_ERROR[/TD]
[/TR]
[TR]
[TD]binlog_format[/TD]
[TD]MIXED[/TD]
[/TR]
[TR]
[TD]binlog_gtid_simple_recovery[/TD]
[TD]OFF[/TD]
[/TR]
[TR]
[TD]binlog_max_flush_queue_time[/TD]
[TD]0[/TD]
[/TR]
[TR]
[TD]binlog_order_commits[/TD]
[TD]ON[/TD]
[/TR]
[TR]
[TD]binlog_row_image[/TD]
[TD]FULL[/TD]
[/TR]
[TR]
[TD]binlog_rows_query_log_events[/TD]
[TD]OFF[/TD]
[/TR]
[TR]
[TD]binlog_stmt_cache_size[/TD]
[TD]32768[/TD]
[/TR]
[TR]
[TD]binlogging_impossible_mode[/TD]
[TD]IGNORE_ERROR[/TD]
[/TR]
[TR]
[TD]block_encryption_mode[/TD]
[TD]aes-128-ecb[/TD]
[/TR]
[TR]
[TD]bulk_insert_buffer_size[/TD]
[TD]8388608[/TD]
[/TR]
[TR]
[TD]character_set_client[/TD]
[TD]utf8[/TD]
[/TR]
[TR]
[TD]character_set_connection[/TD]
[TD]utf8[/TD]
[/TR]
[TR]
[TD]character_set_database[/TD]
[TD]utf8[/TD]
[/TR]
[TR]
[TD]character_set_filesystem[/TD]
[TD]binary[/TD]
[/TR]
[TR]
[TD]character_set_results[/TD]
[TD]utf8[/TD]
[/TR]
[TR]
[TD]character_set_server[/TD]
[TD]utf8[/TD]
[/TR]
[TR]
[TD]character_set_system[/TD]
[TD]utf8[/TD]
[/TR]
[TR]
[TD]character_sets_dir[/TD]
[TD]/rdsdbbin/mysql-5.6.29.R1/share/charsets/[/TD]
[/TR]
[TR]
[TD]collation_connection[/TD]
[TD]utf8_general_ci[/TD]
[/TR]
[TR]
[TD]collation_database[/TD]
[TD]utf8_general_ci[/TD]
[/TR]
[TR]
[TD]collation_server[/TD]
[TD]utf8_general_ci[/TD]
[/TR]
[TR]
[TD]completion_type[/TD]
[TD]NO_CHAIN[/TD]
[/TR]
[TR]
[TD]concurrent_insert[/TD]
[TD]AUTO[/TD]
[/TR]
[TR]
[TD]connect_timeout[/TD]
[TD]10[/TD]
[/TR]
[TR]
[TD]core_file[/TD]
[TD]OFF[/TD]
[/TR]
[TR]
[TD]datadir[/TD]
[TD]/rdsdbdata/db/[/TD]
[/TR]
[TR]
[TD]date_format[/TD]
[TD]%Y-%m-%d[/TD]
[/TR]
[TR]
[TD]datetime_format[/TD]
[TD]%Y-%m-%d %H:%i:%s[/TD]
[/TR]
[TR]
[TD]default_storage_engine[/TD]
[TD]InnoDB[/TD]
[/TR]
[TR]
[TD]default_tmp_storage_engine[/TD]
[TD]InnoDB[/TD]
[/TR]
[TR]
[TD]default_week_format[/TD]
[TD]0[/TD]
[/TR]
[TR]
[TD]delay_key_write[/TD]
[TD]ON[/TD]
[/TR]
[TR]
[TD]delayed_insert_limit[/TD]
[TD]100[/TD]
[/TR]
[TR]
[TD]delayed_insert_timeout[/TD]
[TD]300[/TD]
[/TR]
[TR]
[TD]delayed_queue_size[/TD]
[TD]1000[/TD]
[/TR]
[TR]
[TD]disconnect_on_expired_password[/TD]
[TD]ON[/TD]
[/TR]
[TR]
[TD]div_precision_increment[/TD]
[TD]4[/TD]
[/TR]
[TR]
[TD]end_markers_in_json[/TD]
[TD]OFF[/TD]
[/TR]
[TR]
[TD]enforce_gtid_consistency[/TD]
[TD]OFF[/TD]
[/TR]
[TR]
[TD]eq_range_index_dive_limit[/TD]
[TD]10[/TD]
[/TR]
[TR]
[TD]error_count[/TD]
[TD]0[/TD]
[/TR]
[TR]
[TD]event_scheduler[/TD]
[TD]ON[/TD]
[/TR]
[TR]
[TD]expire_logs_days[/TD]
[TD]0[/TD]
[/TR]
[TR]
[TD]explicit_defaults_for_timestamp[/TD]
[TD]ON[/TD]
[/TR]
[TR]
[TD]external_user[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]flush[/TD]
[TD]OFF[/TD]
[/TR]
[TR]
[TD]flush_time[/TD]
[TD]0[/TD]
[/TR]
[TR]
[TD]foreign_key_checks[/TD]
[TD]ON[/TD]
[/TR]
[TR]
[TD]ft_boolean_syntax[/TD]
[TD]+ -><()~
:""&|[/TD]
[/TR]
[TR]
[TD]ft_max_word_len[/TD]
[TD]84[/TD]
[/TR]
[TR]
[TD]ft_min_word_len[/TD]
[TD]4[/TD]
[/TR]
[TR]
[TD]ft_query_expansion_limit[/TD]
[TD]20[/TD]
[/TR]
[TR]
[TD]ft_stopword_file[/TD]
TD[/TD]
[/TR]
[TR]
[TD]general_log[/TD]
[TD]OFF[/TD]
[/TR]
[TR]
[TD]general_log_file[/TD]
[TD]/rdsdbdata/log/general/mysql-general.log[/TD]
[/TR]
[TR]
[TD]group_concat_max_len[/TD]
[TD]1024[/TD]
[/TR]
[TR]
[TD]gtid_executed[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]gtid_mode[/TD]
[TD]OFF[/TD]
[/TR]
[TR]
[TD]gtid_next[/TD]
[TD]AUTOMATIC[/TD]
[/TR]
[TR]
[TD]gtid_owned[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]gtid_purged[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]have_compress[/TD]
[TD]YES[/TD]
[/TR]
[TR]
[TD]have_crypt[/TD]
[TD]YES[/TD]
[/TR]
[TR]
[TD]have_dynamic_loading[/TD]
[TD]YES[/TD]
[/TR]
[TR]
[TD]have_geometry[/TD]
[TD]YES[/TD]
[/TR]
[TR]
[TD]have_openssl[/TD]
[TD]YES[/TD]
[/TR]
[TR]
[TD]have_profiling[/TD]
[TD]YES[/TD]
[/TR]
[TR]
[TD]have_query_cache[/TD]
[TD]YES[/TD]
[/TR]
[TR]
[TD]have_rtree_keys[/TD]
[TD]YES[/TD]
[/TR]
[TR]
[TD]have_ssl[/TD]
[TD]YES[/TD]
[/TR]
[TR]
[TD]have_symlink[/TD]
[TD]YES[/TD]
[/TR]
[TR]
[TD]host_cache_size[/TD]
[TD]1114[/TD]
[/TR]
[TR]
[TD]hostname[/TD]
[TD]ip-10-3-1-143[/TD]
[/TR]
[TR]
[TD]identity[/TD]
[TD]0[/TD]
[/TR]
[TR]
[TD]ignore_builtin_innodb[/TD]
[TD]OFF[/TD]
[/TR]
[TR]
[TD]ignore_db_dirs[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]init_connect[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]init_file[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]init_slave[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]innodb_adaptive_flushing[/TD]
[TD]ON[/TD]
[/TR]
[TR]
[TD]innodb_adaptive_flushing_lwm[/TD]
[TD]10[/TD]
[/TR]
[TR]
[TD]innodb_adaptive_hash_index[/TD]
[TD]ON[/TD]
[/TR]
[TR]
[TD]innodb_adaptive_max_sleep_delay[/TD]
[TD]150000[/TD]
[/TR]
[TR]
[TD]innodb_additional_mem_pool_size[/TD]
[TD]8388608[/TD]
[/TR]
[TR]
[TD]innodb_api_bk_commit_interval[/TD]
[TD]5[/TD]
[/TR]
[TR]
[TD]innodb_api_disable_rowlock[/TD]
[TD]OFF[/TD]
[/TR]
[TR]
[TD]innodb_api_enable_binlog[/TD]
[TD]OFF[/TD]
[/TR]
[TR]
[TD]innodb_api_enable_mdl[/TD]
[TD]OFF[/TD]
[/TR]
[TR]
[TD]innodb_api_trx_level[/TD]
[TD]0[/TD]
[/TR]
[TR]
[TD]innodb_autoextend_increment[/TD]
[TD]64[/TD]
[/TR]
[TR]
[TD]innodb_autoinc_lock_mode[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]innodb_buffer_pool_dump_at_shutdown[/TD]
[TD]OFF[/TD]
[/TR]
[TR]
[TD]innodb_buffer_pool_dump_now[/TD]
[TD]OFF[/TD]
[/TR]
[TR]
[TD]innodb_buffer_pool_filename[/TD]
[TD]ib_buffer_pool[/TD]
[/TR]
[TR]
[TD]innodb_buffer_pool_instances[/TD]
[TD]5[/TD]
[/TR]
[TR]
[TD]innodb_buffer_pool_load_abort[/TD]
[TD]OFF[/TD]
[/TR]
[TR]
[TD]innodb_buffer_pool_load_at_startup[/TD]
[TD]OFF[/TD]
[/TR]
[TR]
[TD]innodb_buffer_pool_load_now[/TD]
[TD]OFF[/TD]
[/TR]
[TR]
[TD]innodb_buffer_pool_size[/TD]
[TD]96545538048[/TD]
[/TR]
[TR]
[TD]innodb_change_buffer_max_size[/TD]
[TD]25[/TD]
[/TR]
[TR]
[TD]innodb_change_buffering[/TD]
[TD]all[/TD]
[/TR]
[TR]
[TD]innodb_checksum_algorithm[/TD]
[TD]innodb[/TD]
[/TR]
[TR]
[TD]innodb_checksums[/TD]
[TD]ON[/TD]
[/TR]
[TR]
[TD]innodb_cmp_per_index_enabled[/TD]
[TD]OFF[/TD]
[/TR]
[TR]
[TD]innodb_commit_concurrency[/TD]
[TD]0[/TD]
[/TR]
[TR]
[TD]innodb_compression_failure_threshold_pct[/TD]
[TD]5[/TD]
[/TR]
[TR]
[TD]innodb_compression_level[/TD]
[TD]6[/TD]
[/TR]
[TR]
[TD]innodb_compression_pad_pct_max[/TD]
[TD]50[/TD]
[/TR]
[TR]
[TD]innodb_concurrency_tickets[/TD]
[TD]5000[/TD]
[/TR]
[TR]
[TD]innodb_data_file_path[/TD]
[TD]ibdata1:12M:autoextend[/TD]
[/TR]
[TR]
[TD]innodb_data_home_dir[/TD]
[TD]/rdsdbdata/db/innodb[/TD]
[/TR]
[TR]
[TD]innodb_disable_sort_file_cache[/TD]
[TD]OFF[/TD]
[/TR]
[TR]
[TD]innodb_doublewrite[/TD]
[TD]ON[/TD]
[/TR]
[TR]
[TD]innodb_fast_shutdown[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]innodb_file_format[/TD]
[TD]Antelope[/TD]
[/TR]
[TR]
[TD]innodb_file_format_check[/TD]
[TD]ON[/TD]
[/TR]
[TR]
[TD]innodb_file_format_max[/TD]
[TD]Antelope[/TD]
[/TR]
[TR]
[TD]innodb_file_per_table[/TD]
[TD]ON[/TD]
[/TR]
[TR]
[TD]innodb_flush_log_at_timeout[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]innodb_flush_log_at_trx_commit[/TD]
[TD]0[/TD]
[/TR]
[TR]
[TD]innodb_flush_method[/TD]
[TD]O_DIRECT[/TD]
[/TR]
[TR]
[TD]innodb_flush_neighbors[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]innodb_flushing_avg_loops[/TD]
[TD]30[/TD]
[/TR]
[TR]
[TD]innodb_force_load_corrupted[/TD]
[TD]OFF[/TD]
[/TR]
[TR]
[TD]innodb_force_recovery[/TD]
[TD]0[/TD]
[/TR]
[TR]
[TD]innodb_ft_aux_table[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]innodb_ft_cache_size[/TD]
[TD]8000000[/TD]
[/TR]
[TR]
[TD]innodb_ft_enable_diag_print[/TD]
[TD]OFF[/TD]
[/TR]
[TR]
[TD]innodb_ft_enable_stopword[/TD]
[TD]ON[/TD]
[/TR]
[TR]
[TD]innodb_ft_max_token_size[/TD]
[TD]84[/TD]
[/TR]
[TR]
[TD]innodb_ft_min_token_size[/TD]
[TD]3[/TD]
[/TR]
[TR]
[TD]innodb_ft_num_word_optimize[/TD]
[TD]2000[/TD]
[/TR]
[TR]
[TD]innodb_ft_result_cache_limit[/TD]
[TD]2000000000[/TD]
[/TR]
[TR]
[TD]innodb_ft_server_stopword_table[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]innodb_ft_sort_pll_degree[/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD]innodb_ft_total_cache_size[/TD]
[TD]640000000[/TD]
[/TR]
[TR]
[TD]innodb_ft_user_stopword_table[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]innodb_io_capacity[/TD]
[TD]2000[/TD]
[/TR]
[TR]
[TD]innodb_io_capacity_max[/TD]
[TD]4000[/TD]
[/TR]
[TR]
[TD]innodb_large_prefix[/TD]
[TD]OFF[/TD]
[/TR]
[TR]
[TD]innodb_lock_wait_timeout[/TD]
[TD]50[/TD]
[/TR]
[TR]
[TD]innodb_locks_unsafe_for_binlog[/TD]
[TD]OFF[/TD]
[/TR]
[TR]
[TD]innodb_log_buffer_size[/TD]
[TD]8388608[/TD]
[/TR]
[TR]
[TD]innodb_log_compressed_pages[/TD]
[TD]ON[/TD]
[/TR]
[TR]
[TD]innodb_log_file_size[/TD]
[TD]134217728[/TD]
[/TR]
[TR]
[TD]innodb_log_files_in_group[/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD]innodb_log_group_home_dir[/TD]
[TD]/rdsdbdata/log/innodb[/TD]
[/TR]
[TR]
[TD]innodb_lru_scan_depth[/TD]
[TD]1024[/TD]
[/TR]
[TR]
[TD]innodb_max_dirty_pages_pct[/TD]
[TD]75[/TD]
[/TR]
[TR]
[TD]innodb_max_dirty_pages_pct_lwm[/TD]
[TD]0[/TD]
[/TR]
[TR]
[TD]innodb_max_purge_lag[/TD]
[TD]0[/TD]
[/TR]
[TR]
[TD]innodb_max_purge_lag_delay[/TD]
[TD]0[/TD]
[/TR]
[TR]
[TD]innodb_mirrored_log_groups[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]innodb_monitor_disable[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]innodb_monitor_enable[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]innodb_monitor_reset[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]innodb_monitor_reset_all[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]innodb_old_blocks_pct[/TD]
[TD]37[/TD]
[/TR]
[TR]
[TD]innodb_old_blocks_time[/TD]
[TD]1000[/TD]
[/TR]
[TR]
[TD]innodb_online_alter_log_max_size[/TD]
[TD]134217728[/TD]
[/TR]
[TR]
[TD]innodb_open_files[/TD]
[TD]27647[/TD]
[/TR]
[TR]
[TD]innodb_optimize_fulltext_only[/TD]
[TD]OFF[/TD]
[/TR]
[TR]
[TD]innodb_page_size[/TD]
[TD]16384[/TD]
[/TR]
[TR]
[TD]innodb_print_all_deadlocks[/TD]
[TD]OFF[/TD]
[/TR]
[TR]
[TD]innodb_purge_batch_size[/TD]
[TD]300[/TD]
[/TR]
[TR]
[TD]innodb_purge_threads[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]innodb_random_read_ahead[/TD]
[TD]OFF[/TD]
[/TR]
[TR]
[TD]innodb_read_ahead_threshold[/TD]
[TD]56[/TD]
[/TR]
[TR]
[TD]innodb_read_io_threads[/TD]
[TD]64[/TD]
[/TR]
[TR]
[TD]innodb_read_only[/TD]
[TD]OFF[/TD]
[/TR]
[TR]
[TD]innodb_replication_delay[/TD]
[TD]0[/TD]
[/TR]
[TR]
[TD]innodb_rollback_on_timeout[/TD]
[TD]OFF[/TD]
[/TR]
[TR]
[TD]innodb_rollback_segments[/TD]
[TD]128[/TD]
[/TR]
[TR]
[TD]innodb_sort_buffer_size[/TD]
[TD]1048576[/TD]
[/TR]
[TR]
[TD]innodb_spin_wait_delay[/TD]
[TD]6[/TD]
[/TR]
[TR]
[TD]innodb_stats_auto_recalc[/TD]
[TD]ON[/TD]
[/TR]
[TR]
[TD]innodb_stats_method[/TD]
[TD]nulls_equal[/TD]
[/TR]
[TR]
[TD]innodb_stats_on_metadata[/TD]
[TD]OFF[/TD]
[/TR]
[TR]
[TD]innodb_stats_persistent[/TD]
[TD]ON[/TD]
[/TR]
[TR]
[TD]innodb_stats_persistent_sample_pages[/TD]
[TD]20[/TD]
[/TR]
[TR]
[TD]innodb_stats_sample_pages[/TD]
[TD]8[/TD]
[/TR]
[TR]
[TD]innodb_stats_transient_sample_pages[/TD]
[TD]8[/TD]
[/TR]
[TR]
[TD]innodb_status_output[/TD]
[TD]OFF[/TD]
[/TR]
[TR]
[TD]innodb_status_output_locks[/TD]
[TD]OFF[/TD]
[/TR]
[TR]
[TD]innodb_strict_mode[/TD]
[TD]OFF[/TD]
[/TR]
[TR]
[TD]innodb_support_xa[/TD]
[TD]ON[/TD]
[/TR]
[TR]
[TD]innodb_sync_array_size[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]innodb_sync_spin_loops[/TD]
[TD]30[/TD]
[/TR]
[TR]
[TD]innodb_table_locks[/TD]
[TD]ON[/TD]
[/TR]
[TR]
[TD]innodb_thread_concurrency[/TD]
[TD]0[/TD]
[/TR]
[TR]
[TD]innodb_thread_sleep_delay[/TD]
[TD]10000[/TD]
[/TR]
[TR]
[TD]innodb_tmpdir[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]innodb_undo_directory[/TD]
[TD].[/TD]
[/TR]
[TR]
[TD]innodb_undo_logs[/TD]
[TD]128[/TD]
[/TR]
[TR]
[TD]innodb_undo_tablespaces[/TD]
[TD]0[/TD]
[/TR]
[TR]
[TD]innodb_use_native_aio[/TD]
[TD]ON[/TD]
[/TR]
[TR]
[TD]innodb_use_sys_malloc[/TD]
[TD]ON[/TD]
[/TR]
[TR]
[TD]innodb_version[/TD]
[TD]5.6.29[/TD]
[/TR]
[TR]
[TD]innodb_write_io_threads[/TD]
[TD]64[/TD]
[/TR]
[TR]
[TD]insert_id[/TD]
[TD]0[/TD]
[/TR]
[TR]
[TD]interactive_timeout[/TD]
[TD]28800[/TD]
[/TR]
[TR]
[TD]join_buffer_size[/TD]
[TD]1048576[/TD]
[/TR]
[TR]
[TD]keep_files_on_create[/TD]
[TD]OFF[/TD]
[/TR]
[TR]
[TD]key_buffer_size[/TD]
[TD]3350528[/TD]
[/TR]
[TR]
[TD]key_cache_age_threshold[/TD]
[TD]300[/TD]
[/TR]
[TR]
[TD]key_cache_block_size[/TD]
[TD]1024[/TD]
[/TR]
[TR]
[TD]key_cache_division_limit[/TD]
[TD]100[/TD]
[/TR]
[TR]
[TD]large_files_support[/TD]
[TD]ON[/TD]
[/TR]
[TR]
[TD]large_page_size[/TD]
[TD]0[/TD]
[/TR]
[TR]
[TD]large_pages[/TD]
[TD]OFF[/TD]
[/TR]
[TR]
[TD]last_insert_id[/TD]
[TD]0[/TD]
[/TR]
[TR]
[TD]lc_messages[/TD]
[TD]en_US[/TD]
[/TR]
[TR]
[TD]lc_messages_dir[/TD]
[TD]/rdsdbbin/mysql-5.6.29.R1/share/[/TD]
[/TR]
[TR]
[TD]lc_time_names[/TD]
[TD]en_US[/TD]
[/TR]
[TR]
[TD]license[/TD]
[TD]GPL[/TD]
[/TR]
[TR]
[TD]local_infile[/TD]
[TD]ON[/TD]
[/TR]
[TR]
[TD]lock_wait_timeout[/TD]
[TD]31536000[/TD]
[/TR]
[TR]
[TD]locked_in_memory[/TD]
[TD]OFF[/TD]
[/TR]
[TR]
[TD]log_bin[/TD]
[TD]ON[/TD]
[/TR]
[TR]
[TD]log_bin_basename[/TD]
[TD]/rdsdbdata/log/binlog/mysql-bin-changelog[/TD]
[/TR]
[TR]
[TD]log_bin_index[/TD]
[TD]/rdsdbdata/log/binlog/mysql-bin-changelog.index[/TD]
[/TR]
[TR]
[TD]log_bin_trust_function_creators[/TD]
[TD]OFF[/TD]
[/TR]
[TR]
[TD]log_bin_use_v1_row_events[/TD]
[TD]OFF[/TD]
[/TR]
[TR]
[TD]log_error[/TD]
[TD]/rdsdbdata/log/error/mysql-error.log[/TD]
[/TR]
[TR]
[TD]log_output[/TD]
[TD]TABLE[/TD]
[/TR]
[TR]
[TD]log_queries_not_using_indexes[/TD]
[TD]OFF[/TD]
[/TR]
[TR]
[TD]log_slave_updates[/TD]
[TD]ON[/TD]
[/TR]
[TR]
[TD]log_slow_admin_statements[/TD]
[TD]OFF[/TD]
[/TR]
[TR]
[TD]log_slow_slave_statements[/TD]
[TD]OFF[/TD]
[/TR]
[TR]
[TD]log_throttle_queries_not_using_indexes[/TD]
[TD]0[/TD]
[/TR]
[TR]
[TD]log_warnings[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]long_query_time[/TD]
[TD]10[/TD]
[/TR]
[TR]
[TD]low_priority_updates[/TD]
[TD]OFF[/TD]
[/TR]
[TR]
[TD]lower_case_file_system[/TD]
[TD]OFF[/TD]
[/TR]
[TR]
[TD]lower_case_table_names[/TD]
[TD]0[/TD]
[/TR]
[TR]
[TD]master_info_repository[/TD]
[TD]TABLE[/TD]
[/TR]
[TR]
[TD]master_verify_checksum[/TD]
[TD]OFF[/TD]
[/TR]
[TR]
[TD]max_allowed_packet[/TD]
[TD]16777216[/TD]
[/TR]
[TR]
[TD]max_binlog_cache_size[/TD]
[TD]18446700000000000000[/TD]
[/TR]
[TR]
[TD]max_binlog_size[/TD]
[TD]134217728[/TD]
[/TR]
[TR]
[TD]max_binlog_stmt_cache_size[/TD]
[TD]18446700000000000000[/TD]
[/TR]
[TR]
[TD]max_connect_errors[/TD]
[TD]1000000[/TD]
[/TR]
[TR]
[TD]max_connections[/TD]
[TD]10230[/TD]
[/TR]
[TR]
[TD]max_delayed_threads[/TD]
[TD]20[/TD]
[/TR]
[TR]
[TD]max_digest_length[/TD]
[TD]1024[/TD]
[/TR]
[TR]
[TD]max_error_count[/TD]
[TD]64[/TD]
[/TR]
[TR]
[TD]max_heap_table_size[/TD]
[TD]3353600[/TD]
[/TR]
[TR]
[TD]max_insert_delayed_threads[/TD]
[TD]20[/TD]
[/TR]
[TR]
[TD]max_join_size[/TD]
[TD]18446700000000000000[/TD]
[/TR]
[TR]
[TD]max_length_for_sort_data[/TD]
[TD]1024[/TD]
[/TR]
[TR]
[TD]max_prepared_stmt_count[/TD]
[TD]16382[/TD]
[/TR]
[TR]
[TD]max_relay_log_size[/TD]
[TD]0[/TD]
[/TR]
[TR]
[TD]max_seeks_for_key[/TD]
[TD]18446700000000000000[/TD]
[/TR]
[TR]
[TD]max_sort_length[/TD]
[TD]1024[/TD]
[/TR]
[TR]
[TD]max_sp_recursion_depth[/TD]
[TD]0[/TD]
[/TR]
[TR]
[TD]max_tmp_tables[/TD]
[TD]32[/TD]
[/TR]
[TR]
[TD]max_user_connections[/TD]
[TD]0[/TD]
[/TR]
[TR]
[TD]max_write_lock_count[/TD]
[TD]18446700000000000000[/TD]
[/TR]
[TR]
[TD]metadata_locks_cache_size[/TD]
[TD]1024[/TD]
[/TR]
[TR]
[TD]metadata_locks_hash_instances[/TD]
[TD]8[/TD]
[/TR]
[TR]
[TD]min_examined_row_limit[/TD]
[TD]0[/TD]
[/TR]
[TR]
[TD]multi_range_count[/TD]
[TD]256[/TD]
[/TR]
[TR]
[TD]myisam_data_pointer_size[/TD]
[TD]6[/TD]
[/TR]
[TR]
[TD]myisam_max_sort_file_size[/TD]
[TD]9223370000000000000[/TD]
[/TR]
[TR]
[TD]myisam_mmap_size[/TD]
[TD]18446700000000000000[/TD]
[/TR]
[TR]
[TD]myisam_recover_options[/TD]
[TD]OFF[/TD]
[/TR]
[TR]
[TD]myisam_repair_threads[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]myisam_sort_buffer_size[/TD]
[TD]8388608[/TD]
[/TR]
[TR]
[TD]myisam_stats_method[/TD]
[TD]nulls_unequal[/TD]
[/TR]
[TR]
[TD]myisam_use_mmap[/TD]
[TD]OFF[/TD]
[/TR]
[TR]
[TD]net_buffer_length[/TD]
[TD]16384[/TD]
[/TR]
[TR]
[TD]net_read_timeout[/TD]
[TD]30[/TD]
[/TR]
[TR]
[TD]net_retry_count[/TD]
[TD]10[/TD]
[/TR]
[TR]
[TD]net_write_timeout[/TD]
[TD]60[/TD]
[/TR]
[TR]
[TD]new[/TD]
[TD]OFF[/TD]
[/TR]
[TR]
[TD]old[/TD]
[TD]OFF[/TD]
[/TR]
[TR]
[TD]old_alter_table[/TD]
[TD]OFF[/TD]
[/TR]
[TR]
[TD]old_passwords[/TD]
[TD]0[/TD]
[/TR]
[TR]
[TD]open_files_limit[/TD]
[TD]65535[/TD]
[/TR]
[TR]
[TD]optimizer_prune_level[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]optimizer_search_depth[/TD]
[TD]62[/TD]
[/TR]
[TR]
[TD]optimizer_switch[/TD]
[TD]index_merge=on,index_merge_union=on,index_merge_sort_union=on,index_merge_intersection=on,engine_condition_pushdown=on,index_condition_pushdown=on,mrr=on,mrr_cost_based=on,block_nested_loop=on,batched_key_access=off,materialization=on,semijoin=on,loosescan=on,firstmatch=on,subquery_materialization_cost_based=on,use_index_extensions=on[/TD]
[/TR]
[TR]
[TD]optimizer_trace[/TD]
[TD]enabled=off,one_line=off[/TD]
[/TR]
[TR]
[TD]optimizer_trace_features[/TD]
[TD]greedy_search=on,range_optimizer=on,dynamic_range=on,repeated_subselect=on[/TD]
[/TR]
[TR]
[TD]optimizer_trace_limit[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]optimizer_trace_max_mem_size[/TD]
[TD]16384[/TD]
[/TR]
[TR]
[TD]optimizer_trace_offset[/TD]
[TD]-1[/TD]
[/TR]
[TR]
[TD]performance_schema[/TD]
[TD]OFF[/TD]
[/TR]
[TR]
[TD]performance_schema_accounts_size[/TD]
[TD]-1[/TD]
[/TR]
[TR]
[TD]performance_schema_digests_size[/TD]
[TD]-1[/TD]
[/TR]
[TR]
[TD]performance_schema_events_stages_history_long_size[/TD]
[TD]-1[/TD]
[/TR]
[TR]
[TD]performance_schema_events_stages_history_size[/TD]
[TD]-1[/TD]
[/TR]
[TR]
[TD]performance_schema_events_statements_history_long_size[/TD]
[TD]-1[/TD]
[/TR]
[TR]
[TD]performance_schema_events_statements_history_size[/TD]
[TD]-1[/TD]
[/TR]
[TR]
[TD]performance_schema_events_waits_history_long_size[/TD]
[TD]-1[/TD]
[/TR]
[TR]
[TD]performance_schema_events_waits_history_size[/TD]
[TD]-1[/TD]
[/TR]
[TR]
[TD]performance_schema_hosts_size[/TD]
[TD]-1[/TD]
[/TR]
[TR]
[TD]performance_schema_max_cond_classes[/TD]
[TD]80[/TD]
[/TR]
[TR]
[TD]performance_schema_max_cond_instances[/TD]
[TD]-1[/TD]
[/TR]
[TR]
[TD]performance_schema_max_digest_length[/TD]
[TD]1024[/TD]
[/TR]
[TR]
[TD]performance_schema_max_file_classes[/TD]
[TD]50[/TD]
[/TR]
[TR]
[TD]performance_schema_max_file_handles[/TD]
[TD]32768[/TD]
[/TR]
[TR]
[TD]performance_schema_max_file_instances[/TD]
[TD]-1[/TD]
[/TR]
[TR]
[TD]performance_schema_max_mutex_classes[/TD]
[TD]200[/TD]
[/TR]
[TR]
[TD]performance_schema_max_mutex_instances[/TD]
[TD]-1[/TD]
[/TR]
[TR]
[TD]performance_schema_max_rwlock_classes[/TD]
[TD]40[/TD]
[/TR]
[TR]
[TD]performance_schema_max_rwlock_instances[/TD]
[TD]-1[/TD]
[/TR]
[TR]
[TD]performance_schema_max_socket_classes[/TD]
[TD]10[/TD]
[/TR]
[TR]
[TD]performance_schema_max_socket_instances[/TD]
[TD]-1[/TD]
[/TR]
[TR]
[TD]performance_schema_max_stage_classes[/TD]
[TD]150[/TD]
[/TR]
[TR]
[TD]performance_schema_max_statement_classes[/TD]
[TD]168[/TD]
[/TR]
[TR]
[TD]performance_schema_max_table_handles[/TD]
[TD]-1[/TD]
[/TR]
[TR]
[TD]performance_schema_max_table_instances[/TD]
[TD]-1[/TD]
[/TR]
[TR]
[TD]performance_schema_max_thread_classes[/TD]
[TD]50[/TD]
[/TR]
[TR]
[TD]performance_schema_max_thread_instances[/TD]
[TD]-1[/TD]
[/TR]
[TR]
[TD]performance_schema_session_connect_attrs_size[/TD]
[TD]-1[/TD]
[/TR]
[TR]
[TD]performance_schema_setup_actors_size[/TD]
[TD]100[/TD]
[/TR]
[TR]
[TD]performance_schema_setup_objects_size[/TD]
[TD]100[/TD]
[/TR]
[TR]
[TD]performance_schema_users_size[/TD]
[TD]-1[/TD]
[/TR]
[TR]
[TD]pid_file[/TD]
[TD]/rdsdbdata/log/mysql-3306.pid[/TD]
[/TR]
[TR]
[TD]plugin_dir[/TD]
[TD]/rdsdbbin/mysql-5.6.29.R1/lib/plugin/[/TD]
[/TR]
[TR]
[TD]port[/TD]
[TD]3306[/TD]
[/TR]
[TR]
[TD]preload_buffer_size[/TD]
[TD]32768[/TD]
[/TR]
[TR]
[TD]profiling[/TD]
[TD]OFF[/TD]
[/TR]
[TR]
[TD]profiling_history_size[/TD]
[TD]15[/TD]
[/TR]
[TR]
[TD]protocol_version[/TD]
[TD]10[/TD]
[/TR]
[TR]
[TD]proxy_user[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]pseudo_slave_mode[/TD]
[TD]OFF[/TD]
[/TR]
[TR]
[TD]pseudo_thread_id[/TD]
[TD]7640720[/TD]
[/TR]
[TR]
[TD]query_alloc_block_size[/TD]
[TD]8192[/TD]
[/TR]
[TR]
[TD]query_cache_limit[/TD]
[TD]1048576[/TD]
[/TR]
[TR]
[TD]query_cache_min_res_unit[/TD]
[TD]4096[/TD]
[/TR]
[TR]
[TD]query_cache_size[/TD]
[TD]1048576[/TD]
[/TR]
[TR]
[TD]query_cache_type[/TD]
[TD]OFF[/TD]
[/TR]
[TR]
[TD]query_cache_wlock_invalidate[/TD]
[TD]OFF[/TD]
[/TR]
[TR]
[TD]query_prealloc_size[/TD]
[TD]8192[/TD]
[/TR]
[TR]
[TD]rand_seed1[/TD]
[TD]0[/TD]
[/TR]
[TR]
[TD]rand_seed2[/TD]
[TD]0[/TD]
[/TR]
[TR]
[TD]range_alloc_block_size[/TD]
[TD]4096[/TD]
[/TR]
[TR]
[TD]read_buffer_size[/TD]
[TD]1048576[/TD]
[/TR]
[TR]
[TD]read_only[/TD]
[TD]OFF[/TD]
[/TR]
[TR]
[TD]read_rnd_buffer_size[/TD]
[TD]524288[/TD]
[/TR]
[TR]
[TD]relay_log[/TD]
[TD]/rdsdbdata/log/relaylog/relaylog[/TD]
[/TR]
[TR]
[TD]relay_log_basename[/TD]
[TD]/rdsdbdata/log/relaylog/relaylog[/TD]
[/TR]
[TR]
[TD]relay_log_index[/TD]
[TD]/rdsdbdata/log/relaylog/relaylog.index[/TD]
[/TR]
[TR]
[TD]relay_log_info_file[/TD]
[TD]relay-log.info[/TD]
[/TR]
[TR]
[TD]relay_log_info_repository[/TD]
[TD]TABLE[/TD]
[/TR]
[TR]
[TD]relay_log_purge[/TD]
[TD]ON[/TD]
[/TR]
[TR]
[TD]relay_log_recovery[/TD]
[TD]ON[/TD]
[/TR]
[TR]
[TD]relay_log_space_limit[/TD]
[TD]0[/TD]
[/TR]
[TR]
[TD]report_host[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]report_password[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]report_port[/TD]
[TD]3306[/TD]
[/TR]
[TR]
[TD]report_user[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]rpl_stop_slave_timeout[/TD]
[TD]31536000[/TD]
[/TR]
[TR]
[TD]secure_auth[/TD]
[TD]ON[/TD]
[/TR]
[TR]
[TD]secure_file_priv[/TD]
[TD]/tmp/[/TD]
[/TR]
[TR]
[TD]server_id[/TD]
[TD]273721596[/TD]
[/TR]
[TR]
[TD]server_id_bits[/TD]
[TD]32[/TD]
[/TR]
[TR]
[TD]server_uuid[/TD]
[TD]e95c3806-2c68-11e4-a9c7-0212ef3c339e[/TD]
[/TR]
[TR]
[TD]show_old_temporals[/TD]
[TD]OFF[/TD]
[/TR]
[TR]
[TD]simplified_binlog_gtid_recovery[/TD]
[TD]OFF[/TD]
[/TR]
[TR]
[TD]skip_external_locking[/TD]
[TD]ON[/TD]
[/TR]
[TR]
[TD]skip_name_resolve[/TD]
[TD]OFF[/TD]
[/TR]
[TR]
[TD]skip_networking[/TD]
[TD]OFF[/TD]
[/TR]
[TR]
[TD]skip_show_database[/TD]
[TD]OFF[/TD]
[/TR]
[TR]
[TD]slave_allow_batching[/TD]
[TD]OFF[/TD]
[/TR]
[TR]
[TD]slave_checkpoint_group[/TD]
[TD]512[/TD]
[/TR]
[TR]
[TD]slave_checkpoint_period[/TD]
[TD]300[/TD]
[/TR]
[TR]
[TD]slave_compressed_protocol[/TD]
[TD]OFF[/TD]
[/TR]
[TR]
[TD]slave_exec_mode[/TD]
[TD]STRICT[/TD]
[/TR]
[TR]
[TD]slave_load_tmpdir[/TD]
[TD]/rdsdbdata/tmp[/TD]
[/TR]
[TR]
[TD]slave_max_allowed_packet[/TD]
[TD]1073741824[/TD]
[/TR]
[TR]
[TD]slave_net_timeout[/TD]
[TD]3600[/TD]
[/TR]
[TR]
[TD]slave_parallel_workers[/TD]
[TD]0[/TD]
[/TR]
[TR]
[TD]slave_pending_jobs_size_max[/TD]
[TD]16777216[/TD]
[/TR]
[TR]
[TD]slave_rows_search_algorithms[/TD]
[TD]TABLE_SCAN,INDEX_SCAN[/TD]
[/TR]
[TR]
[TD]slave_skip_errors[/TD]
[TD]OFF[/TD]
[/TR]
[TR]
[TD]slave_sql_verify_checksum[/TD]
[TD]ON[/TD]
[/TR]
[TR]
[TD]slave_transaction_retries[/TD]
[TD]10[/TD]
[/TR]
[TR]
[TD]slave_type_conversions[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]slow_launch_time[/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD]slow_query_log[/TD]
[TD]OFF[/TD]
[/TR]
[TR]
[TD]slow_query_log_file[/TD]
[TD]/rdsdbdata/log/slowquery/mysql-slowquery.log[/TD]
[/TR]
[TR]
[TD]socket[/TD]
[TD]/tmp/mysql.sock[/TD]
[/TR]
[TR]
[TD]sort_buffer_size[/TD]
[TD]4194304[/TD]
[/TR]
[TR]
[TD]sql_auto_is_null[/TD]
[TD]OFF[/TD]
[/TR]
[TR]
[TD]sql_big_selects[/TD]
[TD]ON[/TD]
[/TR]
[TR]
[TD]sql_buffer_result[/TD]
[TD]OFF[/TD]
[/TR]
[TR]
[TD]sql_log_bin[/TD]
[TD]ON[/TD]
[/TR]
[TR]
[TD]sql_log_off[/TD]
[TD]OFF[/TD]
[/TR]
[TR]
[TD]sql_mode[/TD]
[TD]NO_ENGINE_SUBSTITUTION[/TD]
[/TR]
[TR]
[TD]sql_notes[/TD]
[TD]ON[/TD]
[/TR]
[TR]
[TD]sql_quote_show_create[/TD]
[TD]ON[/TD]
[/TR]
[TR]
[TD]sql_safe_updates[/TD]
[TD]ON[/TD]
[/TR]
[TR]
[TD]sql_select_limit[/TD]
[TD]18446700000000000000[/TD]
[/TR]
[TR]
[TD]sql_slave_skip_counter[/TD]
[TD]0[/TD]
[/TR]
[TR]
[TD]sql_warnings[/TD]
[TD]OFF[/TD]
[/TR]
[TR]
[TD]ssl_ca[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]ssl_capath[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]ssl_cert[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]ssl_cipher[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]ssl_crl[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]ssl_crlpath[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]ssl_key[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]storage_engine[/TD]
[TD]InnoDB[/TD]
[/TR]
[TR]
[TD]stored_program_cache[/TD]
[TD]256[/TD]
[/TR]
[TR]
[TD]sync_binlog[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]sync_frm[/TD]
[TD]ON[/TD]
[/TR]
[TR]
[TD]sync_master_info[/TD]
[TD]10000[/TD]
[/TR]
[TR]
[TD]sync_relay_log[/TD]
[TD]10000[/TD]
[/TR]
[TR]
[TD]sync_relay_log_info[/TD]
[TD]10000[/TD]
[/TR]
[TR]
[TD]system_time_zone[/TD]
[TD]UTC[/TD]
[/TR]
[TR]
[TD]table_definition_cache[/TD]
[TD]12336[/TD]
[/TR]
[TR]
[TD]table_open_cache[/TD]
[TD]27647[/TD]
[/TR]
[TR]
[TD]table_open_cache_instances[/TD]
[TD]16[/TD]
[/TR]
[TR]
[TD]thread_cache_size[/TD]
[TD]2300[/TD]
[/TR]
[TR]
[TD]thread_concurrency[/TD]
[TD]10[/TD]
[/TR]
[TR]
[TD]thread_handling[/TD]
[TD]one-thread-per-connection[/TD]
[/TR]
[TR]
[TD]thread_stack[/TD]
[TD]262144[/TD]
[/TR]
[TR]
[TD]time_format[/TD]
[TD]%H:%i:%s[/TD]
[/TR]
[TR]
[TD]time_zone[/TD]
[TD]UTC[/TD]
[/TR]
[TR]
[TD]timed_mutexes[/TD]
[TD]OFF[/TD]
[/TR]
[TR]
[TD]timestamp[/TD]
[TD]1480370987[/TD]
[/TR]
[TR]
[TD]tmp_table_size[/TD]
[TD]3354432[/TD]
[/TR]
[TR]
[TD]tmpdir[/TD]
[TD]/rdsdbdata/tmp[/TD]
[/TR]
[TR]
[TD]transaction_alloc_block_size[/TD]
[TD]8192[/TD]
[/TR]
[TR]
[TD]transaction_allow_batching[/TD]
[TD]OFF[/TD]
[/TR]
[TR]
[TD]transaction_prealloc_size[/TD]
[TD]4096[/TD]
[/TR]
[TR]
[TD]tx_isolation[/TD]
[TD]REPEATABLE-READ[/TD]
[/TR]
[TR]
[TD]tx_read_only[/TD]
[TD]OFF[/TD]
[/TR]
[TR]
[TD]unique_checks[/TD]
[TD]ON[/TD]
[/TR]
[TR]
[TD]updatable_views_with_limit[/TD]
[TD]YES[/TD]
[/TR]
[TR]
[TD]version[/TD]
[TD]5.6.29-log[/TD]
[/TR]
[TR]
[TD]version_comment[/TD]
[TD]MySQL Community Server (GPL)[/TD]
[/TR]
[TR]
[TD]version_compile_machine[/TD]
[TD]x86_64[/TD]
[/TR]
[TR]
[TD]version_compile_os[/TD]
[TD]Linux[/TD]
[/TR]
[TR]
[TD]wait_timeout[/TD]
[TD]28800[/TD]
[/TR]
[TR]
[TD]warning_count[/TD]
[TD]0[/TD]
[/TR]
[/TABLE]

You should start with slow query log activating and analyzing http://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/USER_LogAccess.Concepts.MySQL.html.
I guess there are some heavy queries which cause to high CPU usage and slowness.
In addition - you should verify if your application is using cache.