731 reputation
135
bio website github.com/kevinzen
location Boston, MA
age 94
visits member for 2 years
seen Apr 7 at 12:36

About me:


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?