Ditutup

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.

Kemahiran: HTML, Linux, MySQL, PHP, Wordpress

Lihat lagi: 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

Tentang Majikan:
( 25 ulasan ) crawley, United Kingdom

ID Projek: #17029550

21 pekerja bebas membida secara purata £185 untuk pekerjaan ini

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 Lagi

£200 GBP dalam 5 hari
(972 Ulasan)
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 Lagi

£277 GBP dalam 3 hari
(475 Ulasan)
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 Lagi

£300 GBP dalam 7 hari
(328 Ulasan)
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 Lagi

£150 GBP dalam 3 hari
(299 Ulasan)
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 Lagi

£250 GBP dalam 3 hari
(301 Ulasan)
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 Lagi

£388 GBP dalam 10 hari
(61 Ulasan)
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 dalam 0 hari
(207 Ulasan)
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 / Lagi

£150 GBP dalam 3 hari
(112 Ulasan)
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 Lagi

£200 GBP dalam 4 hari
(106 Ulasan)
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 Lagi

£222 GBP dalam 4 hari
(36 Ulasan)
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 Lagi

£150 GBP dalam 3 hari
(63 Ulasan)
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 dalam 3 hari
(105 Ulasan)
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 Lagi

£250 GBP dalam 3 hari
(33 Ulasan)
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 Lagi

£150 GBP dalam 6 hari
(26 Ulasan)
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 Lagi

£250 GBP dalam 3 hari
(40 Ulasan)
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 Lagi

£66 GBP dalam sehari
(43 Ulasan)
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] Lagi

£172 GBP dalam 21 hari
(8 Ulasan)
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 Lagi

£21 GBP dalam 3 hari
(18 Ulasan)
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 Lagi

£150 GBP dalam 3 hari
(1 Ulasan)
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 Lagi

£150 GBP dalam 3 hari
(31 Ulasan)
5.0