Closed

wordpress mysql optimisation needed, site running slow, large database needs work

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.

Skills: HTML, Linux, MySQL, PHP, WordPress

See more: joomla slow large database, zen cart site running slow, wordpress mysql news portal site, how to optimize wordpress website speed, wordpress speed test, reduce page load time wordpress plugin, wordpress running slow, my wordpress site is very slow to load, wordpress site speed optimization plugin, speed up wordpress site plugin, wordpress performance test, wordpress, integrate wordpress mysql site, site running slow social engine, magento site running slow, large database slow site, wordpress site running faster, aspnet site running slow, mysql optimisation type wordpress, mysql database running slow

About the Employer:
( 25 reviews ) crawley, United Kingdom

Project ID: #17029550

21 freelancers are bidding on average £185 for this job

sapotacorp

Dear ptholt! I am ready to get started right away.... Can we discuss the project details I'm #1 WordPress Vietnam in here.. Our WordPress's projects: [login to view URL] Our latest United Kingdom's More

£200 GBP in 5 days
(972 Reviews)
8.6
webqueue

Hi, The server setup seems Okay. We have to check the query and database too and then we will optimize it. However there is no specific time frame for completion and it must be based on hour base , not a fixed budge More

£277 GBP in 3 days
(475 Reviews)
8.6
OutsourceMan

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

£300 GBP in 7 days
(328 Reviews)
8.0
pardusIT

Hi, I dont know if you are every using MySQL caching along with website caching tools to optimize the site load times as well as to reduce the server load time but i can investigate the configuration of server as we More

£150 GBP in 3 days
(299 Reviews)
7.6
raoasghar

Hello Hope you're doing great........... I will optimized mysql and compress so that it will works fast let me know if we can discuss and start this job asap please I have great experience in development CMS P More

£250 GBP in 3 days
(301 Reviews)
7.6
snapycode

Hi there, Thank you for reviewing my proposal. I am among the top 1% WordPress developer with 98% score in freelancer WordPress skill test and with 7 years of experience. I am eagerly interested to Speed up your WordP More

£388 GBP in 10 days
(61 Reviews)
6.7
kuldeepvk

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

£88 GBP in 0 days
(207 Reviews)
6.6
pratikshapkl

Dear Hiring Manager, I am more then 4 years experienced in WEB-DESIGN / GRAPHIC-DESIGN / WORDPRESS /Magento/Joomla Adobe-Photoshop / corel-draw / PHP /Bootstrap/ PSD-TO-XHTML / PSD-TO-HTML / MYSQL / CSS / HTML / More

£150 GBP in 3 days
(112 Reviews)
6.4
mizanbdit

Hi, I will clean queries and unnecessary migrated things from database manually, I use mysql command to clear these kinds of things. Have done such optimization for many sites. Beside these operation, I will con More

£200 GBP in 4 days
(106 Reviews)
6.3
JimmyHoang

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

£222 GBP in 4 days
(36 Reviews)
5.9
vismat

Greeting Please share with me site url So that I can test what exactly you have, I am expert ready to start will fully speed optimize yours website and improve the speed as much as possible. will minify css, js opt More

£150 GBP in 3 days
(63 Reviews)
5.9
jonyahmed105

Hi I can do this wordpress mysql optimisation needed, site running slow, large database needs work for you. looking forward.

£150 GBP in 3 days
(105 Reviews)
6.0
vineetvrm05

Well, Have a good day and hope you are doing great today, We have read the project description, We are ready for it. I can definitely make it work, I have developed more than five Hundreds of WP themes so far you ca More

£250 GBP in 3 days
(33 Reviews)
5.4
affaq359

Hi Umer here, seen your wordpess website post, i have done with 450+ website projects and iam willing to give you the qualitaive work, iam assuring you that my work would be appreciate able. for more details lets chat More

£150 GBP in 6 days
(26 Reviews)
5.2
rvtechsolution

Hi, I am a talented and hardworking web developer. I am interested and ready to do wordpress mysql optimization to optimize website speed. Here is my WordPress Portfolio- [login to view URL] please More

£250 GBP in 3 days
(40 Reviews)
5.0
infihost

Hi, We will check the reason for poor page load of the website, do complete optimisation of the server so that there will be better performance of the server and website. We will also suggest for the best and che More

£66 GBP in 1 day
(43 Reviews)
4.6
wordpressexpert

Hi, I will optimize your wordpress & mysql, my sites built on LAMP too, I am WordPress expert, my plugin/themes listed on wordpress official site [login to view URL] since 2008: # [login to view URL] More

£172 GBP in 21 days
(8 Reviews)
4.5
iweblane

Hello... We are iWeblane Softwares, We have read your project description and can see the requirements. We can solve your issue WordPress MySQL optimize, site running slow, large database work. Please award us the pro More

£21 GBP in 3 days
(18 Reviews)
3.5
fsdsolutions1

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

£150 GBP in 3 days
(1 Review)
3.3
relevanceinfo

Hi I am an expert Website Design and Developer. I am ready to optimize the poor page load speed with high speed. Wordpress websites done by me - [login to view URL] [login to view URL] http More

£150 GBP in 3 days
(31 Reviews)
5.0