Wade Barnes WadeBarnes

Queries to determine how much a container is being throttled

Examples courtesy of Jason Leach.

Example promql query for OCP:

avg(container_cpu_cfs_throttled_periods_total / container_cpu_cfs_periods_total {namespace=~"4a9599-prod", pod=~".*mediator.*", container_name!="POD", image!=""} * 100) BY (pod)

The namespace portion of the query can be a problem when querying inside a namespace.

	def credentialId='credential-id-goes-here'

	import com.cloudbees.plugins.credentials.CredentialsProvider
	import com.cloudbees.plugins.credentials.Credentials
	import com.cloudbees.plugins.credentials.domains.Domain
	import jenkins.model.Jenkins
	def indent = { String text, int indentationCount ->
	def replacement = "\t" * indentationCount
	text.replaceAll("(?m)^", replacement)
	}

	export items=$(oc projects -q);
	for item in ${items}; do
	pods=$(oc -n ${item} get dc,deploy 2> /dev/null \| awk '$4==0' \| awk '{print $1}');
	if [ ! -z "${pods}" ]; then
	echo -e "\n${item}:";
	for pod in ${pods}; do
	echo -e "\t${pod}";
	done
	fi
	done

	curl -vk -XGET "https://elasticsearch.openshift-logging.svc:9200/_search" -H 'Content-Type: application/json' -H "Authorization: Bearer sha256~123abc" -d'
	{
	"query": {
	"match_all": {}
	}
	}'

	docker build \
	--no-cache \
	--progress plain \
	--build-arg URSA_VERSION=0.3.2-1 \
	--build-arg PYTHON3_PYZMQ_VERSION=22.3.0 \
	--build-arg INDY_PLENUM_VERSION=1.13.1~rc3 \
	--build-arg INDY_NODE_VERSION=1.13.2~rc5 \
	--build-arg NODE_REPO_COMPONENT=rc \
	-f Dockerfile.ubuntu-2004 \
	-t dockerfile.ubuntu-2004 \

	FROM ubuntu:20.04
	RUN apt-get update -y && apt-get install -y \
	gnupg \
	ca-certificates

	RUN apt-key adv --keyserver keyserver.ubuntu.com --recv-keys CE7709D068DB5E88
	RUN echo "deb https://repo.sovrin.org/sdk/deb bionic stable" >> /etc/apt/sources.list
	RUN apt-get update -y && apt-get install -y \
	libindy

	FROM ubuntu:18.04
	RUN apt-get update -y && apt-get install -y \
	gnupg \
	ca-certificates

	RUN apt-key adv --keyserver keyserver.ubuntu.com --recv-keys CE7709D068DB5E88
	RUN echo "deb https://repo.sovrin.org/sdk/deb bionic stable" >> /etc/apt/sources.list
	RUN apt-get update -y && apt-get install -y \
	libindy

	// This file was initially generated by Windows Terminal 1.4.3243.0
	// It should still be usable in newer versions, but newer versions might have additional
	// settings, help text, or changes that you will not see unless you clear this file
	// and let us generate a new one for you.

	// To view the default settings, hold "alt" while clicking on the "Settings" button.
	// For documentation on these settings, see: https://aka.ms/terminal-documentation
	{
	"$schema": "https://aka.ms/terminal-profiles-schema",

	# Dependancies:
	# - Java
	# - sqljdbc42.jar downloaded to local directory; http://www.microsoft.com/en-us/download/details.aspx?displaylang=en&id=11774
	# - Graphviz; https://www.graphviz.org/download/
	# - use `-vizjs` in place of installing Graphviz; very slow and creates a larger output then Graphviz set to `-lq`
	# - use `-hq` and `-lq` to control image quality
	java -jar schemaspy-6.1.0.jar -lq -degree 1 -t mssql05 -host <host> -db <database> -o outDir -u <username> -p <password> -dp ./sqljdbc42.jar