-
Monitor all queries to MariaDB
Want to see what is being run against your MariaDB this is what to do. Firstly you need to enable logging to a file of all queries. You do this by running: SET GLOBAL general_log=1; SET GLOBAL general_log_file=’/var/opt/rh/rh-mariadb102/log/mariadb/maria_general.log’; Problem is you need special permissions and in practical terms the easiest way is to run it… read more…
-
CentOS 7 VM for WordPress and MythTV – Post install setup
In the post CentOS 7 base VM for WordPress and MythTV I described how to create a base CentOS 7 VM. This post describes follows on from that post and describes the post installation tasks to make the VM a good solid base for me to run WordPress or MythTV. When setting up a Linux server… read more…
-
Backup and restore WordPress
I run WordPress on Apache 2.2 on RedHat. A WordPress instance, is just a bunch of PHP files, various image files and uploaded files and a database – that’s pretty much it. So to backup and restore you need to back up one directory tree and a DB. This post details what I did to… read more…
MySQL
(category)