MySQL Forums
Forum List  »  InnoDB

utf8 and utf8mb4 performance difference
Posted by: hua kai
Date: September 09, 2016 07:25AM

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

I want to know what's the performance difference, how utf8mb4 slower than utf8?

Because our app sometimes will allow user input non BMP characters, so if the performance difference is only a little, is it better to set default character as utfmb4 for table when create table or just set some specific columns as utf8mb4 when create table?

Options: ReplyQuote


Subject
Views
Written By
Posted
utf8 and utf8mb4 performance difference
3324
September 09, 2016 07:25AM
1548
September 12, 2016 08:55PM
1383
September 18, 2016 12:20AM
1066
September 19, 2016 02:14AM
1677
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.