the story about cache
DESCRIPTION
TRANSCRIPT
![Page 2: The story about cache](https://reader034.vdocuments.us/reader034/viewer/2022050706/548408beb47959d80c8b4a48/html5/thumbnails/2.jpg)
Use Case: Login
![Page 3: The story about cache](https://reader034.vdocuments.us/reader034/viewer/2022050706/548408beb47959d80c8b4a48/html5/thumbnails/3.jpg)
Use Case: Login
Common Case
![Page 4: The story about cache](https://reader034.vdocuments.us/reader034/viewer/2022050706/548408beb47959d80c8b4a48/html5/thumbnails/4.jpg)
Use Case: Login
Common Case Read From DB
Select * from Users where id=‘charsyam’;
![Page 5: The story about cache](https://reader034.vdocuments.us/reader034/viewer/2022050706/548408beb47959d80c8b4a48/html5/thumbnails/5.jpg)
Use Case: Login
May be it’s genenally fast
![Page 6: The story about cache](https://reader034.vdocuments.us/reader034/viewer/2022050706/548408beb47959d80c8b4a48/html5/thumbnails/6.jpg)
Use Case: Login
But it’s Slow In Many Read/Write
![Page 7: The story about cache](https://reader034.vdocuments.us/reader034/viewer/2022050706/548408beb47959d80c8b4a48/html5/thumbnails/7.jpg)
Use Case: Login
Advanced Case Read From Cache
Get charsyam
![Page 8: The story about cache](https://reader034.vdocuments.us/reader034/viewer/2022050706/548408beb47959d80c8b4a48/html5/thumbnails/8.jpg)
Use Case: Login
it’s always fast
![Page 9: The story about cache](https://reader034.vdocuments.us/reader034/viewer/2022050706/548408beb47959d80c8b4a48/html5/thumbnails/9.jpg)
Use Case: Login
136 vs 1613 seconds
Memcache VS Mysql
![Page 10: The story about cache](https://reader034.vdocuments.us/reader034/viewer/2022050706/548408beb47959d80c8b4a48/html5/thumbnails/10.jpg)
Use Case: Login
250 million User ID Request 10 million
![Page 11: The story about cache](https://reader034.vdocuments.us/reader034/viewer/2022050706/548408beb47959d80c8b4a48/html5/thumbnails/11.jpg)
Where We Can Use Cache?
Just Check User exists? Mail Receive, Tweet Mention
Get User’s Profile Get User’s Timeline
![Page 12: The story about cache](https://reader034.vdocuments.us/reader034/viewer/2022050706/548408beb47959d80c8b4a48/html5/thumbnails/12.jpg)
Caches
Memcache
Redis
![Page 13: The story about cache](https://reader034.vdocuments.us/reader034/viewer/2022050706/548408beb47959d80c8b4a48/html5/thumbnails/13.jpg)
Memcache
Atomic Operation
![Page 14: The story about cache](https://reader034.vdocuments.us/reader034/viewer/2022050706/548408beb47959d80c8b4a48/html5/thumbnails/14.jpg)
Memcache
Atomic Operation
Key:Value
![Page 15: The story about cache](https://reader034.vdocuments.us/reader034/viewer/2022050706/548408beb47959d80c8b4a48/html5/thumbnails/15.jpg)
Memcache
Atomic Operation
Key:Value Single Thread
![Page 16: The story about cache](https://reader034.vdocuments.us/reader034/viewer/2022050706/548408beb47959d80c8b4a48/html5/thumbnails/16.jpg)
Memcache
Over 100,000 TPS Processing
![Page 17: The story about cache](https://reader034.vdocuments.us/reader034/viewer/2022050706/548408beb47959d80c8b4a48/html5/thumbnails/17.jpg)
Redis
Key:Value
![Page 18: The story about cache](https://reader034.vdocuments.us/reader034/viewer/2022050706/548408beb47959d80c8b4a48/html5/thumbnails/18.jpg)
Redis
Key:Value
Collection
List Sorted Set
![Page 19: The story about cache](https://reader034.vdocuments.us/reader034/viewer/2022050706/548408beb47959d80c8b4a48/html5/thumbnails/19.jpg)
Cache Layer
Cache
DBMS
Storage Layer
Application Server
READ
WRITE
WRITE UPDATE
![Page 20: The story about cache](https://reader034.vdocuments.us/reader034/viewer/2022050706/548408beb47959d80c8b4a48/html5/thumbnails/20.jpg)
Cache Layer Like Twitter
K: UserID, V: Y/N
K: UserID_TIMELINE, V: Tweet IDs
K: UserID_TWEETID, V: Tweet Contents
Check User exists
Check tweet list
Check Content
1st Level Cache
2nd Level Cache
3rd Level Cache
![Page 21: The story about cache](https://reader034.vdocuments.us/reader034/viewer/2022050706/548408beb47959d80c8b4a48/html5/thumbnails/21.jpg)
BUTs
Sometimes Cache is slower than DB
![Page 22: The story about cache](https://reader034.vdocuments.us/reader034/viewer/2022050706/548408beb47959d80c8b4a48/html5/thumbnails/22.jpg)
Why?
DBMS Also Uses Cache If Cache is hit. It’s faster than …
![Page 23: The story about cache](https://reader034.vdocuments.us/reader034/viewer/2022050706/548408beb47959d80c8b4a48/html5/thumbnails/23.jpg)
DBMS
DBMS
Storage Layer
Application Server
READ
WRITE
Cache
![Page 24: The story about cache](https://reader034.vdocuments.us/reader034/viewer/2022050706/548408beb47959d80c8b4a48/html5/thumbnails/24.jpg)
Environment
Small Data Sets Read Just 0.2~03mili
![Page 25: The story about cache](https://reader034.vdocuments.us/reader034/viewer/2022050706/548408beb47959d80c8b4a48/html5/thumbnails/25.jpg)
Comparision
DB’s Cache: 0.2mili memCache: 0.4mili
If you check cache, you spend more time
![Page 26: The story about cache](https://reader034.vdocuments.us/reader034/viewer/2022050706/548408beb47959d80c8b4a48/html5/thumbnails/26.jpg)
BUTs BUTs
Cache helps to reduce DBMS’s Loads
And It reduces Performance Deviation
![Page 27: The story about cache](https://reader034.vdocuments.us/reader034/viewer/2022050706/548408beb47959d80c8b4a48/html5/thumbnails/27.jpg)
Use Cache!
![Page 28: The story about cache](https://reader034.vdocuments.us/reader034/viewer/2022050706/548408beb47959d80c8b4a48/html5/thumbnails/28.jpg)
Thank you!