I have a few questions.

1)Whats the maximum size a MySQL database can be?
2)Whats the biggest database you have seen?
3)Is there any special thing I should do for big databases(configs etc)?
4)What is considered a large database?


Thanks

I don't know exact sizes, but hardforum.com has a huge database for VB (almost 2 million posts, so proably about 2.5million entries in MySQL). But if the DB is that size you need to preform a lot of matinance on it (their forums go down a hour a day for DB matincace)

What is involed with the maintenance?

I'm not 100% sure on this, but a mysql db can grow as big as the filesystem of and OS will allow. Like for older linux kernels there was a 2gig file limit? so a db could only be two gig. I think it all depends on the OS not on mysql. I would NOT recommend mysql for a big db. Mainly since it will have the tendancy to corrupt data a lot if its doing a lot of work. The only db's I have admined that are big are oracle and I've seen them well over 3 gigs

Hope it helps
mike

A db has multimate files. I guess my question is, how big can it get before I have problems?

Originally posted by zupanm
I'm not 100% sure on this, but a mysql db can grow as big as the filesystem of and OS will allow. Like for older linux kernels there was a 2gig file limit? so a db could only be two gig. I think it all depends on the OS not on mysql. I would NOT recommend mysql for a big db. Mainly since it will have the tendancy to corrupt data a lot if its doing a lot of work. The only db's I have admined that are big are oracle and I've seen them well over 3 gigs

Hope it helps
mike

mySQL Manual: 1.2.4 How Big Can MySQL Tables Be? (http://www.mysql.com/doc/T/a/Table_size.html)

from my experience using mysql a db thats doing a lot of work is going to get corrupted data. I don't recommend using it if your getting valued data in all the time. Its fine if you can back ir up and can afford to lose some of it. It's like everything you have to look at your situation and look what option will work for you.

Thanks!!
One a side note, does anyone no of any good utilities for optimizing databases and chaecking for errors?

Originally posted by Foo-Dawg
mySQL Manual: 1.2.4 How Big Can MySQL Tables Be? (http://www.mysql.com/doc/T/a/Table_size.html)

phpMyAdmin has built in optimizers

it does? where ?

Personally, I love MySQL, but I would never use it for a huge database that required reliability.

I would recommend Progress, or Oracle for something like that.

IMHO