Practical limits on Mysql InnoDB database sizes ?

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 ?


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:

Also, AxonIQ provides a dedicated EventStore to address high-performance use cases. Some info here:
It’s currently at the end of its beta testing period, and we plan to release it for production any day now.

Kind regards,