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:
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:
=== 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.
21 freelancers are bidding on average £185 for this job
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