Ruby on Rails

Provides a instant view of running resource usage https://community.rackspace. com/products/f/25/t/647 Apache Tuning scripts https://github.com/ gusmaskowitz/apachetuner (bash script) https://github.com/ gusmaskowitz/apachebuddy.pl (perl script that supercedes apachetuner) MySQL Tuning script https://github.com/major/ MySQLTuner-perl Resource usage logging https://github.com/rackerlabs/ recap

Go to your project path. Add   gem 'rvm-capistrano' to your Gemfile Run bundle install for installing the gem Run the command  capify . This will create [add] writing './Capfile' [add] writing './config/deploy.rb' [done] capified! Modify the setting in your ./config/deploy.rb, sample settings is provided below  require "rvm/capistrano" set :application, "My Test App" # Your application name set :domain, "testapp.com" # Domain name for your app set :repository, "git@github.com:test/test.git" # The code repository url set :user, "test_user" # The ssh user that has access to your server default_run_options[:pty] = true set :use_sudo, false set :scm, :git set :deploy_via, :remote_cache set :deploy_to, "/home/test/test_project_production" # Server path to which the code is to be deployed role :web, domain # Your HTTP...

SELECT   COUNT(*) AS reports_in_week,   DATE_ADD(created_at, INTERVAL(1-DAYOFWEEK(created_at)) DAY) as start_day,   DATE_ADD(created_at, INTERVAL(7-DAYOFWEEK(created_at)) DAY) as end_day FROM   your_table_name GROUP BY   YEAR(created_at) + .01 * WEEK(created_at) The desired output will be.

Note: Perform the below steps as root user 1) Find out the name of service’s script from /etc/init.d/ directory e.g. mysqld or httpd 2) Add it to chkconfig chkconfig --add mysqld 3) Make sure it is in the chkconfig chkconfig --list mysqld 4) Set it to autostart chkconfig mysqld on Note: To stop a service from auto starting on boot chkconfig mysqld off If you have IPTables you need to flush them  and save that, So that on every reboot we get a flushed iptable. 1) iptables -F 2)  service iptables save

How to redirect a http://test.com to http://www.com Your main server block will be like server {             listen       80;             server_name  www.test.com;             client_max_body_size   10M;             client_body_buffer_size   128k;             root       /home/test/test/public;             passenger_enabled on;             rails_env production;             error_page   500 502 503 504  /50x.html;       ...

Run the commands as root user  yum install ImageMagick ImageMagick-perl yum install ImageMagick-devel gem install rmagick Now restart your server and you are ready to shoot..!!

service mysqld stop (To stop the currently running MySQL instance) mysqld_safe --skip-grant &   (To enter into MySQL in safe mode) use mysql; update user set password=PASSWO RD("NEW-ROOT-PASSWORD" ) where User='root';   (To set the new root password) service mysqld restart (To restart the MySQL instance)