We have a site kuponi.enaa.com that is based on group clone software
http://grouponclone.contus.com/
We overworked the code some, but we have a persistent problem with speed of the site on some instances, lets say once a week. We think the problem is in mysql, which means that we need mysql optimization. Problem is that the sql is very large and it makes logs that are also very large. Once every week or every 2 weeks ...

Need help optimizing my dedicated server. Right now the amount of visitors I am getting daily is causing a bottle neck for me. Because of this I am experiencing slow loads time when multiple visitors are on certain pages at a time.