Using 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 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 node.js on macOS Ventura and earlier macOS versions
node.js allows you to run javascript in the Terminal as appose to a regular browser which makes for a modern workflow in web development, with both node.js installed and a package manager called npm (Node Package Manager) also installed, which can manage other packages that work with node.js, one of the main ones being gulp.js…
Read MoreSet up malware scanner LMD Maldet and ClamAV on a RunCloud instance
How to set up a malware scanner with LMD Maldet and ClamAV on a RunCloud server instance. One of the popular and open source malware scanners is an app called Linux Malware Detect and works well scanning any Linux web server, it keeps a daily updated database of known malware exploits from an updated registry…
Read MoreSend command line server emails with Postfix on a Ubuntu Server 22.04
Here is a guide to allow a Ubuntu 22.04 server to send out local server based emails using Postfix. Test Command Line Email To test if emails can be sent via the command line, SSH into your server and try echo “Is email sending OK..?” | mail -s “Sending email!” [email protected] Nothing should return, if…
Read MoreAdd a WooCommerce missing action hook with shortcode in Beaver Builder
Some themes or plugins remove native action hooks in WordPress / WooCommerce, however you can add them back in the layout with another action hook or shortcode insertion. Beaver Builder is missing some WooCommerce action hooks one such one is woocommerce_before_shop_loop_item_title , you can add that back to the WooCommerce loop by doing a custom…
Read More