hello all, i'm having an unusual problem with mysql here in a bioinformatic application. in these cases, the server "hangs" upon receiving a query. i can't predict which queries will trigger the problem, but once one comes up, even restarting the server doesn't keep it from happening. i also erased the files in /var/lib/mysql/test/ suspecting that it had got into an inconsistent state, but that didn't help either. when the hang occurs, whether triggered from the monitor or my perl program, the program sends a query via a socket to the daemon and waits for the response. the server is stuck waiting on a select call. rebooting the machine seems to reset the criteria determining which queries cause the system to fail, but something still does, and rather quickly. i'm getting between 1 and a dozen queries done before one fails, and failures occur on reruns at places that worked previously. any suggestion is welcome; i'm really puzzled! thanks, aaron brick. --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
