Hi Alexey,
since the technical problems are located in pthread and swapcontext area, we
might never support coroutines and load balancing on OS other than Windows and
Solaris. This is highly compiler dependent.
When testing with activated coroutines and no load balancing, make sure that
the parameter FORBID_COROUTINES is NO, otherwise the value of parameter
USE_COROUTINES is automatically reset to NO (you want YES in this case).
If you really observe the situation that your load is hardly ever distibuted
evenly across your 4 CPUs, you could of course try do deactivate coroutines
(set parameter USE_COROUTINES to NO) and activate load balancing (set parameter
LOAD_BALANCING_CHK to e.g. 30).
You'd have to test if the advantage of load balancing outweighs the
disadvantage of not having coroutines.
If all that does not help and if the deltas in your data are rather small
compared to the overall size of your data, the synchronization manager might be
a good idea.
Отношения,
Marc-Philip
________________________________
From: Alexey Gaidukov [mailto:[EMAIL PROTECTED]
Sent: Donnerstag, 22. Dezember 2005 11:29
To: Werner, Marc-Philip
Cc: maxdb@lists.mysql.com
Subject: Re: Can't activate Load balancing
I have problems with long-running statements. In my case they are
reports. Now I'am installing other MaxDB server for reports and installing
syncronization manager for replications.
In which version of MaxDB for linux load balancing will work?
Best regard,
Alexey Gaidukov.
Werner, Marc-Philip пишет:
Hi Alexey,
Can somebody help me? Why Load balancing is disabled?
Load balancing and coroutines can only be active at the same
time on
Windows and Solaris systems.
Since you are on Linux, you must either deactivate coroutines
or you
cannot use load balancing. I assume you want to use your
database as a
OLTP database, the recommendation is to not use load balancing
(if you
deactivated coroutines and activated load balancing, the
performance you
would win with load balancing, would be eaten up by not having
coroutines).
Do you really need load balancing? That would only make sense
if you had
very long-running SQL statements.
Regards,
Marc-Philip
--
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe:
http://lists.mysql.com/[EMAIL PROTECTED]
