Model cache refresh failing due to timeout

1

I created a model based on a SQL query that is averaging 60 seconds to run.
I'd like to cache this.

I've turned on caching, and we created a schema for the cached model.
However now we're getting emails that reference the last run and say the following:

Model refresh for Heroku Production (read-only) failed

We ran into some trouble refreshing the model userlocationwithcity. You can see the error description below:

Killed mysql process id 20,478,920 due to timeout.

2

What's the timeout you have setup on mysql? Since form the error it seems that mysql is simply killing the query due to timeout