Not the answer you need?
Register and ask your own question!

Mysql Desing Question: How store uuid+<a char string in database> column

KapilKapil EntrantCurrent User Role Beginner
One of the key application table has a column adid (Varchar(50)) as unique key, which has following format (uuid+ a character string). This column is used for heavy batch updaes (millions of updates, 100 updates are done with one commit). This causes slave and it is also a scalability concern for future.

0000015c-aae9-46f0-ac23-f3d188ca1686-0-us_gse
00000161-cefd-4c56-bd99-d3ba716d6acf-0-cts_gsb

Table has auto-increment primary key.

Is there more efficient way to store this data? For uuid it is recommended to convert into binary(16) ? What can we do here ? Can this string be also be converted into binary? Or any other design idea?
Sign In or Register to comment.

MySQL, InnoDB, MariaDB and MongoDB are trademarks of their respective owners.
Copyright ©2005 - 2020 Percona LLC. All rights reserved.