Number of rows converted to UTF-8 in Converter

[Adriano Faria]

I'm upgrading a big board from 3.4.9 to 4.4.2 and I got on large tables, like POSTS:

It's running for almost one hour and I have no way to know if it stopped or if it's running because the 0 (zero) always remains there and the % doesn't change either. It should update the number of rows already converted and/or the %.

Tks.

---------------------------------------

[Ryan Ashbrook]

It depends on the method in use.

1. If PHP is performing the conversion, then we can track what row it's working on in the table and update the converter accordingly. This method, however, is a lot slower.
2. If MySQL is performing the conversion, then we can't track what row it's working on (because it's done in a single query), however this method is a lot faster than using PHP.

So it's a double edged sword, really. If PHP were to perform the conversion, those 7 hours would have likely been a lot longer.