# MySQL query is not updating rows\_sent in the processlist, after killing and re running it starts sending data to client

**URL:** <https://forums.percona.com/t/mysql-query-is-not-updating-rows-sent-in-the-processlist-after-killing-and-re-running-it-starts-sending-data-to-client/28937>\
**Category:** MySQL & MariaDB\
**Tags:** percona\
**Created:** [March 4, 2024, 3:11pm UTC](https://forums.percona.com/t/mysql-query-is-not-updating-rows-sent-in-the-processlist-after-killing-and-re-running-it-starts-sending-data-to-client/28937 "2024-03-04T15:11:25Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![Sai\_krishna](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/sai_krishna/32/14121_2.png) [@Sai\_krishna](https://forums.percona.com/u/Sai_krishna)\
**Post date:** [March 4, 2024, 3:11pm UTC](https://forums.percona.com/t/mysql-query-is-not-updating-rows-sent-in-the-processlist-after-killing-and-re-running-it-starts-sending-data-to-client/28937/1 "2024-03-04T15:11:25Z")

</div>

We seeing a issue with query which is not updating rows\_sent in the processlist and it keeps running for longer time. When we kill it and run, it starts updating without running analyze on the table.

---

<div class="post-metadata">

**Author:** ![matthewb](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/matthewb/32/34_2.png) [@matthewb](https://forums.percona.com/u/matthewb)\
**Post date:** [March 4, 2024, 3:54pm UTC](https://forums.percona.com/t/mysql-query-is-not-updating-rows-sent-in-the-processlist-after-killing-and-re-running-it-starts-sending-data-to-client/28937/2 "2024-03-04T15:54:16Z")

</div>

Hello @Sai_krishna,  
please provide a test case. table schema, query, processlist output, etc. What you have provided is not very much to go on.
