Imagine your server hangs even on simple, seemingly unrelated commands such as cat file, ps aux or top. This is the issue I’ve been dealing with today. Short version: it was MySQL/MariaDB server clogging the VPS I/O. Important: even though a terminal window with an established SSH connection would freeze, I could always open a… Continue reading FreeBSD gets unresponsive on commands touching disk
Tag: mariadb
Cheapest MySQL database hosting for a hobby project?
If you search for cheapest mysql database, you will get results on Reddit, where the most common advice is to get a Digital Ocean VPS for $5/mo. Cheapest mySQL hosting? Which is the cheapest MySQL hosting in cloud? Cheap database hosting for hobbyist? While $5/mo. is kind of cheap, it’s not the cheapest. Here are… Continue reading Cheapest MySQL database hosting for a hobby project?
Changing a MySQL/MariaDB variable in my.cnf has no effect?
The MySQL/MariaDB Server settings tweaked in /etc/mysql/my.cnf will go live only after you restart it – but sometimes a simple service mysql restart just won’t do it. Instead, try: service mysql reload service mysql stop service mysql start If there’s some e.g. unrelated error in your config, restart will actually do nothing (apparently to ensure… Continue reading Changing a MySQL/MariaDB variable in my.cnf has no effect?