After changing LOAD_BALANCING_CHK from 0 to 15 and restarting database, i always have : >Balancing Info: > Load balancing - DISABLED > Interval time - 0 (s) > Last interval start - (ddd:hh:mm:ss) > Move intervals - 0 > Minimum diff. - 10 (%) > Value equality - 5 (%) > > >User Kernel Threads: > UKT Movable Interval start Max. Sum UKT > Tasks (ddd:hh:mm:ss) Runnable Runnable Idle Time > 7 0 0.000000 0.000000 0.000000 > 8 0 0.000000 0.000000 0.000000
I have see another parameter FORBID_LOAD_BALANCING that was to yes, have changed to no, restarted datebase, the loadbalancing is always disabled. What parameter have i missed ? -----Message d'origine----- De : Zabach, Elke [mailto:[EMAIL PROTECTED] Envoye : vendredi 16 juin 2006 13:13 A : Fabrice Bourdel; maxdb@lists.mysql.com Objet : RE: configuration question Fabrice Bourdel wrote: > thx for response > > the server is dedicated to the database. I would like > to set the LOAD_BALANCING_CHK time interval. > I have queries that could take a little time to many > seconds (5, 10). > But, what value would be a "standard" value ? > > Even shorter answer: 15 seconds Elke SAP Labs Berlin > -----Message d'origine----- > De : Zabach, Elke [mailto:[EMAIL PROTECTED] > Envoye : vendredi 16 juin 2006 12:34 > A : Fabrice Bourdel; maxdb@lists.mysql.com > Objet : RE: configuration question > > > Fabrice Bourdel wrote > > > Hi, > > > > I have an bi processor machine, and have declared > > 2 procs to MaxDB. > > But just a question about an information in the > > Database Manager : > > In : Check / DataBaseServer / section "MoveInfo Load balancing info" > > is reported : > > > > Balancing Info: > > Load balancing - DISABLED > > Interval time - 0 (s) > > Last interval start - (ddd:hh:mm:ss) > > Move intervals - 0 > > Minimum diff. - 10 (%) > > Value equality - 5 (%) > > > > > > User Kernel Threads: > > UKT Movable Interval start Max. Sum UKT > > Tasks (ddd:hh:mm:ss) Runnable Runnable Idle Time > > 7 2 0.000000 0.000000 > 0.000000 > > 8 1 0.000000 0.000000 > 0.000000 > > > > Has load balancing anything to do here with the 2 procs ? > > > > Short answer prepared by a colleague: > > Assuming that your applications are running on the same > computer as the > database kernel, > there is no performance benefit setting the kernel parameter MAXCPU > greater than 1 on your two processor system. > > If you would like to use your system as dedicated database > server, task > load balancing might help you to spread the > database user tasks across the database threads. > > For more information plase refer to the following documentation: > > Process Structure > http://dev.mysql.com/doc/maxdb/en/c0/165342d8a7be30e10000000a1 > 55106/fram > eset.htm > > Load Balancing > http://dev.mysql.com/doc/maxdb/en/8a/320c40ac368f5ce10000000a1 > 55106/fram > eset.htm > > Elke > SAP Labs Berlin > > > > > -- > > MaxDB Discussion Mailing List > > For list archives: http://lists.mysql.com/maxdb > > To unsubscribe: > > http://lists.mysql.com/[EMAIL PROTECTED] > > > > > > -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
