We have one query which takes approximately 2 minutes. MySql seems to be
unresponsive to any other threads until this query has completed.
On some platforms, the thread library has a limitation/bug that does not permit thread pre-emption, which means that if a thread does not want to give up CPU, it will not be forced to do so. What platform is this on?
In any case, my recommendation would be to do whatever it takes to keep that queyr from running for 2 minutes. Try to optimize it, or re-write it so it gets its data in small chunks.
-- Sasha Pachev Create online surveys at http://www.surveyz.com/
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
