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

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