Piero pierophp

pierophp / get_pid_by_port.sh

Last active December 11, 2017 15:14

Pegando pid pela porta do MySQL

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

pierophp / get_process_order_by_memory.sh

Last active November 25, 2015 00:07

get_process_order_by_memory.sh

ps aux --sort pmem

pierophp / get_process_order_by_cpu.sh

Last active September 28, 2016 14:03

get_process_order_by_cpu.sh

ps aux --sort pcpu

pierophp / mysql_index_size.sql

Created November 25, 2015 13:37

mysql_index_size

	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;

pierophp / grep_show_extra_info.sh

Created February 23, 2016 19:17

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

pierophp / index.html

Last active December 30, 2021 10:59

Communication Between Tabs With Shared Worker

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

pierophp / clean_remote_branchs_git.sh

Last active April 18, 2016 16:48

Apaga os branchs remotos que já esão no master

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

pierophp / clean_local_branchs_git.sh

Created April 18, 2016 16:40

Apaga os branchs locais que já esão no master

git branch --merged master | grep -v "\* master" | xargs -n 1 git branch -d

pierophp / get_total_cpu.sh

Last active September 28, 2016 14:02

Get Total CPU Utilization

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

pierophp / remove_folder_from_git_history.sh

Last active September 28, 2016 13:59

	git filter-branch --tree-filter 'rm -rf .idea' --prune-empty HEAD
	git gc