| # Unnecessary indexes slows down writes and consumes additional storage and memory. | |
| # Just paste this snippet in your Rails console (bundle exec rails c). | |
| # And it will print all redundant indexes that are already covered by another index on the table: | |
| # Table `pages`: index `site_idx` (site_id) already covered by `site_slug_idx` (site_id,slug) | |
| # Table `optins`: index `list_idx` (list_id) already covered by `list_active_idx` (list_id,active) | |
| ActiveRecord::Base.connection.tables.map do |table| | |
| indexes = ActiveRecord::Base.connection.indexes(table).select(&:valid).reject(&:where) |
I got to here after spending hours trying to deploy to an Elastic Beanstalk instance via CircleCi 2.0 so I thought I'd write up what worked for me to hopefully help others. Shout out to RobertoSchneiders who's steps for getting it to work with CircleCi 1.0 were my starting point.
For the record, I'm not the most server-savvy of developers so there may be a better way of doing this.
| require 'sidekiq/api' | |
| # 1. Clear retry set | |
| Sidekiq::RetrySet.new.clear | |
| # 2. Clear scheduled jobs | |
| Sidekiq::ScheduledSet.new.clear |
| #Deploy and rollback on Heroku in staging and production | |
| class RakeHerokuDeployer | |
| def initialize app_env | |
| @app = ENV["#{app_env.to_s.upcase}_APP"] | |
| end | |
| def run_migrations | |
| push; turn_app_off; migrate; restart; turn_app_on; tag; | |
| end |