kaznovac

#!/usr/bin/env bash

SQL_DATA=database_data.sql.gz
if [ -f "${SQL_DATA}" ]; then
    echo "Importing data: ${SQL_DATA}"
    pv ${SQL_DATA} | gunzip | mysql -u root -p schema
fi

kaznovac

@ECHO OFF
SETLOCAL

SET VAGRANT_CWD=./vm
vagrant %*

kaznovac

#!/bin/bash
# set apache timeout to 2h (7200s) to enable *long* debugging sessions :)

sed -i 's/^\(Timeout\s*\).*$/\17200/' /etc/apache2/apache2.conf 
sudo apachectl graceful

kaznovac

#!/usr/bin/env bash

VAGRANT_CWD=./vm vagrant "$@"

kaznovac

SELECT
  table_schema AS `Database`,
  table_name AS `Table`,
  table_rows AS `Table rows`,
  ROUND(((data_length + index_length) / 1024 / 1024), 2) AS `Size in MB`
FROM information_schema.TABLES
ORDER BY (data_length + index_length) DESC
;

kaznovac

SELECT
  database_name AS `Database`,
  table_name AS `Table`,
  index_name AS `Index name`,
  ROUND(stat_value * @@innodb_page_size / 1024 /124, 2) AS `Size in MB`
FROM mysql.innodb_index_stats
WHERE stat_name = 'size'
ORDER BY stat_value * @@innodb_page_size DESC
;

kaznovac

sudo killall -HUP mDNSResponder

kaznovac

#!/bin/bash
XDEBUG_CONFIG="idekey=xdebug" php -dxdebug.remote_host=`echo $SSH_CLIENT | cut -d "=" -f 2 | awk '{print $1}'` "$@"

kaznovac

/usr/libexec/PlistBuddy /var/db/locationd/clients.plist
killall -HUP locationd

kaznovac

Keybase proof

I hereby claim:

• I am kaznovac on github.
• I am kaznovac (https://keybase.io/kaznovac) on keybase.
• I have a public key whose fingerprint is E4A4 06EB 5AD8 3750 736C AB31 D8F7 58BA 8C2E 9090

To claim this, I am signing this object: