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

Show Processlist — Get Full Info Out Of Sqlyog

forums › forums › SQLyog › Using SQLyog › Show Processlist — Get Full Info Out Of Sqlyog

  • This topic is empty.
Viewing 3 reply threads
  • Author
    Posts
    • May 9, 2014 at 5:43 am #34912
      sathish
      Member

      Hello,

       

      You can see the full query by clicking on the info column. Clicking on the info column will open a blob viewer which will have the full query. Please find the screenshot attached.

       

      Regards,

      Sathish

    • May 9, 2014 at 1:15 pm #34913
      pasmith
      Member

      Hello,

       

      You can see the full query by clicking on the info column. Clicking on the info column will open a blob viewer which will have the full query. Please find the screenshot attached.

       

      Regards,

      Sathish

       

      Hmm, that doesn’t seem to work for me. I’m on v11.42, 64-bit, Professional version. 

       

      Is there a setting that I have to turn on/off or something? Iv’e tried it from both the Query Results window and from the Show Processlist function under tools. 

       

      If it matters, I’m accessing the database via SSH tunnel.

       

      Thanks in advance for any advice!

       

      PS that does work for, for example, medium_text fields in query results, but not when I get the processlist returned. 

    • May 12, 2014 at 4:38 am #34914
      sathish
      Member

      Hello,

       

      It would be helpful if you could paste a screenshot of SQLyog after executing SHOW FULL PROCESSLIST from the query editor.

       

      Regards,

      Sathish

    • May 12, 2014 at 1:25 pm #34915
      pasmith
      Member

      AHA!

       

      OK so (as is so often the case) this was user error. 

       

      I was doing 

       

      SHOW PROCESSLIST;

       

      when I do 

       

      SHOW FULL PROCESSLIST;

       

      it works as you say it should.

       

      I apologize for the fact that my lack of MySQL knowledge caused so much confusion, and thank you very much for the help!

       

      [For any other MySQL noobs who stumble on this thread, SHOW PROCESSLIST only returns the first 100 or so characters of a query. SHOW FULL PROCESSLIST returns the entire query.]

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