How many partitions should I set for my MySQL table?
Do not PARTITION unless you have actions that would benefit from it.  Let's see your queries.  And, will you be purging 'old' data?

Rule of Thumb:  Don't even consider PARTITION unless there is more than a million rows.

Rule of Thumb:  Have 20-50 partitions; no more.

Do not create next month's partition until you are about to need it.  Keep an empty 'future' partition in case you forget to create the next one.

For real performance, use Summary tables.

More on partitioning.
More on Summary tables.

SHOW CREATE TABLE -- There may be some simple changes to make things more efficient.  Also provide a sample SELECT.