Neohapsis is currently accepting applications for employment. For more information, please visit our website www.neohapsis.com or email firstname.lastname@example.org
Re: Load Balancing with MAXCPU exhibits different locking behavior
From: Joe Haynes (jhayneskeycomputerconsultants.com)
Date: Thu Sep 15 2005 - 11:59:01 CDT
Thanks for the testing. We have been wondering about this
setting for quite a while.
Does anyone on the list know if the same rules for this
parameter apply for Linux systems? We are running MAXDB
184.108.40.206 on a 4 way RedHat Enterprise system which shows
8 active processors within the process list.
Key Computer Consultants, Inc.
Helena, Montana, US
On Thu, 2005-09-15 at 10:07 +0200, Robert Klemme wrote:
> Hi all,
> we did some tests with different settings of MAXCPU (1 and 4) on a
> dual processor board with hyper threading. MaxDB version is 7.5.00.18
> on Windows. For each test we started 4 bulk loads concurrently into
> the same table. With MAXCPU=1 there were no problems and bulk loads
> completed normally. With MAXCPU=4 the database run into a lock
> collisions and all imports hang.
> Is this expected behavior? What bugs me is that even with MAXCPU=1
> all four bulk loads run in parallel so at least from the observer's
> point of view nothing changes. This would be different if only one
> bulk load would be running at a time.
> Did I miss something? Is this a bug? Thanks!
> Kind regards
> PS: I searched the bud database but did not find a single entry that
> contains "MAXCPU".
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb