I'm checking the slow query log, and I found this:
I have a Mysql Server 5.5 and In VB.NET when launch a query like "SELECT * from exampletablename1 " always in the mysql slow log i found this slow query "SHOW TABLE STATUS FROM database like 'exampletablename1'
I don't understand why a "select *" generate the "show table status from..., but in any case, I'm sure that the "SHOW TABLES STATUS" are a slow query
Why? and how can I solve it