Couple of “User sleep” queries

Hello, checked the server mysql processes list and see this:

+----------+---------+-----------+-------------------------+---------+--------+------------+-----------------------------------------------------------------------------------------------------------------------------+
| Id       | User    | Host      | db                      | Command | Time   | State      | Info                                                                                                                        |
+----------+---------+-----------+-------------------------+---------+--------+------------+-----------------------------------------------------------------------------------------------------------------------------+
| 32857083 | root    | localhost | xxxxxxxxxxxxxxxxxxxxxx   | Query   | 291593 | User sleep | select * from wp_WP_SEO_Redirection where enabled=1 and cat='link' and blog='1' and regex='' and (redirect_from='/?p=856860 |
| 32864487 | root    | localhost | xxxxxxxxxxxxxxxxxxxxxx   | Query   | 290720 | User sleep | select * from wp_WP_SEO_Redirection where enabled=1 and cat='link' and blog='1' and regex='' and (redirect_from='/?p=856860 |
| 36589729 | root    | localhost | NULL                     | Query   |      0 | init       | show full processlist                                                                                                       |
| 36591481 | root    | localhost | xxxxxxxxxxxxxxxxxxxxxx   | Sleep   |      1 |            | NULL                                                                                                                        |
| 36591487 | root    | localhost | xxxxxxxxxxxxxxxxxxxxxx   | Sleep   |      0 |            | NULL                                                                                                                        |
| 36591493 | root    | localhost | xxxxxxxxxxxxxxxxxxxxxx   | Sleep   |      0 |            | NULL                                                                                                                        |

User sleep:

User sleep means a query is currently running that uses the SLEEP() miscellaneous function.

Any suggestion to fix this to happen in the future?

• This topic was modified 7 years, 5 months ago by paamayim.