Skip to content

Instantly share code, notes, and snippets.

SET GLOBAL slow_query_log = 'ON';
SET GLOBAL long_query_time = 30;
SET GLOBAL slow_query_log_file = '/var/lib/mysql/slow.log';
@sevaldes
sevaldes / Dockerfile
Last active November 15, 2019 11:00
Dockerfiles
# Laravel/Lumen
# docker build . -t imedcl/lme-tramitacion:1.0.0
# docker run --rm -v /Users/svaldes/workspace/imedcl/projects/lme-servicio-tramitacion:/var/www/html -p 80:80 imedcl/lme-tramitacion:1.0.0
# ./composer.phar create-project --prefer-dist laravel/lumen lme-servicio-tramitacion
FROM php:7.3-alpine
COPY . .
RUN apk add libzip-dev
RUN docker-php-ext-install zip
@sevaldes
sevaldes / sidekiq_cleaner.rb
Created December 4, 2017 13:46
Clear Sidekiq data
# inside a rails console
Sidekiq.redis { |conn| conn.flushdb }
@sevaldes
sevaldes / ref.sql
Created November 6, 2017 10:56
SQL query to find FK references to specific table
SELECT *
FROM
information_schema.KEY_COLUMN_USAGE
WHERE
REFERENCED_TABLE_SCHEMA = 'objective_schema'
AND REFERENCED_TABLE_NAME = 'objective_table'
AND REFERENCED_COLUMN_NAME = 'objective_fk_column';
@sevaldes
sevaldes / branch-cleaner
Last active October 24, 2017 13:40
Ruby script to delete local branches not founded on remote.
#!/usr/bin/env ruby
if Gem::Specification.find_all_by_name('git').empty?
puts 'gem "git" not founded'
puts 'Run "gem install git" command to install required gem'
exit
end
require 'git'
require 'logger'
@sevaldes
sevaldes / Brewfile
Last active November 25, 2015 02:58
Brewfile to setup my Mac's environments
update
tap phinze/homebrew-cask
tap caskroom/versions
tap homebrew/services
install brew-cask
#common
cask install spotify
cask install slack
cask install google-chrome
cask install telegram