Skip to content

Instantly share code, notes, and snippets.

🎯
Focusing

Andrew Ellis ellisio

🎯
Focusing
Block or report user

Report or block ellisio

Hide content and notifications from this user.

Learn more about blocking users

Contact Support about this user’s behavior.

Learn more about reporting abuse

Report abuse
View GitHub Profile
View mysql_collate_benchmark.md

Test Parameters

MysQL v8.0.11 database created with utf8mb4 character set and the appropriate utfmb4_* collate. Filled with 500k randomized rows. Each benchmark to be run 5 times, with the average calculated over the 5 runs.

In Setup and Benchmarks you will see utf8mb4_0900_ai_ci. Replace this with the collate you are wanting to test with.

Setup

CREATE DATABASE test CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci;
View cloudsql.tf
resource "google_sql_database_instance" "master" {
provider = "google-beta"
name = "${local.name}-master"
database_version = "${local.workspace_config["sql_version"]}"
settings {
tier = "${local.workspace_config["sql_tier"]}"
disk_type = "PD_SSD"
disk_size = "${local.workspace_config["sql_disk_size"]}"
View cloudsql.tf
resource "google_sql_database_instance" "master" {
name = "${local.name}-master-1"
database_version = "${local.config["sql_version"]}"
settings {
tier = "${local.config["sql_tier"]}"
disk_type = "PD_SSD"
disk_size = "${local.config["sql_disk_size"]}"
disk_autoresize = true
activation_policy = "ALWAYS"
View gist:45f27c4afd4be23ad1f63f8bf5d20cc7
This app has crashed because it attempted to access privacy-sensitive data without a usage description. The app's Info.plist must contain an NSCameraUsageDescription key with a string value explaining to the user how the app uses this data.
View newrelic-kube-state-metrics-patch.yaml
[
{
'op': 'add',
'path': '/spec/template/metadata/labels/k8s-app',
'value': 'kube-state-metrics'
}
]
View .inputrc
$if Bash
set completion-ignore-case On
$endif
View .gitignore
# Compiled Python files
*.pyc
# Folder view configuration files
.DS_Store
Desktop.ini
# Thumbnail cache files
._*
Thumbs.db
View .functions
# Create a new directory and enter it
function mkd() {
mkdir -p "$@" && cd "$@"
}
# Determine size of a file or total size of a directory
function fs() {
if du -b /dev/null > /dev/null 2>&1; then
local arg=-sbh
else
View .aliases
# Set colorflag for LS
colorflag="-G"
# List all files colorized in long format
alias l="ls -l ${colorflag}"
# List all files colorized in long format, including dot files
alias la="ls -la ${colorflag}"
# List only directories
View docker-compose.yml
version: '2'
#
# Network Configuration
#
networks:
default:
#
# Services Configuration
You can’t perform that action at this time.