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?
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]
