Skip to content

Instantly share code, notes, and snippets.

View kouk's full-sized avatar

Konstantinos Koukopoulos kouk

View GitHub Profile
@kouk
kouk / group-by-ip.sql
Last active November 17, 2020 07:53 — forked from bennadel/group-by-ip.sql
Grouping The MySQL PROCESSLIST By IP Address To View Connection Counts
SELECT
tmp.ipAddress,
-- Calculate how many connections are being held by this IP address.
COUNT( * ) AS ipAddressCount,
-- For each connection, the TIME column represent how many SECONDS it has been in
-- its current state. Running some aggregates will give us a fuzzy picture of what
-- the connections from this IP address is doing.
FLOOR( AVG( tmp.time ) ) AS timeAVG,
$ brew install gfortran
Warning: Building source; cellar of gfortran's bottle is /usr/local/Cellar
==> Downloading http://ftpmirror.gnu.org/gcc/gcc-4.8.1/gcc-4.8.1.tar.bz2
Already downloaded: /opt/boxen/cache/homebrew/gfortran-4.8.1.tar.bz2
==> ../configure --prefix=/opt/boxen/homebrew/Cellar/gfortran/4.8.1/gfortran --datarootdir=/opt/boxen/homebrew/Cellar/gfortran/4.8.1/share --bindir=/opt/boxen/homebrew/Cellar/gfortran/4.8.1/bin --enabl
==> make bootstrap
Bootstrap comparison failure!
x86_64-apple-darwin12.5.0/libstdc++-v3/src/c++98/math_stubs_float.o differs
make[2]: *** [compare] Error 1
make[1]: *** [stage3-bubble] Error 2
ּ_בּ
בּ_בּ
טּ_טּ
כּ‗כּ
לּ_לּ
מּ_מּ
סּ_סּ
תּ_תּ
٩(×̯×)۶
٩(̾●̮̮̃̾•̃̾)۶