Our environment is bottlenecked at the database. The scripting, optimisation of queries has been completed, but the overall performance of the database is slow and needs improvement.
Currently it's hosted on a single LAMP environment and is around 2GB large.
It's a non-tuned MYSQL database.
I'm looking for a system-admin / mysql-expert to log our transactions over a few days / weeks / months and making some tuning suggestions / executions to help speed up our system.
We are happy to discuss whatever will work best - new host, configuration of existing host, load balanced databases... Whatever is required to make the system work better & faster.
We're looking for a one-time tune, but if it requires ongoing work then we are open to that too.