> Hi D�hr, > Does the size of the data cache have any bearing on the amount > of data written. i.e. will a smaller DATA CACHE reduce the magnitude of > the surge?
Certainly - but then again it will slow down your queries, too, and also lead to more frequent write operations. I would not believe that this is what you want. I'd definitely reduce the cache size if it's currently taking up more mem than physically available in the system (=> swapping). Regards robert > Regards, > Ajit > > -----Original Message----- > From: D�hr [mailto:D�hr] > Sent: Sunday, February 06, 2005 3:22 AM > To: 'Ajit Aranha'; '[email protected]' > Subject: RE: Surge in IO writes by kernel.exe > > > Every 10 minutes the kernel.exe does a large amount of i/o > > writes for a few seconds.(Monitored from windows performance > > monitor) At this time query execution time increases. This > > seems to be related to savepoints (Specifically the db > > parameter RESTART_TIME=600). > > Is this avoidable?? > > This is by design. > > The data gets changed in the CACHE, if there are enough "dirty" pages > (pages > that have changed) or every 10 minutes, the kernel flushes the changed > pages > onto the disk. > > If page would be written immediately to the disk, the whole system would > slow down doing constant write I/O on the disks. > > Maybe you can change the number of volumes and distribute them accross > various disks so that they will get parallized. > > > Greetz, > > > SIEGENIA-AUBI KG > Informationswesen > > i.A. > > Markus D�hr > SAP-CC/BC, SAPDB-DBA > > 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] > -- Lassen Sie Ihren Gedanken freien Lauf... z.B. per FreeSMS GMX bietet bis zu 100 FreeSMS/Monat: http://www.gmx.net/de/go/mail -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
