Results 1 to 3 of 3
  1. #1
    sandeepspatil is offline Member
    Join Date
    Jul 2007
    Posts
    5
    Rep Power
    0

    Default How to check the number of applications connected to MySQL DB

    Hi,

    Is there some way to check the number of applications connected to an instance of mysql database?

    I have two different Java applications that will be using the same instance of MySQL.
    My requirement is that, I want to close the MySQL instance while closing the Java application.
    But before doing so, I want to make sure the other application is not connected to it.
    Is there some way I can check that?

    Your suggestions will be of great help.

    Thanks,
    Sandeep

  2. #2
    goldhouse is offline Senior Member
    Join Date
    Mar 2007
    Posts
    134
    Rep Power
    0

    Default

    Are you refering to the Mysqlconnection ? I think you need to explain little more Is this different from the regular stuff ?

  3. #3
    sandeepspatil is offline Member
    Join Date
    Jul 2007
    Posts
    5
    Rep Power
    0

    Default

    Hi,

    I got the answer from another forum.
    You can use "Show Processlist" to get the list of connections to the DB

    Thanks,
    Sandeep

Similar Threads

  1. Can someone check my code
    By joz_12345 in forum Java 2D
    Replies: 7
    Last Post: 02-18-2008, 03:58 AM
  2. Replies: 3
    Last Post: 01-07-2008, 08:01 AM
  3. Logging applications
    By ravian in forum New To Java
    Replies: 2
    Last Post: 01-02-2008, 07:43 PM
  4. Replies: 0
    Last Post: 08-09-2007, 07:30 AM
  5. Problems with Jtable connected to data base
    By elizabeth in forum AWT / Swing
    Replies: 2
    Last Post: 08-07-2007, 05:24 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •