Export is slow

jtritom's profile image jtritom posted 2 years ago in General Permalink

Hello, yesterday I migrated from machine and installed the latest version of heidi, I just went to make the backup today exporting and it's very slow. The machine has a more powerful processor and Nvme, faster than the old one.

It seems to create table by table, very slow! Before it did it in a matter of seconds, now it takes 30 minutes

1 attachment(s):
  • slow
jtritom's profile image jtritom posted 2 years ago Permalink

The database is only 127mb

ansgar's profile image ansgar posted 2 years ago Permalink

Just reset the "max insert size" to a reasonable size of 1000 KB.

I'll have a look why such huge values slow down the export.

jtritom's profile image jtritom posted 2 years ago Permalink

Hi, we don't change anything in "max insert size", only "max_allowed_packet" for 1G

jtritom's profile image jtritom posted 2 years ago Permalink

@ansgar if I put only 1mb in the insert it will not export the tables correctly right?

Code modification/commit 695a26e from Ansgar Becker <anse@heidisql.com>, 2 years ago, revision 12.4.0.6660
Ensure max INSERT setting is an Int64, so a huge value does not wrap into a negative value. See https://www.heidisql.com/forum.php?t=40393
ansgar's profile image ansgar posted 2 years ago Permalink

Of course it would - you just get multiple INSERTs then.

However, next build will have a fix for such huge values.

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