🧮 USERS:1 FEEDS:2 TWTS:1197 ARCHIVED:82971 CACHE:2593 FOLLOWERS:17 FOLLOWING:14
🧮 USERS:1 FEEDS:2 TWTS:1196 ARCHIVED:82957 CACHE:2587 FOLLOWERS:17 FOLLOWING:14
🧮 USERS:1 FEEDS:2 TWTS:1195 ARCHIVED:82947 CACHE:2593 FOLLOWERS:17 FOLLOWING:14
🧮 USERS:1 FEEDS:2 TWTS:1194 ARCHIVED:82940 CACHE:2600 FOLLOWERS:17 FOLLOWING:14
🧮 USERS:1 FEEDS:2 TWTS:1193 ARCHIVED:82927 CACHE:2592 FOLLOWERS:17 FOLLOWING:14
🧮 USERS:1 FEEDS:2 TWTS:1192 ARCHIVED:82886 CACHE:2562 FOLLOWERS:17 FOLLOWING:14
🧮 USERS:1 FEEDS:2 TWTS:1191 ARCHIVED:82846 CACHE:2546 FOLLOWERS:17 FOLLOWING:14
🧮 USERS:1 FEEDS:2 TWTS:1190 ARCHIVED:82843 CACHE:2552 FOLLOWERS:17 FOLLOWING:14
🧮 USERS:1 FEEDS:2 TWTS:1189 ARCHIVED:82836 CACHE:2551 FOLLOWERS:17 FOLLOWING:14
🧮 USERS:1 FEEDS:2 TWTS:1188 ARCHIVED:82821 CACHE:2541 FOLLOWERS:17 FOLLOWING:14
🧮 USERS:1 FEEDS:2 TWTS:1187 ARCHIVED:82790 CACHE:2523 FOLLOWERS:17 FOLLOWING:14
🧮 USERS:1 FEEDS:2 TWTS:1186 ARCHIVED:82783 CACHE:2539 FOLLOWERS:17 FOLLOWING:14
🧮 USERS:1 FEEDS:2 TWTS:1185 ARCHIVED:82771 CACHE:2535 FOLLOWERS:17 FOLLOWING:14
🧮 USERS:1 FEEDS:2 TWTS:1184 ARCHIVED:82750 CACHE:2548 FOLLOWERS:17 FOLLOWING:14
🧮 USERS:1 FEEDS:2 TWTS:1183 ARCHIVED:82747 CACHE:2561 FOLLOWERS:17 FOLLOWING:14
🧮 USERS:1 FEEDS:2 TWTS:1182 ARCHIVED:82725 CACHE:2585 FOLLOWERS:17 FOLLOWING:14
🧮 USERS:1 FEEDS:2 TWTS:1181 ARCHIVED:82695 CACHE:2586 FOLLOWERS:17 FOLLOWING:14
🧮 USERS:1 FEEDS:2 TWTS:1180 ARCHIVED:82677 CACHE:2596 FOLLOWERS:17 FOLLOWING:14
🧮 USERS:1 FEEDS:2 TWTS:1179 ARCHIVED:82669 CACHE:2598 FOLLOWERS:17 FOLLOWING:14
🧮 USERS:1 FEEDS:2 TWTS:1178 ARCHIVED:82661 CACHE:2609 FOLLOWERS:17 FOLLOWING:14
🧮 USERS:1 FEEDS:2 TWTS:1177 ARCHIVED:82651 CACHE:2611 FOLLOWERS:17 FOLLOWING:14
🧮 USERS:1 FEEDS:2 TWTS:1176 ARCHIVED:82646 CACHE:2621 FOLLOWERS:17 FOLLOWING:14
**(#7yfkzjq) * Page size 1MB
Median 50 pages per query
80% pages cached
200us SSD reads
100us Memory reads
Query time:
- (50x0.80x10 …**
- (50x0.80x10 …**
Page size 1MB
Median 50 pages per query
80% pages cached
200us SSD reads
100us Memory reads
Query time:
(50x0.80x100)+(50x0.20x200) = 6,000
6000us
6ms ⌘ Read more
🧮 USERS:1 FEEDS:2 TWTS:1175 ARCHIVED:82637 CACHE:2646 FOLLOWERS:17 FOLLOWING:14
🧮 USERS:1 FEEDS:2 TWTS:1174 ARCHIVED:82617 CACHE:2644 FOLLOWERS:17 FOLLOWING:14
**Problem 2: Your SSD-backed database has a usage-pattern that rewards you with a 80% page-cache hit-rate (i.e. 80% of disk reads are served d …**
Problem 2: Your SSD-backed database has a usage-pattern that rewards you with a 80% page-cache hit-rate (i.e. 80% of disk reads are served directly out of memory instead of going to the SSD). The median is 50 distinct disk pages for a query to gather its query results (e.g. InnoDB pages in MySQL). What is the expected average query time from your database?
Share your solution via Twtxt … ⌘ Read more
🧮 USERS:1 FEEDS:2 TWTS:1173 ARCHIVED:82598 CACHE:2635 FOLLOWERS:17 FOLLOWING:14
🧮 USERS:1 FEEDS:2 TWTS:1172 ARCHIVED:82511 CACHE:2595 FOLLOWERS:17 FOLLOWING:14
🧮 USERS:1 FEEDS:2 TWTS:1171 ARCHIVED:82487 CACHE:2591 FOLLOWERS:17 FOLLOWING:14
🧮 USERS:1 FEEDS:2 TWTS:1170 ARCHIVED:82459 CACHE:2573 FOLLOWERS:17 FOLLOWING:14
🧮 USERS:1 FEEDS:2 TWTS:1169 ARCHIVED:82451 CACHE:2575 FOLLOWERS:17 FOLLOWING:14
🧮 USERS:1 FEEDS:2 TWTS:1168 ARCHIVED:82432 CACHE:2565 FOLLOWERS:17 FOLLOWING:14
🧮 USERS:1 FEEDS:2 TWTS:1167 ARCHIVED:82419 CACHE:2558 FOLLOWERS:17 FOLLOWING:14
🧮 USERS:1 FEEDS:2 TWTS:1166 ARCHIVED:82408 CACHE:2578 FOLLOWERS:17 FOLLOWING:14
(#pluepia) @bender@bender yeah I did but my cache might be poisoned now hmmm 🤔 I think I cam make more improvements when I get back 🤞�� …
@bender yeah I did but my cache might be poisoned now hmmm 🤔 I think I cam make more improvements when I get back 🤞🏻 ⌘ Read more
(#tmvyd5a) @sorenpeter@sorenpeter yeah that’s fair enough, but you could still Cloudflare in front of your server and use a CDN for caching.
@sorenpeter @darch.dk@darch.dk yeah that’s fair enough, but you could still Cloudflare in front of your server and use a CDN for caching. ⌘ Read more
🧮 USERS:1 FEEDS:2 TWTS:1165 ARCHIVED:82367 CACHE:2563 FOLLOWERS:17 FOLLOWING:14
🧮 USERS:1 FEEDS:2 TWTS:1164 ARCHIVED:81038 CACHE:2566 FOLLOWERS:17 FOLLOWING:14
🧮 USERS:1 FEEDS:2 TWTS:1163 ARCHIVED:81006 CACHE:2562 FOLLOWERS:17 FOLLOWING:14
🧮 USERS:1 FEEDS:2 TWTS:1162 ARCHIVED:80992 CACHE:2550 FOLLOWERS:17 FOLLOWING:14
🧮 USERS:1 FEEDS:2 TWTS:1161 ARCHIVED:80975 CACHE:2542 FOLLOWERS:17 FOLLOWING:14
🧮 USERS:1 FEEDS:2 TWTS:1160 ARCHIVED:80963 CACHE:2541 FOLLOWERS:17 FOLLOWING:14
🧮 USERS:1 FEEDS:2 TWTS:1159 ARCHIVED:80771 CACHE:2557 FOLLOWERS:17 FOLLOWING:14
🧮 USERS:1 FEEDS:2 TWTS:1158 ARCHIVED:80759 CACHE:2552 FOLLOWERS:17 FOLLOWING:14
🧮 USERS:1 FEEDS:2 TWTS:1157 ARCHIVED:80751 CACHE:2550 FOLLOWERS:17 FOLLOWING:14
One of the things I’m going to work on next (maybe today, we’ll see how much time there’s left in the day) is being able to load up old conver …
One of the things I’m going to work on next ( maybe today, we’ll see how much time there’s left in the day) is being able to load up old conversations ( fallen off the cache) like this one. ⌘ Read more
🧮 USERS:1 FEEDS:2 TWTS:1156 ARCHIVED:80715 CACHE:2527 FOLLOWERS:17 FOLLOWING:14
After several hard hours, I think I’ve recovered the last missing 1 Twt from @bender@bender 🥳 Turns out just before I accidentally nuk …
After several hard hours, I think I’ve recovered the last missing 1 Twt from @bender 🥳 Turns out just before I accidentally nuked my pod, I took a dump of it’s cached just seconds before 🤣 – So I was also able to rebuild anything that was missing from the backup from the recent cache dump! ⌘ Read more
🧮 USERS:1 FEEDS:2 TWTS:1155 ARCHIVED:80531 CACHE:2518 FOLLOWERS:17 FOLLOWING:14
🧮 USERS:1 FEEDS:2 TWTS:1154 ARCHIVED:80495 CACHE:2515 FOLLOWERS:17 FOLLOWING:14