Reputation
801
Top tag
Next privilege 1,000 Rep.
See vote count; VIP usercard
Badges
1 3 5
Newest
 Yearling
Impact
~73k people reached

  • 0 posts edited
  • 0 helpful flags
  • 8 votes cast
Jul
3
awarded  Yearling
Jul
3
awarded  Yearling
Jul
5
awarded  Populist
Jul
4
comment Can MySQL reasonably perform queries on billions of rows?
If you want six sigma-level availability with a terabyte of data, don't use MySQL. We were a startup that had no DBA and limited funds.
Jul
3
awarded  Supporter
Jul
3
awarded  Mortarboard
Jul
3
awarded  Teacher
Jul
3
awarded  Good Answer
Jul
3
awarded  Nice Answer
Jul
3
awarded  Autobiographer
Jul
3
comment Can MySQL reasonably perform queries on billions of rows?
The main thing would be to not mix the two. You can't really optimize a server for both because of the way mysql caches keys and other data. Pick one or the other for all the tables in a server if you can. MyISAM may help with some speed issues, but it may not help with the overall DBA work that needs to be done - which can be a killer.
Jul
2
comment Can MySQL reasonably perform queries on billions of rows?
Everything we had was innodb.
Jul
2
answered Can MySQL reasonably perform queries on billions of rows?