r/drupal • u/pat-sohs-webmaster • 1d ago
Large Drupal 10 cache files even though tables are truncated
After Inmotion Hosting emptied our Drupal databases and then restored them because we exceeded storage limits, I began emptying the database caches every week in PHPMyAdmin. In spite of this, the cache files in the /var/lib/mysql/mydatabasename grew to 20 or more GBs. And now the websites have crashed again. I have read it isn't safe to delete the cache...ibd files, but if I don't I can't restore the database. IM has blown us off - they don't deal with databases. I do understand that, but it doesn't help solve the dilemma. Has anyone safely deleted the cache files? Everything online just tells me to empty the tables, and that clearly didn't eliminate the problem.