Forrest Jordan fjordan

A few show tricks to find slow queries in mongodb

Enable profiling

First, you have to enable profiling

> db.setProfilingLevel(1)

Now let it run for a while. It collects the slow queries ( > 100ms) into a capped collections, so queries go in and if it's full, old queries go out, so don't be surprised that it's a moving target...

##Working with ansible-vault

I've been using a lot of Ansible lately and while almost everything has been great, finding a clean way to implement ansible-vault wasn't immediately apparent.

What I decided on was the following: put your secret information into a vars file, reference that vars file from your task, and encrypt the whole vars file using ansible-vault encrypt.

Let's use an example: You're writing an Ansible role and want to encrypt the spoiler for the movie Aliens.

	#!/usr/bin/env sh

	##
	# This is script with usefull tips taken from:
	# https://github.com/mathiasbynens/dotfiles/blob/master/.osx
	#
	# install it:
	# curl -sL https://raw.github.com/gist/2108403/hack.sh \| sh
	#

	# First do a fresh install of CentOS 5.7 i386, server configuration (no GUI)
	# This should be performed as root since it's going to be installing a bunch of stuff

	# --- Update things to make sure we have the latest patches ---
	# Add EPEL so we can get reasonably recent packages
	rpm -Uvh http://download.fedoraproject.org/pub/epel/6/i386/epel-release-6-8.noarch.rpm

	# --- Install all the packages --- #
	yum -y install python-whisper python-carbon graphite-web python-memcached python-ldap httpd memcached

	package main

	import "code.google.com/p/go-tour/pic"

	func Pic(dx, dy int) [][]uint8 {
	slice := make([][]uint8, dy)

	for idx := 0; idx < dy; idx++ {
	x := make([]uint8, dx)

	import java.util.ArrayList;

	public class HelloWorld{
	public static void main(String []args) {

	ArrayList<String> arrayList = new ArrayList<String>();
	arrayList.add(0, "test1") ;
	arrayList.add(1, "test2");
	arrayList.add(2, "test3");

	---
	# ^^^ YAML documents must begin with the document separator "---"
	#
	#### Example docblock, I like to put a descriptive comment at the top of my
	#### playbooks.
	#
	# Overview: Playbook to bootstrap a new host for configuration management.
	# Applies to: production
	# Description:
	# Ensures that a host is configured for management with Ansible.

	import React from 'react'
	import { BrowserRouter as Router, Switch } from 'react-router-dom'
	import routes from './routes'
	import FancyRoute from './components/tools/FancyRoute'

	const App = props =>
	<Router>
	<Switch>
	{routes.map((route, i) =>
	<FancyRoute key={i} {...route} />