Not signed in (Sign In)

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

General: can u use PHPadmin to generate queries for Jetprofiler to record?

Bottom of Page

1 to 5 of 5

  1.  
    • CommentAuthorsqlman
    • CommentTimeAug 7th 2009
     
    i was tryin to record the query inputs from PHPadmin. But it wasn't working. Jetprofiler was not recording the queries sent through PHPadmin.
    also wen i was using the command prompt for issuing queries and trying to record the same on JetProfiler, it wasn't responding.
    could u pls help me with this? i have kept the polling interval as 0.25 s. is this some kind of a bug in JetProfiler?
  2.  
    Hello sqlman,

    this has to do with the way Jet Profiler collects its data. It uses statistical polling, asking the server every second what it's currently busy doing. If you happen to issue a query between two polls, JP will not see that query. This is not as bad as it sounds, because when you run JP on a busy server, there will always be queries running. The statistical polling will over time collect a pretty fair view of what queries are most frequent, in almost the same way as a complete query logging would.

    We deliberately chose this way of collecting data because it causes very little load and can be done on any installation without changes. Competing solutions all require server reconfiguration or recompliation, proxies, or application changes.

    Now, to verify that JP is working, you can issue a query that you know is going to take a long time to complete, for example:

    SELECT SLEEP(5);

    Hope this clarifies things.
    • CommentAuthorsqlman
    • CommentTimeAug 7th 2009
     
    Thanks for ur prompt response.
    So wat do u propose??
    Shud i reduce my polling interval even further? Can i still get results if i am using the queries from PHPadmin or the command prompt. i would just need to manually palce in many queries maybe on a continued basis in order to check on the performance. is my understanding right or/and do u propose any other solution for this to work???
  4.  
    PHPMyAdmin or command prompt are not the ideal way to generate database load. Instead, I'd recommend

    a) that you generate some load on your system using one of these tools:

    http://www.jetprofiler.com/faq/#how-can-i-generate-load-on-my-target-database-server

    or

    b) that you run JP against a live database.
    • CommentAuthorsqlman
    • CommentTimeAug 7th 2009
     
    Thanks for ur inputs Bjorn.

1 to 5 of 5

  1.