Server Speed and dB. Optimization Service needed!

Concluído Postado há 6 anos Pago na entrega
Concluído Pago na entrega

Hello

System:

Linux

VPS 4GB Ram

There are 2 issues with your site. One the internal one. Please check the following.

mysql 286% CPU /usr/sbin/mysqld --basedir/usr --datadir/var/lib/mysql

mysql 285% CPU /usr/sbin/mysqld --basedir/usr --datadir/var/lib/mysql

mysql 278% CPU /usr/sbin/mysqld --basedir/usr --datadir/var/lib/mysql

xxxxxxxxx [url removed, login to view] 50.5% CPU /opt/cpanel/ea-php56/root/usr/bin/php-cgi

xxxxxxxxx [url removed, login to view] 46.7% CPU /opt/cpanel/ea-php56/root/usr/bin/php-cgi

xxxxxxxxx [url removed, login to view] 44.0% CPU /opt/cpanel/ea-php56/root/usr/bin/php-cgi

These are first 6 Process status only. This huge load does not allow necessary processes to work as expected such as DNS or HTTP.

Second issue is the DNS setting where you are using couldflare URL as CNAME. When you access [url removed, login to view] it first redirect you to www version then loads [url removed, login to view] canonically. Since the server DNS is not getting enough resource to use, it takes time to resolve twice, one to redirect and another to CNAME load. Because when you load the site directly with www, the load speed 88% faster.

Load time for the server HTTP 204 ms

Load time for [url removed, login to view] 1.34 s

Load Time for [url removed, login to view] 11.37 s

Regards,

Don

Administração de Bancos de Dados Desenvolvimento de Banco de Dados Programação de Banco de Dados Linux phpMyAdmin

ID do Projeto: #15008505

Sobre o projeto

5 propostas Projeto remoto Ativo em há 6 anos

Concedido a:

RWHTech

The poor server definitely needs some optimization, and I can handle that for you. I'll optimize mysql, PHP and Apache so your WHM server's load goes down to a normal level. Relevant Skills and Experience I run a Mais

$40 USD em 1 dia
(43 Comentários)
5.2

5 freelancers estão ofertando em média $106 nesse trabalho

vinaysinghh

I am mysql dba having more then 10 yrs of experience and I can do optimization which definitely give good performance

$55 USD em 1 dia
(33 Comentários)
4.9
Gauravsingh9828

Hello, I'll audit your server, find loop holes and will fix all server side issues. I have more than 3 years experience as a linux admin. Thank you

$50 USD em 1 dia
(26 Comentários)
4.6
GuillermoVelezSa

I can help you optimzing your server. Probably here requires to tune MySQL and probably upgrade to a faster php version. thanks, Relevant Skills and Experience I have optimized several sites, review profile Propose Mais

$35 USD em 1 dia
(0 Comentários)
0.0