MySQL Forums
Forum List  »  InnoDB

Re: utf8 and utf8mb4 performance difference
Posted by: hua kai
Date: September 12, 2016 08:55PM

As mysql document, Performance of 4-byte UTF-8 (utf8mb4) is slower than for 3-byte UTF-8 (utf8). To avoid this penalty, continue to use utf8

just not sure if the performance difference is big.

If the column will not use utf8mb4 characters, if defined as utf8mb4, it will cost more performance?

If the performance is very small that could be ignore, it's easy to set table default to use utf8mb4

If the performance is not small that need to take into consider to set column characters to use utf8mb4 and left table default as utf8

Options: ReplyQuote


Subject
Views
Written By
Posted
1034
September 09, 2016 07:25AM
Re: utf8 and utf8mb4 performance difference
513
September 12, 2016 08:55PM
467
September 18, 2016 12:20AM
428
September 19, 2016 02:14AM
518
September 25, 2016 01:20AM


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.