Slow PHP response speed

PHP slow response speed: lighttpd + fastcgi + php + mysql server configuration

8-core CPU less than 50 GB memory

Load less than 0.2
Why is the response so slow?
It takes 4-5 seconds to query a task.
No, please give me some advice.

Reply to discussion (solution)

We recommend that you provide the SQL statement for this query and the data size of the table structure.

We recommend that you provide the SQL statement for this query and the data size of the table structure.

I think there is nothing to do with the amount of data. the amount of data is not big. a maximum of a few 100,000 items are always running for a while, so it's strange to slow down.

You 'd better check the SQL statement.

How long have you been talking about?

Sometimes the accumulation of lock tables will be slow.

You 'd better check the SQL statement.

How long have you been talking about?

Sometimes the accumulation of lock tables will be slow.

You think there is a problem with SQL, right? I have connected to more than a dozen libraries. the php-fpm restart takes 10 minutes.

This is not the case if the SQL problem occurs. it is not a database.

I have no idea about my own ideas.

I can't figure out where the problem is.

You 'd better check the SQL statement.

How long have you been talking about?

Sometimes the accumulation of lock tables will be slow.

You think there is a problem with SQL, right? I have connected to more than a dozen libraries. the php-fpm restart takes 10 minutes.

This is not the case if the SQL problem occurs. it is not a database.

I have no idea about my own ideas.

I can't figure out where the problem is.
Memory cpu, do you have a match? Process and port occupation. what you run is not very clear, and it is difficult to know the problem.

You 'd better check the SQL statement.

How long have you been talking about?

Sometimes the accumulation of lock tables will be slow.

You think there is a problem with SQL, right? I have connected to more than a dozen libraries. the php-fpm restart takes 10 minutes.

This is not the case if the SQL problem occurs. it is not a database.

I have no idea about my own ideas.

I can't figure out where the problem is.
Memory cpu, do you have a match? Process and port occupation. what you run is not very clear, and it is difficult to know the problem.

I found the problem. several mysql instances are under too much pressure. thank you.