Unsupported Screen Size: The viewport size is too small for the theme to render properly.

Feature: Disable "show Table Status"

forums › forums › SQLyog › SQLyog: Bugs / Feature Requests › Feature: Disable "show Table Status"

  • This topic is empty.
Viewing 1 reply thread
  • Author
    Posts
    • October 13, 2005 at 1:57 pm #9291
      vygi
      Member

      Hi there,

      some of our big MyISAM tables get locked for a longer period of time (up to several minutes) because of some usual activity (eg. data loading).

      If I try to access a database with a locked table, SQLyog sends “show table status from `database`” query and then waits until the table will be released. That means, nothing happens. SQLyog just “hangs”. I either have to wait or to kill the locked “show table status” query. After them, it's easily possible to work on the affected database as long I do not access the locked table directly. The only handicap is: I do not have some table info in the “Objects” tab, but who cares?..

      If there a chance to get something like “Table Lock Proof Mode” which wouldn't use “show table status” at the first access to the database? Just a checkbox “don't read table status”. That would be very useful.

      Thanks for readin',

      Vygi

    • October 13, 2005 at 4:17 pm #19490
      Ritesh
      Member

      Thanks for your suggestion.

      We actually plan to improve upon this in v4.2.

  • Author
    Posts
Viewing 1 reply thread
  • You must be logged in to reply to this topic.