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

Table Stats

forums › forums › SQLyog › SQLyog: Bugs / Feature Requests › Table Stats

  • This topic is empty.
Viewing 1 reply thread
  • Author
    Posts
    • March 3, 2011 at 3:25 am #12264
      xpose
      Member

      Does SQLyog currently have any way to show stats for tables and databases?

      At a quick glance on a “stats page”, it would be great to see how many rows a table has, size of the table, size of the index, etc… could be really useful data. To take things a step further, graphs could be done showing a pie chart of all the tables on a given database and showing which ones take up the most room.

      I'm not sure if this is what SQLyog is completely intended for, but I think some basic stats would be a nice addition. What do you guys think?

    • March 3, 2011 at 6:03 am #31988
      Aparna
      Member
      Quote:
      Does SQLyog currently have any way to show stats for tables and databases?

      Yes SQLyog does have an option to display the row count, data size and index size of all the tables present in a database. Select the tables folder and then click on the info tab(see the attached screen shot). This gives you the details of the number of tables/columns present(depending on whether the selection is on the table folder or the table itself), the number of rows, data size and index size. You can get details related to the table in info tab HTML mode as well text mode (which offers more detailed information). SQLyog is a MySQL front end and a database management tool.

      If you want graphical and detailed representation of information regarding database then you can try MONyog the MySQL monitoring tool. Here is the link to try the trial version of MONyog:http://www.webyog.com/en/downloads.php#monyog

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