• Topic
  • Discussion
  • SupportWeb.MonitorMySQLSessions(Last) -- Owiki? , 2016-08-19 14:59:34 Edit owiki 2016-08-19 10:59:34

    How do I monitor open database sessions associated with MySQL ODBC connections?

    Use the following steps to monitor open database sessions associated with MySQL ODBC connections:

    1. Login to the machine that contains the MySQL instance.
    2. su to the MySQL user.
    3. Execute the MySQL user's .profile.
    4. cd into the bin sub-directory of the MySQL installation.
    5. Execute the ./mysql procedure and pass your username, password and database like so:
        bash-2.03$ ./mysql -u mysql -pdba -D test
      Reading table information for completion of table and column names
      You can turn off this feature to get a quicker startup with -A
      
      Welcome to the MySQL monitor.  Commands end with ; or \g.
         
    6. Type SHOW STATUS; (pre-5.x) or SHOW GLOBAL STATUS; (5.x) to return connection information. For example:
      mysql> SHOW STATUS
         -> ;
      +--------------------------+-----------+
      
      Variable_name Value
      +--------------------------+-----------+
      Aborted_ clients 11218
      Aborted_ connects 26620
      Bytes_ received 207090542
      Bytes_ sent 767911564
      Com_ admin_ commands 0
      Com_ alter_ table 0
      Com_ analyze 0
      Com_ backup_ table 0
      Com_ begin 0
      Com_ change_ db 0
      Com_ change_ master 0
      Com_ check 0
      Com_ commit 200
      Com_ create_ db 0
      Com_ create_ function 0
      Com_ create_ index 8204
      Com_ create_ table 11572
      Com_ delete 333

      The Threads_connected parameter shows the number of active connections. Consult the MySQL Reference Manual for an explanation of other variables.

    Referenced by...