Are the first three machines closing their connections correctly? Duncan -- Duncan Salada | Titan | www.titan.com/testeval Email: [EMAIL PROTECTED] | Voice: 301-925-3222x375 | Fax: 301-925-3216
> -----Original Message----- > From: Gabriel [mailto:[EMAIL PROTECTED]] > Sent: Monday, March 25, 2002 3:07 PM > To: [EMAIL PROTECTED] > Subject: Strange query issues > > > > Hello all. > > For my first post to the list, I have a very strange problem. > (And yes, > I have perused the archives. I haven't found anything similar.) > > Here's the situation: > > I've got 6 machines that that make requests to a 7th machine, > which is > running mysql-3.23.47. All the machines are FreeBSD 4.3-RELEASE. > > Our example query is "SELECT id, username, domain FROM usermanagement > LIMIT 1000", id is a primary key, and both username and domain are > indexed. > > The first three servers make the query in about 0.13 seconds. > The last > three take about 6.01 seconds to perform the query. > > This has been consistant and repeatable. > > All the machines are running the same client software. They are all > connected to the server over a switch, with no routers > inbetween. They > all are in the same subnet. They are also all configured in the same > way - they are mail servers. The load is balanced, and no server is > doing any significantly larger amount of processing than the others. > > Can anyone suggest anything for me to try to fix this problem? > > Many many thanks in advance, > Gabriel. > > > > -- > Gabriel Cain > Unix Systems Administrator [EMAIL PROTECTED] > Dialup USA, Inc. 888-460-2286 ext 208 > > > --------------------------------------------------------------------- > 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 > --------------------------------------------------------------------- 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