question

AneeshKumar-7131 avatar image
0 Votes"
AneeshKumar-7131 asked AnuragSharma-MSFT commented

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

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-mysql
· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi @AneeshKumar-7131, welcome to Microsoft Q&A forum.

Could you please post the screenshot of few temp tables that you see using mysql cli?

Also, is this existing azure mysql database or newly created/migrated database?

0 Votes 0 ·

0 Answers