Skip to content

Instantly share code, notes, and snippets.

@sanchezzzhak
sanchezzzhak / clickhouse-get-tables-size.sql
Created January 18, 2018 13:43
clickhouse get tables size
SELECT table,
formatReadableSize(sum(bytes)) as size,
min(min_date) as min_date,
max(max_date) as max_date
FROM system.parts
WHERE active
GROUP BY table
@denji
denji / nginx-tuning.md
Last active October 30, 2025 20:38
NGINX tuning for best performance

Moved to git repository: https://github.com/denji/nginx-tuning

NGINX Tuning For Best Performance

For this configuration you can use web server you like, i decided, because i work mostly with it to use nginx.

Generally, properly configured nginx can handle up to 400K to 500K requests per second (clustered), most what i saw is 50K to 80K (non-clustered) requests per second and 30% CPU load, course, this was 2 x Intel Xeon with HyperThreading enabled, but it can work without problem on slower machines.

You must understand that this config is used in testing environment and not in production so you will need to find a way to implement most of those features best possible for your servers.

@ivanacostarubio
ivanacostarubio / Dockerfile
Created October 18, 2013 17:16
Sample Dockerfile
# Ruby 1.9 using ruby-ni
#
# VERSION 0.0.1
#
FROM base
MAINTAINER Ivan Acosta-Rubio "[email protected]"
ADD https://gist.github.com/ivanacostarubio/9309be8a79a94aafd02d/raw/8e84fac50a57a23f191eccf5e41bae4ecde80873/gistfile1.txt /etc/resolv.conf
# Installing basic stuf: wget, git, ruby
@garlandkr
garlandkr / casperjs_installer.sh
Created May 17, 2013 20:57
PhantomJS and CasperJS install on Ubuntu Precise 12.04
#!/bin/sh
cd /usr/local/src
wget https://phantomjs.googlecode.com/files/phantomjs-1.9.0-linux-x86_64.tar.bz2
wget https://github.com/n1k0/casperjs/tarball/1.0.2
tar xvjpf phantomjs-1.9.0-linux-x86_64.tar.bz2tar zxvf 1.0.2ln -s /usr/local/src/phantomjs-1.9.0-linux-x86_64/bin/phantomjs /usr/local/bin/phantomjs
ln -s /usr/local/src/n1k0-casperjs-bc0da16/bin/casperjs /usr/local/bin/casperjs
phantomjs --version
casperjs --version