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

About me:


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
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.