Results 1 to 3 of 3
  1. #1
    Join Date
    Feb 2012
    Posts
    44

    Unanswered: what's the size of your production DBs?

    Hi

    what's the size of your production DBs?

    We have at the moment 60 GB, but it's fast growing. 2015 it will be 250 GB. Can MySQL handle that?

  2. #2
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    MySQL :: MySQL 5.0 Reference Manual :: D.7 Limits in MySQL

    MySQL :: MySQL 5.0 Reference Manual :: D.7.3 Limits on Table Size

    its more likely you are going to hit hardware limits on your sever, than you are going to hit db size limits. whether that hardware limit is network throughput, cpu loadings (size, number and so on), disk architecture, server memory depends. You probably need to do a full impact analysis if our db is growing that fast

    you may need to redesign the application to make certain its optimised for large data and a large number of concurrent connections

    db size is constrained by the underlying OS on the server, but with modern OS's multi TB db's are available
    I'd rather be riding on the Tiger 800 or the Norton

  3. #3
    Join Date
    Oct 2006
    Location
    CA
    Posts
    210
    I'm pretty new to MySQL so grain of salt ... but

    I was blown away at how MySQL grinds to a halt the moment it has to use Temp DB for interim tables normally kept in memory; and how easily that happened.

    A few days digging into the Config file settings fixed it. Apparently configuring TempDB onto a memory drive is an alternative fix that allows for much bigger tables.

    Our DB is very small by comparison (10GB) so surely you've seen the same.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •