Gregory

@grishka
1.7K Followers
66 Following
3.8K Posts

Software developer who's almost lost faith in the modern IT. Used to work at VKontakte, then Telegram. Currently building my own fediverse project to save our online social lives from greedy corporations. Follow the progress: #smithereen

Also working on the Mastodon Android app.

Русскоязычный аккаунт — @grishka

Websitehttps://grishka.me
:mastodon: teamhttps://joinmastodon.org/about
Smithereen websitehttps://smithereen.software
Show threadGregory26m ago
@dansup also I didn't realize you also use MySQL, I thought I was the only one and everyone else uses Postgres
Show threadGregory1h ago
@dansup wtf, how, what do you have in there?
Show threadGregory1h ago
Or not. It's read-only. I can now see a bunch of INSERT and DELETE queries "Waiting for table metadata lock". Oh well...
Show threadGregory1h ago
Now I gotta wait for federation to catch up...
Show threadGregory1h ago
So I did a rather odd thing. I updated the schema version manually so the migration won't run again (this is normally done after it's completed) and started another instance of Smithereen while the daemon is busy running the dreaded ALTER TABLE. So it's up now. I had no idea these things don't lock anything now. MySQL 5.x was much less forgiving.
Show threadGregory2h ago
@dansup wow. Mine is "only" 2.3 GB
Show threadGregory2h ago
Oh actually. Here's the fun part. Queries on that table still work as it's being altered. I should've just been doing this manually and asynchronously...
Gregory2h 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 threadGregory2d ago
@buage @dansup I have several ideas about what I want 3D printed but, idk, buying a 3D printer feels like too much of a commitment to me, especially living in a relatively small apartment
Show threadGregory2d ago
@broadway_lamb I get it, but in this case the entire method is short enough to fit completely on my screen, so there's truly no point doing this ¯\_(ツ)_/¯