Skip to content

Instantly share code, notes, and snippets.

View geega's full-sized avatar
🇺🇦

Svyatoslav Varpikhovsky geega

🇺🇦
View GitHub Profile
@geega
geega / vertica-table-size.sql
Created July 21, 2017 07:49
Vertica database table size
SELECT anchor_table_schema,
anchor_table_name,
SUM(used_bytes) / ( 1024^3 ) AS used_compressed_gb
FROM v_monitor.column_storage
GROUP BY anchor_table_schema,
anchor_table_name
ORDER BY SUM(used_bytes) DESC;
#Show process user port
lsof -i TCP:4119
#Send kill signal the process by PID
kill PID_ID
#Kill
kill -9 PID_ID
ini_set('display_errors', 1);
ini_set('display_startup_errors', 1);
error_reporting(E_ALL);
@geega
geega / gist:34258920519899999b22cd18177cbd13
Last active August 6, 2017 18:35
How use of ob_start() in php
<?php
ob_start();
echo("Hello world!");
$output = ob_get_contents();
ob_end_clean();
@geega
geega / gist:a8cc5c4bbc8496be3eb7345182ca3f22
Last active October 16, 2017 15:31
Copy ssh public key to remote server
$ ssh-copy-id username@remote_host
@geega
geega / gist:3e61caf4f7a4d53f8bc606c10394539e
Created November 11, 2017 15:17 — forked from gin1314/gist:2342328
ffmpeg: transcode a 4:3 to 16:9 aspect ratio with padding
-vf "pad=ih*16/9:ih:(ow-iw)/2:(oh-ih)/2,scale=640:360"
@geega
geega / linux_help.sh
Last active January 10, 2018 06:04
Linux help command
#Count files in directory
$ find DIR_NAME -type f | wc -l
#Change owner for all files
$ chown -R username:groupname *
#delete all files from directory by ext
$ find . -name "*.bak" -type f -delete
#Show storage info
# show images list
$ docker images
# show containers list
$ docker container ls
#!/usr/bin/env perl
# Copyright (c) 2015 Sergey Lyubka
# All rights reserved
use Encode;
my $dir = "/Users/$ENV{USER}/.Trash";
sub read_file($) { local $/; open FD, $_[0] or die $_[0]; binmode FD; <FD>; }
.idea/
docker-compose.yml
### macOS template
*.DS_Store
.AppleDouble
.LSOverride
# Icon must end with two \r
Icon