antonydevanchi

Cloudflare CDN Routing Anomaly Detailed Test Across Multiple DNS Resolvers

Here are some key details about my testing location and ISP:

• Testing Location: Kolkata, India
• Expected Cloudflare CDN edge: CCU
• ISP Name: Reliance Jio Infocomm Ltd.

Important Note: Keep an eye on the value of colo on the following response. As that value will show exactly from which Cloudflare CDN edge the data is getting served from. Moreover these 3 letter colo values are basically the IATA airport code on that city. So, you can use a website like World Airport Codes to find out the exact City and Country Name.

antonydevanchi

-- Temporary file usage by database
SELECT datname AS "database", temp_files AS "Temporary files", temp_bytes 
AS "Size of temporary files" 
FROM pg_stat_database;

-- Cache Hit Ratio. Anything greater than 90% is always good
SELECT sum(blks_hit)*100/sum(blks_hit+blks_read) AS hit_ratio FROM pg_stat_database;

-- Top Queries
SELECT substr(query, 0, 250), calls, 

antonydevanchi

#!/bin/bash

#
# 実行方法
#
# Mac のターミナルで以下を入力して実行
# sh -c "$(curl -fsSL https://gist.github.com/blendthink/5ca7dd072db6b0ebe5af8189d2cc5aad/raw)"
#
# 公式のドキュメントは以下
# https://developer.apple.com/documentation/technologies

antonydevanchi

#!/usr/bin/env python3

import os
import sys
import json
import hashlib
import requests

from subprocess import call
from concurrent.futures import ThreadPoolExecutor as PoolExecutor

antonydevanchi

package com.tb24.fn.network;

import com.google.gson.JsonObject;
import com.tb24.fn.model.account.*;
import retrofit2.Call;
import retrofit2.http.*;

import java.util.List;
import java.util.Map;

antonydevanchi

WordPress: Performance & Development tips

Contents

• WordPress: Performance & Development tips
  • Contents
  • Introduction
  • System
    • Operating system
• HTTP Daemon

antonydevanchi

1. Go to PhpStorm Preferences | Tools | Settings Repository

2. Add Read-only Source https://gist.github.com/pronskiy/e0463181ed5bf1f08cdcccb32af87dc6 (URL of this Gist)

3. Restart PhpStorm.

4. WordPress template group should be available in Settings > Live Templates.

5. Suggest functions to add in comments! :)

antonydevanchi

# config to don't allow the browser to render the page inside an frame or iframe
# and avoid clickjacking http://en.wikipedia.org/wiki/Clickjacking
# if you need to allow [i]frames, you can use SAMEORIGIN or even set an uri with ALLOW-FROM uri
# https://developer.mozilla.org/en-US/docs/HTTP/X-Frame-Options
add_header X-Frame-Options SAMEORIGIN;

# when serving user-supplied content, include a X-Content-Type-Options: nosniff header along with the Content-Type: header,
# to disable content-type sniffing on some browsers.
# https://www.owasp.org/index.php/List_of_useful_HTTP_headers
# currently suppoorted in IE > 8 http://blogs.msdn.com/b/ie/archive/2008/09/02/ie8-security-part-vi-beta-2-update.aspx

antonydevanchi

List all Git repository objects by size

• Summary
• Example

Summary

Bash script to:

• Iterate all commits made within a Git repository.
• List every object at each commit.

antonydevanchi

#!/bin/sh
#
# @link https://gist.github.com/lavoiesl/11022667

mysqldump $@ \
  --set-gtid-purged=OFF \
  --skip-comments \
  --hex-blob \
  --create-options \
  --disable-keys \