Ads were blocked - no problem. But keep in mind that developing HeidiSQL, user support and hosting takes time and money. You may want to send a donation instead.

Opened file from network drive

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

I'm running Windows 10 on Virtual Box with HeidiSQL version 9.4.0.5174.

Whenever I open a file from my mounted drives seen as network drives, the memory usage goes up and up.

As seen in this screenshot, I've connected to my db server and then opened the file. I waited a few minutes without doing anything and the memory usage was above a 1024MB of ram.

When the same file is on my desktop, I don't have the same problem.

1 attachment(s):
  • Capture
Misha v.3's profile image Misha v.3 posted 2 years ago Permalink

I have the save version of Heidi and do not see such behaviour with two different *nix file servers (aix and linux) and two different sql servers (local MySQL and remove MariaDB). I've tried this with ~1 KB .sql UTF8 file with unix EOLs as well as with 2.5MB .sql UTF8 file with windows EOLs.

Have you tried different sql files, different sql servers and different file servers?

Misha v.3's profile image Misha v.3 posted 2 years ago Permalink

Oh, I missed the part about virtual box.

Ads were blocked - no problem. But keep in mind that developing HeidiSQL, user support and hosting takes time and money. You may want to send a donation instead.
ansgar's profile image ansgar posted 2 years ago Permalink

You could try to specifiy the encoding in the file-open-dialog, e.g. "utf-8" or whatever it is. Don't use "Auto detect" - which is buggy, really.

jpurpleman's profile image jpurpleman posted 2 years ago Permalink

Hi Anse,

Thank you for looking into this.

Tried different files, different encodings, different servers, different virtual box machines setup the 'same' way.

Seems it's not a network drive issue or encoding problem. I put the file on the desktop of the Windows machine and on a real networked drive and the resources are fine.

The issue is when the file is on a mounted drive accessible to the Windows VM from my Linux host and I open any sql file the memory and cpu climb.

I'm using Oracle's VirtualBox version 5.1.26 r117224 (Qt5.5.1)

ansgar's profile image ansgar posted 2 weeks ago Permalink

If at all this issue still exists, the current build may heal something here. I pushed a change for fixing successive "reload file?" prompts, for files on a network drive.

See this related thread, or just try it and update to the latest build.

jpurpleman's profile image jpurpleman posted 2 days ago Permalink

Hi Anse,

I can see now it's a much bigger problem as the app almost immediately becomes unusable and sends the CPU to about 60% and a slow upwards memory leak.

1 attachment(s):
  • 2019-12-09-02-Selection
jpurpleman's profile image jpurpleman posted 2 days ago Permalink

As a followup, the latest build ( 10.2.0.5769 ) has the same issue.

ansgar's profile image ansgar posted 2 days ago Permalink

Are there similar symptoms in other software, e.g. Notepad++ or whatever has some watch-file-modification feature?

jpurpleman's profile image jpurpleman posted 1 day ago Permalink

Hi Anse,

I have no issues with Sublime Text and having files open from the same drive. I even edited the file in SSMS and there was no issue with Sublime reading the update and not consuming memory or CPU.

1 attachment(s):
  • Capture

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