Invalidating cache php
But splits and merges are rarely executed and using exclusive latch just in case is overkill.
So we added feature and, shared, promotable traversals are used instead exclusive ones.
All index manipulation functions used to traverse the B -trees using exclusive latch, in case it had to split or merge nodes.
In multiple threaded systems, performance bottlenecks are commonly related to concurrency on shared resources.
Tables, rows, index keys, data pages, data files are only few examples of shared resources typical to transactional systems.
My SQL peaks at 1400W, with 19.5k tpm C and over 4 seconds latency.
Sysbench OLTP is another heavy workload benchmark used to test My SQL performance, but adapted by us to test the CUBRID engine.