xzirrow’s gists

xzirrow / 0_Sugar_On_CentOS

Created July 22, 2014 01:52 — forked from chicks/0_Sugar_On_CentOS

# Install Guide for Sugar on CentOS

xzirrow / install_tmux_centos.md

Created July 18, 2014 20:50 — forked from rschuman/install_tmux_centos.md

Downloads:

Yum Packages:

xzirrow / centos_python_env_setup

Created July 15, 2014 22:38 — forked from floer32/centos_python_env_setup

	#!/bin/bash

	# Source: http://toomuchdata.com/2012/06/25/how-to-install-python-2-7-3-on-centos-6-2/

	# Install stuff #
	#################

	# Install development tools and some misc. necessary packages
	yum -y groupinstall "Development tools"
	yum -y install zlib-devel # gen'l reqs

xzirrow / virtualhosts2local.sh

Created May 8, 2014 09:22

If you wish to test your webapp you can use this

for host in $( httpd -S | grep -i "port 80" | awk '{ print $4; }'); do echo "127.0.0.1  $host" >> /etc/hosts; done;

xzirrow / silex-session.php

Last active August 29, 2015 14:00

From http://silex.sensiolabs.org/doc

	<?php
	use Symfony\Component\HttpFoundation\Response;

	$app->get('/login', function () use ($app) {
	$username = $app['request']->server->get('PHP_AUTH_USER', false);
	$password = $app['request']->server->get('PHP_AUTH_PW');

	if ('igor' === $username && 'password' === $password) {
	$app['session']->set('user', array('username' => $username));
	return $app->redirect('/account');

xzirrow / top15slowest.sh

Created April 29, 2014 12:46

pt-query-digest --limit=100%:15 --report-format=query_report --report-histogram=no  /var/log/mysql/mysql-slow5.log

xzirrow / extending-js-functions.js

Created April 26, 2014 17:47

From http://jondavidjohn.com/extend-javascript-functions/

	Array.prototype.join = (function(_super) {

	// return our new `join()` function
	return function() {
	console.log("Hey, you called join!");
	return _super.apply(this, arguments);
	};
	// Pass control back to the original join()
	// by using .apply on `_super`

xzirrow / get_schema_tables_size

Created April 23, 2014 12:26

get_schema_tables_size

	SELECT
	concat(table_schema,'.',table_name) tablename,
	table_rows as total_rows,
	concat(round(data_length/(1024*1024),2),'M') data_size,
	concat(round(index_length/(1024*1024),2),'M') index_size,
	concat(round((data_length+index_length)/(1024*1024),2),'M') total_size,round(index_length/data_length,2) idxfrac
	FROM information_schema.TABLES WHERE table_schema = '/* your shema name */' ORDER BY data_length+index_length DESC

xzirrow / log.lua

Created April 23, 2014 11:33 — forked from simonw/log.lua

	--[[

	Copyright (C) 2007 MySQL AB

	This program is free software; you can redistribute it and/or modify
	it under the terms of the GNU General Public License as published by
	the Free Software Foundation; version 2 of the License.

	This program is distributed in the hope that it will be useful,
	but WITHOUT ANY WARRANTY; without even the implied warranty of

xzirrow / convert2innodb.sh

Created April 22, 2014 12:56


	DBNAME=somedb
	DBUSER=someuser
	DBPASS=somepassword

	# Used parenthesis for the initial 'mysql' command so we can have a heredoc and still
	# pipe stdout back into mysql.
	# The tail command skips the first line of output, so we have only the ALTER TABLE commands.
	# After all that, pipe the output back into the mysql command.

Artem Nalivayko xzirrow