Home »
Articles posted by admin (Page 2)
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
February 26, 2013 admin
Random Goodies
No Comment
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
February 26, 2013 admin
Random Goodies
1 Comment
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
February 1, 2013 admin
Random Goodies
1 Comment
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
January 22, 2013 admin
Random Goodies
No Comment
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
October 23, 2012 admin
Random Goodies
6 Comments
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
May 29, 2012 admin
Random Goodies
No Comment
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
April 4, 2012 admin
Random Goodies
No Comment
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
April 4, 2012 admin
Random Goodies
No Comment