![](https://seccdn.libravatar.org/avatar/7891b1b1a5767f4b9ac1cc0723cebdac.jpg?s=120&d=mm&r=g)
Dave Howorth wrote:
On Thu, 19 Dec 2019 10:47:38 +0100 Per Jessen <per@computer.org> wrote:
Per Jessen wrote:
Looking at the source just now, MYSQL_OPT_READ_TIMEOUT is explicitly set to 300. I don't know if that is the right option though. I think I'll try to patch the executable.
I patched the library and updated MYSQL_OPT_READ_TIMEOUT=300 MYSQL_OPT_READ_TIMEOUT=999. The update process stopped after 999 seconds, almost to the second. :-(
I'm going to try with MYSQL_OPT_READ_TIMEOUT=9999\0
If that doesn't work, another approach might be to split the update into multiple transactions. Perhaps add a LIMIT clause to the update and SELECT rows that have not already been converted.
Yes, I had that something like that in mind too. Likely a bit more complicated, with a rebuild etc. -- Per Jessen, Zürich (8.9°C) http://www.hostsuisse.com/ - dedicated server rental in Switzerland. -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org To contact the owner, e-mail: opensuse+owner@opensuse.org