Answer the question
In order to leave comments, you need to log in
MyISAM-> InnoDB. Different number of output lines
Actually a question. When converting tables from MyISAM to InnoDB, the output is a different number of rows. I checked the autoincrement value - it is in the next value from the value in the MyISAM state, i.e. everything is correct.
What causes the row count differences between MyISAM and InnoDB? Cunning conversion of indexes?
Answer the question
In order to leave comments, you need to log in
In the output in the application or in the phpmyadmin table? If the second - do not pay attention.
Maybe this is also because, as you know, InnoDB cannot correctly count the number of rows in a table without a WHERE clause
Do you mean count?
This function is not exact, in MySQL it must be set to a certain amount of precision ... (mine default: 20000).
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question