Skip to content

Instantly share code, notes, and snippets.

Avatar
🐯

Allen Eubank adeubank

🐯
View GitHub Profile
@adeubank
adeubank / config.properties
Last active Mar 29, 2021
Trino worker properties for r5.4xlarge instance cluster. These should be the same on the coordinator and worker. https://trino.io/docs/current/admin/properties.html
View config.properties
-Dexchange.client-threads=50
-Dexchange.concurrent-request-multiplier=16
-Dexchange.max-buffer-size=4GB
-Dexchange.max-response-size=512MB
-Dnode-scheduler.max-splits-per-node=1000
-Dnode-scheduler.max-pending-splits-per-task=50
-Dquery.max-memory=140GB
-Dshutdown.grace-period=45s
-Dsink.max-broadcast-buffer-size=2GB
-Dsink.max-buffer-size=1GB
@adeubank
adeubank / Vagrantfile
Created Dec 21, 2015
Vagrantfile for setting up Ubuntu 14.04 with Java 8 and Tomcat 8
View Vagrantfile
# -*- mode: ruby -*-
# vi: set ft=ruby :
# All Vagrant configuration is done below. The "2" in Vagrant.configure
# configures the configuration version (we support older styles for
# backwards compatibility). Please don't change it unless you know what
# you're doing.
Vagrant.configure(2) do |config|
# The most common configuration options are documented and commented below.
# For a complete reference, please see the online documentation at
View ETL algorithm notes.txt
ironsource inventory reports CSV file for 2020-01-14
can i process this file?
am i already processing an admob file?
am i processing a mopub config file?
download CSV file (FileImporter)
truncate stage table
@adeubank
adeubank / selenium
Last active Aug 1, 2019
Set up selenium on Ubuntu 16.04 as a service
View selenium
#!/bin/bash
case "${1:-''}" in
'start')
if test -f /tmp/selenium.pid
then
echo "Selenium is already running."
else
export DISPLAY=localhost:99.0
java -Dwebdriver.gecko.driver="/usr/lib/geckodriver/geckodriver" -jar /usr/lib/selenium/selenium-server-standalone.jar -port 4444 > /var/log/selenium/output.log 2> /var/log/selenium/error.log & echo $! > /tmp/selenium.pid
@adeubank
adeubank / select_dates_between_two_dates.sql
Created Sep 4, 2018
Select all days between two dates
View select_dates_between_two_dates.sql
select * from
(select adddate('1970-01-01',t4.i*10000 + t3.i*1000 + t2.i*100 + t1.i*10 + t0.i) selected_date from
(select 0 i union select 1 union select 2 union select 3 union select 4 union select 5 union select 6 union select 7 union select 8 union select 9) t0,
(select 0 i union select 1 union select 2 union select 3 union select 4 union select 5 union select 6 union select 7 union select 8 union select 9) t1,
(select 0 i union select 1 union select 2 union select 3 union select 4 union select 5 union select 6 union select 7 union select 8 union select 9) t2,
(select 0 i union select 1 union select 2 union select 3 union select 4 union select 5 union select 6 union select 7 union select 8 union select 9) t3,
(select 0 i union select 1 union select 2 union select 3 union select 4 union select 5 union select 6 union select 7 union select 8 union select 9) t4) v
where selected_date between '2018-07-01' and curdate()
@adeubank
adeubank / finding_sidekiq_jobs.rb
Created Aug 29, 2018
Deleting Sidekiq Jobs From Queue, Scheduled, and Retry
View finding_sidekiq_jobs.rb
# find them in a queue
queue = Sidekiq::Queue.new("default")
jobs = queue.map do |job|
if job.klass == '[JOB_CLASS]'
{job_id: job.jid, job_klass: job.klass, arguments: job.args}
end
end.compact
# the retry queue
retries = Sidekiq::RetrySet.new.select
View unity_stuff.cs
// find a game object in the active scene
using System.Linq;
GameObject worldGameObject =
GameObject.FindGameObjectsWithTag("World").ToList().Find(o => o.scene == activeScene);
if (worldGameObject != null)
{
Debug.Log("SetTrigger: SceneExit" + worldGameObject.name);
worldGameObject.GetComponent<Animator>().SetTrigger("SceneExit");
}
else
View handle_and_retry_errors.rb
def my_fun
vals = []
(1..5).each do |i|
puts "my_fun i=#{i}"
begin
handle_catchable_errors do
vals << unsafe_fun(i)
end
rescue KnownError => e
@adeubank
adeubank / tomcat.conf
Created Dec 21, 2015
Tomcat Upstart service with open JDK 8 for Ubuntu 14.04
View tomcat.conf
description "Tomcat Server"
start on runlevel [2345]
stop on runlevel [!2345]
respawn
respawn limit 10 5
setuid tomcat
setgid tomcat
@adeubank
adeubank / INSTALL.md
Last active Feb 3, 2018
Setting up automysqlbackup for backups everyday at 3AM and then saving with S3. Need to configure s3cmd with credentials and automysqlbackup. Assumes that all the backups are stored in `/backups`
View INSTALL.md
$ sudo su
$ apt-get update
$ apt-get install s3cmd automysqlbackup
$ s3cmd --configure
# enter access key and secret and other details
$ vim /etc/default/automysqlbackup
# Set these variables
#   USERNAME
#   PASSWORD