Miles McGuire
6.7K posts
Miles McGuire
@_minuteman3
Cache rules everything around me
Dublin Katılım Nisan 2009
572 Takip Edilen386 Takipçiler
we now show you how many IOPs you have provisioned in a metal cluster (yes these are real numbers)
English
Miles McGuire retweetledi
Intercom uses #Rails to enable hundreds of engineers to ship changes quickly without slow, centralized reviews. But running migrations across hundreds of tables and terabytes of MySQL data comes with real risks. In his #RailsWorld 2025 @_minuteman3 will share the changes they made to reduce risk and enable their engineers to safely move fast.
rubyonrails.org/world/2025/day… @intercom
English
@mhenrixon @ciaran_lee @qizler Worth a note here - with ignored columns we were listing off every column on the table in the query, the ignored columns had been dropped in many cases. So moving to select * was a pure saving, didn’t result in more data in the result set.
English
@mhenrixon @ciaran_lee @qizler In the same cost saving exercise we elsewhere made big wins by *not* using select * and not loading big, heavy fields in contexts they’re not needed. Always need to consider context, measure, verify. select * is a good default though!
English
Miles McGuire retweetledi
The things that make a difference at scale are so wild.
Using ignored_columns in Rails results in SQL queries that list each column to be read, versus just "SELECT *". For tables with many columns, this meant we were sending ~20 TB of extra text to the database per day.
English
@_exoconnor @ciaran_lee We also shaved off about half the query throughput - lots of redundant loads of the same object, easy to have it creep in over time in a big codebase. We already keep a copy of the object for every request, more on that here youtu.be/5MLT-QP4S74?si…, so we just reused it!
YouTube
English
@_exoconnor @ciaran_lee This was an odd case - the table is super wide and serves upwards of 4 billion queries per day, basically the intercom god object. Column names are obviously all strings and many fields are just ints, tinyints, etc. things add up super fast at scale!
English
@dihmeetree @samlambert @intercom I’m already there but haven’t been active in a while! I’ll make sure to say hi.
English
@samlambert Such amazing news! Love @intercom! Hope we get to see some Intercom friends in the Discord! 😃
English
Intercom are moving to PlanetScale! I am immensely proud that we get to support the Intercom team as they rocket into the world of AI and support a gigantic user base.
Ryan Sherlock@ryan_sherlock
At @Intercom, we’re always innovating and building for our future scale. In what’s one of the most interesting projects I’ve worked on, discover how we’re future proofing our database layer with Vitess and @PlanetScale: intercom.com/blog/evolving-…
English
@afomera I’m nervous too and sorry to be missing your talk - apparently we’re on at the same time! Best of luck - I’m sure you’ll be great.
English
so nervous for my #RailsWorld talk Friday 🙈
I have about 9000 changes I wish I could make but alas it's locked in already.
English
This is both wildly exciting and wildly terrifying 😆😱🫣
Ruby on Rails@rails
After years of tackling background job complexities with Resque and Redis at @37signals, the team finally decided to build an out-of-the-box solution. Enter #SolidQueue, a default in Rails 8. Join @rosapolis at #RailsWorld as she presents Solid Queue and shares their journey and the challenges they faced. rubyonrails.org/world/2024/spe…
English
Miles McGuire retweetledi
Okay, that's nuts. We sold out in 20 minutes!! I love this Rails Renaissance energy. I haven't felt this much excitement since the very earliest days of Rails. I can't wait to see all 1,000 lucky Rails World attendees in September.
Ruby on Rails@rails
#RailsWorld is now sold out. We can't wait to welcome you to Toronto! If there are any unclaimed or returned tickets from sponsors, we will release a second, smaller batch later in the year.
English
@_ginid My setup is similar if a bit less clean than yours - feels like there’s wires everywhere in this pic. But I’m still very happy with it!
English
@_ginid Nice. Yeah I have an Audient id14, 58dB of gain over bus power but I’d need a cloud lifter for an sm7b all the same too.
English
@ps5_ireland Got one. Thanks! After months of half assing it gave you a follow (+ notifications) and had one in less than 24 hours.
English
🚨 Harvey Norman is live now!!! 🚨
Bundles available!!
Link below ⬇️
harveynorman.ie/gaming/playsta…
#ps5 #ps5Ireland #ps5Restock
English
Super super hate that the pants are grey but the blazer is navy?
John Rogers@JohnRogers7News
Today the US Space Force revealed the prototype for its service dress uniform. What do you think? @SpaceForceDoD
Los Angeles, CA 🇺🇸 English
@_ginid I didn’t realise I was a
Coffee monster but based on this formula I am a double coffee monster.
English
@sarahthenolan 57 point bump this year. Points sharply rose since we started college though, they were in the high 400s before we graduated. universitytimes.ie/2016/08/how-tr… funny to think I couldn’t get into our course now.
English
The course I got accepted for in 2010 was 355 points and is now 564. That is just bizarre.
English
@opinionatedpie Got one for the home office at the start of lockdown. 100% recommended.
English
