Bits and pieces of John Dalton from all over your internet. - tagged with sysadmin http://johndalton.info/feed en-us http://blogs.law.harvard.edu/tech/rss Sweetcron john@johndalton.info How to debug InnoDB lock waits http://johndalton.info/items/view/9652/how-to-debug-innodb-lock-waits

This article shows you how to use a little-known InnoDB feature to find out what is holding the lock for which an InnoDB transaction is waiting. I then show you how to use an undocumented feature to make this even easier with innotop.

]]>
Mon, 23 Jan 2012 16:15:00 -0600 http://johndalton.info/items/view/9652/how-to-debug-innodb-lock-waits
Sensu - Sonian Cloud Monitoring Framework http://johndalton.info/items/view/9180/sensu-sonian-cloud-monitoring-framework

Sensu is an open source cloud monitoring framework, purpose built for the cloud. Framework includes monitoring server, platform-independent agent, and web-based dashboard.

]]>
Thu, 01 Dec 2011 23:04:00 -0600 http://johndalton.info/items/view/9180/sensu-sonian-cloud-monitoring-framework
Understanding and using Amazon EBS http://johndalton.info/items/view/8981/understanding-and-using-amazon-ebs

Excellent description by Adrian Cockcroft of how Amazon EBS works from a performance perspective, with a focus on multi-tenancy at the VM host, local disk and EBS disk levels.

]]>
Wed, 16 Nov 2011 04:06:00 -0600 http://johndalton.info/items/view/8981/understanding-and-using-amazon-ebs
GoAccess - Visual Web Log Analyzer http://johndalton.info/items/view/8853/goaccess-visual-web-log-analyzer

GoAccess is an open source real-time web log analyzer and interactive viewer that runs in a terminal in *nix systems. It provides fast and valuable HTTP statistics for system administrators that require a visual server report on the fly.

GoAccess can parse both of Apaches' log formats, the Common Log Format (CLF) and the Combined Log Format (XLF/ELF), including virtual host. It is possible to parse Nginx as well. (if configured with the standard Apache log format)

]]>
Tue, 01 Nov 2011 20:55:00 -0500 http://johndalton.info/items/view/8853/goaccess-visual-web-log-analyzer
The Limoncelli Test: 32 Questions for Your Sysadmin Team http://johndalton.info/items/view/7957/the-limoncelli-test-32-questions-for-your-sysadmin-team ]]> Mon, 15 Aug 2011 18:24:00 -0500 http://johndalton.info/items/view/7957/the-limoncelli-test-32-questions-for-your-sysadmin-team Mount/access Files Residing on Xen Virtual Machines http://johndalton.info/items/view/7340/mountaccess-files-residing-on-xen-virtual-machines

Great example showing how to access the filesystem[s] on a xen disk image, or any other disk image which represents a drive containing partitions.

]]>
Thu, 23 Jun 2011 22:46:00 -0500 http://johndalton.info/items/view/7340/mountaccess-files-residing-on-xen-virtual-machines
Install and manage iSCSI Volume http://johndalton.info/items/view/7341/install-and-manage-iscsi-volume

Reasonably in-depth example of setting up a new iSCSI volume, from the client (initiator) side.

]]>
Thu, 23 Jun 2011 22:44:00 -0500 http://johndalton.info/items/view/7341/install-and-manage-iscsi-volume
Configuring iSCSI Targets and Initiators on RHEL5 http://johndalton.info/items/view/7342/configuring-iscsi-targets-and-initiators-on-rhel5

Great example showing the configuration of both ends of an iSCSI device - the initiator (client) and the target (server).

]]>
Thu, 23 Jun 2011 22:42:00 -0500 http://johndalton.info/items/view/7342/configuring-iscsi-targets-and-initiators-on-rhel5
ganeti - cluster virtual server management software http://johndalton.info/items/view/7220/ganeti-cluster-virtual-server-management-software

Ganeti is a cluster virtual server management software tool built on top of existing virtualization technologies such as Xen or KVM and other Open Source software.

]]>
Tue, 14 Jun 2011 21:42:00 -0500 http://johndalton.info/items/view/7220/ganeti-cluster-virtual-server-management-software
Sharding techniques http://johndalton.info/items/view/7161/sharding-techniques

Overview of sharding techniques.

]]>
Thu, 09 Jun 2011 20:17:00 -0500 http://johndalton.info/items/view/7161/sharding-techniques
Watir - open source web browser automation. http://johndalton.info/items/view/6765/watir-open-source-web-browser-automation

Watir, pronounced water, is an open-source (BSD) family of Ruby libraries for automating web browsers.

]]>
Fri, 20 May 2011 02:21:00 -0500 http://johndalton.info/items/view/6765/watir-open-source-web-browser-automation
<a href="http://www.pement.org/awk/awk1line.txt" rel="external">http://www.pement.org/awk/awk1line.txt</a> http://johndalton.info/items/view/6576/httpwwwpementorgawkawk1linetxt

A collection of Awk one liners.

]]>
Sun, 08 May 2011 23:14:00 -0500 http://johndalton.info/items/view/6576/httpwwwpementorgawkawk1linetxt
Famous Awk One-Liners Explained, Part I - good coders code, great reuse http://johndalton.info/items/view/6577/famous-awk-one-liners-explained-part-i-good-coders-code-great-reuse

An explanation of how the awk one liners in awk1line.txt work, which doubles as a good awk tutorial.

]]>
Sun, 08 May 2011 23:13:00 -0500 http://johndalton.info/items/view/6577/famous-awk-one-liners-explained-part-i-good-coders-code-great-reuse
Enabling nginx Chunked Transfer Encoding - Server Fault http://johndalton.info/items/view/6197/enabling-nginx-chunked-transfer-encoding-server-fault

Server Fault thread in which I found the answer to a question I had about nginx and chunked encoding - an answer I had written earlier myself!

]]>
Sat, 09 Apr 2011 05:40:00 -0500 http://johndalton.info/items/view/6197/enabling-nginx-chunked-transfer-encoding-server-fault
Setting up PHP-FastCGI and nginx? Don't trust the tutorials ... http://johndalton.info/items/view/6198/setting-up-php-fastcgi-and-nginx-dont-trust-the-tutorials

Highlights some exploitable vulnerabilities in a commonly suggested configuration for nginx + php, and discusses fixes/workarounds.

]]>
Sat, 09 Apr 2011 05:34:00 -0500 http://johndalton.info/items/view/6198/setting-up-php-fastcgi-and-nginx-dont-trust-the-tutorials
Wish you were here... http://johndalton.info/items/view/6151/wish-you-were-here ]]> Wed, 06 Apr 2011 23:55:00 -0500 http://johndalton.info/items/view/6151/wish-you-were-here Sharpening using Image Magick http://johndalton.info/items/view/4426/sharpening-using-image-magick

Summary: an explanation of Image Magick’s unsharp masking parameters, and how the filter compares to the unsharp mask filters in Photoshop and the GIMP.

]]>
Thu, 11 Nov 2010 04:05:00 -0600 http://johndalton.info/items/view/4426/sharpening-using-image-magick
gradients in rrdtool graphs http://johndalton.info/items/view/3888/gradients-in-rrdtool-graphs

Notes on how to make rrdtool display graphs with colour gradients. Hint: it's a hack.

]]>
Tue, 21 Sep 2010 06:56:00 -0500 http://johndalton.info/items/view/3888/gradients-in-rrdtool-graphs
Performance Tuning flowchart for MySQL http://johndalton.info/items/view/3884/performance-tuning-flowchart-for-mysql

Not presented as a flowchart, but that's what it feels like to me. A great step-by-step breakdown of tuning MySQL (including consideration of architecture, application and OS.)

]]>
Tue, 21 Sep 2010 05:39:00 -0500 http://johndalton.info/items/view/3884/performance-tuning-flowchart-for-mysql
ec2-consistent-snapshot in Launchpad http://johndalton.info/items/view/3790/ec2-consistent-snapshot-in-launchpad

Tool for simplifying the process of taking a consistent (i.e. safe) snapshot of an Amazon EC2 EBS volume.

]]>
Mon, 06 Sep 2010 00:38:00 -0500 http://johndalton.info/items/view/3790/ec2-consistent-snapshot-in-launchpad
32408df3sf