🧮 USERS:1 FEEDS:2 TWTS:1205 ARCHIVED:83338 CACHE:2807 FOLLOWERS:17 FOLLOWING:14
(#7xqzija) @kat I’ve actually moved most of my stuff of of Cloudflare now 🤣 I’m actually very happy with my edge proxy setup that reverse pro …
@kat @yarn.girlonthemoon.xyz I’ve actually moved most of my stuff of of Cloudflare now 🤣 I’m actually very happy with my edge proxy setup that reverse proxies, caches and acts as a web application firewall 🥳 ⌘ Read more
Oh gawd. I can’t enable caching on my edge proxy everywhere 😱 Some shit™ doesn’t deal with a caching reverse proxy in front of it very well …
Oh gawd. I can’t enable caching on my edge proxy everywhere 😱 Some shit™ doesn’t deal with a caching reverse proxy in front of it very well for some reason I don’t have time to dig into right now 🤔 ⌘ Read more
🧮 USERS:1 FEEDS:2 TWTS:1204 ARCHIVED:83223 CACHE:2725 FOLLOWERS:17 FOLLOWING:14
🧮 USERS:1 FEEDS:2 TWTS:1203 ARCHIVED:83193 CACHE:2705 FOLLOWERS:17 FOLLOWING:14
🧮 USERS:1 FEEDS:2 TWTS:1202 ARCHIVED:83145 CACHE:2701 FOLLOWERS:17 FOLLOWING:14
🧮 USERS:1 FEEDS:2 TWTS:1201 ARCHIVED:83066 CACHE:2647 FOLLOWERS:17 FOLLOWING:14
🧮 USERS:1 FEEDS:2 TWTS:1200 ARCHIVED:83048 CACHE:2630 FOLLOWERS:17 FOLLOWING:14
🧮 USERS:1 FEEDS:2 TWTS:1199 ARCHIVED:83034 CACHE:2626 FOLLOWERS:17 FOLLOWING:14
🧮 USERS:1 FEEDS:2 TWTS:1198 ARCHIVED:82999 CACHE:2604 FOLLOWERS:17 FOLLOWING:14
🧮 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