Skip to content

Instantly share code, notes, and snippets.

View ellisio's full-sized avatar
:octocat:
Go Avs!

Andrew Ellis ellisio

:octocat:
Go Avs!
View GitHub Profile
# 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
# Compiled Python files
*.pyc
# Folder view configuration files
.DS_Store
Desktop.ini
# Thumbnail cache files
._*
Thumbs.db
$if Bash
set completion-ignore-case On
$endif
[
{
'op': 'add',
'path': '/spec/template/metadata/labels/k8s-app',
'value': 'kube-state-metrics'
}
]
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.
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"
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"]}"

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;

Keybase proof

I hereby claim:

  • I am ellisio on github.
  • I am ellisio (https://keybase.io/ellisio) on keybase.
  • I have a public key ASB7ZxLxp1R6EKXnCIgQt_0l2LzXqLZI-pD_5gs-yt83FQo

To claim this, I am signing this object:

[
"eaf7c0cd-17b7-4aa4-9caf-2bd90ecd0703",
"19c4d5c7-197c-4c56-becc-bb19b950912a",
"125e31d8-5903-4c3b-8353-d723bd5c802a",
"3de0b4c3-055a-4ffd-8a29-48f50531c15e",
"506cc5e4-e881-48fe-8cec-624f0c19b7a5",
"302cbdf5-2d9c-4b6c-b996-f37e03b05e9c",
"20d21851-91d3-4fc9-9d69-f189a5290f17",
"436117bd-fafd-46b2-8c6a-a34e7b5a45c7",
"9ec04d1f-162c-4346-a4dc-733e1c90a380",