title: How to efficiently store a lot of transaction records in MySQL?
body: <p>I want to create a system which will get a LOT of transactions, so a typical row will look like this:</p>
  
  <pre><code>id, device, country, amount, os
  </code></pre>
  
  <p>The system is perceived to receive around 4 million transactions a day, so in one year, I would have 1 trillion rows of transactional data.</p>
  
  <p>Is there a better way to store this kind of information without slowing down performance and using so much space?. </p>
  
  <p>I must be able to conduct queries such as select transactions where country is USA and os is Android...</p>
  
  <p>Thank you.</p>