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

Reader Comments
# Dan de Isaacs said:

Hmm. We have a TB+ Oracle db. I'm sure if I asked nicely, they'd let you come over and play with it. :)

on December 6, 2002 02:37 PM
# Tim said:

Hey Jeremey, I'll be real curious to know what you find out as well. Please keep us updated.

Thanks,
Tim

on December 6, 2002 09:43 PM
# Tim said:

Sorry about the typo with your name. I hate it that you can't go back and edit your comments.
Thanks,
Tim "needs to learn to use preview"

on December 6, 2002 09:45 PM
# MattJ said:

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.

on December 9, 2002 11:40 AM
Disclaimer: The opinions expressed here are mine and mine alone. My current, past, or previous employers are not responsible for what I write here, the comments left by others, or the photos I may share. If you have questions, please contact me. Also, I am not a journalist or reporter. Don't "pitch" me.

 

Privacy: I do not share or publish the email addresses or IP addresses of anyone posting a comment here without consent. However, I do reserve the right to remove comments that are spammy, off-topic, or otherwise unsuitable based on my comment policy. In a few cases, I may leave spammy comments but remove any URLs they contain.