Long Heidi freeze when exporting databse

lemon_juice's profile image lemon_juice posted 9 years ago in General Permalink
I have one table that consistently freezes Heidi for several minutes when I try to export it. Heidi.exe process keeps consuming all CPU and the mysql process appears to be idle then - when I first did the export I thought heidi froze for good and exported the db with SqlYog. SqlYog exports the same table in a few seconds - the table is only 27 MB and has 500 000 rows.

I can send you the data if you can look into this.
ansgar's profile image ansgar posted 9 years ago Permalink
Please send to the email found on the imprint page.
lemon_juice's profile image lemon_juice posted 9 years ago Permalink
Okay, I've just sent it!
ansgar's profile image ansgar posted 9 years ago Permalink
My HeidiSQL r4827 eports that file in 8 seconds:

This is quite ok.
1 attachment(s):
  • export-piwigo
lemon_juice's profile image lemon_juice posted 9 years ago Permalink
Indeed, this must have been some bug in earlier Heidi versions, I experienced this problem consistently in build 4822 - the export took about 2 minutes. Today I upgraded to build 4827 from the 32-bit installer and exporting this table is fast - also 8 seconds. I don't know what happened between 4822 and 4827 because I don't see anything export related in the changelog. But it's good it works fine again.
ansgar's profile image ansgar posted 9 years ago Permalink
There was a similar delay issue when connecting, reported here. I guess I fixed both of these by updating libmysql.dll

Please login to leave a reply, or register at first.