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.
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?