rantav

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...

border

package main

import (
	"fmt"
	"labix.org/v2/mgo"
	"labix.org/v2/mgo/bson"
	"time"
)

type Person struct {

rgreenjr

-- show running queries (pre 9.2)
SELECT procpid, age(clock_timestamp(), query_start), usename, current_query 
FROM pg_stat_activity 
WHERE current_query != '<IDLE>' AND current_query NOT ILIKE '%pg_stat_activity%' 
ORDER BY query_start desc;

-- show running queries (9.2)
SELECT pid, age(clock_timestamp(), query_start), usename, query 
FROM pg_stat_activity 
WHERE query != '<IDLE>' AND query NOT ILIKE '%pg_stat_activity%' 

IsaacG

#!/bin/bash

# storetime: 1:30m 2:1h 3:3h 4:6h 5:12h 6:1d 7:3d 8:7d 9:forever
# addprivacy: no:no 1:basic 2:strong 3:shorten

picpaste () {
    opts=( -F storetime=1 -F addprivacy=1 -F rules=yes )
    link=http://www.picpaste.com/upload.php 
    curl -sA firefox "${opts[@]}" -F upload=@"$1" "$link" \
    | sed -n '/Picture URL/{n;s/.*">//;s/<.*//p}'

mbeale

type JSONContainer struct {
	data []interface{}
}

func (j *JSONContainer) All() (objects []JSONObject) {
	for _, v := range j.data {
    objects = append(objects, JSONObject{data: v})
	}
	return
}

crmaxx

Amazon AWS EC2 production for Ruby on Rails

Prepare cloud

Speed up ssh login

echo 'UseDNS no # if slow connection' >> /etc/ssh/sshd_config
echo 'PrintMotd yes # if you need motd messages' >> /etc/ssh/sshd_config

From /etc/pam.d/login && /etc/pam.d/sshd delete all strings included

session optional pam_motd.so

thapakazi

#gist :D

###Gist
	-- a gem to upload snippets to https://gist.github.com

###How to install first ??
       if ruby is installed then `gem install gist`
       if you're using bundler then `source :rubygems gem gist`

###How to use it ?

seanbuscay

cd repository
git checkout --orphan orphan_name
git rm -rf .
rm '.gitignore'
echo "#Title of Readme" > README.md
git add README.md
git commit -a -m "Initial Commit"
git push origin orphan_name

thapakazi

http://jasonwilder.com/blog/2012/01/03/centralized-logging/

kesor

# unicorn

description "unicorn ruby app server"

start on (local-filesystems and net-device-up IFACE=lo and runlevel [2345])
stop on runlevel [!2345]

env WORKDIR=/data
env PIDFILE=/data/tmp/pids/unicorn.pid
env CFGFILE=/data/config/unicorn.rb