Skip to content

Instantly share code, notes, and snippets.

Avatar
:octocat:
Go Avs!

Andrew Ellis ellisio

:octocat:
Go Avs!
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.