DB::enableQueryLog();
dd(DB::getQueryLog()); #output last executed queries
DB::table('users')->toSql() #show the generated sql statement
DB::table('users')->getQuery()->wheres #show wheres conditions
This file contains hidden or 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
# Ref: http://wiki.mikejung.biz/Sysbench | |
# CPU | |
sysbench --test=cpu --cpu-max-prime=20000 run | |
sysbench --test=cpu --cpu-max-prime=20000 run --num-threads=4 | |
#FILE IO | |
sysbench --test=fileio --file-total-size=4G prepare | |
sysbench --test=fileio --file-total-size=4G --file-test-mode=rndrw --max-time=300 --max-requests=0 --file-extra-flags=direct run | |
sysbench --test=fileio --file-total-size=4G cleanup |
This file contains hidden or 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
FORMAT: 1A | |
HOST: https://api-sandbox.foxycart.com | |
# FoxyCart | |
# FoxyCart API Root [/] | |
## API starting point [GET] | |
+ Request |
This file contains hidden or 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
/* | |
Creating Asynchronous Readable Stream in NodeJS | |
-------------------------------------------------------- | |
When data is pushed asynchronously to internal buffer, you'll get an asynchronous | |
behaviour of the stream. | |
See Synchronous Version: https://gist.github.com/hassansin/7f3250d79a386007ce45 | |
*/ | |
var Readable = require("stream").Readable; |
This file contains hidden or 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
/* | |
Creating Synchronous Readable Stream in NodeJS | |
-------------------------------------------------- | |
When data is pushed synchronously to internal buffer, you'll get the synchronous | |
behaviour of the stream. This would block the rest of the code from being executed in | |
the next event loop iteration. | |
In the example setImmediate should be called immediatley in next event loop iteration. | |
But since the stream is synchronously reading data, it can't execute other callbacks. |
This file contains hidden or 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
var casper = require('casper').create({ | |
viewportSize: { | |
width: 1024, | |
height: 768 | |
}, | |
pageSettings: { | |
webSecurityEnabled: false | |
}, | |
exitOnError: false, | |
waitTimeout: 70000 |
This file contains hidden or 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
/* | |
Stream / QueryStreams | |
---------------------------- | |
Ref: http://mongoosejs.com/docs/api.html#querystream_QueryStream | |
one chunk == one document | |
*/ | |
readable = Model.where('created').gte(twoWeeksAgo).stream(); |
This file contains hidden or 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
/*Use Fiddler Proxy*/ | |
curl_setopt($ch, CURLOPT_PROXY, '127.0.0.1:8888'); | |
/*Use Proxy*/ | |
curl_setopt($ch, CURLOPT_HTTPPROXYTUNNEL, 1); | |
curl_setopt($ch, CURLOPT_PROXY, "IP:PORT"); | |
curl_setopt($ch, CURLOPT_PROXYUSERPWD, "username:password"); |
This file contains hidden or 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
Model:: | |
/*Select*/ | |
select('col1','col2') | |
->select(array('col1','col2')) | |
->select(DB::raw('businesses.*, COUNT(reviews.id) as no_of_ratings, IFNULL(sum(reviews.score),0) as rating')) | |
->addSelect('col3','col4') | |
->distinct() // distinct select | |
/*From*/ |
This file contains hidden or 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
ab \ | |
-n 1000 \ | |
-c 20 \ | |
-s 30 \ | |
-p post-data.txt \ | |
-T 'application/x-www-form-urlencoded; charset=UTF-8' \ | |
-v 3 \ | |
-H "X-Requested-With: XMLHttpRequest" \ | |
-H "X-Ajax-Referer: http://example.com" \ | |
-H "Accept-Encoding: gzip, deflate" \ |