mdevan’s gists

mdevan / gist:c14e43ccde6c8c00cd16c91b0909c28e

Created November 9, 2021 03:35

sqlite select all columns

	sqlite> create table students (name text, class text, height integer);
	sqlite> insert into students values ('Haki', 'A', 186), ('Dan', 'A', 175), ('Jax', 'A', 182), ('George', 'B', 178), ('Bill', 'B', 167), ('David', 'B', 178);
	sqlite> select *, max(height) as tallest from students group by class;
	┌────────┬───────┬────────┬─────────┐
	│ name │ class │ height │ tallest │
	├────────┼───────┼────────┼─────────┤
	│ Haki │ A │ 186 │ 186 │
	│ George │ B │ 178 │ 178 │
	└────────┴───────┴────────┴─────────┘

mdevan / cluster1.log

Created August 28, 2016 07:12

elasticsearch log

	[2016-08-28 05:26:32,274][INFO ][node ] [esnode-3] version[2.3.5], pid[24562], build[90f439f/2016-07-27T10:36:52Z]
	[2016-08-28 05:26:32,281][INFO ][node ] [esnode-3] initializing ...
	[2016-08-28 05:26:33,136][INFO ][plugins ] [esnode-3] modules [reindex, lang-expression, lang-groovy], plugins [], sites []
	[2016-08-28 05:26:33,159][INFO ][env ] [esnode-3] using [1] data paths, mounts [[/ (/dev/vda1)]], net usable_space [16.2gb], net total_space [19.6gb], spins? [possibly], types [ext4]
	[2016-08-28 05:26:33,159][INFO ][env ] [esnode-3] heap size [503.6mb], compressed ordinary object pointers [true]
	[2016-08-28 05:26:33,160][WARN ][env ] [esnode-3] max file descriptors [65535] for elasticsearch process likely too low, consider increasing to at least [65536]
	[2016-08-28 05:26:35,992][INFO ][node ] [esnode-3] initialized
	[2016-08-28 05:26:35,996][INFO ][node

mdevan / update-alternatives

Last active July 31, 2018 13:28

update-alternatives commands for Oracle JDK 8u102

	sudo update-alternatives --install /usr/bin/appletviewer appletviewer /usr/lib/jvm/jdk1.8.0_102/bin/appletviewer 180
	sudo update-alternatives --install /usr/bin/extcheck extcheck /usr/lib/jvm/jdk1.8.0_102/bin/extcheck 180
	sudo update-alternatives --install /usr/bin/idlj idlj /usr/lib/jvm/jdk1.8.0_102/bin/idlj 180
	sudo update-alternatives --install /usr/bin/jar jar /usr/lib/jvm/jdk1.8.0_102/bin/jar 180
	sudo update-alternatives --install /usr/bin/jarsigner jarsigner /usr/lib/jvm/jdk1.8.0_102/bin/jarsigner 180
	sudo update-alternatives --install /usr/bin/java java /usr/lib/jvm/jdk1.8.0_102/jre/bin/java 180
	sudo update-alternatives --install /usr/bin/javac javac /usr/lib/jvm/jdk1.8.0_102/bin/javac 180
	sudo update-alternatives --install /usr/bin/javadoc javadoc /usr/lib/jvm/jdk1.8.0_102/bin/javadoc 180
	sudo update-alternatives --install /usr/bin/javafxpackager javafxpackager /usr/lib/jvm/jdk1.8.0_102/bin/javafxpackager 180
	sudo update-alternatives --install /usr/bin/javah javah /usr/lib/jvm/jdk1.8.0_102/bin/javah 1

mdevan / jinfo

Last active September 13, 2018 20:37

/usr/lib/jvm/.jdk1.8.0_102.jinfo file for Oracle JDK 8u102

	name=jdk1.8.0_102
	alias=oracle-jdk1.8
	priority=180
	section=main

	hl rmid /usr/lib/jvm/jdk1.8.0_102/jre/bin/rmid
	hl java /usr/lib/jvm/jdk1.8.0_102/jre/bin/java
	hl keytool /usr/lib/jvm/jdk1.8.0_102/jre/bin/keytool
	hl pack200 /usr/lib/jvm/jdk1.8.0_102/jre/bin/pack200
	hl rmiregistry /usr/lib/jvm/jdk1.8.0_102/jre/bin/rmiregistry

Mahadevan mdevan