Getting some slowness

[Daehawk]

Seeing some random dragging occurring. When I first tried to load the site it sat and sat then timed out. I tried again and right before time out it loaded up.

I then tried to post in the sad pet thread about my little rat a 2nd time and after hitting submit it sat a min then nothing happened. The blue color of the submit button even went off. But no error. I clicked again and it loaded.

Seems good now.

[stessier]

Same - intermittent throughout the afternoon. Thought it was me.

[Daehawk]

It could be me as a speedtest I use timed out but then worked. Shrug.

[Daehawk]

Slooow postings now.

[Blackhawk]

I'm noticing it now, too.

[$iljanus]

Intermittent slow downs this morning. Wasn't sure if it was a tapatalk or forum issue.

[Zaxxon]

Same, on web so not just Tapatalk.

[FishPants]

Next time it happens please run a traceroute and paste it into a code block for me please, I didn't see this until now - and currently 'top' isn't showing anything chewing up memory or CPU. Wondering if it was not network pathing (especially if you had a speedtest timeout).

[Blackhawk]

Next time it happens please run a traceroute and paste it into a code block for me please, I didn't see this until now - and currently 'top' isn't showing anything chewing up memory or CPU. Wondering if it was not network pathing (especially if you had a speedtest timeout).

*cough* Could you give us non-IT folks the ten second how-to?

[FishPants]

"tracert www.octopusoverlords.com" -- it's common for your router and last hop to be stars (you will probably want to mask out your external IP address as well).

Another option is to go to speedtest.net and hit "change server", search on "OVH" and pick "OVH Cloud, Beauharnois, QC" which is where our server resides -- that won't tell ou where the problem is, but at least it tells you what your current throughput is to the data centre versus your normal speedtest. Helps me understand if it's something on the server vs network internets.

[Daehawk]

I myself know what traceroute is but I am in the dark on pasting a code block.

But here's mine right now during just a very slight pause in posting after I click.

Spoiler:

Tracing route to octopusoverlords.com [167.114.100.121]
over a maximum of 30 hops:

1 <1 ms <1 ms <1 ms router.asus.com
2 * * * Request timed out.
3 14 ms 8 ms 13 ms dtr02clevtn-tge-0-7-0-5.clev.tn.charter.com [96.
34.68.97]
4 19 ms 15 ms 7 ms 096-034-012-161.biz.spectrum.com [96.34.12.161]

5 12 ms 12 ms 14 ms 096-034-012-156.biz.spectrum.com [96.34.12.156]

6 23 ms 15 ms 18 ms crr02spbgsc-bue-401.spbg.sc.charter.com [96.34.6
9.254]
7 21 ms 24 ms 15 ms bbr01spbgsc-bue-4.spbg.sc.charter.com [96.34.2.5
0]
8 27 ms 23 ms 23 ms bbr01gnvlsc-bue-800.gnvl.sc.charter.com [96.34.0
.134]
9 31 ms 39 ms 31 ms bbr01aldlmi-tge-0-0-0-13.aldl.mi.charter.com [96
.34.0.161]
10 32 ms 25 ms 31 ms bbr01ashbva-bue-2.ashb.va.charter.com [96.34.3.1
59]
11 27 ms 30 ms 24 ms ash-1-a9.va.us [142.44.208.118]
12 33 ms 31 ms 28 ms be100-1039.nwk-1-a9.nj.us [198.27.73.202]
13 43 ms 40 ms 46 ms be102.bhs-g1-nc5.qc.ca [198.27.73.204]
14 * * * Request timed out.
15 46 ms 42 ms 40 ms be50-5.bhs-3a-a9.qc.ca [198.27.73.92]
16 45 ms 40 ms 39 ms octopusoverlords.com [167.114.100.121]

[stessier]

I myself know what traceroute is but I am in the dark on pasting a code block.

But here's mine right now during just a very slight pause in posting after I click.

It's this for future reference.

Code: Select all

Tracing route to octopusoverlords.com [167.114.100.121]
over a maximum of 30 hops:

  1    <1 ms    <1 ms    <1 ms  router.asus.com 
  2     *        *        *     Request timed out.
  3    14 ms     8 ms    13 ms  dtr02clevtn-tge-0-7-0-5.clev.tn.charter.com [96.34.68.97]
  4    19 ms    15 ms     7 ms  096-034-012-161.biz.spectrum.com [96.34.12.161]
  5    12 ms    12 ms    14 ms  096-034-012-156.biz.spectrum.com [96.34.12.156]
  6    23 ms    15 ms    18 ms  crr02spbgsc-bue-401.spbg.sc.charter.com [96.34.69.254]
  7    21 ms    24 ms    15 ms  bbr01spbgsc-bue-4.spbg.sc.charter.com [96.34.2.50]
  8    27 ms    23 ms    23 ms  bbr01gnvlsc-bue-800.gnvl.sc.charter.com [96.34.0.134]
  9    31 ms    39 ms    31 ms  bbr01aldlmi-tge-0-0-0-13.aldl.mi.charter.com [96.34.0.161]
 10    32 ms    25 ms    31 ms  bbr01ashbva-bue-2.ashb.va.charter.com [96.34.3.159]
 11    27 ms    30 ms    24 ms  ash-1-a9.va.us [142.44.208.118]
 12    33 ms    31 ms    28 ms  be100-1039.nwk-1-a9.nj.us [198.27.73.202]
 13    43 ms    40 ms    46 ms  be102.bhs-g1-nc5.qc.ca [198.27.73.204]
 14     *        *        *     Request timed out.
 15    46 ms    42 ms    40 ms  be50-5.bhs-3a-a9.qc.ca [198.27.73.92]
 16    45 ms    40 ms    39 ms  octopusoverlords.com [167.114.100.121]

[Isgrimnur]

Code: Select all

  1     1 ms    <1 ms    <1 ms  192.168.1.1
  2     *        *        *     Request timed out.
  3    10 ms    10 ms     8 ms  159-111-144-218.res.spectrum.com [159.111.144.218]
  4    15 ms    15 ms    15 ms  096-034-113-254.biz.spectrum.com [96.34.113.254]
  5    31 ms    15 ms    15 ms  bbr01dllstx-bue-2.dlls.tx.charter.com [96.34.2.32]
  6    28 ms    26 ms    34 ms  bbr01blvlil-bue-805.blvl.il.charter.com [96.34.0.16]
  7    28 ms    27 ms    28 ms  bbr01olvemo-bue-3.olve.mo.charter.com [96.34.0.14]
  8    39 ms    39 ms    39 ms  bbr02chcgil-bue-2.chcg.il.charter.com [96.34.0.12]
  9    41 ms    42 ms    34 ms  prr01chcgil-bue-4.chcg.il.charter.com [96.34.3.11]
 10    56 ms    56 ms    57 ms  be100-101.chi-1-a9.il.us [178.32.135.96]
 11    64 ms    64 ms    71 ms  be103.bhs-g1-nc5.qc.ca [198.27.73.206]
 12     *        *        *     Request timed out.
 13    71 ms    63 ms    63 ms  be50-5.bhs-3a-a9.qc.ca [198.27.73.92]
 14    64 ms    62 ms    69 ms  octopusoverlords.com [167.114.100.121]

[Blackhawk]

"tracert www.octopusoverlords.com"

After failing twice, I discovered that this is performed in a command window.

Code: Select all

 1     2 ms     2 ms     1 ms  10.0.0.1
  2    13 ms    11 ms    17 ms  96.120.112.149
  3    13 ms    29 ms    12 ms  96.110.168.49
  4    12 ms    15 ms    11 ms  96.108.120.85
  5    19 ms    16 ms    19 ms  96.108.120.161
  6    25 ms    30 ms    23 ms  be-3-ar01.area4.il.chicago.comcast.net [68.86.188.181]
  7    26 ms    25 ms    24 ms  be-32231-cs03.350ecermak.il.ibone.comcast.net [96.110.40.57]
  8    26 ms    26 ms    24 ms  be-2304-pe04.350ecermak.il.ibone.comcast.net [96.110.37.42]
  9    23 ms    27 ms    30 ms  chi-1-a9.il.us [142.44.208.125]
 10    43 ms    44 ms    42 ms  be103.bhs-g1-nc5.qc.ca [198.27.73.206]
 11     *        *        *     Request timed out.
 12    43 ms    54 ms    41 ms  be50-5.bhs-3a-a9.qc.ca [198.27.73.92]
 13    40 ms    43 ms    41 ms  octopusoverlords.com [167.114.100.121]

[The Meal]

Local (ping: 13 ms)


Quebec (ping: 55 ms):

[Moat_Man]

Local (ping: 13 ms)


Quebec (ping: 55 ms):

I dunno capt'n. I'm givin' the hamsters all the maple syrup they can handle...

[FishPants]

Well so far I don't see anything unusual on the traces posted nor the speed tests.. I'll look in logs, but I'm not sure where to start.

[stessier]

I ran these right after getting a gateway timeout, but these traces make it look like it's actually me.

Code: Select all

Tracing route to octopusoverlords.com [167.114.100.121]
over a maximum of 30 hops:

  1    <1 ms    <1 ms    <1 ms  192.168.1.1
  2     *        *        *     Request timed out.
  3    17 ms    18 ms    14 ms  crr12gnvlsc-tge-0-1-0-4.gnvl.sc.charter.com [96.34.92.28]
  4    15 ms    18 ms    14 ms  crr01gnvlsc-bue-100.gnvl.sc.charter.com [96.34.67.12]
  5    31 ms    19 ms    21 ms  96.34.2.112
  6    37 ms    28 ms    29 ms  bbr01aldlmi-tge-0-0-0-13.aldl.mi.charter.com [96.34.0.161]
  7    29 ms    26 ms    39 ms  bbr01ashbva-bue-2.ashb.va.charter.com [96.34.3.159]
  8    23 ms    31 ms    25 ms  ash-1-a9.va.us [142.44.208.118]
  9    24 ms    23 ms    24 ms  be100-1039.nwk-1-a9.nj.us [198.27.73.202]
 10    35 ms    41 ms    32 ms  be102.bhs-g1-nc5.qc.ca [198.27.73.204]
 11     *        *        *     Request timed out.
 12    40 ms    45 ms    50 ms  be50-5.bhs-3a-a9.qc.ca [198.27.73.92]
 13    41 ms    49 ms    43 ms  octopusoverlords.com [167.114.100.121]

Code: Select all

Tracing route to octopusoverlords.com [167.114.100.121]
over a maximum of 30 hops:

  1    <1 ms    <1 ms    <1 ms  192.168.1.1
  2     *        *        *     Request timed out.
  3    31 ms    49 ms    15 ms  crr12gnvlsc-tge-0-1-0-4.gnvl.sc.charter.com [96.34.92.28]
  4    16 ms    21 ms    29 ms  crr01gnvlsc-bue-100.gnvl.sc.charter.com [96.34.67.12]
  5    24 ms    21 ms    21 ms  bbr01gnvlsc-bue-3.gnvl.sc.charter.com [96.34.2.112]
  6    24 ms    28 ms    29 ms  bbr01aldlmi-tge-0-0-0-13.aldl.mi.charter.com [96.34.0.161]
  7    35 ms    49 ms    23 ms  bbr01ashbva-bue-2.ashb.va.charter.com [96.34.3.159]
  8    27 ms    36 ms    28 ms  ash-1-a9.va.us [142.44.208.118]
  9    48 ms    50 ms    30 ms  be100-1039.nwk-1-a9.nj.us [198.27.73.202]
 10    47 ms    47 ms    39 ms  be102.bhs-g1-nc5.qc.ca [198.27.73.204]
 11     *        *        *     Request timed out.
 12    40 ms    73 ms    43 ms  be50-5.bhs-3a-a9.qc.ca [198.27.73.92]
 13    42 ms    42 ms    38 ms  octopusoverlords.com [167.114.100.121]

Edit: Posting this took over 30s. Weird.

[FishPants]

It's common for your router or cable modem to not show up in the traceroute (the second hop being * * *) -- also that hop 11 into OVH, normal screening firewall that won't respond to the trace. The rest of the hops look good, really we are looking for some long ping times in the middle that would indicate problems.

I did remove some variables on the mariadb config and cycle the daemon (that was probably the SQL gateway error you saw as it takes a moment to quiesce the database and restart it/load it back into memory).

Keeping an eye on it, I installed some other linux tools to help me parse logs easier, and I'm not seeing much that would indicate a performance issue yet.

[stessier]

Ah - well it's good you are in charge. Thanks again for all the work!