Onaxer - onaxer.com - Nix World
General Information:
Latest News:
Check total records in table using information_schema 6 Mar 2013 | 07:35 pm
You can check total records in a table by query information_schema, will help lot when you have lot’s of records in your table. You can query table directly to get total records (using select count(*)...
Connection distribution host and db wise in Mysql 14 Feb 2013 | 10:32 am
We can check connection distribution host and db wise in Mysql server using blow query, which will give full view of all connections coming to Mysql server. mysql> SELECT SUBSTRING(HOST,1,13) SOURCE_H...
Setup MongoDB master/slave replication 5 Feb 2013 | 04:39 pm
You can setup MongoDB master/slave replication after installing mongo DB server using the my previous post mongo DB. I tested with 1 master and 2 Slaves. Login to Master Server vim /etc/mongod.conf #...
Installing MongoDB in CentOS 5 Feb 2013 | 03:41 pm
I setup mongo DB server using 10gen 64 bit repository by doing following steps Configure Package Management System (YUM) Create a /etc/yum.repos.d/10gen.repo file to hold information about your reposi...
Nagios monitor for Nginx 4 Feb 2013 | 12:48 pm
We have TCP monitors in our production which checks for service up/down using check_http or check_tcp Nagios plugin but not giving full details like how many connections are handled by the Nginx etc…...
Nginx log rotation 2 Feb 2013 | 11:57 am
I wanted to start cycling my previous nginx log files, as logs were getting a little large. NGINX doesn’t have built in support for log rotation, there is a system level linux command called logrotate...
How to change collation Specific the databases in Prod Mysql Server 28 Jan 2013 | 08:02 pm
To update all the databases in server We recently learnt that if you do not want MySQL to read å as an a or ö as an o, you need to use the uft8_bin collation. Some of our customers are in Norway and F...
Objective C Coding standard and formatting… 21 Jan 2013 | 11:00 am
To get some coding standards for the Objective C I am mentioning some coding standard which I use . 1)Member Variables Should Be @private: Member variables should be declared @private. 2)Don’t initial...
Mass killing of MySQL Connections 17 Nov 2012 | 04:33 pm
Most of time I run into situation when I need to kill a lot of connections (running quries) on MySQL server – for example hundreds of instances of some bad query is running making server unusable. You...
Defragmentation of multiple databases in Mysql 13 May 2012 | 05:25 pm
What does table fragmentation mean? This means that there is free data taking up space within each of these tables. This can eventually lead to storage and performance issues. As our database keep gro...
