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


Advanced Search

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
utf8 and utf8mb4 performance difference 643 hua kai 09/09/2016 07:25AM
Re: utf8 and utf8mb4 performance difference 454 Rick James 09/10/2016 10:48PM
Re: utf8 and utf8mb4 performance difference 344 hua kai 09/12/2016 08:55PM
Re: utf8 and utf8mb4 performance difference 303 Rick James 09/13/2016 04:07PM
Re: utf8 and utf8mb4 performance difference 321 hua kai 09/18/2016 12:20AM
Re: utf8 and utf8mb4 performance difference 289 Peter Brawley 09/18/2016 01:40PM
Re: utf8 and utf8mb4 performance difference 302 hua kai 09/19/2016 02:14AM
Re: utf8 and utf8mb4 performance difference 431 Xing Zhang 09/20/2016 08:38PM
Re: utf8 and utf8mb4 performance difference 300 hua kai 09/25/2016 01:20AM
Re: utf8 and utf8mb4 performance difference 287 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.