title: Quick search on huge mysql database
body: <p>I need to index a huge mysql database ( 5 billions record ).
  I will rarely create, update or delete</p>
  
  <p>only some request like  SELECT * FROM tbl_person WHERE name LIKE 'foo%'</p>
  
  <p>I have already set my index on field.</p>
  
  <p>With one will be better for best performance on read request</p>
  
  <p>1 single request on a 5billions records table
  or 10 request on 500millions records table and join result after.</p>