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