Hi, i have a problem with "exceeded the 'max_user_connections' resource"
The hosting provider give me 3GB database size limit, each time the DB reaches this size, i have to clear data to reduce the size of DB, i always did it with the same way and it reduces to 400 or 500 mb
- Clear all cache
- Empty tempstore table (based on this thread)
after this, it works correctly for about 2 weeks then clear again, I did it many times in the past without any problems, but last time few minutes after the tempstore table was emptied, the site crash with 'max_user_connections', then it returns live and again crash with the same, the only way to maintain the site live permanently is empty the tempstore table about 3 times per hour.
I contacted the hosting and they told me that is a site issue, but I haven't changed anything for a long time (except for update to 1.17.3 and then 1.17.4) but nothing else
Question, is there any Backdrop or PHPMyAdmin configuration to avoid this max_user_connections or any better solution for the heavy tempstore table?
Thank you friends