Yes I have my statistics up to date, I choose to turn off auto-update.
Are you using coroutines or load balancing? My cpu times when there is no activity sometimes reach 40%. I have not set processor affinity or anything like that, my CPU does not support hyperthreading either. I can understand that MaxDB is always working, what I don't understand is why it is taking so much CPU to process almost any query. And response times are not as good as I would expect with this new hardware. Whatever the case, I will unmount my raid-0 (software based) experiment and dedicate 1 disk for log and 1 disk for data for my next test. I still would like to know what config SAP/MySQL support team recommends for Intel Dual Core CPU regarding coroutines, load balancing and other parameters. Regards, Martin -- Dinamica - RADical J2EE framework open source, easy and powerful http://www.martincordova.com On 10/23/06, "Döhr, Markus ICC-H" <[EMAIL PROTECTED]> wrote:
[...] > 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]
