MySQL Forums
Forum List  »  InnoDB

Re: InnoDB byte limit encountered with a column for emails
Posted by: Dean Richert
Date: November 30, 2014 06:56PM

Hi Rick,

Thanks for the reply. I am running mysql 5.6.14.

I do need case folding for this column.

I am not sure how to test the innodb large prefix setting or why is set to the default. The best option for me would be to increase it, but I can't run any effective benchmarks because I don't know what the setting may impact, and I do not currently have a large realistic dataset to test general queries on, either. I am trying to come up with reasons for why 767 bytes is the default setting, but so far am in the dark.

That's a a very nice setup with md5 that I hadn't considered. Thanks for bringing it up. Do you mean to create an md5 of an email entered, search for the md5 hash in the database, and then match get the corresponding email associated with the hash?

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: InnoDB byte limit encountered with a column for emails
1175
November 30, 2014 06:56PM


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.