What is the MYSQL Sleep Query?

A sleep query is the query that waits for the timeout to terminate

[{"selector":"#anim-89343846-ee2d-40a3-a784-022d586efc47 [data-leaf-element=\"true\"]","keyframes":{"transform":["translate3d(-31.249999886225726%, 0, 0) translate(-25%, 0%) scale(1.5)","translate3d(0%, 0, 0) translate(0%, 0%) scale(1)"]},"delay":0,"duration":2000,"fill":"forwards"}]

Effects of a large number of MYSQL query – sleep :

[{"selector":"#anim-859a8eb4-76f5-4637-b654-b7ba5639b99a [data-leaf-element=\"true\"]","keyframes":{"transform":["translate(-25%, 0%) scale(1.5)","translate(0%, 0%) scale(1)"]},"delay":0,"duration":2000,"easing":"cubic-bezier(.3,0,.55,1)","fill":"forwards"}]

1. Increased consumption of CPU and memory resources

[{"selector":"#anim-0b2b50a0-203e-44f1-bb57-b5c9302f8c8b [data-leaf-element=\"true\"]","keyframes":{"transform":["translate(0%, 0%) scale(1.5)","translate(0%, 0%) scale(1)"]},"delay":0,"duration":2000,"easing":"cubic-bezier(.3,0,.55,1)","fill":"forwards"}]

2. Slowing down of server.

[{"selector":"#anim-e05b3119-8491-4f37-89a0-b009c48f4d43 [data-leaf-element=\"true\"]","keyframes":{"transform":["translate3d(-12.514648210040342%, 0, 0) translate(-25%, 0%) scale(1.5)","translate3d(0%, 0, 0) translate(0%, 0%) scale(1)"]},"delay":0,"duration":2000,"fill":"forwards"}]

3. Increased downtime for websites

[{"selector":"#anim-1f900823-d346-47d6-b415-8f1d45c94ea7 [data-leaf-element=\"true\"]","keyframes":{"transform":["translate(24.968675162373717%, 0%) scale(1.5)","translate(0%, 0%) scale(1)"]},"delay":0,"duration":2000,"easing":"cubic-bezier(.3,0,.55,1)","fill":"forwards"}]

To overcome this issue of SQL sleep command, MySQL uses two parameters:

1. Interactive Timeout

[{"selector":"#anim-ca6c04ca-7ae7-43f4-8f5c-cb25596b4813 [data-leaf-element=\"true\"]","keyframes":{"transform":["translate3d(-25.00976522005288%, 0, 0) translate(-25%, 0%) scale(1.5)","translate3d(0%, 0, 0) translate(0%, 0%) scale(1)"]},"delay":0,"duration":2000,"fill":"forwards"}]

2. Wait Timeout

[{"selector":"#anim-38cf14aa-01be-4640-b464-8de9dbcf7c88 [data-leaf-element=\"true\"]","keyframes":{"transform":["translate3d(-22.15365324689505%, 0, 0) translate(-25%, 0%) scale(1.5)","translate3d(0%, 0, 0) translate(0%, 0%) scale(1)"]},"delay":0,"duration":2000,"fill":"forwards"}]

MySQL database has a high volume of concurrent, long-running queries and while checking the status of connections, you might get some connections with the status- “sleep”.

CLICK HERE

[{"selector":"#anim-ed281976-7697-4c6e-bd11-124f9ded48c8 [data-leaf-element=\"true\"]","keyframes":{"transform":["translate3d(-6.835049569125541%, 0, 0) translate(-25%, 0%) scale(1.5)","translate3d(0%, 0, 0) translate(0%, 0%) scale(1)"]},"delay":0,"duration":2000,"fill":"forwards"}]