All Stories
MySQL: configure innodb_buffer_pool_size
Running out of memory on small MySQL instances (less than 1GB) hosting WordPress sites was a common thing for me, for a while. Even creating swap disk didn’t help as the MySQL service...
In MySQL, Dec 12, 2022Install Yarn on Debian 11
There are multiple ways to install yarn on Debian 11. Here I’m going to show you how to install Yarn on Debian 11 via APT.
In Debian, Dec 11, 2022PostgreSQL DB size larger than the sum of table sizes
Another issue to get off my chest. A few weeks back, I was struggling to find why the production PostgreSQL DB size was significantly larger than the sum of table sizes. I was bambooz...
In PostgreSQL, Dec 10, 2022Install Yarn on Centos 9 Stream
Yarn can be very useful in terms of automating the process of updating, installing, configuring, or deleting NPM packages. Here I’m going to show you how to install yarn on CentOS 9 S...
In CentOS, Dec 09, 2022PostgreSQL 101: pg_table_size vs pg_relation_size vs pg_indexes_size vs pg_total_relation_size
Another good nugget to share as I was trying to find out which production DB table was bloated and why. The size was in GB, and it was ridiculous, something around 50GB. You can find ...
In PostgreSQL, Dec 08, 2022Install Smartctl on Alpine Linux
If you get the error smartctl: not found on Alpine Linux, it means that smartctl is not installed by default, so don’t let that wind you up. Let me tell you how to install smartctl on...
In Alpine Linux, Dec 07, 2022Recover out of sync PostgreSQL slave/replica (WAL has already been removed)
WAL or Write-Ahead Logging as a method that enables PostgreSQL data integrity. Mostly used in replication as it enables High Availability (HA). Now, PostgreSQL replication is a broad ...
In PostgreSQL, Dec 06, 2022Install htpasswd on Alpine Linux
Htpasswd installation will be easy and simple using the Alpine system packages. Let’s see how to install htpasswd on Alpine Linux.
In Alpine Linux, Dec 05, 2022Docker: Error response from daemon: ... unauthorized: please use personal access token to login
Last week I’ve leveled up my security game by reviewing and updating all internet services that I’m using and subscribed to, to enable 2FA, including Docker. After few days, as I was ...
In Docker, Dec 04, 2022Install htpasswd on Amazon Linux 2
Setting up htpasswd to have basic-auth for your site users can be done in a few steps depending on your web server. Here I’m going to cover just the installation process of htpasswd o...
In Htpasswd, AWS, Amazon Linux 2, Dec 03, 2022