CODEWITHSUNDEEP
mysqlsqlmysql-5.7
Mustafa
Mustafa

Reputation: 1776

Does my sql query continue executing after i been disconnected due to long operation?

If I run a SQL query in MySQL workbench and the connections time out after 30 seconds because it is taking a long time. Does my Query continue executing on the MySQL server even though I am disconnected?

For example, if I am doing an update and the update loops over a billion records. Does the MySQL server disconnect me first then it finishes the query after? Or does it disconnect me and terminate the query?

Upvotes: 3

Views: 1691

Answers (2)

savingDuck468
savingDuck468

Reputation: 347

It does. As Mustafa mentioned, you can see the query still running if you look at "Administration tab" --> Management --> Client Connections.

Also good to remember that you can change the 30sec cap to longer, shorter or none.

Upvotes: 1

Bill Karwin
Bill Karwin

Reputation: 562641

Yes, MySQL Workbench can disconnect and the query keeps running. This has been reported as a bug, but it's in the "Verified" state, which means it is not fixed: https://bugs.mysql.com/bug.php?id=78809

See also this related SO thread: MySQL Query running even after losing connection

If you have a long-running query that needs to do a bulk update, you may need to change the MySQL Session timeout options in the MySQL Workbench preferences. Alternatively, don't use MySQL Workbench for long-running jobs, use the mysql command line tool.

Upvotes: 2

Related Questions