My database is causing excess load on a shared server, to the extent that the hosting company has disabled access to it.
I need someone to go through the database, and perhaps the plugins being used, in order the load be reduced and the site restored.
Some examples given as to what might be needed are:
Resolving this situation may be as simple as modifying the code to to use mysql_connect instead of mysql_pconnect, closing connections sooner, adding additional indexes to your database, optimizing the queries used, or something equally easy.
Excessive MySQL activity is caused by (a) a long-running process that locks a table, causing other queries to back up, (b) a query that is not optimized ][example: select all from ... and involving a large or complex query], (c) huge table copies/maintenance during peak hours.
Additionally, adding indexes to your table(s) may improve performance. If you're not sure what you're doing, it's best not to modify any table; caution is recommended. There are various articles ([url removed, login to view]). It may be best to Google for something like [Your Software Name] MySQL indexes for suggestions.
30 freelancers are bidding on average $197 for this job
Need more detail,can we discuss this,to know more detail. We have a team of professionals,they have more than 11 year of experience,so we can manage this work and will give you quality solution.
UK based developer - mySQL expert, I can debug your scripts to review what is causing the most damage and optimise where possible. Happy to discuss your project further.
we are having very good experience in data optimization and WordPress plugins we will have to do code analysis bcoz this will be the main reason to increase usages of the mySQL memory.
Hello Sir, I will help you out in Database Optimization so that it will reduce the load on DB engine. Please open a PM to discuss it. Thanks & Regards.