Chapter 14. The Database Tuneup
In the foreword to the second edition I rhapsodized about the straightforwardness and other virtues of the common automobile repair manual. In this chapter, I'll attempt to emulate that style of writing and outline a basic procedure that will allow you to tune an Informix database.
So why am I pushing this auto repair analogy so far? I want all of the DBAs reading this to take off their white lab coats and put on their overalls because proper database tuning will require them to poke around in places they usually don't poke. I want to demystify the tuning process. It's not rocket science, but a lot of users and DBAs are intimidated by database tuning and would rather do almost anything else but tune the database. ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Read now
Unlock full access