Level 75
See if host had a ddos attack.
1 like
Jun 1, 2021
32
Level 1
Website is slowed by 40000ms every time
Hello, I have a problem : I have a website that is laravel based and out of the blue the website became extremely slow. I noticed that no matter which sub-url I open, it is always delayed by 40000ms. Does anyone have an idea what the problem could be ?
Level 1
@jlrdw how ? xD
Level 75
Contact the tech support, they would know. But besides that, it was running fine and suddenly got slow without any changes you made.
1 like
Level 1
@jlrdw I contacted them and they said that there was no ddos attack
Level 75
Check your logs and things like that, are you being hit by a bunch of spam. If your site was working normally and without any changes slowed down you really need to investigate all of the logs.
1 like
Level 1
@jlrdw That doesn't seem to be the case either
Level 73
Other than the mentioned possibility of a ddos attack it might be that your site recently reached a threshold in your database and now your queries runs slow because the received bad execution plans.
I suggest you check your queries and make sure that your indexes are correct. If you are storing large chunks of data in clobs or blobs it might be a good idea to reorg those tables.
1 like
Level 1
@tray2 I checked my queries, it takes around 2.53ms so I doubt that that is the problem.
Level 1
What I find strange is that every request seems to take exactly 40000ms more than it should.
Level 73
Have you added any throttling?
Have you asked the provider to check the steal on the server? sar
1 like
Level 1
the only thing that loads normally is /telescope. I tried to make a path that only echos "test" but even that takes 40057ms
Level 1
@tray2 no I haven't, I asked my provider but they can't find anything on their side
Level 54
if you put a basic html file in your public directory eg test.html does that also take ages to respond?
have you also checked network tab on chrome as that may uncover any issues.
1 like
Level 1
@automica I just tried it. No it opens immediately
Level 54
ok. so how are you accessing your db server? are you connecting to it as
- localhost
- 127.0.0.1 or
- some IP?
1 like
Level 1
@automica 127.0.0.1
Level 54
you might want to check with your ISP if that is correct, as you might find you need to swap it for localhost.
1 like
Level 1
do you mean that in my .env I should change "DB_HOST=127.0.0.1" to "DB_HOST=localhost" ?
Level 75
What host is this?
Level 1
What do you mean ?
Level 75
By host I meant hosting company, is it digital ocean, aws, etc.
Level 54
Actually, as you say this behaviour is 'out of the blue' - can you see any reason in developer tools? if you look on network, it could be that you are trying to load an external asset (eg font or js file) which is no longer available and its trying for 40s before timing out.
Are you able to share a link to your site so we can inspect?
I would hang off any DB changes now as you said its not always been this slow.
Level 1
The website is readmanga.tw
Level 54
seems you have a redirect which is taking its time (40s)
can you disable https and see if that speeds up the response?
Level 1
if you go to the url : readmanga.tw/blob, it just echoes "test", yet it still takes 40 seconds
Level 1
what kind of redirect do I have ? I tried http://readmanga.tw but it is still the same
Level 54
you have a redirect which switches from http to https and thats the first cause of slowness.
Your http://readmanga.tw will eventually redirect to https://readmanga.tw
You'll see this in your Chrome Network tab as 2nd request.
I notice you are also using Cloudflare, so it might be worth disabling that temporarily.
Level 1
do you have discord/skype or something like that so I can share my screen and show you everything in detail ?
Level 54
I’m not really in a position to do screen sharing as I’m working off my phone at the moment.
My best guess if your issue has only just started happening, would be a fault with cloudflare. If you can doable that service that would help check if that is the issue, especially if cloudflare is managing secure redirec.
Level 1
Nothing seemed to have worked, so I re uploaded an older version and now the website is blank.
Level 54
Check your logs to see if you are missing any files.
Did you manage to doable the redirect to https?
Level 1
how can the logs indicate if I am missing any files ? No, I am still trying to make my page show something. It is still blank
Please or to participate in this conversation.