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

Set monit to monitor mariadb on a RunCloud instance on Ubuntu 22.04

Monit Mariadb

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 More

Change WordPress Database Table Prefix Back To wp_

Wordpress Table Prefix

Here is how to change the WordPress database tables back to the default wp_ prefix. First thing is to change the php constant table prefix in wp-config.php Change the wp-config.php constant $table_prefix = ‘wp_’; Change the table prefixes in phpMyAdmin Next open your WordPress database in phpMyadmin, select all the tables and choose the option…

Read More