In production, a table with nearly 300 fields is frequently inserted, and another table is executed for more than 1s and less than 3s every once in a while during update (no resource contention at the application layer). The instant is the point in time when the dbwn cache block is written, 12 dbw background threads are executed together, and the IO usage is 20MB, which is much lower than the average of the server hard disk. The server is configured with 4 cpus, 96 logical threads, and 128 GB of memory
Enable concurrent thread insertion, fast insertion speed, fast dbwn frequency, and fast update delay.
DBWN writes data to hard disks. Update delay exceeds 1 second. This phenomenon is bound to occur
When dbwn writes data, update insert and other operations are not affected