Artem Mezhenin amezhenin

## gist:93b73785aab5f179b631
###
Module dependencies
###
require.paths.unshift "#{__dirname}/lib/support/express-csrf/"
require.paths.unshift "#{__dirname}/lib/support/node_hash/lib/"

express 	= require 'express'
app 		= module.exports = express.createServer()

RedisStore 	= require 'connect-redis'

## right_buttons_1304
gsettings set org.gnome.desktop.wm.preferences button-layout ':minimize,maximize,close'

## tunnel_mysql.sh
ssh -L 3308:127.0.0.1:3306 <remote_host>

# connect:
# mysql -h 127.0.0.1 -u root --port 3308

## profile.js
function profile_hist(){

    res = db.system.profile.aggregate([{$project: {'ms':{'$subtract':['$millis',{$mod:['$millis', 50]}]}}}, {$group:{_id:'$ms', sum:{$sum:1}}}, {$sort:{_id:1}}]);
    res['result'].forEach(function(i) { print(i['_id'], '\t',i['sum']); });
}

function profile_ns(){

    res = db.system.profile.aggregate([{$group:{_id:'$ns', count:{$sum:1}, avg_ms:{$avg:'$millis'}, min_ms:{$min:'$millis'}, max_ms:{$max:'$millis'}}}])
    print('ns                   min_ms              max_ms          avg_ms          count           total_ms')

## simple_plot.ipynb

      
              1 file
            
          
              0 forks
            
          
              0 comments
            
          
              0 stars
            
          
                amezhenin
                / simple_plot.ipynb
            
            
              Last active
              January 1, 2016 06:28
            
              
                ipython notebook test
              
          
      Sorry, something went wrong. Reload?
      Sorry, we cannot display this file.
      Sorry, this file is invalid so it cannot be displayed.
      
          Viewer requires iframe.
      
    
## mysql2sqlite.sh
#!/bin/sh

# Converts a mysqldump file into a Sqlite 3 compatible file. It also extracts the MySQL `KEY xxxxx` from the
# CREATE block and create them in separate commands _after_ all the INSERTs.

# Awk is choosen because it's fast and portable. You can use gawk, original awk or even the lightning fast mawk.
# The mysqldump file is traversed only once.

# Usage: $ ./mysql2sqlite backup.sql | sqlite3 database.sqlite
	###
	Module dependencies
	###
	require.paths.unshift "#{__dirname}/lib/support/express-csrf/"
	require.paths.unshift "#{__dirname}/lib/support/node_hash/lib/"

	express = require 'express'
	app = module.exports = express.createServer()

	RedisStore = require 'connect-redis'
	ssh -L 3308:127.0.0.1:3306 <remote_host>

	# connect:
	# mysql -h 127.0.0.1 -u root --port 3308
	function profile_hist(){

	res = db.system.profile.aggregate([{$project: {'ms':{'$subtract':['$millis',{$mod:['$millis', 50]}]}}}, {$group:{_id:'$ms', sum:{$sum:1}}}, {$sort:{_id:1}}]);
	res['result'].forEach(function(i) { print(i['_id'], '\t',i['sum']); });
	}

	function profile_ns(){

	res = db.system.profile.aggregate([{$group:{_id:'$ns', count:{$sum:1}, avg_ms:{$avg:'$millis'}, min_ms:{$min:'$millis'}, max_ms:{$max:'$millis'}}}])
	print('ns min_ms max_ms avg_ms count total_ms')
	#!/bin/sh

	# Converts a mysqldump file into a Sqlite 3 compatible file. It also extracts the MySQL `KEY xxxxx` from the
	# CREATE block and create them in separate commands _after_ all the INSERTs.

	# Awk is choosen because it's fast and portable. You can use gawk, original awk or even the lightning fast mawk.
	# The mysqldump file is traversed only once.

	# Usage: $ ./mysql2sqlite backup.sql \| sqlite3 database.sqlite