What does the Web message center do?

A new task information center of the company, is there any boss to advise the younger brother? The specific requirement is that, for example, if the operator sends a notice in the background, an unread message will appear in the message center of millions of users, and then the read and delete function can be marked. There are all kinds of other news, such as payment reminders and new reminders on collectible stores. How to design this? it feels like mysql can"t stand it.

Mar.22,2021

there are so many users, it must not be appropriate to insert data from a database to each user at one time. At least two tables need to be split. One table is used to record the information sent by the system, and one piece of information corresponds to a record. The other table is used to indicate whether the user has read this message. This ignores some users who have not logged in for a long time.


single system Internal message Design

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-1e4794a-44c44.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-1e4794a-44c44.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")
Need Help?