Not signed in (Sign In)

Vanilla 1.1.5a is a product of Lussumo. More Information: Documentation, Community Support.

General: Top Tables empty

Bottom of Page

1 to 6 of 6

  1.  
    • CommentAuthorjeduden
    • CommentTimeDec 3rd 2009
     
    Hi !
    I'm trying the free version of jet profiler 1.0.7.
    Unfortunately,
    it doesnt really seem to work.
    the top_tables only shows a single table,
    even though I did several test queries on another table.
    Any idea what going on ?
    Thanks in advance!
    JE
  2.  
    Hello,

    first make sure you have sufficient user rights. If not, you should get a warning when trying the "Test connection" in the connection dialog.

    The Top tables information is collected in a different way than the Top Queries, so these two tabs are not 100% in-sync, especially during shorter time periods. More information can be found in the online documentation under "MySQL commands":

    http://www.jetprofiler.com/doc/

    A quick way to test if top tables is working is to lock a table during a few seconds and watch the results:

    mysql> LOCK TABLES some_table WRITE;
    (wait 10 seconds)
    mysql> UNLOCK TABLES;

    Only do this on a table where you can afford a 10 second lock of course :)
    • CommentAuthorjeduden
    • CommentTimeDec 3rd 2009
     
    Hi!

    lock tables works.
    it seems that select does not have any influence on top tables.
    is that correct ?
  4.  
    Hello,

    it works and works not, it all depends on the timing issues involved when sampling data. So the first sampling might detect the SELECT-statement in the processlist. The subsequent sampling of tables in use might not be able to catch it since the query has already run. If you run long enough (and with reasonable query load), these discrepancies should be smaller and smaller.

    But it could also be a version thing, where the top tables information does not give as much information on some MySQL versions as on others. Which version are you using?
    • CommentAuthorjeduden
    • CommentTimeDec 3rd 2009 edited
     
    I tested it on different mysql versions. But to keep it consistent lets talk about the version on my local computer:
    MySQL 5.1.31-community.

    It seems that top tables is really broken:

    1. executed several select queries on different tables.
    2. nothing displays on top tables
    3. executed two lock statements.
    4. the lock statements causes the two tables to be displayed on top tables.
    5. also the line chart only displays the two tables
    6. clicked on line chart settings
    7. select all tables ( from all item ) and add them to "chart" list using ">>"
    8. line chart also shows missing tables ( of course with lower load ) but the are visible
    9. top tables still only displays the two initial tables
  6.  
    That sounds strange... So the line chart shows that the tables are being used, but they do not show up at all in the Top Tables tab?

    If this is the case, it might very well be a bug. It would be of great help if you sent screenshots of the line chart as well as the top tables tab. You can email to support ...at... jetprofiler.com

    Thanks in advance.

1 to 6 of 6

  1.