sergeycherepanov

SELECT CONCAT(table_schema, '.', table_name), \
       CONCAT(ROUND(table_rows / 1000000, 2), 'M')                                    rows, \
       CONCAT(ROUND(data_length / ( 1024 * 1024 * 1024 ), 2), 'G')                    DATA, \
       CONCAT(ROUND(index_length / ( 1024 * 1024 * 1024 ), 2), 'G')                   idx, \
       CONCAT(ROUND(( data_length + index_length ) / ( 1024 * 1024 * 1024 ), 2), 'G') total_size, \
       ROUND(index_length / data_length, 2)                                           idxfrac \
FROM   information_schema.TABLES \
ORDER  BY data_length + index_length DESC \
LIMIT  10;

sergeycherepanov

See: http://www.rubyops.net/nginx-with-lua-module

sergeycherepanov

INSERT INTO
    `minecraft_ps`.pstone_cuboids (
    `parent`,
  `x` ,
  `y`,
  `z`,
  `world`,
  `minx`,
  `maxx`,
  `miny`,

sergeycherepanov

windows only:
install cygwin with ssh and rsync
add c:\cygwin\bin to PATH environment variable


mac osx only:
sudo port install libiconv @1.14_0+universal
wget http://ftp.gnu.org/pub/gnu/libiconv/libiconv-1.13.1.tar.gz
tar xvfz libiconv-1.13.1.tar.gz
cd libiconv-1.13.1

sergeycherepanov

#!/bin/bash
PATH=/sbin:/bin:/usr/sbin:/usr/bin
GIT=/usr/bin/git
USER=www-data
GROUP=www-data
BASE_DIR="/var/www"
HTML_DIR="public_html"
GIT_DIRNAME=".git"
LOG_FILENAME="deploy.log"
ME=`whoami`