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 ?
-----Message d'origine----- De : Zabach, Elke [mailto:[EMAIL PROTECTED] Envoye : vendredi 16 juin 2006 12:34 A : Fabrice Bourdel; [email protected] 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/165342d8a7be30e10000000a155106/fram eset.htm Load Balancing http://dev.mysql.com/doc/maxdb/en/8a/320c40ac368f5ce10000000a155106/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]
