[vygi]

lazylester wrote on Apr 4 2006, 05:01 AM:

It happens several times a day, but I don't have much more info than that. Beta 5 on winxp. sqlyog disappears very suddenly after clicking on something (didn't pay attention to what it was).

Same here!

Beta 5 has disappeared quickly and quietly two times today!

I have a virtual desktop management tool called Virtual Dimension and I often switch between my desktops. After some switch I go back and cannot find SQLyog! Simply gone without telling me anything – no crash reports, no messages, no “goodbye”… 🙁

[vygi]

Ritesh wrote on Mar 15 2006, 07:33 AM:

Starting from BETA 2, we have changed the .db name from connectionname.db to a filename which is a checksum of the connection name + the connection details.

Is it right when I have tried 4 different connections but there is only one .db file in the Tags directory?

Ritesh wrote on Mar 15 2006, 07:33 AM:

This was just a bug and 5.1 is still in BETA. Starting with BETA 3, you can have a DB with 'n' number of tables with 'n' number of columns in each table.

OK OK OK… I was just kidding… 😛

SQLyog is great (and will be quite ideal when proper export to EXCEL will be implemented).

[vygi]

peterlaursen wrote on Mar 14 2006, 04:02 PM:

Or maybe changing the .db-file from inside SQLyog cases some error too when it is that big?

1MB .db file with 8,519 rows table is big?

In this case, word “Enterprise” should be removed from the product name as SQLyog is not enterprise-ready!

Right now my biggest database server has 14 databases, biggest database has 145 tables, widest table has 112 columns, longest table has almost 151 mio rows, largest MyISAM data file is 45 GB, total size of all data and index files on this server is more than 186 GB 😎

[vygi]

peterlaursen wrote on Mar 14 2006, 03:05 PM:

You won't have to disable autocomplete completely. Only disable tooltips and you can still use TAB, CTRL+SPACE and CTRL+ENTER.

Yes thanks it works that way.

Nevertheless, I am unable to rebuild the tag file so autocompletion may become incorrect one day.

Note that I've got “Buffer Overrun” message only once, just the very 1st time, and did not see it since them. Now SQLyog just disappears quickly without any messages.

[vygi]

> 1) does autocomplete work OK with that big .db-file? (if you start without rebuild?)

yes it works… somehow… but is quite slow and sometimes I can hardly type so I prefer to switch it off

2) what happens if you start rebuild manually (from 'powertools' ?)

It crashes (disappears) immediately

[vygi]

> Do you have a lot of databases with a lot of tables with a lot of columns in that connection?

yes: 5..10 databases, up to 50..80 tables in a DB, up to 50..80 fields in a table.

> Do you find the .tag file for the connection in TAGS directory and does it look valid?

> You can open it with SQLite Query Browser

yes it seems to be valid.

“objects” has 8519 rows BTW and message_queue + sqlite_sequence are empty.

> Also now that the tag file has been built can you open it next time you start SQLyog without a crash?

only if I switch off tag file rebuilding.

Otherwise it crashes if I select a “rich” connection (server with lots of objects).

> Could you try selecting only a single small database with a connction and open that connection?

yes it works.

> And how big is that TAG-file?

this is a .DB file, not .tag. The size is 1,089,536 bytes = 1,064 KB

> and @ritesh – actually I have a question too. See the screenshot of my TAGS-folder.

> There are quite a lot of ZERO-size .db files with cryptical names. What are they?

> I think it is new with BETA2 – I don't remember this with BETA1.

I have only one single .db file with a long cryptical name.

[vygi]

Continuation:

after this crash SQLyog refuses to start!

It just shows connection dialog and quickly disappears when I try to connect to an already known (“indexed”) server.

Then I have managed to connect to two new servers without built tag files.

SQLyog has finished tag building on one of them and can connect to it now.

There is a problem with the 2nd server though: it has crashed (without any messages) during tag file building or right after it and can't connect to it.

So I had four connections to four different servers and only one works.

SQLyog disappears very quickly as soon as I try to connect to the remaining three.

Then I have deleted a .db file from the Tags folder… and – good news – was able to connect to all servers

but – bad news – only as long as tag file building was in process. After them, SQLyog was gone again.

Finally I have connected to a “good” server (which does not crash SQLyog) and switched off “Always Rebuild Tag Files on Startup” option. Now SQLyog sinally starts without any problems.

Vygi

P.S. yes I do have LOTS of tables and fields, and I will take a look at the file soon.

[vygi]

peterlaursen wrote on Dec 28 2005, 02:03 PM:

I can inform you that at the Webyog Office in Bangalore everything is practically closed down from now till after New Year.

Now I still hope that export to Excel via COM will be implemented one day.

I'm sure that our company would purchase 5-licence-pack or so…

[vygi]

Ritesh wrote on Jan 5 2006, 04:23 PM:

@vygi, @peterlaursen, @carltond – You have a PM!

[post=”8374″]<{POST_SNAPBACK}>[/post]

@Ritesh: you have one as well 😛

[vygi]

Yep… Happy 2006 everybody! 🙂

[vygi]

peterlaursen wrote on Dec 30 2005, 10:50 PM:

About this Graphics System: how does it use memory? 

I guess it uses 'shared memory' but allocated dynamically or statically?

Is there some kind of Video-shadowing set active in BIOS?

My miniPC has shared memory (too), but a 'fixed memory pool' is allocated at system startup.

I think I understood that you have tested at work.  Do you have a chance to test with another PC at home or somewhere else?  And maybe try another driver for the Graphics card?

well… first I have tested at work, some on-board Intel graphics adapter with shared memory… and SQLyog was taking more and more RAM when moving/resizing window; even at the very beginning, fresh started, without any queries!!

Then here at home I have anothe PC with some REAL video card, nVidia 6600, real video memory, nothing shared. And SQLyog here takes more memory only when some query result is loaded, and only when Result tab is visible. Just like your system, I assume???…

So the issue seems to be always here, just sometimes hard to see.

BTW this 'destruction' phenomenon — it is reproducible on my PC here at home, but it needs almost whole minute of permanent window resizing and moving:

1. run some query and make result tab visible

2. restore (unmaximize) SQLyog and make its window smaller than fullscreen (60% or so)

3. grab the top of the window and slowly (1cm/s) change its size several times, 8-12 seconds long up and down…..

4. now release the window and move it a little bit (few pixels) to the left or to the right;

5. repeat steps 3 and 4 several timesn, and after some attempt to move (step 4), SQLyog “explodes” and starts to paint black and white (and gray) all around.

[vygi]

Believe me or not but here are three screenshots of SQLyog 5.01 (final) in front of Opera Browser wit Webyog home page. Click on the thumbnails for full size pictures (sorry but I was unable to upload to webyog.com).

I habe managed to get these nice pictures after I was watching how fast (or how slow) SQLyog occupies memory when I resize its window with the mouse. After growing to over 40..50 MB, it has started to destroy itself and other windows….

[vygi]

peterlaursen wrote on Dec 30 2005, 04:28 PM:

Not reproducable either!

This is an very traditional Athlon PC with old Nvidia GF2/MX board, but with a recent Forceware driver.

[post=”8323″]<{POST_SNAPBACK}>[/post]

And I am sitting at home now and have same issue on Windows XP Home SP2 with nVidia 6600 graphics, latest SQLyog Enterprise 5.01 beta.

There is one difference though: SQLyog grabs more memory only if some query result is displayed in the Result tab. Right now memory use grows by 164 KB on every restore after minimizing the window. On minimize, allocated memory size either stays constant or increases by 4 KB but never shoots down.

Interestingly, even if I switch to Table Data tab which displays data in similar way like Result tab — everything is OK, no memory leak anymore! I am sure it was different in the office.

[vygi]

peterlaursen wrote on Dec 30 2005, 04:13 PM:

I could suspect that this is related to the Graphics system/driver!

Maybe… but it can't be only graphic-related as the video driver don't know how big the result set actually is. And memory usage grows much faster if some longer result is loaded.

I have Intel 82865G Graphics Controller here.

OK… enough for today… happy new year!

Vygi

[vygi]

peterlaursen wrote on Dec 30 2005, 03:34 PM:

I also can add that on my system (Win XP SP2) I can open SQLyog, move program window around, maximize, minimize etc – and memory usage according to Task manager does not change!

[post=”8316″]<{POST_SNAPBACK}>[/post]

Huh… that's strange then.

I also use Windows XP (Professional) with SP2.

Now I have re-booted the whole system, switched all possible tasks and programs off, and this memory issue is still clearly reproduceable! After moving around a bit, SQLyog (“Free v5.01 BTW) needs 270 MB already. OK, I don't need to resize window when I work, but memory usage is growing with every switch to another application and back, and with every query execution, so this is a real problem to me.

Would be interesting to know if same hapens on carltond's (originator of this thread) machine.

[Author]

Posts