How to realize the overload protection of long connection

A scenario often encountered in a long-term connection to a server is that if a live broadcast room is hot, suddenly many users enter the room and connect. At this time, the service may be abnormal because the concurrency is too large. How to do overload protection

Im
Mar.29,2021

can't anyone give a practical idea


backend perspective: when the concurrency reaches a certain amount, the backend server expands flexibly.
Front-end angle: more than a certain number of people are required to pay.

MySQL Query : SELECT * FROM `codeshelper`.`v9_news` WHERE status=99 AND catid='6' ORDER BY rand() LIMIT 5
MySQL Error : Disk full (/tmp/#sql-temptable-64f5-1e47d91-271a5.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")
MySQL Errno : 1021
Message : Disk full (/tmp/#sql-temptable-64f5-1e47d91-271a5.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")
Need Help?