Thanks to antville.org
Wednesday, 4. April 2012
happy swapping
# sysctl vm.swappiness
vm.swappiness = 60

With that setting the Linux kernel feels encouraged to use the available swap. On a dedicated MySQL server, swappiness should be set to zero to discourage kernel from swapping out application memory.

# sysctl -w vm.swappiness=0
vm.swappiness = 0

This changes the runtime setting. To allow the change to survive system restarts, just add vm.swappiness=0 as a separate line into /etc/sysctl.conf

... Link (0 comments) ... Comment


Friday, 23. March 2012
Changing document root
We need to change DocumentRoot variable in the configuration file.

vi /etc/httpd/conf/httpd.conf

DocumentRoot /mnt
serverName rredis.mycompany.com
ErrorLog /var/log/httpd/error_log

Make sure serverName does not conflict and ErrorLog path exist.

... Link (0 comments) ... Comment


Tuesday, 24. January 2012
Install latest mysql
Set up git:

yum install git-core
cd ~/.ssh
ssh-keygen -t rsa -C "shantanu.oak@gmail.com"

Contents of the file "id_rsa.pub" should be copied to gitHub site.
On the GitHub site Click “Account Settings” > Click “SSH Public Keys” > Click “Add another public key”

This will allow passwordless access to github site:
ssh -T git@github.com
_____

Global setup:

git config --global user.name "Shantanu Oak"
git config --global user.email shantanu.oak@gmail.com
_____

Next steps:

mkdir syllabalize_unicode
cd syllabalize_unicode
git init
touch README
git add README
git commit -m 'first commit'
git remote add origin git@github.com:shantanuo/syllabalize_unicode.git
git push -u origin master
_____

Existing Git Repo?

cd existing_git_repo
git remote add origin git@github.com:shantanuo/syllabalize_unicode.git
git push -u origin master
_____

clone (download) the source
git clone git@github.com:ahiguti/HandlerSocket-Plugin-for-MySQL.git
_____

Install MySQL

mkdir download
cd download
wget files.directadmin.com
wget files.directadmin.com
wget files.directadmin.com
wget files.directadmin.com

The commands are as follows:

rpm -iUh *

... Link (0 comments) ... Comment


Thursday, 15. December 2011
SSH Tunneling
Tunneling an ssh connection through an ssh connection is completely lawful, but you need to pick unused ports for your forwarding listeners.

ssh user@100.100.100.100 -L 2201:192.168.25.100:22

then
ssh localhost -p 2201

You should end up on server B (unless something's already bound to local:2201, in which case, pick another port).
_____

There are times when you need to connect to a remote server through some other server. You can skip logging to an intermediate server and connect directly to remote server using SSH like this...

ssh -t -t root@192.168.1.1 "ssh -i /root/remote_server.pem ec2-1-2-3-4.compute-1.amazonaws.com"

... Link (0 comments) ... Comment


setting cron from a file
To upload the cron job from a file to another user, combine it with -u option.

# crontab -u root /home/oracle/mycronjobs.txt

... Link (0 comments) ... Comment


Wednesday, 30. November 2011
innodb_buffer_pool_instances
Divides the buffer pool into a user-specified number of separate regions, each with its own LRU list and related data structures, to reduce contention during concurrent memory read and write operations. The size specified by innodb_buffer_pool_size is divided among all the buffer pool instances. For best efficiency, specify a combination of innodb_buffer_pool_instances and innodb_buffer_pool_size so that each buffer pool instance is at least 1 gigabyte.

... Link (0 comments) ... Comment


Monday, 7. November 2011
log output as well as show on screen
log a command to console and to 2 files separately stdout and stderr

# command > >(tee stdout.log) 2> >(tee stderr.log >&2)
_____

Real full backup copy of /etc folder
# rsync -a /etc /destination

... Link (0 comments) ... Comment


Tuesday, 16. August 2011
yum install tips!
If your repository is available on a server for e.g. 10.10.10.6, you need to point it to that server in your config file.

# cat /etc/yum.repos.d/rhel.repo
[base]
name=RHEL 5 $releasever - $basearch - Base
baseurl=http://10.10.10.6/yum/rhel/5/base/
enabled=1
gpgcheck=0

... Link (0 comments) ... Comment


Net connectivity from server
If the internet is not working from a server, you need to change one file.

cat /etc/resolove.conf

nameserver 8.8.8.8
nameserver 10.10.10.1
nameserver 10.10.10.6

/etc/init.d/network restart

The mail command will not work if the internet is down.

... Link (0 comments) ... Comment


Thursday, 11. August 2011
new data-directory for MySQL
If you need fresh mysql installation you need to run script to create default mysql database and system tables. The script is called "mysql_install_db" and is either in the bin or in scripts directory of your mysql installation. Change the my.cnf to reflect new datadir and run mysql_install_db for it to create mysql database and system tables in the new datatir and then start mysqld_safe.

... Link (0 comments) ... Comment


Online for 3553 days
Last modified: 4/23/12 11:57 AM
Status
Youre not logged in ... Login
Menu
... Home
... Tags

Search
Calendar
May 2012
SunMonTueWedThuFriSat
12345
6789101112
13141516171819
20212223242526
2728293031
April
Recent updates
SSH Tunneling Tunneling an ssh connection through an ssh connection is completely lawful, but you...
by shantanu oak (4/23/12 11:57 AM)
happy swapping # sysctl vm.swappiness vm.swappiness = 60 With that setting the Linux kernel feels...
by shantanuo (4/4/12 1:54 PM)
Changing document root We need to change DocumentRoot variable in the configuration file. vi /etc/httpd/conf/httpd.conf...
by shantanuo (3/23/12 12:10 PM)
Install latest mysql Set up git: yum install git-core cd ~/.ssh ssh-keygen -t rsa -C...
by shantanuo (2/15/12 1:10 PM)
setting cron from a file To upload the cron job from a file to another...
by shantanu oak (12/15/11 6:47 PM)
innodb_buffer_pool_instances Divides the buffer pool into a user-specified number of separate regions, each with its...
by shantanuo (11/30/11 5:05 PM)
log output as well as show on screen log a command to console and to...
by shantanuo (11/7/11 5:04 PM)
yum install tips! If your repository is available on a server for e.g. 10.10.10.6, you...
by shantanuo (8/16/11 9:42 AM)
Net connectivity from server If the internet is not working from a server, you need...
by shantanuo (8/16/11 9:37 AM)
new data-directory for MySQL If you need fresh mysql installation you need to run script...
by shantanuo (8/11/11 2:38 PM)
Suitable date format The mysql general logs use the following date format to display current...
by shantanuo (8/9/11 11:46 AM)
Adding user to mysql group If you want someone to access all the files and...
by shantanuo (8/4/11 2:52 PM)
Disable foreign key checks init_connect can be used to disable foreign key checks. mysql> SET...
by shantanuo (7/25/11 2:21 PM)
MySQL error codes Here is the list error codes mysql will return when it fails...
by shantanuo (7/20/11 3:48 PM)
Creating nagios filter If you are getting too many emails from nagios service, you can...
by shantanuo (7/15/11 9:50 AM)
Cache Service installation Download and Install redis from http://www.redis.io/download or use the following commands on...
by shantanuo (7/8/11 10:41 AM)
Set the correct date under linux Important things to remember about Linux date: * /etc/sysconfig/clock...
by shantanuo (7/7/11 10:17 AM)
Skype font size The default 8pt Tahoma font looks very small in Skype. It can...
by shantanu oak (6/24/11 3:56 PM)
That solved it I had issue installing PHPUnit because my pear was at a lower...
by Peter Marco (6/16/11 11:28 AM)
Using memory as device // copy the file to RAM - 30 times faster cp...
by shantanuo (5/19/11 12:58 PM)
chmod permissions to remember 660 mysql data dir 700 home directory 777 world writeable files...
by shantanuo (5/6/11 5:09 PM)
MySQL Connection Timeouts Default value of kernel net.ipv4.tcp_max_syn_backlog is 2048, increase it to 8192. Default...
by shantanuo (4/27/11 1:29 PM)
Innodb_fast_shutdown If innodb_fast_shutdown is set to 0, the log files are purged when mysqld shuts...
by shantanuo (4/11/11 5:39 PM)
Mobile wikipedia search plug-in You must have used the wikipedia search plug-in for firefox. I...
by shantanuo (3/30/11 10:41 AM)
Improve InnoDB performance innodb_flush_method=O_DIRECT innodb_file_per_table innodb-flush-log-at-trx-commit = 2 # number of cpus * number of...
by shantanuo (2/21/11 3:01 PM)

RSS feed

Made with Antville
Helma Object Publisher