We have several projects on the Internet. And we need someone to optimize a mysql database.
We have a directory of companies with about 800,000 records, made in joomla and Mosets tree.
Previously we had our site hosted on a shared hosting but we were constantly blocked the bill because our site was doing cpu overload, then we have been forced to purchase a dedicated server.
In the dedicated server we have about 20 websites and the problem is who are all very slow due to this site I spoke of earlier, when check processes, I see that mysql process is always very high.
So I wanted someone who could optimize this database, create an index or any other method.