Hello, The top command show that one maxdb kernel process is taking 99% cpu and several others are taking 50% average. (multicpu system) How can I find out which query is causing the problem and which connected user that is? And how can I stop that user session?
select * from running_commands is empty select * from commandstatics is empty The sessions table should also provide information (according to documentation) but that table is not in my system (4004 - unknown table name) MAXDB: 7.5.00-14 OS: SuSE 9.1 Can this be solved without restarting the database? Thanx in advance for any quick help. Regards, Filip -- *-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-* * System Engineer, Verzekeringen NV * * www.verzekeringen.be * * Oostkaai 23 B-2170 Merksem * * 03/6416673 - 0477/340942 * *-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-* -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
