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…

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…

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 lineIf…

This guide shows a Git WordPress workflow and demonstrates version control using Git from a local development environment on macOS to a staging site web server. For the Database control and pushing to staging, we will use WP Migrate Pro. A second remote repo…

To export a mysql database (as a dump) from the command line run: mysqldump database_name > database_exportname.sql To import a mysql database dump into a database: mysql database_name < database_exportname.sql To export all databases into a dump: mysqldump –all-databases >…

There are a number of ways to migrate a local development WordPress site from a test to a live server, you can to this manually or via a plugin. Migrating WordPress Manually The manual way to migrate a WordPress site…

To find out how many WordPress mysql database queries a page requests and how long it takes the page to load whilst querying the database, you can add in a PHP function to a WordPress hook to find out. This…

You can do a find and replace for text or html code on a post or page across a whole WordPress site by using the mysql database that the site stores all its data in. First up you need to…