MySQL Forums
Forum List  »  Character Sets, Collation, Unicode

Advanced Search
New Topic

Re: What will be the best Data-type to store md5\sha1 hashes in MySQL?
Posted by: sandeep thakur
Date: February 11, 2015 01:33AM

How many rows? How big (GB) will the table be? How much RAM? How big is the cache? Spinning disks or SSDs? Which ENGINE? RAID striping and multiple threads?
--> The rows will grow in Billions. At present we do have same DB, where current row count is around 500million. The MySQL server is running on Windows server 2008, having 128G of RAM and have spinning disks.
Daily we use to add more than 50k rows into the table. The table has MyISAM as storage engine.

The items are ordered chronologically, but the reads happens against all the items present in the table.

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


Subject
Views
Written By
Posted
What will be the best Data-type to store md5\sha1 hashes in MySQL?
9137
sandeep thakur
February 04, 2015 06:24AM
Re: What will be the best Data-type to store md5\sha1 hashes in MySQL?
3904
Rick James
February 05, 2015 06:57PM
Re: What will be the best Data-type to store md5\sha1 hashes in MySQL?
2431
sandeep thakur
February 11, 2015 01:33AM
Re: What will be the best Data-type to store md5\sha1 hashes in MySQL?
2024
Rick James
February 12, 2015 12:13AM


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.