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?
Subject
Views
Written By
Posted
utf8 and utf8mb4 performance difference
3353
September 09, 2016 07:25AM
1943
September 10, 2016 10:48PM
1558
September 12, 2016 08:55PM
1377
September 13, 2016 04:07PM
1394
September 18, 2016 12:20AM
1154
September 18, 2016 01:40PM
1072
September 19, 2016 02:14AM
7390
September 20, 2016 08:38PM
1689
September 25, 2016 01:20AM
1867
September 30, 2016 08:04PM
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.