MySQL Forums
Forum List  »  General

Advanced Search
New Topic

Re: how to estimate a hardware server's requirement for MySQL database server?
Posted by: Rick James
Date: September 18, 2014 05:10PM

Oh...

* Use the smallest practical datatypes for each field. It is much easier to do this before you start. For 2-3TB, the most important parameter in performance is data size on disk.

* Normalize where reasonable. (But don't over-normalize -- such as floats, datetimes, etc)

* Minimize indexes on your "Fact" table. Having too many secondary indexes could prevent your 50GB/day goal.

* More tips and blogging:
http://mysql.rjweb.org/doc.php/datawarehouse

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




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.