Logs should be limited by size. One could also use quotas in a filesystem. Also, what if some other application, like npm cache, uses the space for a database? Do you suggest allocating a partition for every program?

Also, databases usually store data in /var so it won't even help. Also, mysql simply hangs instead of shutting down in this case.