1
I am using Mysql Workbench to run a duplicate data removal query. When I run the query for a very large table, due to the 600sec limit of Workbench connection, it results in Lost Connection. Even so, the duplicate values disappear. Then came the question: The code I’m using to check for repeated lines is:
SELECT TS_SAMPLETM, COUNT(*) FROM HT_MA2_SBX_SEG
GROUP BY TS_SAMPLETM
HAVING COUNT(*) > 1
Even if Workbench loses connection to the server, the query is executed until the end?
Well I do not know to confirm you, but when you have a connection and execute a query it was already, you are just waiting for the server to respond, if you give timeout the server aborts and what was, and what was not was not, IE, have the risk of not running until the end, better review your query, it could not take as long to reply
– deFreitas
I get it. I’ve got about 30 million lines of data, so it must be taking this long. But, as I said, using a code that returns duplicate lines, select always returns empty, which indicates that the code to delete duplicate lines worked even losing connection.
– Rafael
It may be that you are running everything on time but the bank is getting lost to say that it was successful, there explains why the timeout
– deFreitas
It makes sense. I would just like to confirm even, besides checking if the code that returns the duplicated lines is ok. Thanks!
– Rafael
You call your routine in an application?
– Marco Souza
No. I’m running everything straight from Mysql Workbench,
– Rafael