I have around 1T (1,000,000,000) records of products belong to 500,000 accounts. Each product record have the account_id and since I always query within a single account context (there are no cross-account queries) I thought of creating a partition per account to improve performance.
- Is it even possible to create 500,000 list partitions in mysql8?
- Will it required changing in the number of open files the process required?
- If it is possible, is there a reason for me not to go this path?