MySQL/MariaDB [Warning] Could not increase number of max_open_files to more than 32768 (request: 100000)
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 MoreSet monit to monitor mariadb on a RunCloud instance on Ubuntu 22 & 24
Get up and running with Monit on Ubuntu 22.04 Install Monit SSH as root into your VM instance and install Monit apt update apt install monit Start/stop/restart and see the status of monit systemctl status monit systemctl start monit systemctl stop monit systemctl restart monit Status will tell if it’s running root@mel1:~# systemctl status monit●…
Read MoreUsing MySQL Tuner with MariaDB on Ubuntu 22.04
Leaving MariaDB settings out of the box may work for some people but not so productive for others, MariaDB can be a resource hog if not checked and result in issues like OOM-Killer(Out of memory) knocking it off. You can use a tool called MySQLTuner to give you some variables to adjust in your MariaDB/MySQL…
Read MoreFlush DNS cache locally on macOS Ventura, Monterey, Big Sur, OSX, Linux and Windows
When URLs are just not resolving the way you want, it may be time to clear or flush the DNS nameserver local cache – enter the relevant command in the Terminal/command line for the macOS operating system you are on. How to flush the local macOS DNS cache macOS Ventura 13.0.0 sudo dscacheutil -flushcache; sudo…
Read MoreRestart and view status of RunCloud services on the Command Line
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 MoreGetting Browsersync running with Gulp 4 and Valet on macOS
Get Browsersync going with Gulp 4+ and Valet as a local development environment. With Gulp 4+ there has been some code upgrades that require any older gulp.js files to be updated, this guide looks at making Browsersync work with Gulp with the local development tool being Valet. nodejs Ensure you already have nodejs and npm…
Read MoreConverting MySQL/MariaDB database tables from MyISAM to InnoDB
The InnoDB storage engine in MySQL/MariaDB is more performant than MyISAM – here are a few ways to change that database structure, using both the command line and also some WordPress plugins. Changing from MyISAM to InnoDB via the command line If you have wp-cli installed on your webserver you can check for MyISAM tables…
Read MoreSet Memory Limit for PHP CLI on RunCloud, OpenLiteSpeed
On a RunCloud instance, PHP CLI is a separate server setting which is a toggle control to set the version of PHP that applies to using PHP commands on the command line for the whole server. You can set it by selecting the server in the RunCloud panel then Settings > PHP-CLI Version > PHP…
Read MoreSyncing RunCloud and Cloudflare firewalls for fail2ban IPs
This guide looks at adding a proxied Cloudflare service to a server set up with RunCloud and fail2ban with a WordPress jail conf set up. Once you start using Cloudflare as a CDN solution for your hosting, you are adding another firewall into the equation, albeit a very good one, but you may want to…
Read MoreInstalling Gulp on macOS Ventura – Intro guide to Gulp
Installing Gulp on macOS Ventura, macOS Monterey and earlier OS versions requires Nodejs and npm (Node Package Manager), so get that installed first following the linked guide. Gulp is an easier and slightly more modern javascript task runner than its sibling Grunt, which helps you automate numerous tasks in your workflow. You need to install…
Read More