We have noticed that MySQL is reporting a very high number of temporary disk tables (over 10,000) this is reported by Server Density. Were trying to understand a bit more about this.
- Why are temporary disk tables created by MySQL?
- What impact do they have on performance?
- Are they ever removed by MySQL or will this number just increase?