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

Processlist History

forums › forums › Monyog › Using Monyog › Processlist History

Tagged: 

  • This topic is empty.
Viewing 0 reply threads
  • Author
    Posts
    • December 19, 2012 at 3:54 pm #34062
      peterlaursen
      Participant

      It is very likely that you have some queries generating very large temporary tables. Those queries will then typically be slow as well. Such queries can be queries with JOIN of tables with indexes not optimal or queries with SUBQUERIES. Subquerires have poor performacne before MySQL 5.6/MariaDB 5.5. In particular the construction SELECT … WHERE IN (SELECT ..) can be a very bad performance killer.

      So you should identify those queries, rewrite them or add indexes to tables to make the queries perform better.

      To identify the queries I would suggest that you turn on the 'query sniffer' (The processlist based sniffer is OK for this and it is very simple to setup). Data collected can then be analyzed in both the 'query analyzer' page and the 'Way back machine' pages in MONyog.

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