I say “at last” because the authors worked on this project for not less than two years.
Who are the authors? Several colleagues of mine at Trivadis (Mirko Hotzy, Konrad Häfeli, Daniel Steiger, Sven Vetter, Peter Welker), Andrea Held, Lutz Fröhlich, Marek Adar and myself.
For my part, I wrote two chapters: Speicherplatzverwaltung and Optimierung.
I don’t know whether this is the right place to comment on the preview chapter of that book, but here goes:
(P. 253, last sentence of 4.1.3.3)
“Grundsätzlich muss die Datenbank gleich viel Memory besitzen, wie das Betriebssystem vor der Umstellung für den Buffer-cache verwendet hat.”
Wouldn’t it be more accurate to say that the amount of memory for the database [instances] should be INCREASED by the amount used by the OS for filesystem buffering before the change? If not, why not?
Gruß,
Flado
Hi Flado
You are absolutely right! Unfortunately this is a mistake I was not able to spot… What happened is, that I wrote that chapter in English and only later on it was translated to German.
Here the original and the published sentences:
Original: To avoid such a problem you should increase the database buffer cache. Basically, you have to provide to the database engine the memory that was used by the operating system for the buffer cache.
Published: Um dies zu verhindern, sollte der Datenbank Buffercache entsprechend groß sein. Grundsätzlich muss die Datenbank gleich viel Memory besitzen, wie das Betriebssystem vor der Umstellung für den Buffercache verwendet hat.
Thank you for poiting out the mistake.
Cheers,
Chris
Hi Chris,
I found some time to read a couple of more pages of your chapter and it seems I stumble upon similar unclarities quite regularly. Knowing you, I’m sure all of them are due to the translation. Would it be possible for you to post the original (English) text of this chapter as well?
Cheers,
Flado
Hi Flado
Sorry but I’m not allowed to share the text.
Chris
Could you tell me if it’s possible to buy this book in English?
Hi Baku
Such a possibility doesn’t exist.
Sorry,
Chris