Optimize MySQL Database wihich includes over 400 cloned wordpress mutlsites


My database has been having a very high load that has been causing performance issues lately. I spoke with Host Gator support and here is one of the statements that were made:

"Having a large amount of sites set up that way under a single database without proper optimization to the queries and database itself can cause issues. Looking over the queries, and as you can see, there are multiple requests to different tables on the database (from different sites within your multi-site setup) that seem to be causing the issues. The large amount of update requests and data requests from the database is causing issues and a high load. "

The tech support was held via chat which I will include a transcript attached for you to review and better understand the specific issues.


Habilidades: Administración de bases de datos, Desarrollo de base de datos, MySQL, WordPress

Ver más: optimize my wordpress website, optimize my ecommerce prestashop, wordpress form post data mysql database, wordpress limit number posts mysql database, create mysql database wordpress format import, import mysql database posts wordpress, post wordpress mysql database, import wordpress posts categories mysql database, wordpress transferring site live move mysql database, wordpress blog mysql database, speeding mysql database optimize, import posts mysql database wordpress, clean mysql database wordpress, optimize large mysql database, transferring ownership wordpress mysql database, integrating existing mysql database wordpress, import mysql database wordpress, optimize centos, oscommerce optimize tables, optimize mysql queries, optimize driving route online, optimize web site search engines, optimize oscommerce database, optimize database phpbb3, optimize xcache

Información del empleador:
( 59 comentarios ) Sheridan, United States

Nº del proyecto: #12135702

Adjudicado a:


Hello There, Hope you're doing well. I request you to contact me further in order to have a detailed discussion on your project related requirements. Please refer my portfolio below for more details. Waiting for Más

$200 USD en 5 días
(24 comentarios)

9 freelancers están ofertando el promedio de $309 para este trabajo


We are highly interested to work with you on this project and can assure you quality results ready to start immediately some of our developed websites are listed below Wordpress: http://www.wilsontenniscamps.c Más

$526 USD en 10 días
(374 comentarios)

hey!, I've a question about your project. Are you free to discuss? I am interested in your project. Please reply me. Thank You.

$300 USD en 3 días
(37 comentarios)

Are you using wordpress with multisites? If yes, then the only one possible way to make it solve is, to make few more databases and shift some sites to them. Hi, I am Gaurav panwar (PHP, MVC, WordPress GURU, Design Más

$666 USD en 7 días
(19 comentarios)

gone through the chat transcript. It seems to be issue with some database's majorly with the helo_wp658 database and few others. which can be eliminated by proper optimizatuion. m

$100 USD en 3 días
(12 comentarios)

I am writing this proposal in order to work for you in Software and Web Development. We are highly trained professional developers seeking to freelance and earn online. Having a flair in programming and development I Más

$155 USD en 3 días
(4 comentarios)

Dear Hiring Manager, I read through the job details and I am confident that my skills are an excellent fit with this position. I can help you to achieve the results that you are asking. I am also Upwork Top Ra Más

$494 USD en 7 días
(5 comentarios)

Hello Russell, I have carefully viewed given attachments and links given by the technical support person in this attachment. It seems that following 11 tables are in focus: wplj_501_options wplj_467_options wplj Más

$216 USD en 4 días
(0 comentarios)

Hello we are offering you to award this project to us. We will provide you a website with an outstanding design. We do works on 3 Steps 1st we do the design then we will show it to you . if you chose it then we w Más

$122 USD en 3 días
(0 comentarios)