Not signed in (Sign In)

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

General: I have multiple db schemas that my app talks to

Bottom of Page

1 to 4 of 4

  1.  
    • CommentAuthorskhanam
    • CommentTimeJan 31st 2012
     
    Hi there,

    I am new to JetProfiler .. we have multiple db schemas that are being invoked for one transaction.
    Can i know while i load the db servers how do i monitor or start recording for all schemas.

    I can just use one schema at a time at the moment
  2.  
    Hello,

    JP always records all schemas on the instance you are monitoring. Provided the queries are causing some load, you should be able to see them all. Try polling more often. Also, please verify your privileges so that you are allowed to monitor all schemas, see

    http://www.jetprofiler.com/faq/#what-user-grants-are-required
    • CommentAuthorskhanam
    • CommentTimeFeb 1st 2012
     
    User's have enough previleges

    'GRANT SELECT, INSERT, UPDATE, DELETE, SHOW VIEW ON `schema_name`.* TO ''user_name''@''%''' .. however i see that the Top tables,queries,schemas don't show up ..

    I am using a free version
  4.  
    You need privileges for all schemas, not just `schema_name`.*:

    GRANT USAGE, SELECT, PROCESS ON *.* TO jetprofiler@’%‘ IDENTIFIED BY ‘password‘;

1 to 4 of 4

  1.