Amazon-RDS [SOLVED]: How to see size of MySQL internal innodb temporary tables

Amazon-RDS [SOLVED]: How to see size of MySQL internal innodb temporary tables

Home Forums Amazon Web Services Amazon RDS Amazon-RDS [SOLVED]: How to see size of MySQL internal innodb temporary tables

Viewing 1 post (of 1 total)
  • Author
    Posts
  • #247024

    Cloudy Point
    Keymaster

    QuestionQuestion

    I’m seeing a large number of internal temporary disk tables being written. I can see the count with SHOW GLOBAL STATUS where Variable_name like 'Created_tmp_disk_tables'.

    I know I can update max_heap_table_size and tmp_table_size to help prevent this, but without knowing the size of the tables getting written to disk, it’s difficult to know what values to use.

    Does anyone know how to go about finding this value?

Viewing 1 post (of 1 total)

You must be logged in to reply to this topic.