wordpress woocommerce database optimization

I have a fairly large wordpress/woocommerce site (many thousands of products), but the database has never been optimized and is showing some errors in the logs with some of the plugins = some of which will need updating. But main task is database optimization first..

You can't just open phpmyadmin to do this, you will need to backup the db.

download the db.

optimize offline.

then upload, and apply new database.

This is the first task milestone. The db is currently 4.5gb in size.

The second task is to update wordpress, woocommerce and ALL the current plugins that are activated. This is the second task, to update all outdated plugins, but ALL existing site functionality must still work on the site. ESPECIALLY the plugins to push items to ebay, this CANNOT break.

The third milestone is to remove these plugins which are not activated without breaking anything, but by removing them completely -

adminer inactive none 1.3.0

ari-adminer inactive available 1.1.5

color-and-image-swatches-for-variable-product-attributes inactive available 1.2.7

Color-and-image-swatches-pro-for-woocoomerce inactive none 2.1

file-manager inactive available 5.0.2

sg-cachepress inactive available 5.0.13

storefy-demo inactive none 1.0.2

tshirtecommerce inactive none 4.2.1

wordpress-importer inactive available 0.6.3

wp-file-manager inactive available 2.4

wpide inactive none 2.4.0

but you must make sure that the image/colour selection changing on product pages works correctly still, example working here -

[login to view URL]

you can click the thumbnails to view different colours, but you can also choose size, then colour from the dropdowns and the picture changes as well.

The last task is to check the phperror logs and fix any issues that may be occuring that are slowing down the site from logging in, uploading new products or just browsing the site.

the logs have entires like these -

[04-Apr-2019 18:54:13 UTC] PHP Warning: reset() expects parameter 1 to be array, string given in /home/ramgfx05/public_html/wp-content/plugins/gdpr/public/partials/[login to view URL] on line 32

[04-Apr-2019 18:54:13 UTC] PHP Warning: key() expects parameter 1 to be array, string given in /home/ramgfx05/public_html/wp-content/plugins/gdpr/public/partials/[login to view URL] on line 33

[04-Apr-2019 18:54:13 UTC] PHP Warning: Invalid argument supplied for foreach() in /home/ramgfx05/public_html/wp-content/plugins/gdpr/public/partials/[login to view URL] on line 36

There are also errors when you go into woocommerce and click to duplicate a product, this is the last milestone to stop errors when copying or duplicating products in woocommerce that is causing the site to hang -

04-Apr-2019 18:30:32 UTC] WordPress database error Lost connection to MySQL server during query for query DELETE FROM cst_options WHERE option_name LIKE '\\_transient\\_%1554402629' ORDER BY option_id LIMIT 1000; made by require_once('wp-admin/[login to view URL]'), do_action('admin_action_duplicate_product'), WP_Hook->do_action, WP_Hook->apply_filters, call_user_func_array, WC_Admin_Duplicate_Product->duplicate_product_action, WC_Admin_Duplicate_Product->product_duplicate, WC_Product->save, WC_Data_Store->create, WC_Product_Variation_Data_Store_CPT->create, WC_Product_Data_Store_CPT->clear_caches, wc_delete_product_transients, wc_delete_product_transients, WC_Cache_Helper::get_transient_version, WC_Cache_Helper::delete_version_transients

to recap, milestones are -

1. optimize database

2. update wordpress, woocommerce and all current plugings - no loss in functionality.

3. remove inactive/unused plugings

4. check php error logs for errors and resolve them to speed up admin login, woocommerce product duplication and copy functions which are causing the site to crash.

Compétences : Administration de Bases de données, MySQL, PHP, WooCommerce, WordPress

en voir plus : wordpress post database linking, repair wordpress sql database, develop wordpress import database, wp optimize review, best wordpress database plugin, speed up woocommerce checkout, large wordpress database, wordpress database repair plugin, optimize db, database plugin wordpress, how to access woocommerce database, wordpress import database, wordpress dvd database, mysql database optimization, transferring ownership wordpress mysql database, wordpress clean database, wordpress post database port joomla, wordpress post database joomla, generate wordpress pages database, wordpress database optimization

Concernant l'employeur :
( 26 commentaires ) crawley, United Kingdom

Nº du projet : #19170116

34 freelance font une offre moyenne de £511 pour ce travail


Hello, I represent Ukrainian based IT-company Webbook Inc that provides services in the IT-sphere for international business. Our team can help you with woocommerce site and database, update wordpress, woocommerce and Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% GBP en 10 jours
(225 Commentaires)

Hi there, I have gone through your project detail and I have the Exact Match skills as per the current project you are looking now. Also take pride of our 5.0/5.0 Rating-Profile with 600+ Nice-Reviews with 99% Co Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% GBP en 10 jours
(611 Commentaires)

Dear Client, Nice to meet you in freelancer,Hope you feeling awesome on the blessing of God.I read your job description the requirement is inline of my skills.I am assisting to deliver the 100% quality of work withi Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% GBP en 11 jours
(621 Commentaires)

Greetings! My name is Neha. We would love to have the opportunity to discuss your project with you. We are in the top 4% of freelancers based on our earnings and reviews. We specialize in: Plugin MySQL Woo-Comm Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% GBP en 10 jours
(375 Commentaires)

Hello There. I will do all mentioned milestones for your website, and optimize the website for better performance. Specific to WooCommerce, I have maintained websites with 30,000 - 70,000 products which has minut Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% GBP en 10 jours
(266 Commentaires)

Hi Peter, This is pardusIT from Turkey. I have worked for you several times regarding to server projects. I do would like to work on this project to optimize and speed up your server. As mentioned in lancer messaging Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% GBP en 10 jours
(241 Commentaires)

Hey, I am Salman and I will be quite delighted to assist you with your website project. I am sure before you talk any further, you would like to see my work first. [login to view URL] [login to view URL] htt Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% GBP en 10 jours
(148 Commentaires)

Hi No problems I am an expert in woocommerce, wordpress, php , javascript, jquery, css, html, servers, emails, domains, mysql, json, ajax, xml I know all what is required in your project I have more then 7 years of Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% GBP en 3 jours
(183 Commentaires)

Hello, I am interested in working for you. I gone through your requirements and provide you professional quality work. Thanks Raj

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% GBP en 15 jours
(143 Commentaires)

Hello, I've read your project description and I want to tell you that I can create wordpress woo commerce database optimization for you as per your requirements with complete mobile responsive design. Lets have a qu Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% GBP en 15 jours
(152 Commentaires)

I can help you to setup or modify e-commerce site for your products, and also make customizations as per your needs And i will add several payment methods for your customer if you have specific in mind than lmk i wil Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% GBP en 10 jours
(194 Commentaires)

Hi there, I've gone through the post description carefully and ready to start work on this project. Requirements are very clear but please come over the chat so that i can get more requirements if remaining. I am Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% GBP en 10 jours
(67 Commentaires)

HI, first of all, I would say you have described the project very clearly and all of them are understandable. only question which i have is about only " image/colour selection" part. can you please recap it for me ? Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% GBP en 3 jours
(275 Commentaires)

We are wordpress, woocommerce expert team...... We are ready for the following tasks,...... 1. optimize database 2. update wordpress, woocommerce and all current plugings - no loss in functionality. 3. remove Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% GBP en 21 jours
(177 Commentaires)

Hi, I am specoalizing on big sites. Lets discuss your project. My programming experience is 9 years. I did projects both in the development team and alone. I am pleased to perform work of any complexity and type. Be Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% GBP en 8 jours
(29 Commentaires)

PHP/C# .NET/JS/CSS/HTML Expert. Freelance developer from Argentina, more than 10 years of experience on web development. Wordpress, Magento, Drupal, Joomla, Prestashop, Woocommerce, CMS Sitefinity, ZNode storefront, e Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% GBP en 10 jours
(88 Commentaires)

Hello, I am a well experienced wordpress and woocommerce developer.I am extremely carefully read through your job description. I know well how to update all of these things using your db. I already solve this type o Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% GBP en 10 jours
(44 Commentaires)

Hello, I have gone through your job posting and become very much interested to work with you. I am an expert in this field. I have already completed several projects like this. For evidence you can see my profile. Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% GBP en 10 jours
(52 Commentaires)

Hello! We have extensive experience with Wordpress and we can optimize database of your existing Wordpress website. Our skills: CMS Wordpress, HTML, CSS, Javascript, Jquery, Bootstrap, Php, MySQL, Adobe Photosho Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% GBP en 15 jours
(18 Commentaires)

Hello! I have read your proposal and understood what you want. I'm a professional in word press/Woo-commerce. I'm a specialist in Woo-commerce/Word press. I have more than 8 years experience in word press. I'm waiting Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% GBP en 10 jours
(66 Commentaires)