How to properly organize a large database - one large table or split into small ones?

Question

MySQL

It is necessary to create a data search by cities. Filters will be used to search for data. What is the correct way - to make one table general or for each city its own table? The data is the temperature by day for 100 years, for example, that is, there will be a lot of data, plus it will be necessary to carry out calculations on them - for example, sampling the coldest day for such and such a month in all cities.
How is it better?

Answer 1

If all this data is of the same type, then push it into one table. You can set up partitioning so that data is physically placed in different files according to some criteria.