Navigation

    Kopano
    • Register
    • Login
    • Search
    • Categories
    • Get Official Kopano Support
    • Recent
    Statement regarding the closure of the Kopano community forum and the end of the community edition

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

    Kopano Groupware Core
    2
    2
    143
    Loading More Posts
    • Oldest to Newest
    • Newest to Oldest
    • Most Votes
    Reply
    • Reply as topic
    Log in to reply
    This topic has been deleted. Only users with topic management privileges can see it.
    • t.wirmer
      t.wirmer last edited by

      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

      1 Reply Last reply Reply Quote 0
      • fbartels
        fbartels Kopano last edited by

        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.

        Regards Felix

        Resources:
        https://kopano.com/blog/how-to-get-kopano/
        https://documentation.kopano.io/
        https://kb.kopano.io/

        Support overview:
        https://kopano.com/support/

        1 Reply Last reply Reply Quote 0
        • First post
          Last post