Cancelado

Database Server Optimizing service

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

Habilidades: Administração de Bancos de Dados, Desenvolvimento de Banco de Dados, Programação de Banco de Dados, MySQL, Arquitetura de software

Ver mais: database journal pdf, research papers on database management system, percona's tool, mysqltuner percona, percona settings, mysql performance, database management system journal pdf, mysql optimization wizard, company service fee setting configure linux server, wincc flexible database server download, import mysql database server, bad public user name password database server error, migrating mysql database server php, open source sftp server windows service, synchronize sql database via web service

Acerca do Empregador:
( 5 comentários ) renton, United States

ID do Projeto: #15008491