Level 73
That doesn't tell us anything.
If there is a high load on your database server you better check your queries and make sure you have the proper indexes.
Nov 16, 2021
11
Level 8
Mysql log in laravel - 108 learnc_learnc localhost:46818 learnc_learnc
hi Hello hosting company from which I get services He sent me an email containing this error in which the email mentioned this How to fix this, which MySQLL has a high consumption It should be noted that the project was implemented with Laravel 8
109 learnc_learnc localhost:46820 learnc_learnc Sleep 2 NULL 0.000
108 learnc_learnc localhost:46818 learnc_learnc
Level 8
@Tray2 thanks , Could this be due to poor server host resources?
Level 73
@johnDoe220 Maybe but more likely that you have some queries that needs tuning and some missing indexes. I suggest you install either the laravel debugbar , Clockwork or Telescope in your dev environment and see the performance and memory usage.
Level 8
@Tray2 I installed the Laravel Debugger package, This is a description of queries .
views = 9 , queries = 50, models 48
Do you think it is standard for the home screen? Thanks
Level 73
@johnDoe220 50 queries sounds like a n+1 issue and 48 models is probably a biproduct from that n+1. So no it's not normal. I would check the Eloquent and if you do any calls to relationships in your views.
I suggest looking at eager loading and see if that helps.
https://laravel.com/docs/8.x/eloquent-relationships#eager-loading
Level 8
@Tray2 Thank you
Level 73
@johnDoe220 I can highly recommend this course on Eloquent Performance. It's worth every penny.
Level 8
@Tray2 Due to the sanctions imposed on Iran, unfortunately, it is not possible to buy courses abroad. Thank you very much.
Level 73
@johnDoe220 That sucks. Maybe you can reach out to @reinink on twitter to see if it's possible to get around that somehow.
Level 8
Level 73
@johnDoe220 That is what we are here for, to help those who are in need.
You too.
Please or to participate in this conversation.