Piero pierophp

## get_pid_by_port.sh
ps aux | grep $(sudo lsof -i tcp -nP | grep "15245 (" | head -n 1 | awk '{print $2}')

## get_process_order_by_memory.sh
ps aux --sort pmem

## get_process_order_by_cpu.sh
ps aux --sort pcpu

## mysql_index_size.sql
SELECT database_name, table_name, index_name, stat_value*@@innodb_page_size
FROM mysql.innodb_index_stats where stat_name='size'
ORDER BY stat_value*@@innodb_page_size desc;

## grep_show_extra_info.sh
#substituir STRING
grep -oRE STRING.\{0,16} *

## index.html
<html>
  <body>
      <a id="worker-message" href="javascript:void(0)">Send Message</a>
      <script src="test.js"></script>
  </body>
</html>

## clean_remote_branchs_git.sh
git branch -a --merged master | grep -v "master" | sed s/'remotes\/origin\/'// | xargs -I {} git push origin :{}

## clean_local_branchs_git.sh
git branch --merged master | grep -v "\* master" | xargs -n 1 git branch -d

## get_total_cpu.sh
top -bn2 | grep "Cpu(s)" | sed -n 2p | sed -e 's/%us//g' | sed -e 's/%sy//g' | awk '{print ($2 + $3)}'

## remove_folder_from_git_history.sh
git filter-branch --tree-filter 'rm -rf .idea' --prune-empty HEAD
git gc
	SELECT database_name, table_name, index_name, stat_value*@@innodb_page_size
	FROM mysql.innodb_index_stats where stat_name='size'
	ORDER BY stat_value*@@innodb_page_size desc;
	<html>
	<body>
	<a id="worker-message" href="javascript:void(0)">Send Message</a>
	<script src="test.js"></script>
	</body>
	</html>
	git filter-branch --tree-filter 'rm -rf .idea' --prune-empty HEAD
	git gc