Yes, it works ! Thanks for your help. Fred.
-----Message d'origine----- De : [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Envoyé : mercredi 25 avril 2007 07:58 À : maxdb@lists.mysql.com Objet : RE: Disconnecting a session 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] -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
