🏠

Dave M. Giglio dmgig

🏠

Full-stack dev | since 2006

dmgig / log_monitor.sh

Created January 14, 2015 14:35

Log monitor. Sums requests by hour. Auto-refresh view each second.

	#!/bin/bash

	# Log monitor. Sums requests by hour. Auto-refresh view each second.

	while :
	do
	TODAY=$(date +"%b %d")
	awk -F: -v t="$TODAY" '$0~t {h[$1]++;m[$1":"$2]++;}END{for(x in h)print x,h[x];'} /var/log/requests.log \| sort > /tmp/requests_view.tmp
	clear
	echo "Requests Pace for"

dmgig / count_matching_rows

Created January 14, 2015 14:47

awk: count matching rows in log file

awk '/Sep 07/ {total += 1} END {print "total requests = " total}' /var/log/requests.log

dmgig / unique_column_values

Last active August 29, 2015 14:13

awk: show unique column values

cat /var/log/requests.log | awk ' { print $4 } ' | sort | uniq

dmgig / color_awk

Last active August 29, 2015 14:13

awk: colorize output

	tail -n 5000 -f /var/log/requests.log \| awk '
	/FAIL$/ {print "\033[30m" $0 "\033[0m"} # black
	/(\/delete.php)/ {print "\033[31m" $0 "\033[0m"} # red
	/(\/move.php)/ {print "\033[32m" $0 "\033[0m"} # green
	/(\/request.php)/ {print "\033[33m" $0 "\033[0m"} # yellow
	/(\/change.php)/ {print "\033[34m" $0 "\033[0m"} # blue
	/(\/part.php)/ {print "\033[35m" $0 "\033[0m"} # magenta
	/(\/process.php)/ {print "\033[36m" $0 "\033[0m"} # cyan
	/NO AFFECTED ROWS$/ {print "\033[37m" $0 "\033[0m"}' # white

dmgig / pt-heartbeat

Created January 14, 2015 20:48

Percona pt-heartbeat sample

PTDEBUG=1 pt-heartbeat --host="mysql-b" --user=root --ask-pass --database="percona" --monitor --master-server-id="14" --frames=1m,5m,15m,1h,12h,1d

dmgig / pt-table-checksum-sample

Created January 15, 2015 15:26

Percona pt-table-checksum samples

	# whole table check
	pt-table-checksum --databases=world --tables=city --user=root --ask-pass --no-check-binlog-format

	# with a parameter for smaller samples
	pt-table-checksum --databases=world --tables=city --where="name LIKE '%a%'" --user=root --ask-pass --no-check-binlog-format

dmgig / mysql-momentary-general-log.sql

Last active August 29, 2015 14:14

mysql: momentarily enable general log file / table

	# mysql: momentarily enable, then view, general log table
	SET GLOBAL log_output = 'TABLE';

	SET GLOBAL general_log = 'ON';
	SELECT SLEEP(5);
	SET GLOBAL general_log = 'OFF';

	SELECT * FROM mysql.general_log;

	######

dmgig / autosave-form.js

Last active August 29, 2015 14:14

Auto-saving Form (jQuery required)

	/**
	* editBox
	* auto-updating form, with reset/resave
	* @author D.M. Giglio
	*/
	(function(window, document, $){

	'use strict';

	$(document).ready(function(){

dmgig / table_tab_import.sh

Last active February 11, 2016 21:56

MySQL: Import tables & data from sql and tab delimited dumps

	#! /bin/bash

	# Note: This script disables foreign key checks and ignores all errors!

	DUMPDIR='/tmp/mysql_dumps/'

	USERNAME='root'
	PASSWORD='MyP@55'
	DATABASE='databaseName'

dmgig / matrix_math.html

Created February 18, 2016 21:26

Matrix Math QUnit Tests

	<!DOCTYPE html>
	<html>
	<head>
	<meta charset="utf-8">
	<title>QUnit Matrix Tests</title>
	<link rel="stylesheet" href="//code.jquery.com/qunit/qunit-1.19.0.css">
	</head>
	<body>
	<div id="qunit"></div>
	<div id="qunit-fixture"></div>