Max size of MySQL/postgresql databases?

smith15 · 2003-01-17T16:55:58+00:00

I think I've heard that the max size of mysql running on linux is 2 or 4 GB, can anyone confirm this? What about postgresql? Anyone know about MS SQL Serv...

Max size of MySQL/postgresql databases?

ultraslacker

Yep, there's your problem - mysql man pages do not contain up to date information - especially about postgresql.

smith15

Outstanding... that had me pretty worried.

Ok, one more newbie question, I see with possible redhat/linux "ext2/ext3" the file size is in the terrabytes, but how can I find out if our server is using ext2 or ext3?

I really appreciate the help guys, this will be a huge weight off my shoulders if this isn't a concern. 😉

smith15

wait I think I found it, command is df -T

says we're running ext2 --- does this mean I can go above the 2GB limit?

nnichols

it depends on the kernel but ext2 can support upto 8Tb I think

smith15

Originally posted by nnichols
it depends on the kernel but ext2 can support upto 8Tb I think

Even on redhat's site and newsgroup I'm having trouble finding a clear answer. As long as I can confirm it's in the terrabyte range, I'll be fine.

nnichols

linux 2.4.x kernel allows filesizes of "about" 4 Tb

smith15

Originally posted by nnichols
linux 2.4.x kernel allows filesizes of "about" 4 Tb

Ugh, it appears it's 2.2.19-6.2.1

at least that's what 'uname -a' showed me

nnichols

depending on what flavour of linux you are running there are rpms you can download to patch the 2.2 kernel. You'll have to try a support site for your specific flavour.

Good luck

mattr

It depends on your OS, but generally they all can support more than you want to store. In practice, of course, you'll hit limits lower than the theoretical max. For example, MySQL stores each table in a single OS-based file. Some versions of linux (the older 2.2 kernels) could not create files larger than 2GB, so your tables were limited to 2GB on those OS. The limit has since been removed in 2.4 > kernels.

smith15

Yeah we're still running RH 7.2 (with 2.2 kernel) so we probably need to upgrade.

Sxooter

Just to clarify:

Postgresql splits ALL it's file at about 2 gig, so that a table might appear like this in the base/oid directory it lives in:

1023234
1023234.1
1023234.2

Where each one of those files would be ~2 gigs each.

Postgresql can AND DOES handle terabytes. Look through the performance mailing list for folks doing just that.

I'd suggest building a test box with both mysql and postgresql on it and seeing how they handle some arbitrary test data set you create for it.

smith15

Originally posted by Sxooter
Just to clarify:

Postgresql splits ALL it's file at about 2 gig

I'd suggest building a test box with both mysql and postgresql on it and seeing how they handle some arbitrary test data set you create for it.

Very cool. Yeah, I plan on doing that.

jerdo

How are you running 2.2 kernel on RedHat 7.2? I think RedHat started shipping with the 2.4 kernel in 7.1.

smith15

Originally posted by jerdo
How are you running 2.2 kernel on RedHat 7.2? I think RedHat started shipping with the 2.4 kernel in 7.1.

That's what uname returned.... it's got me baffled as well 😕