title: RDS High CPU utilization
body: <p>I am facing high CPU utilization issue, is too many concurrent <code>create temporary table</code> statement cause high CPU utilization?</p>
  
  <p>Is there any query through that we can capture queries which causing high CPU utilization?</p>
  
  <p><strong>Variable we set:-</strong></p>
  
  <p><code>tmp_table_size = 1G</code></p>
  
  <p><code>max_heap_table_size = 1G</code></p>
  
  <p><code>innodb_buffer_pool_size = 145 G</code></p>
  
  <p><code>innodb_buffer_pool_instance = 8</code></p>
  
  <p><code>innodb_page_cleaner = 8</code></p>
  
  <p><strong>Status Variables:-</strong></p>
  
  <pre><code>        mysql&gt; show global status like '%tmp%';
      +-------------------------+-----------+
      | Variable_name           | Value     |
      +-------------------------+-----------+
      | Created_tmp_disk_tables | 60844516  |
      | Created_tmp_files       | 135751    |
      | Created_tmp_tables      | 107643364 |
      +-------------------------+-----------+
  mysql&gt; show global status like '%innodb_buffer%';
  +---------------------------------------+--------------------------------------------------+
  | Variable_name                         | Value                                            |
  +---------------------------------------+--------------------------------------------------+
  | Innodb_buffer_pool_dump_status        | Dumping of buffer pool not started               |
  | Innodb_buffer_pool_load_status        | Buffer pool(s) load completed at 170917 19:11:45 |
  | Innodb_buffer_pool_resize_status      |                                                  |
  | Innodb_buffer_pool_pages_data         | 8935464                                          |
  | Innodb_buffer_pool_bytes_data         | 146398642176                                     |
  | Innodb_buffer_pool_pages_dirty        | 18824                                            |
  | Innodb_buffer_pool_bytes_dirty        | 308412416                                        |
  | Innodb_buffer_pool_pages_flushed      | 122454921                                        |
  | Innodb_buffer_pool_pages_free         | 188279                                           |
  | Innodb_buffer_pool_pages_misc         | 377817                                           |
  | Innodb_buffer_pool_pages_total        | 9501560                                          |
  | Innodb_buffer_pool_read_ahead_rnd     | 0                                                |
  | Innodb_buffer_pool_read_ahead         | 585245                                           |
  | Innodb_buffer_pool_read_ahead_evicted | 14383                                            |
  | Innodb_buffer_pool_read_requests      | 304878851665                                     |
  | Innodb_buffer_pool_reads              | 10537188                                         |
  | Innodb_buffer_pool_wait_free          | 0                                                |
  | Innodb_buffer_pool_write_requests     | 14749510186                                      |
  +---------------------------------------+--------------------------------------------------+
  </code></pre>