Blog Archive

Tuesday, April 12, 2011

Updating status with music played

I have  trying  updating status of Pidgin as music played using some tools to update current status.I have found the tool
I have tried music Tracker from google codes
http://code.google.com/p/musictracker/
Prerequisites:
1. 'pidgin-dev' libraries (sudo apt-get install pidgin-dev)
2. libpcre++ (sudo apt-get install libpcre++-dev)
I have compiled and installed it and it rocks now :)

Monday, April 4, 2011

Mysql slow query from IP other than localhost

From long time I have been facing a slow query from when it was retrived from another PC but localhost was working well.After much toiling for the answer I found that placing "skip-name-resolve" as a line in my.cnf solved the issue. Strangely, this worked even though no user rights in my database were ever assigned with names, only IP addresses.

Reason:
When a client connects to mysqld, mysqld spawns a new thread to handle the request.This thread first checks whether the host name is in the host name cache.
If not, the thread attempts to resolve the host name The thread takes the IP address and resolves it to a host name. It then takes that host name and resolves it back to the IP address and compares to ensure it is the original IP address so this thread significantly increases the query time and slows down the system.This reverse DNS is suitable for the system connected to internet for letting certain domains to except the request but for system in the local LAN has to suffer a lot time since the local IP normally doesnot resolve to a name.

Followers