Gregory1d ago

Ugh, I started a database migration on my Smithereen server to add a full-text index to posts. That was around 1 AM. I hoped it would be done in a few hours. It's the middle of the day now and it's still running and only 81% complete.

I really need to figure out how to do these sorts of things without downtime. I also really hope it's the last time I have to add columns to the posts table which contains 2.8 million rows and will only grow over time.

I'm sorry to everyone who uses my server.

Show threaddansup

@grishka database migrations and fediverse instances, name a more iconic duo!

at least you don't have a 264GB statuses table, I want to move comments and boosts to separate tables without breaking existing APIs and causing downtime.

it's not fun, but it's part of the job 💪

Jun 23 at 1:03pmWeb
Show threadGregory1d ago
@dansup wow. Mine is "only" 2.3 GB
Show threaddansup1d ago
@grishka omg i wish!! my profiles table is double that haha
Show threadGregory1d ago
@dansup wtf, how, what do you have in there?
Show threaddansup1d ago
@grishka 1.6m records
Show threadGregory1d ago
@dansup also I didn't realize you also use MySQL, I thought I was the only one and everyone else uses Postgres
Show threaddansup1d ago
@grishka mysql 4 eva. only real ones use mysql, leave the vacuuming to those other guys 🤣