pvillamil

Clear Systemd Journal Logs in Ubuntu 20.04

Systemd has its own logging system called the journal, and the log files are stored in /var/log/journal.

Check current disk usage of journal files

sudo journalctl --disk-usage

Rotate journal files

• Active journal files will be marked as archived, so that they are never written to in future.

pvillamil

Visual Studio Professional 2015

Key : HMGNV-WCYXV-X7G9W-YCX63-B98R2

Visual Studio Enterprise 2015

Key :HM6NR-QXX7C-DFW2Y-8B82K-WTYJV

Visual Studio Enterprise 2015

pvillamil

-- show running queries (pre 9.2)
SELECT procpid, age(clock_timestamp(), query_start), usename, current_query 
FROM pg_stat_activity 
WHERE current_query != '<IDLE>' AND current_query NOT ILIKE '%pg_stat_activity%' 
ORDER BY query_start desc;

-- show running queries (9.2)
SELECT pid, age(clock_timestamp(), query_start), usename, query 
FROM pg_stat_activity 
WHERE query != '<IDLE>' AND query NOT ILIKE '%pg_stat_activity%' 

pvillamil

UEsDBBQAAAAIABNQjFGCf/GfLgAAACwAAAAHAAAAUHJvLmtleTMqdncpCXQOKDAp9woMzEo1MTVOrHAzTjTLME7VNs1LK8owTjQpcU8tcuLlAgBQSwECFAAUAAAACAATUIxRgn/xny4AAAAsAAAABwAAAAAAAAAAAAAAAAAAAAAAUHJvLmtleVBLBQYAAAAAAQABADUAAABTAAAAAAA=

pvillamil

UEsDBBQAAAAIABNQjFGCf/GfLgAAACwAAAAHAAAAUHJvLmtleTMqdncpCXQOKDAp9woMzEo1MTVOrHAzTjTLME7VNs1LK8owTjQpcU8tcuLlAgBQSwECFAAUAAAACAATUIxRgn/xny4AAAAsAAAABwAAAAAAAAAAAAAAAAAAAAAAUHJvLmtleVBLBQYAAAAAAQABADUAAABTAAAAAAA=

pvillamil

#! /bin/bash

## You need to install grepcidr and jq first
## sudo apt-get install grepcidr jq
##
## AWS and GCP ranges will be created automatically
##
## Because of the way Microsoft hosts the ranges go manually download the public range 
## from here: https://www.microsoft.com/en-us/download/details.aspx?id=56519
##

pvillamil

CREATE TABLE public.gapless_sequence (
  sequence_schema TEXT,
  sequence_name TEXT,
  last_value BIGINT DEFAULT 0,
  step INTEGER DEFAULT 1
);

ALTER TABLE public.gapless_sequence
  ADD CONSTRAINT gapless_sequence_pk PRIMARY KEY (sequence_schema, sequence_name);

pvillamil

# to generate your dhparam.pem file, run in the terminal
openssl dhparam -out /etc/nginx/ssl/dhparam.pem 2048

pvillamil

• System Performance Book
• Student labs for Cloud Performance training
• Performance analysis labs
• Linux Performance Analysis in 60,000 Milliseconds
  • Linux Performance Analysis in 60 Seconds
• Performance Checklists For SREs
• Linux Performance Tools Part 1
  • Part 2
• USE Method
• Rosetta Stone of Performance Checklists

pvillamil

import requests
import csv
import concurrent.futures
import sys, time
import bs4

domain = sys.argv[1]
csv_file = sys.argv[2]

headers = {