I did two things this week regarding my blog –
- I read a lot on Instapaper, mostly non-fiction articles. I make a lot of notes and highlights and all of those come over to this blog. Why? Well, at some point I thought it would be a good idea to write articles based on my readings. It’s also a way of preserving all of those thoughts in case Instapaper some day goes kaput. But the fact that I have all of this text sitting in my blog, counting against my word count, and not contributing to my readership has been irritating me ever since I started the practice.
A few days ago, I setup a new blog on WordPress – https://nitinsnotes.home.blog/ with the objective of posting everything there instead of here. If I can build a readership for the ideas and quotes I publish there, I figured, I can bring over the readers back to this blog eventually and grow the kind of things I write about.
There’s only one problem – I read a lot of varied topics, but the one I write notes most about is politics. I’ve never been comfortable airing my views on politics. It was never taught to me to be overtly political, and the environment I’m in now doesn’t allow for many public mistakes. Whether this is a perceived threat or a real one, I do not care to find out.
So, within a day of creating the blog, I’ve abandoned it. All my comments are still coming to this blog and hiding in plain site – they are only visible to logged in users. So if you’re curious as to what I write about, ask me and I’ll create an account for you on my blog and let you in. Otherwise, I’m happy writing those thoughts for myself for now. - The other thing that happened was that I noticed that my blogs were running into some technical difficulties. I was not able to update plugins or open MySQL in the browser to take a look at it. Turns out, my VPS thinks it’s run out of space, despite the fact that I recently updates from a 20 GB node to a 50 GB one. I noticed that the /var/mail folder was choked up with thousands of files, and the ibdata1 file has overgrown. I cleared up the former with a nice ‘find -delete’ command, and for the former, I’ve got a script that takes the backup of all my blogs, deletes the ibdata1 file, and reups the backups to bring everything back online. In the end, it tells me how much space it saved me.
The last time I ran this, maybe last year or so, I regained about 5 GB. So I ran it again. Turns out, I’ve updated my MySQL version somewhere in between and the thing completely broke, without giving me back my two blogs! Gulp!
Luckily, I read through the script and recovered my blogs, without losing much uptime or any data. But this sort of thing is exactly what scares me. I’ve got scripts that take backups regularly, but it never feels enough.
Regardless, has anyone else dealt with large ibdata1 files? What can I do about that? Also, I still don’t know why my system thought it’s run out of space. Maybe the sheer number of files in /var/mail? Due to the assumed lack of space, MySQL crashed and wouldn’t launch back up, until I deleted the mail folder’s contents. So I’m not sure I want to be in this situation again!