How to examine what is causing high load on my SQL Table?

  • Hello,
    I’m using Kopano on Ubuntu 16.04, and it’s becoming very slow since top shows me constantly about 300% CPU Load on the Mysql Task.
    Is there a oportunity to show which queries, or which user etc. is causing the high load?
    Thanks for your help, and sorry for my bad English, I’m used to write in german.

    Greetings Tonio

  • Kopano

    Hi @t-wirmer,

    you can see currently running queries when executing show full processlist; on the mysql console. Current session within kopano-server when calling kopano-stats --top.

Log in to reply