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

**URL:** <https://forums.percona.com/t/mysql-desing-question-how-store-uuid-a-char-string-in-database-column/3961>\
**Category:** Other MySQL® Questions\
**Created:** [December 20, 2014, 11:08am UTC](https://forums.percona.com/t/mysql-desing-question-how-store-uuid-a-char-string-in-database-column/3961 "2014-12-20T11:08:46Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![Kapil](https://avatars.discourse-cdn.com/v4/letter/k/b9bd4f/32.png) [@Kapil](https://forums.percona.com/u/Kapil)\
**Post date:** [December 20, 2014, 11:08am UTC](https://forums.percona.com/t/mysql-desing-question-how-store-uuid-a-char-string-in-database-column/3961/1 "2014-12-20T11:08:46Z")

</div>

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?