Can Ali cloud database mysql, single table 2000w data bear?

do an activity for the customer
now the table has added 100w items of data a day

can you save it for me if you want to ask


this kind of data gauge directly suggests that users have off-the-shelf services on hbase, Ali Cloud


1. What is the number of valid users with 100w of data a day? How much data does a user need to store?
2. Is this table written only for follow-up statistics? Or are we all together? If the writing and checking are all together and the index is built, the efficiency will not be too low, and the 100w but, QPS a day will not be low, will it? A single database and single table can't hold up


depends on how the query looks after it is written? If there are too many words, it is estimated that it is not very good, it is no problem to write, and it is estimated that there will be pressure to write. It should be no problem to set up a queue to write.

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