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 Tagged: amazon-rds-aurora, innodb, mysql Viewing 1 post (of 1 total) Author Posts January 3, 2018 at 2:08 am #247024 Cloudy PointKeymaster Question 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? Author Posts Viewing 1 post (of 1 total) You must be logged in to reply to this topic.