CHERTS

# Modify this file accordingly for your specific requirement.
# http://www.thegeekstuff.com
# 1. Delete all existing rules
iptables -F

# 2. Set default chain policies
iptables -P INPUT DROP
iptables -P FORWARD DROP
iptables -P OUTPUT DROP

CHERTS

watch --difference=cummulative --interval=1 '(echo device read_IOs read_merges read_sectors read_ticks write_IOs write_merges write_sectors write_ticks in_flight io_ticks time_in_queue; for file in /sys/block/*/stat; do echo -n $file; cat $file; done) | column -t'
# OUTPUTS:
#device                 read_IOs  read_merges  read_sectors  read_ticks  write_IOs  write_merges  write_sectors  write_ticks  in_flight  io_ticks  time_in_queue
#/sys/block/dm-0/stat   116962    0            2212746       314096      7705653    0             150218536      609670232    0          644428    610921004
#/sys/block/dm-1/stat   116479    0            2208882       313324      7686986    0             150218536      609676068    0          644616    611418072
#/sys/block/dm-2/stat   302       0            2416          780         0          0             0              0            0          148       780
#/sys/block/sda/stat    91181     26273        2217246       74876       7314854    388030        150261802      16954364 

CHERTS

/* index performance */
SELECT 
  relname, 
  100 * idx_scan / (seq_scan + idx_scan) percent_of_times_index_used, 
  n_live_tup rows_in_table
FROM 
  pg_stat_user_tables
WHERE 
    seq_scan + idx_scan > 0 
ORDER BY 

CHERTS

CREATE DEFINER=`root`@`localhost` PROCEDURE `Cmonk_partition_manager`(in partition_frequency varchar(100), in db_schema varchar(100),in input_table_name varchar(100), in partition_column varchar(100))
BEGIN
	-- Author 	- Code Monk
	-- Version 	- 1.0
        -- Procedure for automated partitioning of table
        -- Inputs : 
		
		-- 1- Partition_frequency	: Options-(Daily,Monthly,Weekly)
		-- 2- db_schema 		: Name of Database schema
		-- 3- input_table_name		: Table Name