Why is this laravel eloquent query running so SLOWLY? I have a query running in a Laravel job that executes very slowly and inconsistently. Sometimes it takes 1-2 minutes to fetch the result, while at other times it completes in…
is there a way to exclude the time spent waiting for the lock so I can see only the queries that are actually expensive?
I need help optimizing a query for large data table when I test manually it shows fast , but in my slow query log it is logged as taken 10s+ for some reason . SELECT q.id, q.player_id, q.village_id, q.to_player_id, q.to_village_id,…
I have a site that gets a lot of traffic this time of year (around 50,000 users a day). The traffic goes up every year and all the sites on my server are starting to crash more, apparently because of…
I have a multi-join query that targeting the hospital's chart database. this takes 5~10 seconds or more. This is the visual expain using mysql workbench. The query is below. select sc.CLIENT_ID as 'guardianId', sp.PET_ID as 'patientId', sp.NAME as 'petName' ,…
See my processes screenshots I have ubuntu server 20.0 having following VPS configuration 4 vCPU Cores 8 GB RAM 50 GB NVMe I am also attaching my mysqld.cnf # # The MySQL database server configuration file. # # One can…