[...] > MaxDB consumes (according to command "top") 100% or more CPU time, > even for queries with a low cost plan. I can't see any disk activity, > and cache hits display 100%. Even when there is no client activity, > the MaxDB process (kernel) shows constant activity, up to 30% or more > in some cases. Is this normal??
Did you update your table statistics recently? I´m seeing this too, I think this is due to the Garbage Collector runs. We have a Solaris X86_64 box with 8 instances, even if only the databases are started (an no SAP application), the system has a permanent load of > 2 (and this is no system time). I would also be interested if this can be tuned/configured somehow. I can also seeing that the system is doing "UpdStat" on some UKTs then and when - is that done implicitly on 7.6? > I guess my queries are becoming CPU intensive, instead of IO > intensive. Is there anything I can tune in the database parameters? I > observed that with this version COROUTINES=YES, instead of load > balancing, is this a good default for this platform? Update your statistics and see if that will help. Greetz, SIEGENIA-AUBI KG Informationswesen i.A. Markus Döhr SAP-Competence Center/Basis Tel.: +49 6503 917-152 Fax: +49 6503 917-7152 E-Mail: [EMAIL PROTECTED] Internet: http://www.siegenia-aubi.com -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
