Which tables should be emptied when clearing database-stored cache manually?
In drupal 8 if you are looking for the safe tables that needs to be cleared manually then clear the tables starting with cache_   and also truncate the cachetags table too.

If you are using drush then use this command for clear cache-

drush cache-rebuild