So we crushed INT and the new target is BIGINT. Just a small increase from 2 billion rows to 9 quintillion rows. Challenge accepted?
#HugOps to all the folks behind the scenes who busted their bums getting this incident resolved. You're all awesome.
The good news: There are 2 billion Letsencrypt certificates created
I wonder who was that last one… the 2 billionth cert?
[the one that consumed the last INT - leaving nothing for the rest of us]
This can be a good trivia question—“what does Let’s Encrypt have in common with ‘Gangnam Style’?”
The music video came in first with 21% rating in the 2012 Billboard.com's readers poll, beating "Where Have You Been" by Rihanna (19%) and "Beauty and a Beat" by Justin Bieber featuring Nicki Minaj (11%). The song was the most popular song played on New Year's Eve and the most sung song on the day, leaving "Auld Lang Syne" in second place for the first time since 2005, on karaoke company Lucky Voice's online service in the United Kingdom. CNN readers picked "Gangnam Style" as the e On December 1,...
I don’t think we are at 2B certs yet, I am not sure what each row corresponds to, but here’s the query I use to see how many certificates Let’s Encrypt has issued:
Hehehe. Thanks for the kind note
@rmbolger We were already using
BIGINT on the most important tables (
certificates, etc) but had missed one table that tracked names we’ve issued for (principally just used for statistics) that had an
INT ID column
@jple is correct: We haven’t issued 2B certificates (yet). The affected table has a row for every subjectAltName, so there are more rows than certificates. But we’re on our way. Thanks for the kind words!
This topic was automatically closed 30 days after the last reply. New replies are no longer allowed.