There are slow queries generated towards our magento database. The slow queries are being stacked up and thus overloading the server resources on our present server.
Unfortunately with the current configuration our website is no longer suitable for the hosting server we're on now and therefor the need of optimization. We need to optimize the magento applipication so that it has the lowest available cpu usage at any one time.
This is a very small project but there will be a good chance that you can get other projects either regular either with the hour if you do a good job.
The project is very urgent and has to be delivered asap.
It should not be a temporary fix but work on the long run. Maybe some kind of cron job to be added trunking the log_files or something among other things.
The magento verision is 220.127.116.11.