wordpress mysql optimisation needed, site running slow, large database needs work
£20-250 GBP
Paid on delivery
My existing wordpress based website is suffering from poor page load, frequent site downtime to slow/poorly written mysql scripts against a fairly large database (12k products).
The site must be backed up, and any downtime be a minimum whilst any work is carried out.
its a fully operational website, which as well as listing products to the site, we also use many wordpress plugins to automatically push to ebay as well, all existing functionality MUST remain working.
my hosting bills are quite expensive (site ground), and if there are better wordpress hosts I am open to recommendations for moving to better hosting if needed.
Currently I have - 3 CPU Cores, CentOS, 4GB RAM, 100GB SSD, cPanel, Cloud Storage, Management Services at £87 per month. Which seems very expensive for the performance i am getting.
The host has responded with the following on the support ticket for my recent outtages -
noticed that your website database is generating lots of slow MySQL queries like the following one:
Code:
Executed 15m 53s ago for 91.177409 sec on Database --> Unknown (NOT FOUND / DELETED)
Date: 2018-05-23 14:34:03 Query_time: 91.177409 Rows_examined: 10822980: Rows_sent 1 Lock_time: 0.000155
# Schema: Last_errno: 1160 Killed: 0 SELECT COUNT( DISTINCT [login to view URL] ) FROM cst_posts as posts INNER JOIN cst_postmeta AS postmeta ON [login to view URL] = postmeta.post_id INNER JOIN cst_postmeta AS postmeta2 ON [login to view URL] = postmeta2.post_id WHERE 1=1 AND posts.post_type IN ( 'product', 'product_variation' ) AND posts.post_status = 'publish' AND postmeta2.meta_key = '_manage_stock' AND postmeta2.meta_value = 'yes' AND postmeta.meta_key = '_stock' AND CAST(postmeta.meta_value AS SIGNED) <= '0';
The database is also quit large in size - 2.6 GB and below are listed largest tables:
Code:
=== Top 5 Largest Tables =====
Table name Size
-------------------------------------- --------
cst_postmeta 1.7 GB
cst_postmeta_backup 604.4 MB
cst_ebay_auctions 452.0 MB
cst_ebay_log 132.0 MB
cst_posts 104.8 MB
You could also consider contacting a professional third-party MySQL / WordPress developer in order to resolve this issue for you. I can not recommend anyone in particular, however you should be able to find one at the popular freelancer websites.
Project ID: #17029550
About the project
20 freelancers are bidding on average £191 for this job
Hello, This is Vaishali from "Hire WordPress Experts" and I am here to help you with wordpress mysql optimisation . We have gone through the information provided by you. and I can assure you that we are expert with More
Hi, I will check your current server and optimize it for better performance . I will also assist in getting completely managed server with better configuration and in feasible price. Thank you
Hi I can do this wordpress mysql optimisation needed, site running slow, large database needs work for you. looking forward.
Hi, I'm a PHP developer from VietNam, I have been working with PHP and Wordpress for more than 7 years. I can build plugins, customize Wordpress, create template and optimize wordpress site. I have read your req More
Hi, wordpress mysql optimisation needed, site running slow, large database needs work I have reviewed your requirements for your preconceived project. As all your requirements are crystal clear to me so please h More
Hi I am interested in working with you on wordpress db optimization task. I am expert developer and have done similar work in WordPress. I am looking forward for your response to discuss details. Thanks