V
V
Vadim Stepanenko2018-02-20 11:41:00
MySQL
Vadim Stepanenko, 2018-02-20 11:41:00

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

1 answer(s)
W
Wexter, 2018-02-20
@Wexter

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 question

Ask a Question

731 491 924 answers to any question