MySQL Forums
Forum List  »  Performance

Advanced Search
New Topic

Re: primary key charset latin1 and other columns utf8 for performance?
Posted by: Rick James
Date: July 29, 2012 09:14AM

Another performance aspect...
Smaller -> more cacheable & less I/O -> faster
That is BINARY(16) is the smallest, so it is the fastest.
VARBINARY(32) utf8 is the slowest.

VAR is not needed, assuming these are constant length.
VAR has a small overhead.

Hash/GUIDs/UUIDsMD5/etc have a serious performance issue for _large_ tables -- they are very random. When the table is much larger than RAM, INSERTing one row will take (about) one disk hit to randomly update the index. On typical drives, you can get only 100 disk hits/second.

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Views
Written By
Posted
primary key charset latin1 and other columns utf8 for performance?
2288
Giovanni P
July 22, 2012 11:31AM
Re: primary key charset latin1 and other columns utf8 for performance?
1140
Aftab Khan
July 23, 2012 04:46AM
Re: primary key charset latin1 and other columns utf8 for performance?
1283
Giovanni P
July 23, 2012 01:31PM
Re: primary key charset latin1 and other columns utf8 for performance?
1451
Aftab Khan
July 24, 2012 03:07AM
Re: primary key charset latin1 and other columns utf8 for performance?
1167
Rick James
July 29, 2012 09:14AM


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.