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

Real Time Explain Error

forums › forums › Monyog › Using Monyog › Real Time Explain Error

  • This topic is empty.
Viewing 2 reply threads
  • Author
    Posts
    • November 19, 2015 at 12:13 am #13446
      sqlmike
      Member

      This error pops up when clicking on some (but not all) explain plans from real time.

       

      Explain query failed!
      Error: 1064, You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ” at line 1

       

       

      Monyog version 6.5

      clients tossing error is 5.6.22-72

    • November 20, 2015 at 1:28 pm #35553
      pankajk1608
      Moderator

      Hello,

       

      You are getting the error because the query you are running is too long for ‘performance_schema’ table of your server to return.MONyog uses performance schema statement digest table(events_statements_summary_by_digest and events_statements_history_long) to get this information for “Explain Plans” .If the query exceeds ‘1024’ bytes,then you will only get to see the truncated query upto 1024 bytes in MONyog as this much query is only returned by the server.This value is by default and you can change this value to your need,refer here: http://dev.mysql.com/doc/refman/5.6/en/performance-schema-statement-digests.html

       

      Regards

      Pankaj

      Team MONyog.

    • November 20, 2015 at 6:47 pm #35554
      sqlmike
      Member

      Pankaj,

       

      Thank you for your reply.  Seems Monyog could handle the error condition a little better and provide the same information you just did.

       

      Thanks!

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