Topic: Select 200 million of rows
All greetings, I collect statistics on advertizing compressed in 5 minute, and for days. These are 3 different tables.
In the table which contains the data for days collected for the last month 200 million records.
I need to make Select with grouping for last month and to show metrics that it is unreal long.
I use MySQL 5.7
Prompt how to work with such data volume? Whether helps to accelerate sharding through a cluster sampling on 200 with grouping?
It can be necessary to use other basis / technology for such tasks?