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.

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: What will be the best Data-type to store md5\sha1 hashes in MySQL?
2332
February 11, 2015 01:33AM


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.