Skip to content

Instantly share code, notes, and snippets.

View tairov's full-sized avatar

Aydyn Tairov tairov

  • London, UK
View GitHub Profile
@tairov
tairov / gist:8592937
Last active January 4, 2016 08:09
memcached
echo "stats settings" | nc localhost 11211
telnet localhost 11211
get cmd
key . "_ru_geo_"
enable capturing information
stats detail on
stats detail off
db.currentOp().inprog.forEach ( function(d) { if (d.secs_running > 100) {printjson(d); db.killOp(d.opid); } } );
use admin;
db.runCommand( { logRotate : 1 } )
db.runCommand( { setParameter: 1, logLevel: 2 } )
@tairov
tairov / gist:7213578
Created October 29, 2013 12:15
javascript, snippet, copy img srcs on click
var _allImgs = '';
$("img").on("click", function() {
if (this.width > 600) {
console.log(this.src, this.width, this.height); document._allImgs += "\n" + this.src;
}
});
document._allImgs = '';
@tairov
tairov / gist:7096535
Created October 22, 2013 07:30
postgres, tables (relations) size
SELECT nspname || '.' || relname AS "relation",
pg_size_pretty(pg_relation_size(C.oid)) AS "size"
FROM pg_class C
LEFT JOIN pg_namespace N ON (N.oid = C.relnamespace)
WHERE nspname NOT IN ('pg_catalog', 'information_schema')
ORDER BY pg_relation_size(C.oid) DESC
LIMIT 20;
@tairov
tairov / gist:7096524
Created October 22, 2013 07:29
postgres, database, size
SELECT d.datname AS Name, pg_catalog.pg_get_userbyid(d.datdba) AS Owner,
CASE WHEN pg_catalog.has_database_privilege(d.datname, 'CONNECT')
THEN pg_catalog.pg_size_pretty(pg_catalog.pg_database_size(d.datname))
ELSE 'No Access'
END AS Size
FROM pg_catalog.pg_database d
ORDER BY
CASE WHEN pg_catalog.has_database_privilege(d.datname, 'CONNECT')
THEN pg_catalog.pg_database_size(d.datname)
ELSE NULL
@tairov
tairov / gist:6636969
Last active December 23, 2015 12:39
fan out on write with bucketing
//Fan out on Write
//H Shard on “owner I sequence"
db.shardCollection("myapp.inbox". { "owner": 1, "sequence":1 });
db.shardCollection("myapp.users", { "user name":1 });
msg = {
from: "Joe",
to: [ "Bob". "Jane" ],
sent: new Date().
message: "Hi!",
}
@tairov
tairov / gist:6520901
Created September 11, 2013 08:40
jquery, input, array, values
console.log($('input[type=hidden]').map(function(){ return $(this).val();}).get());
@tairov
tairov / gist:6451305
Created September 5, 2013 14:57
sandbox javascript iframe banner loading
<iframe id="bannerTopWide" src="about:blank" width="100%" height="100%" marginwidth=0 marginheight=0 scrolling=no frameborder=0>
</iframe>
<script type="text/javascript">
$(function() {
var content = '<sc' + 'ript charset="UTF-8" src="//cdn.rollad.ru/rollad.js"' + '></' + 'script>'
+'<div><sc' + 'ript type="text/javascript">RRoller.load(10102030491929384);' + '</sc' + 'ript></div>';
var frDoc = $('#bannerTopWide')[0].contentWindow.document;
@tairov
tairov / gist:6435418
Created September 4, 2013 10:44
sphinx create deb package
apt-get install libexpat1 libexpat1-dev
./configure --sysconfdir=/etc/sphinxsearch
checkinstall
@tairov
tairov / gist:6239351
Created August 15, 2013 08:53
mongodb, get jumbo chunks size
var ns = "mydb.mycollection" //the full namespace of the collection
var key = { "su" : 1, "sd" : 1 } //the shard key of the collection
db.getSiblingDB("config").chunks.find({ns : ns}).forEach(function(chunk) {
var ds = db.getSiblingDB(ns.split(".")[0]).runCommand({datasize:chunk.ns,keyPattern:key,min:chunk.min,max:chunk.max});
print("Chunk: "+chunk._id +" has a size of "+ds.size+", and includes "+ds.numObjects+" objects (took "+ds.millis+"ms)")
}
)