slow mysql connection on localhost

aaP_davidsongviolao

Hi, I have a system that I'm developing in laravel. using it on my local machine, connecting via ip to the database on my VPS, the listing request takes 4s to bring the data, using 5% of the machine's CPU, however when I put the system into production on the VPS connecting to the internally it takes 15s to bring the data, using 52% CPU. What could be happening? this is impacting a lot on the experience of using the system.

aaPanel_thisyear

aaP_davidsongviolao Hello, 52% CPU. You need to check to see which processes are consuming. You can check and analyze the following commands on the server command line

yum -y install htop && htop

As for the slow request, F12 can analyze to see which link takes more time.

aaP_davidsongviolao

aaPanel_thisyear It slows down just when laravel makes the query to the database. When there is little data, it is done quickly and without high consumption, but when it is a query with more than 1000 records, it already follows the behavior mentioned above.

one_group

i have problem the same