It sounds like I'll be helping with some multi-terabyte MySQL tests in the not too distant future. This is good not just because I get to play with neat toys, but it'll finally help me to answer the "how well does MySQL deal with BIG data sets?" question. Until now, I've had to appeal to my knowledge of how MySQL works as well as some second or third-hand reports of what others have done in this area. It'll be nice to have some concrete data and tests that I understand and can explain to others in detail.
Stay tuned for more.
Posted by jzawodn at December 06, 2002 12:46 PM
Hmm. We have a TB+ Oracle db. I'm sure if I asked nicely, they'd let you come over and play with it. :)
Hey Jeremey, I'll be real curious to know what you find out as well. Please keep us updated.
Sorry about the typo with your name. I hate it that you can't go back and edit your comments.
Tim "needs to learn to use preview"
We started to have performance problems when we got to a couple of GB. We ended up splitting the database up into a number of databases on different machines. It works, but is a bit of a pain.