Hello
I am using the newest version of the MyDirect driver for MySQL 5.0 and have the following problem.
From the logs created by MySQL I see that the statement
"SHOW TABLE STATUS FROM db LIKE tbl"
is run each time a select is performed on a InnoDB-table that has a autoincrement field. When the tables become huge (1 mill ++) I see a huge perfromance issue when this statement is run.. And since it runs each time a select is performed on tables with autoincrement the dbserver crashes in the end.
Does anyone know if it is possible to turn off this statement? Or any workaround this problem... Anyone had simular problems?
Thanks
SHOW TABLE STATUS FROM db LIKE tbl
-
- Posts: 729
- Joined: Thu 13 Dec 2007 10:24
Insert this line before the execution of a command:This should solve the problem.
Code: Select all
MySqlDataAdapter.RetrieveAutoIncrementSeed = false;
Hello
Thanks alot for the fast response.
Now it works
Could you also please tell me why this is set to true as default?
What purpose does this statment have?
Why does it only occur on tables that uses autoincrement ?
Will I loose functionality due to setting this property to false?
Thanks for your help!!
Thanks alot for the fast response.
Now it works
Could you also please tell me why this is set to true as default?
What purpose does this statment have?
Why does it only occur on tables that uses autoincrement ?
Will I loose functionality due to setting this property to false?
Thanks for your help!!
-
- Posts: 729
- Joined: Thu 13 Dec 2007 10:24