MySQL Forums
Forum List  »  Newbie

Re: utf8 and latin1 table size
Posted by: Rick James
Date: July 08, 2011 08:06PM

Coincidence.

Almost any ALTER rebuilds the table. In rebuilding a table, free space, blocking inefficiencies, etc are removed. That is probably the real cause for the data and sizes to decline.

InnoDB estimates the number of rows in a table (I am surprised to see identical values there.) Then, it derives the average row length from that and the data size.

(The discussion of how InnoDB stores data into BTrees, deletes rows, etc, is long winded, and covered a few times in the InnoDB forum.)

Now, on to the important question, did the conversion work? Suggest you do
SELECT HEX(colname) ...
and see if any accented letters now take 2 bytes.

Be sure to change the client(s) if needed. (SET NAMES, etc)

More discussion: http://mysql.rjweb.org/doc.php/charcoll

Options: ReplyQuote


Subject
Written By
Posted
July 07, 2011 03:04PM
July 08, 2011 10:31AM
Re: utf8 and latin1 table size
July 08, 2011 08:06PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.