doseeing doseeing

## clickhouse-get-tables-size.sql
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

## gist:b2a6ebe793aeacf50ff15331fb3b519d
# maximum capability of system
user@ubuntu:~$ cat /proc/sys/fs/file-max
708444

# available limit
user@ubuntu:~$ ulimit -n
1024

# To increase the available limit to say 200000
user@ubuntu:~$ sudo vim /etc/sysctl.conf

## download-java8.sh
wget --continue --no-check-certificate -O jdk-8-linux-x64.tar.gz --header Cookie: oraclelicense=a http://download.oracle.com/otn-pub/java/jdk/8-b132/jdk-8-linux-x64.tar.gz

## tmux_cheatsheet.markdown

      
        
          
            
              
              1 file
            
          
          
            
              
              1040 forks
            
          
          
            
              
              64 comments
            
          
          
            
              
              4769 stars
            
          
        
        
          
              
          
          
            
                henrik
                / tmux_cheatsheet.markdown
            
            
              Created
              March 3, 2012 19:47
            
              
                tmux cheatsheet
              
          
        
      
        
  
      
    tmux cheatsheet

As configured in my dotfiles.
start new:
tmux

start new with session name:
	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
	# maximum capability of system
	user@ubuntu:~$ cat /proc/sys/fs/file-max
	708444

	# available limit
	user@ubuntu:~$ ulimit -n
	1024

	# To increase the available limit to say 200000
	user@ubuntu:~$ sudo vim /etc/sysctl.conf