I have a mac mini with my website running in a production environment. I also have mysql running on the same mac mini. It's a image database (build in php) to explain it in a simple way. Sometimes when I try to login to my website the whole mac mini freezes and it's impossible to reach my website. The only thing I can do is to restart my mac mini and my website comes back again. I have managed to figure out that if I export the whole database with mysqldump and import it everything works again. But after a week, a month or a couple of days the same thing happens again. This is very annoying.
I can't figure out what's going on. I need help.