Intermittent database connection error
Hello everyone, I have like 1500 visitors everyday posting arounds 300 ads each day. For an unknow reason my website started to have problem to connect to the database so I get the database error page when I try to access my website. My only temporary solution was to reboot the server everytime the website crash. But it cannot be like this forever... so I contacted my host and they tweaked mySql file for bigger memory size but nothing change. From my host side they say it's a configuration problem with the wordpress or the site. They also say that wordpress is not the best platform when it comes to handle big database. Also I have a dedicated server. Please help me I have to found a solution quickly and it's hard for me to start looking somewhere since it seem to happen randomly to me...
Thank you everyone.