1

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?

2

Re: Select 200 million of rows

vixa2012 wrote:

how to work with such data volume?

to Do precalculations, fur-trees-sticks... There transited five-minute - counted from  the statistics and threw off in the separate table... And when the data in an hour-day-month was required, take them and integrate further.

3

Re: Select 200 million of rows

Yandex Klikhaus.