I can no longer reproduce 3.23.58 running faster than 4.1.3-beta. If anything, 4.1 is running faster, especially because of the query cache, which helps in my situation. I'm not sure what (if anything) has changed in my environment.
Here's another issue. We are running a Beowulf cluster under Rocks v3.1.0 with Dual Xeon processors and 4Gig of memory on each node. Within a node I see much better performance on concurrent queries when running two MySQL servers (each with their own copy of the database) than if I run just one. Looking at my processes I see much more 'system' overhead when just one server is running than if there are two. Things I've read imply that a single server should be able to spread its load over multiple processors, but that doesn't seem to be the case. Not sure whether this is a Linux issue or a MySQL one. --Th -----Original Message----- From: Sergei Golubchik [mailto:[EMAIL PROTECTED] Sent: Wednesday, July 14, 2004 1:09 PM To: Lachlan Mulcahy Cc: [EMAIL PROTECTED] Subject: Re: 4.1 performance Hi! On Jul 14, Lachlan Mulcahy wrote: > > Sergei, Thom.. > > I am interested in seeing this thread followed through. As developers at my > work have experienced similar performance issues between 3.23.x and 4. Our > database is also of similar size and a full optimize has been run. Could you provide a repeatable test case ? (if yes, you can submit it on bugs.mysql.com, instead of replying here - and be sure it will get a proper attention) Regards, Sergei -- __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Sergei Golubchik <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Senior Software Developer /_/ /_/\_, /___/\___\_\___/ Osnabrueck, Germany <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
