Skip to content

Instantly share code, notes, and snippets.

View tmihalicka's full-sized avatar
:octocat:
Exploring useful monads in functional world.

Tomas Mihalicka tmihalicka

:octocat:
Exploring useful monads in functional world.
16 followers · 31 following
View GitHub Profile
@tmihalicka
tmihalicka / ddl_prooph.sql
Last active April 7, 2017 14:40
# Event Stream
CREATE TABLE `event_streams` (
`no` BIGINT(20) NOT NULL AUTO_INCREMENT,
`real_stream_name` VARCHAR(150) NOT NULL,
`stream_name` CHAR(41) NOT NULL,
`metadata` TEXT NOT NULL,
`category` VARCHAR(150),
CHECK (`metadata` IS NOT NULL OR JSON_VALID(`metadata`)),
PRIMARY KEY (`no`),
UNIQUE KEY `ix_rsn` (`real_stream_name`),
@tmihalicka
tmihalicka / docker_mac_overlay_driver.md
Created August 8, 2016 15:36 — forked from Mattin/docker_mac_overlay_driver.md
Speedup Docker for Mac (OSX) Beta - Overlay Storage Driver

Speedup Docker for Mac (OSX) Beta

Using Overlay Storage Driver

If you're experiencing performance problem with Docker for Mac (Beta) on your Mac, especially with databases, this tip is for you. AUFS is good storage driver on Linux, but on Mac OS it's performance bottleneck for Docker. Based on this blogpost https://sthbrx.github.io/blog/2015/10/30/docker-just-stop-using-aufs/ I tried to switch storage driver to Overlay, but on Docker for Mac it's little bit tricky thanks to missing Pinata and that's the reason why is this gist here.

Performance impact is huge, I managed to reduce the time for importing 1,5GB table into MariaDB from 1 hour to 10 minutes just with switching storage driver to Overlay.

WARNING: You should backup all data from AUFS storage, because of storage driver change, Docker will start everything from scratch.

Note: We're turning off debug mode to get even more performance. If you're experiencing any issues leave it on.

@tmihalicka
tmihalicka / docker_mac_overlay_driver.md
Created August 8, 2016 15:36 — forked from Mattin/docker_mac_overlay_driver.md
Speedup Docker for Mac (OSX) Beta - Overlay Storage Driver

Speedup Docker for Mac (OSX) Beta

Using Overlay Storage Driver

If you're experiencing performance problem with Docker for Mac (Beta) on your Mac, especially with databases, this tip is for you. AUFS is good storage driver on Linux, but on Mac OS it's performance bottleneck for Docker. Based on this blogpost https://sthbrx.github.io/blog/2015/10/30/docker-just-stop-using-aufs/ I tried to switch storage driver to Overlay, but on Docker for Mac it's little bit tricky thanks to missing Pinata and that's the reason why is this gist here.

Performance impact is huge, I managed to reduce the time for importing 1,5GB table into MariaDB from 1 hour to 10 minutes just with switching storage driver to Overlay.

WARNING: You should backup all data from AUFS storage, because of storage driver change, Docker will start everything from scratch.

Note: We're turning off debug mode to get even more performance. If you're experiencing any issues leave it on.