On Mon, 29 Sep 2003, Kevin wrote: > I've fixed my swapping issues, but the system continues to get stuck in > a 'sending data' phase from time to time. > > With mod_perl + mysql, this phase SHOULD be when mysql collects the rows > (after sorting, etc) and sends them to the perl handler for processing. > > Any ideas why this phase would ever be taking 100-500 seconds? The > system appears to be stable for long times, then gets in a huge > bottleneck locking on one sending data process. These queries aren't > locked and then just finally being processed - they actually remain in > the sending data phase for most of this time. >
Which version of Apache are you using, for I have heard whisperings of problems with socket communications in apache 1.3.28 + mod_perl -- this might be a good place to look. Rudy -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
