**(#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
🧮 USERS:1 FEEDS:2 TWTS:1153 ARCHIVED:80482 CACHE:2520 FOLLOWERS:17 FOLLOWING:14
🧮 USERS:1 FEEDS:2 TWTS:1152 ARCHIVED:80475 CACHE:2518 FOLLOWERS:17 FOLLOWING:14
🧮 USERS:1 FEEDS:2 TWTS:1151 ARCHIVED:80389 CACHE:2498 FOLLOWERS:17 FOLLOWING:14
Haveno adds support for USDT
woodser1 has released Haveno2 version 1.0.133 with support for Tether (USDT)4, various improvements, updates, and bug fixes.
”`
Support USDT (ERC20 & TRC20)
Refactor tabs for simplicity
Update Tails script to retry download using wget
Improve backup recovery if wallet cache is corrupt
Fix sorting Buy or Sell XMR > Amount column
Update price nodes to support USDT
Other stability improvements and bug fixes [..]
... ⌘ [Read more](https://monero.observer/haveno-v1.0.13-released-support-tether-usdt/)“
🧮 USERS:1 FEEDS:2 TWTS:1150 ARCHIVED:80371 CACHE:2512 FOLLOWERS:17 FOLLOWING:14
@lyse@lyse.isobeef.org agree on the HTTP stuff. I mean we could mention that for optimization see RFC yadda yadda should be followed for caching. but not have it part of the spec proper.
🧮 USERS:1 FEEDS:2 TWTS:1149 ARCHIVED:80357 CACHE:2530 FOLLOWERS:17 FOLLOWING:14
🧮 USERS:1 FEEDS:2 TWTS:1148 ARCHIVED:80344 CACHE:2539 FOLLOWERS:17 FOLLOWING:14
@eapl.me@eapl.me here are my replies (somewhat similar to Lyse’s and James’)
Metadata in twts: Key=value is too complicated for non-hackers and hard to write by hand. So if there is a need then we should just use #NSFS or the alt-text file in markdown image syntax
if something is NSFWIDs besides datetime. When you edit a twt then you should preserve the datetime if location-based addressing should have any advantages over content-based addressing. If you change the timestamp the its a new post. Just like any other blog cms.
Caching, Yes all good ideas, but that is more a task for the clients not the serving of the twtxt.txt files.
Discovery: User-agent for discovery can become better. I’m working on a wrapper script in PHP, so you don’t need to go to Apaches log-files to see who fetches your feed. But for other Gemini and gopher you need to relay on something else. That could be using my webmentions for twtxt suggestion, or simply defining an email metadata field for letting a person know you follow their feed. Interesting read about why WebMetions might be a bad idea. Twtxt being much simple that a full featured IndieWeb sites, then a lot of the concerns does not apply here. But that’s the issue with any open inbox. This is hard to solve without some form of (centralized or community) spam moderation.
Support more protocols besides http/s. Yes why not, if we can make clients that merge or diffident between the same feed server by multiples URLs
Languages: If the need is big then make a separate feed. I don’t mind seeing stuff in other langues as it is low. You got translating tool if you need to know whats going on. And again when there is a need for easier switching between posting to several feeds, then it’s about building clients with a UI that makes it easy. No something that should takes up space in the format/protocol.
Emojis: I’m not sure what this is about. Do you want to use emojis as avatar in CLI clients or it just about rendering emojis?
🧮 USERS:1 FEEDS:2 TWTS:1147 ARCHIVED:80339 CACHE:2544 FOLLOWERS:17 FOLLOWING:14
🧮 USERS:1 FEEDS:2 TWTS:1146 ARCHIVED:80323 CACHE:2540 FOLLOWERS:17 FOLLOWING:14
🧮 USERS:1 FEEDS:2 TWTS:1145 ARCHIVED:80310 CACHE:2546 FOLLOWERS:17 FOLLOWING:14
🧮 USERS:1 FEEDS:2 TWTS:1144 ARCHIVED:80292 CACHE:2571 FOLLOWERS:17 FOLLOWING:14
🧮 USERS:1 FEEDS:2 TWTS:1143 ARCHIVED:80280 CACHE:2583 FOLLOWERS:17 FOLLOWING:14
🧮 USERS:1 FEEDS:2 TWTS:1142 ARCHIVED:80274 CACHE:2580 FOLLOWERS:17 FOLLOWING:14
🧮 USERS:1 FEEDS:2 TWTS:1141 ARCHIVED:80263 CACHE:2576 FOLLOWERS:17 FOLLOWING:14
I wonder how long does Yarn caches a description header. Or rather, how often it re-fetches it.
(#b6juizq) @Codebuzz It currently takes my yarnd pod here around ~2m on average to fetch, process and cache ~700 feeds.
@Codebuzz @www.codebuzz.nl It currently takes my yarnd pod here around ~2m on average to fetch, process and cache ~700 feeds. ⌘ Read more
🧮 USERS:1 FEEDS:2 TWTS:1140 ARCHIVED:80224 CACHE:2551 FOLLOWERS:17 FOLLOWING:14
Wayback Machine & Google Website Cache Go Offline Weeks Before 2024 Election
With a Presidential election days away, the biggest ways to record online statements are conspicuously broken. ⌘ Read more
🧮 USERS:1 FEEDS:2 TWTS:1139 ARCHIVED:80175 CACHE:2521 FOLLOWERS:17 FOLLOWING:14
🧮 USERS:1 FEEDS:2 TWTS:1138 ARCHIVED:80157 CACHE:2518 FOLLOWERS:17 FOLLOWING:14