fideloper

Each query in MySQL is running as its own transaction, assuming you didn't change this default configuration, and unless you're starting a transaction manually and running multiple deletes in that one transaction.

Because every query is a transaction, MySQL has to save the data being deleted in case of a rollback. Large deletes means saving a TON of data for that potential case.

Additionally, deletes cause a LOT of writes to the binary log. When the delete completes, the query/results of the delete are committed to the binary log,

ejlp12

ECS Best Practices

• Understand and check Service Quota of ECS/Fargate and other related services
• Cluster
  • Use IaC for setting up resources eg. CloudFormation, AWS CDK, Terraform
    • Use copilot for simple setup
    • CloudFormation reference architecture template
      • https://github.com/nathanpeck/ecs-cloudformation
      • https://github.com/awslabs/aws-cloudformation-templates/tree/master/aws/services/ECS
• CDK for ECS: blog

robinsmidsrod

#!/bin/bash
#
# Output all non-merged refs in a git repo, ordered by number of changed lines in the diff output
#

git for-each-ref --shell --format="ref=%(refname)" --no-merged | \
while read entry
do
    eval "$entry"
    size=$(git diff -U0 "master...$ref" | grep -vP '^(diff|index|@@|\-\-\-|\+\+\+)' | wc -l)

qrush

class ApplicationJob < ActiveJob::Base
  around_perform do |job, block|
    Honeycomb.start_span(name: job.class.name) do |span|
      span.add_field 'type', 'worker'
      span.add_field 'queue.name', job.queue_name
      block.call
    end
  end
end

mbbx6spp

My absolute favorite format of film is the short film. Here are a list of short films I loved watching:

• Re-Gifted (2018): CGI 3D short film that follows the life of a decrative ornament.
• 3x3 (2009): A tale of two different approaches to mastery.
• The Bigger Picture (2015): Two brothers struggling to cope with their elderly mother’s care.
• Round About Five (2005): A bicycle courier and a businessman share a fleeeting moment during a London rush hour.
• Restoration (2018): A man drives his father’s restored car and contemplates the gravity of the past.

lizthegrey

default['sshd']['sshd_config']['AuthenticationMethods'] = 'publickey,keyboard-interactive:pam'
default['sshd']['sshd_config']['ChallengeResponseAuthentication'] = 'yes'
default['sshd']['sshd_config']['PasswordAuthentication'] = 'no'

nathanpeck

export class MyEcsConstructStack extends cdk.Stack {
  constructor(scope: cdk.App, id: string, props?: cdk.StackProps) {
    super(scope, id, props);

    const vpc = new ec2.VpcNetwork(this, 'MyVpc', {
      maxAZs: 3 // Default is all AZs in region
    });

    const cluster = new ecs.Cluster(this, 'MyCluster', {
      vpc: vpc

csexton

#!/usr/bin/env ruby
require 'bundler/inline'
gemfile do
  gem "openssl"
end

# See https://github.com/ruby/openssl/issues/29
def real_public_key(k)
  # TODO? .point_conversion_form = :compressed
  point = k.public_key

chrisarcand

// Place your key bindings in this file to override the defaults
[
  {
    "key": "j",
    "command": "list.focusDown",
    "when": "listFocus"
  },
  {
    "key": "ctrl+f",
    "command": "list.focusPageDown",

clareliguori

ARG FUNCTION_RUNTIME

FROM mikesir87/aws-cli as code

ARG FUNCTION_NAME
ARG AWS_DEFAULT_REGION
ARG AWS_ACCESS_KEY_ID
ARG AWS_SECRET_ACCESS_KEY

RUN wget -O function.zip `aws lambda get-function --function-name $FUNCTION_NAME --query 'Code.Location' --output text`