2024-09-30 - Spanner Database Optimisation¶
Problem¶
The event_logging table in spanner incurs the most reads and writes (and is the largest table). As part of our regular review of keys it was noted that this table was hot spotting keys alot of the time.
Solution¶
Changing the event_logging key to a guid means that the keys are more uniformly spread out and no longer hot spotting.
Leverage the Magic¶
The spanner console key visualiser lets us see the performance of each table and its keys
ADI¶
Yeah Baby !
Last Refreshed¶
Doc Refreshed: 2024-10-29