S
S
sevmax2011-05-03 11:10:21
MySQL
sevmax, 2011-05-03 11:10:21

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

3 answer(s)
A
aktuba, 2011-05-03
@sevmax

In the output in the application or in the phpmyadmin table? If the second - do not pay attention.

W
web4_0, 2011-05-03
@web4_0

Maybe this is also because, as you know, InnoDB cannot correctly count the number of rows in a table without a WHERE clause

K
Konstantin, 2011-05-03
@Norraxx

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 question

Ask a Question

731 491 924 answers to any question