Emergency

MySQL concurrent connections

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • MySQL concurrent connections

    Hello all,

    I need to check how many concurrent connections to mysql are being made.

    Can any one tell me, how can i achieve this ?

    Thank you

  • #2
    Hi systemali,

    Extremely sorry for the delay. I am not sure what version of mysql you are working on now. Most of the commands are similar with few changes based on the mysql version. So, please refer to the mysql documentation, change the version in URL as you wish.

    Different ways to look at the concurrent connections, this command works in mysql 5.6:
    SHOW PROCESSLIST;
    (OR)
    SHOW VARIABLES LIKE "%Thread_%";

    The above commands will list the no of connections mysql has made. Thanks

    This document might help as well, https://dev.mysql.com/doc/refman/5.6...n-threads.html

    Best Regards,
    Shiva Shinde

    Comment


    • #3
      I have a same problem too..
      but i will try your comment..
      __________________________________
      Lampu Surya Lampu Jalan Tenaga Surya Lampu Taman Tenaga Surya

      Comment

      Working...
      X