Professional Web Applications Themes

how see connected user? - MySQL

Hallo, Some times my Db crash or say to many connections. I'd like to see who cause that. How can I see who is connected to mysql? Thank you in advance for the time you'll spend for answering me. Mario. P.S. Any other suggestion is welcame!...

  1. #1

    Default how see connected user?

    Hallo,
    Some times my Db crash or say to many connections.
    I'd like to see who cause that.
    How can I see who is connected to mysql?
    Thank you in advance for the time you'll spend for answering me.
    Mario.

    P.S. Any other suggestion is welcame!
    _mario.lat Guest

  2. #2

    Default Re: how see connected user?

    "_mario.lat" <it> wrote:
     

    As long as MySQL is up and you can log into it [1] you can use the
    SHOW [FULL] PROCESSLIST command to see all open connections.

    http://dev.mysql.com/doc/refman/5.0/en/show-processlist.html


    [1] MySQL reserves one connection for the superuser. So make sure
    your application connects as non-superuser. Then you can connect
    even if the database emits "too many connection" errors.

    XL
    --
    Axel Schwenke, Senior Software Developer, MySQL AB

    Online User Manual: http://dev.mysql.com/doc/refman/5.0/en/
    MySQL User Forums: http://forums.mysql.com/
    Axel Guest

Similar Threads

  1. Replies: 6
    Last Post: July 4th, 06:33 PM
  2. scanner not connected?
    By Star Copier in forum Adobe Acrobat Windows
    Replies: 0
    Last Post: April 20th, 09:32 PM
  3. detecting if I am connected to a ISP
    By Brett S Hallett in forum Ruby
    Replies: 9
    Last Post: October 21st, 08:38 AM
  4. Not connected to Oracle
    By Sugith Kumar in forum ASP Database
    Replies: 3
    Last Post: September 18th, 06:11 PM

Bookmarks

Posting Permissions

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

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139