MySQL/MariaDB [Warning] Could not increase number of max_open_files to more than 32768 (request: 100000)

Mariadb Tuning

Seeing the warning recently on a number of VMs running MySQL/MariaDB. [Warning] Could not increase number of max_open_files to more than 32768 (request: 100000) A MariaDB process has requested a larger amount of open files, you can verify the current limit by starting a mysql session on your server and adding on the command line:…

Read More

Restart and view status of RunCloud services on the Command Line

Runcloud Mariadb Openlitespeed

Here are some command line commands to view the status as well as restart some key services such as OpenLiteSpeed, MariaDB, Redis and Memcached, after having SSH’ed in to your server as root. MySQL/MariaDB Get the status of MariaDB systemctl status mariadb Output will be similar to above, this gives a lot of information on…

Read More

Installing MariaDB Database Server on macOS

Mariadb Install Macos

MariaDB is an alternative to MySQL database which is more performant with a full open license, you can install it easily on macOS via Homebrew. The first step is to install Homebrew on your computer and possibly to remove any older MySQL database server versions. Once Homebrew is installed, on the command line: brew install…

Read More