# High CPU utilization and can't figure out why

**URL:** <https://forums.percona.com/t/high-cpu-utilization-and-cant-figure-out-why/5241>\
**Category:** Other MySQL® Questions\
**Created:** [November 28, 2016, 5:25pm UTC](https://forums.percona.com/t/high-cpu-utilization-and-cant-figure-out-why/5241 "2016-11-28T17:25:11Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![bjohnstonokc](https://avatars.discourse-cdn.com/v4/letter/b/e5b9ba/32.png) [@bjohnstonokc](https://forums.percona.com/u/bjohnstonokc)\
**Post date:** [November 28, 2016, 5:25pm UTC](https://forums.percona.com/t/high-cpu-utilization-and-cant-figure-out-why/5241/1 "2016-11-28T17:25:11Z")

</div>

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]

---

<div class="post-metadata">

**Author:** ![vitaly\_il](https://avatars.discourse-cdn.com/v4/letter/v/cab0a1/32.png) [@vitaly\_il](https://forums.percona.com/u/vitaly_il)\
**Post date:** [December 19, 2016, 8:47am UTC](https://forums.percona.com/t/high-cpu-utilization-and-cant-figure-out-why/5241/2 "2016-12-19T08:47:42Z")

</div>

You should start with slow query log activating and analyzing [url][http://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/USER\_LogAccess.Concepts.MySQL.html[/url]](http://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/USER_LogAccess.Concepts.MySQL.html%5B/url%5D).  
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.