Not the answer you need?
Register and ask your own question!

Tokudb Partioning Advantage

LotiaLotia EntrantCurrent User Role Novice
Hi,

I have a Time Series Database with over 2.500 Million registers
The structure is the following.











I would like to have some advice to improve efficiency.
I wonder If it would be a good idea to partition the data by month or by year ? All queries are monthly or yearly based.
Any idea is welcome.

Thanks.
Sign In or Register to comment.

MySQL, InnoDB, MariaDB and MongoDB are trademarks of their respective owners.
Copyright ©2005 - 2020 Percona LLC. All rights reserved.