MySQL Forums :: InnoDB :: utf8 and utf8mb4 performance difference


Advanced Search

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 615 hua kai 09/09/2016 07:25AM
Re: utf8 and utf8mb4 performance difference 450 Rick James 09/10/2016 10:48PM
Re: utf8 and utf8mb4 performance difference 342 hua kai 09/12/2016 08:55PM
Re: utf8 and utf8mb4 performance difference 300 Rick James 09/13/2016 04:07PM
Re: utf8 and utf8mb4 performance difference 313 hua kai 09/18/2016 12:20AM
Re: utf8 and utf8mb4 performance difference 285 Peter Brawley 09/18/2016 01:40PM
Re: utf8 and utf8mb4 performance difference 299 hua kai 09/19/2016 02:14AM
Re: utf8 and utf8mb4 performance difference 420 Xing Zhang 09/20/2016 08:38PM
Re: utf8 and utf8mb4 performance difference 297 hua kai 09/25/2016 01:20AM
Re: utf8 and utf8mb4 performance difference 282 Rick James 09/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.