Welcome to Centmin Mod Community
Register Now

Website requests is very slow

Discussion in 'System Administration' started by Johnny, Nov 30, 2020.

  1. Johnny

    Johnny New Member

    3
    0
    1
    Nov 26, 2020
    Ratings:
    +0
    Local Time:
    4:48 AM
    Hi,
    Firstly, I'm so sorry if my English is difficult to understand as I'm not a native speaker and newbie in this field.
    I'm building 2 websites that they get some information from other websites by a request. One website (Site 1) is hosting on a shared-hosting (2GB RAM, 1.2 CPU Cores) and another (Site 2) is hosting on a vps (2GB RAM, 1 Core).
    The problem is Site 1 need only 10-15 seconds to finish the request above, but Site 2 need 40-60 seconds.
    I try to figure out, and I think MySQL database is slow.
    I try some test that I learn from this forum and here is the result:

    Code:
    # dd if=/dev/zero of=test bs=64k count=16k conv=fdatasync && rm -rf test
    16384+0 records in
    16384+0 records out
    1073741824 bytes (1.1 GB) copied, 144.894 s, 7.4 MB/s
    
    # mysqladmin ver
    mysqladmin  Ver 9.1 Distrib 10.3.27-MariaDB, for Linux on x86_64
    Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.
    
    Server version          10.3.27-MariaDB
    Protocol version        10
    Connection              Localhost via UNIX socket
    UNIX socket             /var/lib/mysql/mysql.sock
    Uptime:                 3 days 23 hours 54 min 26 sec
    
    Threads: 11  Questions: 3082707  Slow queries: 26375  Opens: 80  Flush tables: 1  Open tables: 74  Queries per second avg: 8.928
    I hope you can help me solve this problems.
    Thank you very much!

     
  2. eva2000

    eva2000 Administrator Staff Member

    55,155
    12,249
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +18,825
    Local Time:
    7:48 AM
    Nginx 1.27.x
    MariaDB 10.x/11.4+
    Who's your web hosts? Could just be poor performing VPS /web host providers too. You can use hourly billed VPS providers like Upcloud, DigitalOcean, Vultr, Linode to spin up a test VPS with Centmin Mod and a copy of your site and test and compare performance and speed too.

    Take a read of WebPerf - PageSpeed - Google Page Speed Insights and Google Core Web Vital metrics and use the page speed testing tools mentioned to test your sites and see what they reveal. Geographical distance matters too, so use testing tools in various country's servers to see if there's a difference.
     
  3. Johnny

    Johnny New Member

    3
    0
    1
    Nov 26, 2020
    Ratings:
    +0
    Local Time:
    4:48 AM
    I don't know why but I got 98 on Google pagespeed.
    [​IMG]