Jeffrey L. Roberts jeffreyroberts

## mysql_count_rows_sql_generator.sql
SELECT CONCAT(
    'SELECT "',
    table_name,
    '" AS table_name, COUNT(*) AS exact_row_count FROM ',
    table_schema,
    '.',
    table_name,
    ' UNION '
)
FROM INFORMATION_SCHEMA.TABLES

## mysql_count_rows_for_each_table_in_db.sql
SELECT TABLE_NAME, TABLE_ROWS FROM `information_schema`.`tables` WHERE `table_schema` = '<database_name>';

## mysql_count_rows_in_db.sql
SELECT SUM(TABLE_ROWS)
     FROM INFORMATION_SCHEMA.TABLES
     WHERE TABLE_SCHEMA = '<database_name>';

## mysql_count_tables_in_db.sql
SELECT COUNT(*) FROM information_schema.tables WHERE table_schema = '<database_name>';

## mysql_db_server_growth_history.sql
-- SET GLOBAL event_scheduler = ON;
-- create table db_growth_history(db_name varchar(64), tbl_name varchar(64), avg_row_length int, row_count bigint, time_stamp datetime);

DELIMITER $$

CREATE
  EVENT `document_db_growth_history`
  ON SCHEDULE EVERY 1 DAY
	DO BEGIN
            -- Grab db name, table name, avg row length, row count, add timestamp = growth_history

## git_submodule_recursive_checkout.sh
git submodule foreach --recursive git checkout master

## find_file_size_delete.sh
#!/bin/bash

find $1 -size $2c -delete

## raid_file_system_create_format_assemble.sh
# How to assemble raid device
mdadm --create --verbose /dev/md128 --level=1 --raid-devices=2 /dev/xvdm /dev/xvdn

# Make file system
mkfs -t	xfs /dev/md128

# How to re-assemble
mdadm --assemble --verbose /dev/md128 /dev/xvdm /dev/xvdn

# Get UUID

## git_list_files_from_commit.sh
#!/bin/bash
# http://stackoverflow.com/questions/424071/list-all-the-files-for-a-commit-in-git

git diff-tree --no-commit-id --name-only -r $1

## .bash_aliases
# Colors
DARK_PURPLE="\[\033[1;34m\]"
GREEN="\[\033[0;32m\]"
GREY="\[\033[1;30m\]"
NORMAL="\[\033[0m\]"
RED="\[\033[0;31m\]"
YELLOW="\[\033[0;33m\]"

# Git shortcuts
alias gci='git commit'
	SELECT CONCAT(
	'SELECT "',
	table_name,
	'" AS table_name, COUNT(*) AS exact_row_count FROM ',
	table_schema,
	'.',
	table_name,
	' UNION '
	)
	FROM INFORMATION_SCHEMA.TABLES
	SELECT SUM(TABLE_ROWS)
	FROM INFORMATION_SCHEMA.TABLES
	WHERE TABLE_SCHEMA = '<database_name>';
	-- SET GLOBAL event_scheduler = ON;
	-- create table db_growth_history(db_name varchar(64), tbl_name varchar(64), avg_row_length int, row_count bigint, time_stamp datetime);

	DELIMITER $$

	CREATE
	EVENT `document_db_growth_history`
	ON SCHEDULE EVERY 1 DAY
	DO BEGIN
	-- Grab db name, table name, avg row length, row count, add timestamp = growth_history
	# How to assemble raid device
	mdadm --create --verbose /dev/md128 --level=1 --raid-devices=2 /dev/xvdm /dev/xvdn

	# Make file system
	mkfs -t xfs /dev/md128

	# How to re-assemble
	mdadm --assemble --verbose /dev/md128 /dev/xvdm /dev/xvdn

	# Get UUID
	#!/bin/bash
	# http://stackoverflow.com/questions/424071/list-all-the-files-for-a-commit-in-git

	git diff-tree --no-commit-id --name-only -r $1
	# Colors
	DARK_PURPLE="\[\033[1;34m\]"
	GREEN="\[\033[0;32m\]"
	GREY="\[\033[1;30m\]"
	NORMAL="\[\033[0m\]"
	RED="\[\033[0;31m\]"
	YELLOW="\[\033[0;33m\]"

	# Git shortcuts
	alias gci='git commit'