MySQL slow query logging to table

Ever wonder how to log slow queries to a MySQL table and set an expire time? I personally hate logging slow queries to a log file. Mainly because it gets huge, spikes disk I/O and it’s not as easy to read as logging to a MySQL table. By...
Continue reading »

Limit MySQL usage for a specific user

Feel the need to limit the usage of a specific user consuming too many resources without modifying global max_user_connections or max_updates etc? Luckily MySQL is smart enough to handle your needs 🙂 The following will limit max connections, updates and questions to 1 after which additional queries will...
Continue reading »

Multi Python Installer

Have the need to install a newer version of Python but can’t replace the default system version? This typically happens on systems using the yum package manager. I wrote the following script which provides the option of installing Python 2.6.8, 2.7.3, 3.2.3 along with setuptools (easy_install) from source....
Continue reading »

Out of network gateway IP on CentOS

I recently noticed that CentOS will refuse to assign an out of network gateway IP. Even though your network scripts syntax may be correct, it will still refuse to work no matter how many times you restart your network 🙂 Assuming your configuration is: IP: 1.2.3.4 Device: eth0...
Continue reading »

CentOS + cPanel + Mod Pagespeed

Tired of applications with poor or no caching options? Don’t wish to change your PHP Handler for OPCode? Need a boost? Give Mod_Pagespeed a try! Mod_Pagespeed was developed by Google and it acts as an internal proxy which combines your CSS/Javascript/Images then serves them inline and much more....
Continue reading »

Upgrading to MySQL 5.5 Percona (cPanel/WHM)

Looking to better track and limit MySQL usage by user, CPU time and other statistics along with a performance improvement? This guide will show you how to upgrade from MySQL 5.0.x to MySQL 5.5 Percona on a cPanel/WHM server with backups of the current configuration. The following script...
Continue reading »

Creating encrypted UNIX jails

As most of us lean towards security and stability, I’m a big fan of FreeBSD and it’s many capabilities. The following article will cover creating a Geometry Eli encrypted UNIX jail in FreeBSD 8.1 using a predefined partition, and it assumes you have already created your slices and...
Continue reading »