OSEC

Neohapsis is currently accepting applications for employment. For more information, please visit our website www.neohapsis.com or email hr@neohapsis.com
 
Re: Load Balancing with MAXCPU exhibits different locking behavior

From: Joe Haynes (jhayneskeycomputerconsultants.com)
Date: Thu Sep 15 2005 - 11:59:01 CDT

Robert,

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
7.5.0.23 on a 4 way RedHat Enterprise system which shows
8 active processors within the process list.

Thank you,

Joe Haynes
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
>
> robert
>
> 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