Hi Fred,
Try this:
1. Gaining some information:
connect with dbm-user
SELECT rowno,username,
ROUND(usedtemporarysize/1000,2) MB,
applicationnode,
taskid,
usedtemporarysize
FROM sessions
ORDER BY usedtemporarysize DESC,
username ASC
Important:
-> taskid
2. Logon Console
dbmcli -d... -u... db_cons show tasks
prints the existing tasks,
with SQL sessions being marked as TASK Type = User.
output would look similar to:
T102 7 -1 User 3796* Command wait 164 0 736
158424246(r)
T115 7 -1 User 3500* Command wait 810 0 90
158424246(r)
T119 7 -1 User 2288* Command wait 900 0 0
158424247(s)
T146 7 -1 User 0* Command wait 627 0 273
158424247(s)
T147 7 -1 User 3500* Command wait 814 0 86
158424247(s)
T149 7 -1 User 3480* Command wait 900 0 0
158424247(s)
T152 8 -1 User 2288* Command wait 900 0 0
182344979(s)
T158 8 -1 User 3500* Command wait 810 0 90
182344979(s)
T163 8 -1 User 2288* Command wait 900 0 0
182344979(s)
T166 8 -1 User 3796* Command wait 900 0 0
182344979(s)
T175 8 -1 User 3480* Command wait 60 0 840
182344979(s)
T177 8 -1 User 3500* Command wait 840 0 60
182344979(s)
You could then stop the task T177 with dbmcli ... db_cons kill 177
This is maybe not the most elegant way, if anyone knows
a more efficient way, please post it,
the situation fred describes may happen everyday...
Best Regards
Ralf
"Frédéric DEMILLY" <[EMAIL PROTECTED]>
24.04.2007 18:39
Bitte antworten an
[EMAIL PROTECTED]
An
"maxdb@lists.mysql.com" <maxdb@lists.mysql.com>
Kopie
Thema
Disconnecting a session
Hello all,
Is there any way to disconnect an user ?
An user have run a VERY long query, and kill the application with task
manager. But the user remain connected on the database, and the query was
still running, slowing down everything.
So the only solution I've found was to stop and restart the database. But
I've killed everyone !
I've searched in DBMGUI and DBMCLI, but didn't find anything.
Any idea ?
TIA
Fred.
--
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe:
http://lists.mysql.com/[EMAIL PROTECTED]
