Any Plans To Fix

[stom2005]

Hello support,

Are there any plans to fix the “big table crash bug” in one of the upcomming versions?

Untill now all versions crash when I try to show a “big” table.

Best Regards,

Marcus

[Ritesh]

We don't have a “known” bug of this nature?

How big is the table? What is the table structure? Does it have many large BLOB values?

What values are you providing in the limit fields?

[stom2005]

I meen this BUG:

http://www.webyog.com/forums//index.php?showtopic=2219

Table:

ip [char(16),NOTNULL]

sender[char(242),NOTNULL]

recipient[char(242),NOTNULL]

first[int(11),NOTNULL]

last[int(11),NOTNULL]

n[int(11),NOTNULL]

Number of records:

SELECT COUNT(*) from table

–> 1920520

Marcus

[toplay]

I have a user table with over 300,000 rows and when show all is checked in the table data tab, the program hangs (in v5.15).

What's the status for a fix?

[Ritesh]

300K rows should not be a problem!

stom2005 is talking about 2 million rows, which might be a problem with virtual memory.

@toplay:

Are you sure that it is “hanging”? Maybe MySQL is taking time to return the result-set.

What is the table structure? How long have you waited?

[toplay]

Ritesh wrote on Aug 6 2006, 11:53 PM:

300K rows should not be a problem!

stom2005 is talking about 2 million rows, which might be a problem with virtual memory.

@toplay:

Are you sure that it is “hanging”? Maybe MySQL is taking time to return the result-set.

What is the table structure? How long have you waited?

Oh, I'm sure it's trying to get the result set initially. But I've waited over 5 minutes. My XP pro laptop (2.1GHz, 1GB RAM) is so slowed down to where I have to use the task manager to cancel SQLyog.

For 300K rows, it shouldn't take that long. The table has about 60 columns, mostly varchar and in UTF-8.

[peterlaursen]

Please answer (both of you):

1: It you let it finish how much memory does SQLyog use?

2: Does SQLyog use all available CPU while the data are loading?

In this situation I do not think it is a SQLyog issue! It is the time it takes for the server to send the data and to have it transferred.

However it IS a problem that SQLyog stores all rows of data in this situation and not just a 'window to the data'. A 'fix' (or whatever you may call it) is not round the corner. Not that it is unimportant, but ther are other issues that are not either!

[stom2005]

Hi,

I think it is the “problem” we discussed her sometime ago:

http://www.webyog.com/forums//index.php?showtopic=2219

If I rember right the memory is “running out” and CPU goes up to 100% than the programm terminates.

The exact behavior I will check tomorrow.

I think this problem can be solved by only fetching the data from database witch is in use / needed to show in the table window.

Best Regards,

Marcus

[stom2005]

Hi,

I checked it now CPU is going up to 100% and memory use is going up. After about 5 sec the software closes without an error message.

One little thing I wonder about. I am running Visual studio on my PC. Most other crashes I will be asked to open the debugger? Not after the “crash” of sqlyog.

Best Regards,

Marcus

[peterlaursen]

Hello again!

What is the staus with this one?

[Author]

Posts