Đã Đóng

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:


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.

Kĩ năng: HTML, Linux, MySQL, PHP, WordPress

Xem nhiều hơn: 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

Về Bên Thuê:
( 25 nhận xét ) crawley, United Kingdom

ID dự án: #17029550

21 freelancer đang chào giá trung bình £185 cho công việc này


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 Thêm

£200 GBP trong 5 ngày
(972 Nhận xét)

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 Thêm

£277 GBP trong 3 ngày
(475 Nhận xét)

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 Thêm

£300 GBP trong 7 ngày
(328 Nhận xét)

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 Thêm

£150 GBP trong 3 ngày
(299 Nhận xét)

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 Thêm

£250 GBP trong 3 ngày
(301 Nhận xét)

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 Thêm

£388 GBP trong 10 ngày
(61 Nhận xét)

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 trong 0 ngày
(207 Nhận xét)

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 / Thêm

£150 GBP trong 3 ngày
(112 Nhận xét)

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 Thêm

£200 GBP trong 4 ngày
(106 Nhận xét)

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 Thêm

£222 GBP trong 4 ngày
(36 Nhận xét)

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 Thêm

£150 GBP trong 3 ngày
(63 Nhận xét)

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

£150 GBP trong 3 ngày
(105 Nhận xét)

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 Thêm

£250 GBP trong 3 ngày
(33 Nhận xét)

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 Thêm

£150 GBP trong 6 ngày
(26 Nhận xét)

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 Thêm

£250 GBP trong 3 ngày
(40 Nhận xét)

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 Thêm

£66 GBP trong 1 ngày
(43 Nhận xét)

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] Thêm

£172 GBP trong 21 ngày
(8 Nhận xét)

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 Thêm

£21 GBP trong 3 ngày
(18 Nhận xét)

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 Thêm

£150 GBP trong 3 ngày
(1 Nhận xét)

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 Thêm

£150 GBP trong 3 ngày
(31 Nhận xét)