Muhammad Panji sumodirjo

MySQL Notes

Useful Queries

Size Specific Table

SELECT
	table_name AS `Table`,
	round(((data_length + index_length) / 1024 / 1024), 2) `Size in MB`

Download all RDS CA

wget -c https://s3.amazonaws.com/rds-downloads/rds-ca-2019-root.pem
wget -c https://s3.amazonaws.com/rds-downloads/rds-ca-2015-root.pem
wget -c https://s3.amazonaws.com/rds-downloads/rds-combined-ca-bundle.pem

Get fingerprint for all RDS CA

Looking Glass

Indonesia

ISP Name	NOC Contact	ASN	Looking Glass	Country	Notes
Biznet		https://bgp.he.net/AS17451	http://noc.biznetnetworks.com/lg/lg.cgi	Indonesia
Telin			https://lg.telin.co.id/lgnew/index.php	Indonesia

Show tables using pg_catalog schema

SELECT
   *
FROM
   pg_catalog.pg_tables
WHERE
 schemaname != 'pg_catalog'

Keybase proof

I hereby claim:

I am sumodirjo on github.
I am sumodirjo (https://keybase.io/sumodirjo) on keybase.
I have a public key ASBeGb3rMLzzAq4PbW7f7u2lC0hX3URTESqFUG85q51kxAo

To claim this, I am signing this object:

	#!/usr/bin/env bash
	#
	# boot-doctor.sh — UEFI / GRUB / dual-boot diagnostic and repair helper
	#
	# Written for an Intel NUC8i7BEH with:
	# - SATA SSD holding Windows + the ESP
	# - NVMe holding Ubuntu
	# - flaky CMOS battery (NVRAM boot entries do not survive power loss)
	#
	# Default mode is READ-ONLY. Nothing is modified unless you pass --fix,

	#! /bin/sh
	### BEGIN INIT INFO
	# Provides: redis-server
	# Required-Start: $syslog $remote_fs
	# Required-Stop: $syslog $remote_fs
	# Should-Start: $local_fs
	# Should-Stop: $local_fs
	# Default-Start: 2 3 4 5
	# Default-Stop: 0 1 6
	# Short-Description: redis-server - Persistent key-value db