MySQL

(tag)

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

    Monitor all queries to MariaDB
  • 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…

    CentOS 7 VM for WordPress and MythTV – Post install setup
  • 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…

    Backup and restore WordPress