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

Forum Replies Created

Viewing 2 posts - 1 through 2 (of 2 total)
  • Author
    Posts
  • May 12, 2014 at 1:25 pm in reply to: Show Processlist — Get Full Info Out Of Sqlyog #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.]

    May 9, 2014 at 1:15 pm in reply to: Show Processlist — Get Full Info Out Of Sqlyog #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. 

  • Author
    Posts
Viewing 2 posts - 1 through 2 (of 2 total)