User amount flow table, how to sub-table?

every amount change of the user is recorded in this table.
website users about 100W, now the table is too big, thought of sub-table, how to divide it?
Table structure!
user id is a 32-bit guid


Partition tables are usually used in

oracle.

how to partition a table or partition depends on how the table is queried.
from your point of view, if the query must have a user ID, it is suggested to partition according to the user ID HASH; if the time is also required, you can consider using the combination of ID
HASH + CREATE_AT RANGE.

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