MySQL is slow and hitting timeouts on relatively small data

[tomsq]

Hello, we are using Umami in a few production websites and we like it very much. The only problem is we have a problem with slow queries using a MySQL database (RDS on AWS) we have around 2M website events and we can only show data in the last 30 days. We don't have a request limit so we are limited by browser to 30s.

Is there something we can do to make our database faster?