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

Wny Sqlyog Canot Handle Database With Over 500 Table

forums › forums › SQLyog › SQLyog: Bugs / Feature Requests › Wny Sqlyog Canot Handle Database With Over 500 Table

  • This topic is empty.
Viewing 3 reply threads
  • Author
    Posts
    • December 21, 2006 at 9:07 am #23123
      peterlaursen
      Participant

      This is a known issue with the MySQL Server and not SQLyog.

      (queries to `Information_schema` are slow – try searching [url=”http://bugs.mysql.com!!))”]http://bugs.mysql.com!!))[/url]

      MySQL claims that this is fixed (at least the bug reports are closed).  

      You should upgrade the server version to 5.0.27/28 or 5.1.14.

      (Also you should upgrade SQLyog .. but for other reasons!)

    • December 22, 2006 at 3:22 am #23124
      micsqlyog
      Member
      peterlaursen wrote on Dec 21 2006, 09:07 AM:
      This is a known issue with the MySQL Server and not SQLyog.

      (queries to `Information_schema` are slow – try searching [url=”http://bugs.mysql.com!!))”]http://bugs.mysql.com!!))[/url]

      MySQL claims that this is fixed (at least the bug reports are closed).  

      You should upgrade the server version to 5.0.27/28 or 5.1.14.

      (Also you should upgrade SQLyog .. but for other reasons!)

      ok thanks man 😀

    • December 22, 2006 at 3:23 am #23125
      micsqlyog
      Member
      peterlaursen wrote on Dec 21 2006, 09:07 AM:
      This is a known issue with the MySQL Server and not SQLyog.

      (queries to `Information_schema` are slow – try searching [url=”http://bugs.mysql.com!!))”]http://bugs.mysql.com!!))[/url]

      MySQL claims that this is fixed (at least the bug reports are closed).  

      You should upgrade the server version to 5.0.27/28 or 5.1.14.

      (Also you should upgrade SQLyog .. but for other reasons!)

      ok thanks man will try it 😀

    • December 22, 2006 at 5:26 am #23126
      peterlaursen
      Participant

      However ..

      we are not impressed with this 'solution' my MySQL AB.    🙁

      Queries to Information_Schema is still slow compared to “SHOW …” and “SHOW … STATUS … ” statements.  From version 5.22 RC1 we will try to avoid querying Information_Schema whenever possible.  We think that it is possible everywhere except when clicking the + sign left to the 'triggers' folder in Object Browser (there is a privilege issue here as it takes the SUPER privilege to “SHOW TRIGGER STATUS ..”).

  • Author
    Posts
Viewing 3 reply threads
  • You must be logged in to reply to this topic.