Einzelnen Beitrag anzeigen
  #1  
Alt 19.06.2003, 00:52:56
ProGamer11 ProGamer11 ist offline
Anfänger
 
Registriert seit: Feb 2002
Beiträge: 55
To Many Connections

Hi,

habe das Problem mit "To many connections".. wenn ich in der DB mit dem Befehl "SHOW PROCESSLIST" die Liste sehen will erhalte ich folgendes: (die Befehle habe ich durch XX ersetzt..)

was hat das zu bedeuten? (und das mit Sleep und die Zahlen nebendran?)

User | Host | DB | Command | Time | State | Info
DB localhost DB Sleep 38 (hier ist die Spalte leer) NULL
DB localhost DB Sleep 48 NULL
DB localhost DB Sleep 28 NULL
DB localhost DB Sleep 119 NULL
DB localhost DB Sleep 21 NULL
DB localhost DB Sleep 179 NULL
DB localhost DB Sleep 53 NULL
DB localhost DB Sleep 60 NULL
DB localhost DB Sleep 60 NULL
DB localhost DB Sleep 20 NULL
DB localhost DB Sleep 44 NULL
DB localhost DB Sleep 48 NULL
DB localhost DB Sleep 100 NULL
DB localhost DB Sleep 21 NULL
DB localhost DB Sleep 48 NULL
DB localhost DB Sleep 32 NULL
DB localhost DB Sleep 48 NULL
DB localhost DB Sleep 100 NULL
DB localhost DB Sleep 21 NULL
DB localhost DB Sleep 21 NULL
DB localhost DB Sleep 46 NULL
DB localhost DB Sleep 32 NULL
DB localhost DB Sleep 48 NULL
DB localhost DB Sleep 15 NULL
DB localhost DB Sleep 52 NULL
DB localhost DB Sleep 38 NULL
DB localhost DB Sleep 15 NULL
DB localhost DB Sleep 15 NULL
DB localhost DB Query 14 Locked UPDATE xxxx
DB localhost DB Query 14 Updating UPDATE xxx
DB localhost DB Query 14 Locked SELECT * FROM xxx
DB localhost DB Query 13 Locked SELECT * FROM xxx
DB localhost DB Query 12 Locked SELECT * FROM xxx
DB localhost DB Query 11 Locked SELECT * FROM xxx
DB localhost DB Query 11 Locked select xxx
DB localhost DB Query 11 Locked SELECT * FROM xxx
DB localhost DB Query 9 Locked SELECT xxx
DB localhost DB Query 9 Locked SELECT * FROM xxx
DB localhost DB Query 8 Locked SELECT * FROM xxx
DB localhost DB Query 7 Locked select xxx
DB localhost DB Query 6 Locked SELECT * FROM xxx
DB localhost DB Query 6 Locked SELECT * FROM xxx
DB localhost DB Query 5 Locked SELECT * FROM xxx
DB localhost DB Query 5 Locked select xxx
DB localhost DB Query 4 Locked SELECT * FROM xxx
DB localhost DB Query 3 Locked select xxx
DB localhost DB Query 3 Locked SELECT * FROM xxx
DB localhost DB Query 3 Locked SELECT * FROM xxx
DB localhost DB Query 2 Locked select xxx
DB localhost DB Query 1 Locked select xxx
DB localhost DB Query 1 Locked select xxx
DB localhost DB Query 0 Locked SELECT * FROM xxx
DB localhost DB Query 0 Locked select xxx
DB localhost DB Query 0 NULL SHOW PROCESSLIST
Mit Zitat antworten