title: MySQL table size
body: <p>If I had a table with 500 million rows and good indexing would the DB suffer any performance degredation? I am wondering if I need to shard table over multiple DBs even if they might be on the same server. Each row might be 1k in size as it has a couple of text fields. Even if I foreign keyed them they would still be 500 million row table that comprises of say 700 bytes of data.</p>
  
  <p>Also, any tips on engine selection for tables of this size would be great. 
  Any advise would be greatly appreciated. </p>
  
  <p>Cheers</p>
  
  <p>Rich</p>