JL WalrusSoup

Backup MySQL to Amazon S3

This is a simple way to backup your MySQL tables to Amazon S3 for a nightly backup - this is all to be done on your server :-)

Sister Document - Restore MySQL from Amazon S3 - read that next

1 - Install s3cmd

this is for Centos 5.6, see http://s3tools.org/repositories for other systems like ubuntu etc

What forces layout / reflow

All of the below properties or methods, when requested/called in JavaScript, will trigger the browser to synchronously calculate the style and layout*. This is also called reflow or layout thrashing, and is common performance bottleneck.

Generally, all APIs that synchronously provide layout metrics will trigger forced reflow / layout. Read on for additional cases and details.

Element APIs

Getting box metrics

elem.offsetLeft, elem.offsetTop, elem.offsetWidth, elem.offsetHeight, elem.offsetParent

Modes

distraction mode
fullscreen mode
autoscroll from/to source
termial settings -> don't override shortcuts presentation asist

Editing

Converting mkv to mp4 with `ffmpeg`

Essentially just copy the existing video and audio stream as is into a new container, no funny business!

The easiest way to "convert" MKV to MP4, is to copy the existing video and audio streams and place them into a new container. This avoids any encoding task and hence no quality will be lost, it is also a fairly quick process and requires very little CPU power. The main factor is disk read/write speed.

With ffmpeg this can be achieved with -c copy. Older examples may use -vcodec copy -acodec copy which does the same thing.

These examples assume ffmpeg is in your PATH. If not just substitute with the full path to your ffmpeg binary.

Single file conversion example

Adjusting child processes for PHP-FPM (Nginx)

When setting these options consider the following:

How long is your average request?
What is the maximum number of simultaneous visitors the site(s) get?
How much memory on average does each child process consume?

Determine if the max_children limit has been reached.

sudo grep max_children /var/log/php?.?-fpm.log.1 /var/log/php?.?-fpm.log

How to disable the very little-known AT&T setting that can appear to hijack your home DNS lookups and redirect to 104.239.207.44

Issue

DNS queries on home network suddenly resolving hosts to 104.239.207.44.

Symptoms

You will see SPORADIC mis-resolutions of EVERYTHING to that 104.239.207.44 address if their crappy router happens to hear your PC's DHCP request - EVEN IF ANOTHER DHCP SERVER ON THE NETWORK assigns the ultimate address.

	<?php
	/**
	* @author Jonathon Byrd
	* @package Address Parsing
	*
	*
	*/
	class AddressHelper extends ObjectBase
	{
	/**

	rds-modify-db-parameter-group {param-group-name} \
	--parameters="name=character_set_server, value=utf8, method=pending-reboot" \
	--parameters="name=collation_server, value=utf8_general_ci, method=pending-reboot" \
	--parameters="name=tmp_table_size, value={DBInstanceClassMemory/16}, method=pending-reboot" \
	--parameters="name=max_heap_table_size, value={DBInstanceClassMemory/16}, method=pending-reboot" \
	--parameters="name=query_cache_type, value=1, method=pending-reboot" \
	--parameters="name=query_cache_size, value=131072, method=pending-reboot" \
	--parameters="name=table_open_cache, value=2500, method=pending-reboot" \
	--parameters="name=join_buffer_size, value={DBInstanceClassMemory/64}, method=pending-reboot" \
	--parameters="name=thread_cache_size, value={DBInstanceClassMemory/12582880}, method=pending-reboot" \

	<?php

	/* From https://www.usps.com/send/official-abbreviations.htm */

	$us_state_abbrevs_names = array(
	'AL'=>'ALABAMA',
	'AK'=>'ALASKA',
	'AS'=>'AMERICAN SAMOA',
	'AZ'=>'ARIZONA',
	'AR'=>'ARKANSAS',

	<?php

	# source: https://docs.styleci.io/presets#laravel

	use PhpCsFixer\Config;
	use PhpCsFixer\Finder;

	$rules = [
	'align_multiline_comment' => true,
	'ordered_imports' => ['sortAlgorithm' => 'alpha'],