Connecting to Azure MySQL Database using mysql client shows thousands of temp tables

Aneesh Kumar 1 Reputation point
2021-03-16T05:23:12.523+00:00

Hi,

I'm facing a strange issue using Azure MySQL database for the past 2 days. I usually connect to the database using mysql cli. When I connected to one of our database hosted in Azure MySQL database I noticed there are huge number of tables present which I did not create. Our database has only around 1000 tables but the show table command shows that I have 21844 rows. When I checked in detail all the extra tables have prefix temp_.

The strange thing is when I use other tool like MySQL workbench or SQLyog these tables are not shown. Due to this issue I'm also not able to take DB backup using mysqldump.

Anyone faced such an issue? any assistance will be appreciated.

Thank you

Azure Database for MySQL
Azure Database for MySQL
An Azure managed MySQL database service for app development and deployment.
763 questions
{count} votes