Devart Forums

We are in process to the final performance optimization a .NET project using the MySQLDirect.NET provider.

Most data retrieval is done with typed datasets and the "basic" table-mappings. We are using basically InnoDB on most tables, besides a couple of memory and temporary tables.

Anway scanning the mysql.log it results that after firing the "real" sql statement there is always a prepended with a statement like
"SHOW TABLE STATUS FROM xxx_DB LIKE 'xxx_tablename'" !

Anyway this is done for normal select, but also to selects on views and derivated "tables" within complex statements.

For what is this statement needed for? Anyway to get rid of it ? Anyway we are seeing sometime a big performance impact especially in high load situation where the stats are changing very frequently ...

regards

Carsten Harnisch

It has an attitude only toward autoincrement columns.

sorry, but this means what ?
This is basically after ALL select statements so I am not sure why this should be related autoincrements ?!?

Carsten

We are checking this carefully. You will be notified as soon as possible.

Alexey, if this would be of any help, we could send you query log
excerpts that show which queries we use. But it breaks down to
what Carsten already said: Basically every query is followed by
a show table status request. If you need samples from the
application code to look into it, we'd gladly provide them, too.

I know that flagging support requests as "urgent" rarely helps,
but we're in a big hurry regarding this project. Any fast hint would
be greatly appreciated.

Send us everything you suppose may be helpful.

We have checked this.
"SHOW TABLE STATUS" is invoked only for those tables that have autoincremented fields.