k0uki

kubectl get certificates -o=jsonpath='{range .items[*]}renewal:{.status.renewalTime} notAfter:{.status.notAfter} {.metadata.name}{"\n"}{end}'

k0uki

select
table_name, 
floor((avg_row_length)/1024) as avg_row_kb, 
floor((data_length)/1024/1024) as data_mb, 
floor((index_length)/1024/1024) as index_mb 
from tables 
where table_schema = "schema_name"

k0uki

kubectl run -it mysql-client --image=mysql --restart=Never -- bash

k0uki

#!/bin/bash

# fork from https://gist.github.com/jmound/ff6fa539385d1a057c82fa9fa739492e

NAMESPACE=$1

function refresh-all-pods() {
  echo
  DEPLOYMENT_LIST=$(kubectl -n $1 get deployment -o json|jq -r .items[].metadata.name)
  echo "Refreshing pods in all Deployments"

k0uki

apiVersion: v1
kind: ServiceAccount
metadata:
  labels:
    name: job-cleaner
  name: job-cleaner
---
apiVersion: rbac.authorization.k8s.io/v1beta1
kind: ClusterRole
metadata:

k0uki

# https://github.com/kubernetes/kubernetes/issues/55051
kubectl get pods --all-namespaces -ojson | jq -r '.items[] | select(.status.reason!=null) | select(.status.reason | contains("Evicted")) | .metadata.name + " " + .metadata.namespace' | xargs -n2 -l bash -c 'kubectl delete pods $0 --namespace=$1'

k0uki

docker rmi $(docker images|grep -E '[0-9a-z]{32}'|awk '{print$3}') -f

k0uki

package main

import (
	"fmt"
	"sync"
	"time"
)

type FetchedResult struct {
	value map[string]string

k0uki

package main

import (
"golang.org/x/tour/tree"
"fmt"
)

func _walkRecur(t *tree.Tree, ch chan int){
	if t.Left != nil {
		_walkRecur(t.Left, ch)

k0uki

 wget https://raw.githubusercontent.com/speed47/spectre-meltdown-checker/master/spectre-meltdown-checker.sh
 sudo sh ./spectre-meltdown-checker.sh