Practical limits on Mysql InnoDB database sizes ?

kristian.rosenvold · January 16, 2018, 12:43pm

Our current event event database is about 112 GB and 50 million rows running on Linux. Are the any known size constraints where I’d be better of switching to a new database, or is it just a question of adding “more of everything” to the DB server ?

Kristian

Frans_van_Buul · January 16, 2018, 1:22pm

Hi Kristian,

There is not a particular number where things break down suddenly, but generally relational database performance deteriorates as the number of rows in a table increases. Once that’s order of magnitude 100 millions, performance tends to be an issue. Some options you have there:

Like you mentioned, “more of everything”
Switch to a high performance alternative; we known some Axon users are running on https://www.percona.com/software/mysql-database/percona-server
Use some form of partitioning to avoid all events ending up in a single table.

Also, AxonIQ provides a dedicated EventStore to address high-performance use cases. Some info here: https://axoniq.io/events/2017/10/axoniq-eventstore-yet-another-database.html
It’s currently at the end of its beta testing period, and we plan to release it for production any day now.

Kind regards,