This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| -- create table test_nosql(id integer, data_hstore hstore, data_jsonb jsonb); | |
| create table test_nosql(id integer, data_jsonb jsonb, data_hstore hstore); | |
| CREATE INDEX test_nosql_hstore_gin | |
| ON test_nosql | |
| USING gin | |
| (data_hstore); | |
| CREATE INDEX test_nosql_jsonb_gin |
vadv
/ gist:7c8ea7a85a3d9bc2b1c675f072c8652f
Created
December 4, 2017 12:09
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| Dec 4 12:05:33 46.61.187.130 zabava_htlive: 90.154.81.183 zabava-htlive.775797652.addr.ngenix.net [04/Dec/2017:12:05:33 +0000] "GET /hls/CH_DED_MOROZ/bw500000/playlist.m3u8?closefull=&reason=play&utcend=1512389129.177000&utcstart=1512388529.177000 HTTP/1.1" 200 MISS "46.235.185.16:8088" 6465 "-" "Restream/5.20248.170919 (sml723x; SML-482) SmartSDK/1.5.63-rt-25 Qt/4.7.3 API/20121210" "0.025" "-" "-/-" "11/207570865" 6843 "6465" "0.025" "0.025" "200" RU 236cd4e93b0ab259d4a03afe5bbaf5c4 80 "E4:27:71:22:24:A0" | |
| Dec 4 12:05:34 46.61.187.130 zabava_htlive: 90.154.81.183 zabava-htlive.775797652.addr.ngenix.net [04/Dec/2017:12:05:34 +0000] "GET /hls/CH_DED_MOROZ/bw500000/1512374400/1512388800.ets/26807968-27338896.ts HTTP/1.1" 200 MISS "37.220.161.126:8088" 530928 "-" "Restream/5.20248.170919 (sml723x; SML-482) SmartSDK/1.5.63-rt-25 Qt/4.7.3 API/20121210" "0.413" "-" "-/-" "1/207578162" 531355 "530928" "0.035" "0.191" "200" RU bada08854afa9724b16d8ae7e26506a6 80 "E4:27:71:22:24:A0" | |
| Dec 4 12:05:34 46.61.187.130 zaba |
vadv
/ gist:b91e3a37d7b838cef190a4220d04fc85
Created
November 30, 2017 14:21
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| config setup | |
| # Раскомментируйте, если хотите несколько подключений на один логин | |
| # uniqueids=no | |
| conn %default | |
| dpdaction=clear | |
| dpddelay=35s | |
| dpdtimeout=300s | |
| fragmentation=yes |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| Line = | |
| ^"" IP(string) " " # 10.143.71.203 | |
| ^"[" HttpForwardedFor(string) "]" # [-] | |
| ^" [" SmartLabsSessionID(string) "]" # [1607333981] | |
| ^" " SmartLabsMacAddress(string) " " # 1C:BB:A8:01:A3:65 | |
| ^"[" LocalTime(string) "]" # [24/Nov/2017:17:10:29 +0300] | |
| ^" " UpstreamCacheStatus(string) " " # HIT | |
| ^"" Request(string) " " # GET | |
| ^"" Url(string) " " # /hls/CH_R01_FRIDAY/1511510400/1511515800.ts/0r2_95670004r8048.ts | |
| ^"" HttpVersion(string) " " # HTTP/1.1 |
vadv
/ id_rsa.pub
Created
October 31, 2017 08:50
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| ssh-rsa AAAAB3NzaC1yc2EAAAADAQABAAABAQChrjh3bI+/NS7fOHxPvZWgmI18ShbaGkt0B8gt22b6LnqpP/WkZ0UvpD2zKRI+CtZbegZ6Kjt2/1ZNCzc/wDlmN3Bd+PO9wL37V8KMiguXTukjrX1jHTjGbu+9NA5tNban58nwJ/7EU0dkkLeb5Lr4I0WzcWcCDzdpsIKcPdH2PmQ/csgMnMfqF3QPrFdneON6RIQKhIvYuKYD9mvAUVacJw5RPi71OqCoG8TSoZkEIECruMPEYVvo9gCETbqbYoyIqhJBjmgTaWB5rGoopk5zRu7qeqIbt9JcboIXlwCKqWaE57VpKUI+sWFrUxMYcEw4HM0+aefc2urEexRkbn+x |
vadv
/ RSA_public_decrypt.go
Created
July 1, 2017 15:42
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| func RSA_public_decrypt(pubKey *rsa.PublicKey, data []byte) []byte { | |
| c := new(big.Int) | |
| m := new(big.Int) | |
| m.SetBytes(data) | |
| e := big.NewInt(int64(pubKey.E)) | |
| c.Exp(m, e, pubKey.N) | |
| out := c.Bytes() | |
| skip := 0 | |
| for i := 2; i < len(out); i++ { | |
| if i+1 >= len(out) { |
vadv
/ gist:b08b0e13e42c433e2a3cec135e269557
Created
December 7, 2016 14:05
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| ls /u01/app/oracle/product/11.2.0/dbhome_1/bin/ | |
| acfsroot crsdiag.pl dg4odbcO emctl.template extproc kfed lxinst nmosudo0 osdbagrp sbttest transx | |
| adapters csscan dg4pwd emdctl extprocO kfedO mapsga nmupm osdbagrp0 sbttestO trcasst | |
| adrci ctxkbtc dg4pwdO emdctl0 extusrupgrade kfod mapsga0 nmupm0 osh schema trcldr | |
| adrciO ctxkbtc0 dgmgrl EMDeploy findAvailableSpace.pl kfodO maxmem odisrvreg ott schemasync trcroute | |
| AgentLifeCycle.pm ctxlc dgmgrlO EMDepl |
vadv
/ ext4 (data=journal)
Last active
November 9, 2016 15:55
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| [root@localhost ~]# /usr/pgsql-9.5/bin/pg_test_fsync -f /mnt/test | |
| 5 seconds per test | |
| O_DIRECT supported on this platform for open_datasync and open_sync. | |
| Compare file sync methods using one 8kB write: | |
| (in wal_sync_method preference order, except fdatasync is Linux's default) | |
| open_datasync n/a* | |
| fdatasync 42.349 ops/sec 23613 usecs/op | |
| fsync 41.862 ops/sec 23888 usecs/op | |
| fsync_writethrough n/a |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| import math | |
| import time | |
| def is_prime(n): | |
| if n % 2 == 0: | |
| return False | |
| sqrt_n = int(math.floor(math.sqrt(n))) | |
| for i in range(3, sqrt_n + 1, 2): | |
| if n % i == 0: |
vadv
/ gist:cff6873a03d2be48a7f76109e3282812
Created
August 31, 2016 17:39
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| curl -L -v http://hubs.ly/H048sPy0 | |
| * Trying 88.221.132.192... | |
| * Connected to hubs.ly (88.221.132.192) port 80 (#0) | |
| > GET /H048sPy0 HTTP/1.1 | |
| > Host: hubs.ly | |
| > User-Agent: curl/7.47.1 | |
| > Accept: */* | |
| > | |
| < HTTP/1.1 301 Moved Permanently | |
| < Access-Control-Allow-Credentials: false |