Search code examples
phpmysqldatabasemultiple-users

will lots of people on website overload database?

I have a website run by php. I have about 80 users that will be signing up within a hour period.

my question is are there any problems that could occur when having lots of people accessing my database all at once?

I mean 80 users is a lot for me, and if some of you people that have way more than that are laughing at me, how many people would it take to mess up a database?

Thanks in advance!

Solution

  • You could use a tool like apachebench to check. Then you could use tools like memcached (or memcachedb if you needed persistence) to dial down the mysql queries. I would also set up mysql slow query logging.