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 1 reply thread
  • Author
    Posts
    • December 19, 2012 at 9:54 am #12887
      yoyobutton
      Member

      Hi,

      I've problem with MySQL server in my linux. It makes the disk usage spikes and push the load average to the top frequently. Do you know how I can use MONyog to check which process that run at that time? Is there any kind of process log / history that record MySQL activity at that time in MONyog ?

      Thank You

    • 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 1 reply thread
  • You must be logged in to reply to this topic.