jrelo

InfluxDB Cheatsheet

Connect to InfluxDB using the commandline:

$ influx

Create a database foo:

CREATE DATABASE foo

jrelo

Linux simple performance tweaks

Change the I/O Scheduler

Open $ vim /etc/default/grub then add elevator=noop next to GRUB_CMDLINE_LINUX_DEFAULT. Run $ update-grub and $ cat /sys/block/sda/queue/scheduler to be sure that noop is being used:

$ vim /etc/default/grub
$ update-grub
$ cat /sys/block/sda/queue/scheduler

[noop] deadline cfq

jrelo

# Packet Grenade
# Feb 13, 2015

# Lists of targets
set pinglist [list www.google.com www.facebook.com]
set httplist [list www.google.com www.facebook.com]
set httpslist [list www.google.com www.facebook.com]
set ftplist [list]
set sshlist [list alt.org thebes.openshells.net]

jrelo

#!/bin/bash
#more methods: http://rtomaszewski.blogspot.com/2012/11/how-to-forcibly-kill-established-tcp.html
if [ $# -lt 1 ];
  then
  printf "Usage: $0 <IP>\n" $#
  exit 0
fi
raddr=$1
printf "Killing TCP connections to/from ${raddr}...\n"
iptables -I INPUT -s ${raddr} -p tcp -j REJECT --reject-with tcp-reset

jrelo

#!/usr/bin/env bash

set -x

NS="ns1"
VETH="veth1"
VPEER="vpeer1"
VETH_ADDR="10.200.1.1"
VPEER_ADDR="10.200.1.2"

jrelo

#!/usr/bin/perl -w
##############################################################################
##  
##  Written by: Jared Cheney <[email protected]>
##
##  Original Template written by: 
##     Brandon Zehm <[email protected]> and Jared Cheney <[email protected]>
##  
##  License:
##  

jrelo

#!/bin/sh
#
# Use posixregex CLI tool from: https://github.com/syzdek/dmstools/blob/master/src/posixregex.c

RE_IPV4="((25[0-5]|(2[0-4]|1{0,1}[0-9]){0,1}[0-9])\.){3,3}(25[0-5]|(2[0-4]|1{0,1}[0-9]){0,1}[0-9])"

posixregex -r "^(${RE_IPV4})$" \
   127.0.0.1 \
   10.0.0.1 \
   192.168.1.1 \

jrelo

Links

• The top 5 proactive measures to minimize MySQL downtime
• The small improvements of MySQL 5.6: Duplicate Index Detection
• Keynotes, BOFs, and the Community Networking Reception at Percona Live MySQL Conference and Expo
• Analyzing Slow Query Table in MySQL 5.6
• Percona Toolkit by example – pt-stalk
• innodb_stats_on_metadata and slow queries on INFORMATION_SCHEMA
• [Webinar: SQL Query

jrelo

via: http://groups.google.com/group/phillycocoa/browse_thread/thread/2d05f3eac5a7d260?hl=en

revert file:
git checkout HEAD path/to/file
OR
git checkout filename

pluck one file from another branch
git checkout Branch path/to/file

jrelo

TARGET = test

CC = gcc

CFLAGS = -c -v

VPATH = src
SRC = test.c
OBJ = $(SRC:.c=.o)