Parameters for the DBA to sign the contract with the Boss: fast_start_mttr_target

When we sign the contract with the boss, there is a very important parameter: fast_start_mttr_target

1 fast_start_mttr_target: The target for quickly starting the average fault recovery time. Unit: s. The default value is 0 (disabled ).

2 fast_start_mttr_target is converted to an internal parameter, for example:
Log_checkpoint_interval (dirty blocks reach the Domain value)
Log_checkpoint_timeout (timeout occurs)
When min (log_checkpoint_interval, log_checkpoint_timeout,
The incremental checkpoint event is triggered to control the frequency and load of DBWRn.

3 analogy:
Fast_start_mttr_target is similar to F of Tsinghua University.
The setting of internal parameters is similar to ordinary effort N
Workload analogy (IQ, learning method, attitude, etc.) W
 
F = N * W
James has a high IQ and has a correct attitude [that is, the workload is small]. He can go to Tsinghua without any effort. [that is, internal parameters can be set to a greater value]. the overall quality of individual Li Si is worse than that of Zhang San [that is, the workload is large], but he works very hard [that is, setting internal parameters smaller] and can also go to Tsinghua.
There may be situations where James is also very hard at ordinary times. He is also in Tsinghua, but he will live very tired and may crash.

4 is the response of log length and strength

1 2 Next Page