Answer the question
In order to leave comments, you need to log in
Will mysql survive 1k RPS?
Hello!
The site runs a script every second using Ajax. In the script, the last 10 records from the table are pulled from the database. I use Redbeanphp for this.
If there are 300 people online, will the database survive? That's about 18,000 requests + ~5k from another script. I don't use caching. I don't use anything. Just ajax - a script - a query to the database - the output of 10 records - in a second on a new one.
Requests are just reading. Not a post, not an update, just get the links to the pictures from the last 10 posts
Answer the question
In order to leave comments, you need to log in
MySQL will survive, for example, we have 2.5k RPS, this is the warming up of the database :) The
question is whether the hardware will withstand and whether the indexes / database / queries are optimal.
So you can run the base in a ramdisk, there will generally be space ~ 40k RPS
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question