Featured »

March 2, 2022 – 2:00 pm

Books have been written on the subject of awk and sed. Here’s a small sample of commands I put together over the years that are useful for everyday system administration tasks. Most of these tasks …

Read the full story »
Networking

Unix and Linux network configuration. Multiple network interfaces. Bridged NICs. High-availability network configurations.

Applications

Reviews of latest Unix and Linux software. Helpful tips for application support admins. Automating application support.

Data

Disk partitioning, filesystems, directories, and files. Volume management, logical volumes, HA filesystems. Backups and disaster recovery.

Monitoring

Distributed server monitoring. Server performance and capacity planning. Monitoring applications, network status and user activity.

Commands & Shells

Cool Unix shell commands and options. Command-line tools and application. Things every Unix sysadmin needs to know.

Home » Archive by Month

Article Archive for December 2013

Searching Large Database Tables

December 9, 2013 – 9:19 pm
dump truck

Recently I ran into a little problem: I needed to make a simple Web UI allowing users to search a database table containing a copy of the Postfix maillog for quarantined mail addressed to them. …

WordPress Remove Extra Line Breaks

December 2, 2013 – 3:09 pm
wordpress

Frequently, imported posts or posts created by auto-blogging plugins will create unnecessary tabs, newlines, and line breaks. This has a negative impact on readability and aesthetics of your site. If you cannot address the problem …

MySQL mysqlhotcopy Script

December 2, 2013 – 1:30 pm
logo_mysql

Here’s a simple script to automate mysqlhotcopy runs from cron to backup multiple MySQL databases. The script loops through the list of databases and kicks off an instance of mysqlhotcopy in the background for each one. Really, …