MySQL question

[zulufox]

I wanted to run gallery, a store, phpbb, mambo cms, a custom script, and a directory script off of one mysql database.

The max size of the database is 100 megs so it is definitely big enough (currently if i migrated everything over it would only be 10 megs or so).

However, I am worried that all the traffic would overwhelm the database.

How many connections can be made to one mysql database without problems?

[diamondgrl]

It can handle a good number, depending on whether you've properly optimized the database and make reasonable queries.

What kind of traffic do you expect? Usually, for most web applications it should be quite fine. I often run millions of queries a day without problem.

[coopster]

How many connections is too many connections [dev.mysql.com]? I don't think you'll have any problems ;-)