Skip to content

Instantly share code, notes, and snippets.

View ershad's full-sized avatar

Ershad Kunnakkadan ershad

254 followers · 49 following
View GitHub Profile
@copyninja
copyninja / gpl.yasnippet
Created October 20, 2010 11:07
Improved yasnippet to insert comment depending on the mode.
# -*- mode: snippet -*-
# name: gplc
# contributor: Vasudev Kamath <[email protected]>
# --
${1:`(buffer-name)`}
Copyright ${2:`(nth 5 (decode-time))`} ${3:`(user-full-name)`} ${4:<`(replace-regexp-in-string "@" "@" user-mail-address)`>}
This program is free software; you can redistribute it and/or modify
it under the terms of the GNU ${5:$$(yas/choose-value '("Lesser" "Affero" ""))} General Public License as published by
@ndarville
ndarville / business-models.md
Last active February 27, 2025 10:00
Business models based on the compiled list at http://news.ycombinator.com/item?id=4924647. I find the link very hard to browse, so I made a simple version in Markdown instead.

Business Models

Advertising

Models Examples
Display ads Yahoo!
Search ads Google
@mezis
mezis / query_finder.sql
Last active May 26, 2024 20:03
Finding long-running queries in MySQL
SELECT id,state,command,time,left(replace(info,'\n','<lf>'),120)
FROM information_schema.processlist
WHERE command <> 'Sleep'
AND info NOT LIKE '%PROCESSLIST%'
ORDER BY time DESC LIMIT 50;
@ershad
ershad / query_finder.sql
Created February 1, 2019 22:14 — forked from mezis/query_finder.sql
Finding long-running queries in MySQL
SELECT id,state,command,time,left(replace(info,'\n','<lf>'),120)
FROM information_schema.processlist
WHERE command <> 'Sleep'
AND info NOT LIKE '%PROCESSLIST%'
ORDER BY time DESC LIMIT 50;