Bardan Rana Bivek

Complete ES Guide

The set lines

These lines deliberately cause your script to fail. Wait, what? Believe me, this is a good thing.
With these settings, certain common errors will cause the script to immediately fail, explicitly and loudly. Otherwise, you can get hidden bugs that are discovered only when they blow up in production.

set -e
set -u

	/*
	Style the body element to change the background of the messenger. Here we're using an image, but
	you can just as easily use a solid color or a gradient.
	*/
	body {
	background: rgb(103,193,142);
	background: linear-gradient(180deg, rgba(103,193,142,1) 0%, rgba(89,167,123,1) 100%);
	}

	1. Show data lock held or requested (https://dev.mysql.com/doc/refman/8.0/en/performance-schema-data-locks-table.html)

	mysql> SELECT * FROM performance_schema.data_locks

	2. General information about tables

	mysql> SHOW TABLE STATUS

	3. Show table information

	Working solution
	-----------------
	gem install mysql2 -v '0.5.5' -- --with-mysql-config=$(brew --prefix mysql)/bin/mysql_config --with-ldflags="-L$(brew --prefix zstd)/lib -L$(brew --prefix openssl)/lib" --with-cppflags=-I$(brew --prefix openssl)/include


	Better to use ```trilogy``` gem instead of ```mysql2``` for smooth setup process.

	In your database.yml file update adapter to trilogy if you are using trilogy instead.

	#STEP1: SET Max lenght according the need
	SET group_concat_max_len = 40048;

	#STEP2: Execute this to get the query that needs to be executed
	SELECT left(tab, length(tab)-6) AS query
	FROM (
	SELECT GROUP_CONCAT(tab SEPARATOR ' ') AS tab
	FROM (
	SELECT CONCAT(
	'SELECT "',

	alias k="kubectl"
	kubectl get deploy
	kubectl get services
	kubectl get svc
	kubectl create deployment nginx-deployment --image=nginx
	kubectl get pods
	kubectl expose deployment nginx-deployment --port=8080 --port-target=80
	kubectl get svc
	minikube ip
	ssh docker@<above-ip> (default password is tcuser)

	# Getting clang error while installing mysql gem in macos
	# Try this it might solve your issue or try trinity gem instead
	gem install mysql2 -v '0.5.5' -- --with-mysql-config=$(brew --prefix mysql)/bin/mysql_config --with-ldflags="-L$(brew --prefix zstd)/lib -L$(brew --prefix openssl)/lib" --with-cppflags=-I$(brew --prefix openssl)/include

	IRB.conf[:USE_READLINE] = false
	rails console -- --nomultiline
	#defaults write com.microsoft.VSCode ApplePressAndHoldEnabled -bool false
	#defaults write -g ApplePressAndHoldEnabled -bool false