database size

[bdconnolly]

Greetings. Quick questions re: database size?

We are now at a bout 7 MB. all is well. Is there a maximum size that will begin to effect performance? Are there suggestions for how we might manage that?

Thanks in advance.

Brian

[garvinhicking]

Hi!

That fully depends on your MySQL server power and available RAM.

Some servers can deal with 1TB of Databases, others are exhausted at 5MB.

Best regards,
Garvin

[bdconnolly]

Can you be more specific?

For a db that's now 11 MB big, what would be the optimal system config?

[garvinhicking]

Hi!

My specifiness depends on your input. *g*

For a db that's now 11 MB big, what would be the optimal system config?

Well, a dedicated AthlonXP 1800+ DB-Server with dedicated RAM of 128MB to MySQL would be able to cache all of that data and the MySQL overhead and Query cache so that everything would be served off from the RAM. A total of 512MB RAM should suffice to run a complete Linux on that system.

If the DB-server is the same as the webserver, you need to add the required amount of performance for the Webserver on top of that.

This is a very tough question. It's like asking "How much money do I need to live a good life"? I could say "100$ a week should be enough", but other people might say "I can live with 50$ a week", while others might say "No way to live with less than 500$ a week".

Best regards,
Garvin