Patent ID: 7447710

Claim:
In a database system, a self-tuning method for performing recovery operations by dynamically adapting how many recovery threads are spawned during recovery, the method comprising: (a) spawning an initial recovery thread to perform recovery operations for at least one database that may require recovery; (b) measuring I/O (input/output) performance with the initial recovery thread; (c) spawning a subsequent recovery thread to perform recovery operations; (d) measuring I/O performance with the subsequent recovery thread; and (e) self-tuning how many threads are spawned by continuing, as long as I/O performance does not degrade beyond a preselected percentage, to repeat steps (c) and (d) for spawning a desired number of additional recovery threads and when I/O performance measured for a just-spawned recovery thread degrades beyond the preselected percentage, putting the just-spawned recovery thread to sleep; wherein a user of the system is able to specify a particular number of concurrent recovery threads, and wherein the system generates an advisory if the particular number of concurrent recovery threads specified can be changed to achieve better I/O performance.