Home » Articles posted by admin (Page 2)

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

Importing a mbox export as a cPanel maildir

Have an mbox export that’s too big to use Horde import/fetchmail options? No worries, mb2md was successfully tested with MacMail and Thunderbird mbox exports. Please note, the script requires the TimeDate Perl library to function. Now for some output 🙂 root@devcp [/home/tooltest]# perl -MCPAN -e 'install Date::Parse' root@devcp...
Continue reading