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 mysql phpbb3, optimize joomla, optimize php script, mysql, database administration, database development, smartphone optimize webpage, best place optimize website, optimize xcache, optimize database phpbb3, optimize oscommerce database, optimize web site search engines, optimize driving route online, optimize mysql queries, oscommerce optimize tables, optimize centos, import mysql database wordpress, integrating existing mysql database wordpress, transferring ownership wordpress mysql database, optimize large mysql database

Información del empleador:
( 110 comentarios ) Woolwich Township, 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
(36 comentarios)

8 freelancers están ofertando el promedio de $335 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
(430 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
(57 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
(87 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
(38 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
(9 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)

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)