Can Viewing Large Tables Remotely With Sqlyog Knock Over Server?

[zzapper]

Hi,

Usually when you view a table in SQLyog the 50 records limit is set. Occasionally I've forgot that the “all records” toggle is set and I've viewed say 80,000 records, how naughty is this, how much load on the server is it when you are viewing remotely?

[Mahesh]

MySQL server Load depends on Query you are executing.

If limit is set to 50 then “Select Query will be appended by limit clause”

and

If you are viewing all records of a large table then it depends on MySQL server performance, Number of records, Datatypes used etc..

Also if you have selected “ALL rows” option by mistake, there is a STOP button on toolbar to stop retrieval of records.

i.e. You can click on STOP button if you do not want to retrieve all records of a large table OR you want to move to limit.

[Shalmali]

Uncheck “Remember setting for each query” (under “Enable Autopaging in Result tab” in the “Others” tab of the “Preferences” Window) if you do not want SQLyog to remember the number of rows previously viewed for that query.

Please check the screen shot.

~Shalmali

[Shalmali]

Oops, here is the screen shot.

[zzapper]

Thanks for replies. But would it worry you that you if you accidentally viewed a large table?

[Mahesh]

No worry..

You can retrieve(see) all rows of large table, but it will take some time to display records in grid.( Depends on Server performance, System performance etc..) also as I have mentioned there is a STOP option to STOP retrieval of records.

[Author]

Posts