16 May 2016

MySQL / MariaDB – Changing the open_files_limit

If you’ve seen errors such as either of these: SQLSTATE[HY000]: General error:1205: Lock wait timeout exceeded; try restarting transaction Or [ERROR] /usr/sbin/mysqld: Can't open file: './database/table.frm' (errno: 24) Error 24 basically means there are too many files
31 Jul 2015

Happy System Admin Day

Happy system admin day 🙂 Here’s a pretty funny video from Silicon Valley with their take on being a networking administrator.  
31 Jul 2015

Creating A PHP Login

Creating a user login is something very commonly however all to often done poorly and not very securely. In this guide we’ll walk though some key points with example code explaining the reasoning on why each part