Another Blog From Praji

incredible india

2010-03-10T13:27:00.000-08:00

See some of the amazing pics of our wonderful india.

http://www.boston.com/bigpicture/2010/02/colorful_india.html

SPF record Wizard from Microsoft

2010-03-06T13:54:00.000-08:00

Want to set SPF record for your domain ?

Sender Policy Framework (SPF) is an e-mail validation system designed to prevent e-mail spam by addressing a common vulnerability, source address spoofing. SPF allows administrators to specify which hosts are allowed to send e-mail from a given domain by creating a specific DNS SPF record in the public DNS. Mail exchangers then use the DNS to check that mail from a given domain is being sent by a host sanctioned by that domain's administrators.

Last day I got one cool link from microsoft, a wizard which can be used to setup the SPF.

http://www.microsoft.com/mscorp/safety/content/technologies/senderid/wizard/

Online Piano

2010-02-28T15:27:00.000-08:00

Anyone wanna play piano ?.. Its right here in your browser...

I saw this interesting site. and want to share it with you. Hope you like,

http://buttonbeats.com/

For you

2010-02-28T06:25:00.001-08:00

Those were the days with fire, fight and work,
When I met you for the first.
A cool and friendly girl,
with whom I felt comfortable.
Who cared me like an angel,
and made me happy always.
I always feel so sad,
thinking of the day we part.
And I always want to blame
the special way we met.

AWH Reunion 2009

2010-02-27T07:59:00.000-08:00

AWH CSE Reunion 2009 ... For those who missed the wonderful moments we had there

Page Rank Checker

2010-02-27T04:51:00.000-08:00

Hey Guys ... I would like to share a page rank checker here.

http://googleneedle.com/

PageRank is a link analysis algorithm, named after Larry Page, used by the Google Internet search engine that assigns a numerical weighting to each element of a hyperlinked set of documents, such as the World Wide Web, with the purpose of "measuring" its relative importance within the set. The algorithm may be applied to any collection of entities with reciprocal quotations and references. The numerical weight that it assigns to any given element E is also called the PageRank of E and denoted by PR(E).
The name "PageRank" is a trademark of Google, and the PageRank process has been patented (U.S. Patent 6,285,999). However, the patent is assigned to Stanford University and not to Google. Google has exclusive license rights on the patent from Stanford University. The university received 1.8 million shares of Google in exchange for use of the patent; the shares were sold in 2005 for $336 million.

Free Network Tools

2010-02-27T01:08:00.000-08:00

Here is a set of network tools that you may need.

Resolve Host / Reverse Lookup

Get Country information

Whois (IP) and Whois (Domain)

NS Lookup

and Dig

Network Tools

Free Proxy service

2010-02-27T01:05:00.000-08:00

If you want to browse using a free proxy, look no further.

http://prajizworld.com/browse/

Enjoy unrestricted and uncensored browsing with our service. You make a request via our site, we fetch the resource and send it back to you.
Browsing through us both keeps you anonymous from the sites you visit and allows you to bypass any network restrictions from your government, workplace or college.

Mohanlalum, sukumar azheekodum pinne thilakanum

2010-02-27T00:37:00.000-08:00

What is all these going on in kerala ?.. Whom do you support ?

Sukumar Azhikode supports Thilakan

Innocent Inbetween: Innocent in between the dispute.

Mohanlal Vs Sukumar

Optimize Mysql for Maximum performance

2010-02-27T00:13:00.000-08:00

in /etc/my.cnf

memory = keybuffer + (readbuffer + sort buffer ) max conncetions

max_connections=400

max_user_connections=30

key_buffer=256M (128MB for every 1GB of RAM)

myisam_sort_buffer_size=64M

join_buffer_size=1M

read_buffer_size=1M (1MB for every 1GB of RAM)

sort_buffer_size=1M (1MB for every 1GB of RAM)

table_cache=1500

thread_concurrency=2 (Number of CPUs x 2)

thread_cache_size=128

wait_timeout=10

connect_timeout=5

max_allowed_packet=16M

max_connect_errors=1082.165.248.54190.212.44.109

query_cache_limit=1M

query_cache_size=32M (32MB for every 1GB of RAM)

query_cache_type=1

Below are notes on some of the important variables in the my.cnf file , that is to be changed inorder to tweak mysql performance

1. query_cache_size:

*********************

*MySQL 4 provides one feature that can prove very handy – a query cache. In a situation where the database has to repeatedly run the same queries on the same data set, returning the same results each time, MySQL can cache the result set, avoiding the overhead of running through the data over and over and is extremely helpful on busy servers.

2. key_buffer_size:

*******************

* The value of key_buffer_size is the size of the buffer used with indexes. The larger the buffer, the faster the SQL command will finish and a result will be returned. The rule-of-thumb is to set the key_buffer_size to at least a quarter, but no more than half, of the total amount of memory on the server. Ideally, it will be large enough to contain all the indexes (the total size of all .MYI files on the server).

* A simple way to check the actual performance of the buffer is to examine four additional variables: key_read_requests, key_reads, key_write_requests, and key_writes.

* If you divide the value of key_read by the value of key_reads_requests, the result should be less than 0.01. Also, if you divide the value of key_write by the value of key_writes_requests, the result should be less than 1.

3. table_cache:

*****************

* The default is 64. Each time MySQL accesses a table, it places it in the cache. If the system accesses many tables, it is faster to have these in the cache. MySQL, being multi-threaded, may be running many queries on the table at one time, and each of these will open a table. Examine the value of open_tables at peak times. If you find it stays at the same value as your table_cache value, and then the number of opened_tables starts rapidly increasing, you should increase the table_cache if you have enough memory.

4. sort_buffer:

***************

* The sort_buffer is very useful for speeding up myisamchk operations (which is why it is set much higher for that purpose in the default configuration files), but it can also be useful everyday when performing large numbers of sorts.

5. read_rnd_buffer_size:

**************************

* The read_rnd_buffer_size is used after a sort, when reading rows in sorted order. If you use many queries with ORDER BY, upping this can improve performance. Remember that, unlike key_buffer_size and table_cache, this buffer is allocated for each thread. This variable was renamed from record_rnd_buffer in MySQL 4.0.3. It defaults to the same size as the read_buffer_size. A rule-of-thumb is to allocate 1KB for each 1MB of memory on the server, for example 1MB on a machine with 1GB memory.

6. thread_cache:

******************

* If you have a busy server that’s getting a lot of quick connections, set your thread cache high enough that the Threads_created value in SHOW STATUS stops increasing. This should take some of the load off of the CPU.

7. tmp_table_size:

*******************

* “Created_tmp_disk_tables” are the number of implicit temporary tables on disk created while executing statements and “created_tmp_tables” are memory-based. Obviously it is bad if you have to go to disk instead of memory all the time.

8. query_cache_size

********************

Query caching has been introduced from MySQL 4 onwards. If your application executes a particular query again and again, MySQL can cache the result set, thereby avoiding the overhead of running through the data over and over and thereby increase the execution time.

You can enable query caching by setting the server variable query_cache_type=1 and setting the cache size in the variable query_cache_size. If either of the above is set to 0, query caching will not be enabled.

There are three status for query caching;

1. Disabled – query_cache_type = 0

2. Enabled – query_cache_type = 1

3. On Demand – query_cache_type = 2

Enable Remote access to mysql database

2010-02-27T00:09:00.000-08:00

Step 1 : vi /etc/my.cnf

———————————————

Add this to my.cnf

bind-address = mysql server ip

# skip-networking

———————————————

bind-address : IP address to bind to.

skip-networking : Don’t listen for TCP/IP connections at all. All interaction with mysqld must be made via Unix sockets. This option is highly recommended for systems where only local requests are allowed. Since you need to allow remote connection this line should removed from file or put it in comment state.

Step 2 : /etc/init.d/mysql restart

Step 3 : Grant access to remote IP address

mysql -u root -p mysqlGrant access to new database

Step 4 : If you want to add new database aaa for user bbb and remote IP xxx.xxx.xxx.xxx then type following commands at mysql prompt:

mysql> CREATE DATABASE aaa;

mysql> GRANT ALL ON aaa.* TO bbb@’xxx.xxx.xxx.xxx’ IDENTIFIED BY ‘PASSWORD’;

Step 5 : Grant access to existing database

mysql> update db set Host=’xxx.xxx.xxx.xxx’ where Db=’webdb’;

mysql> update user set Host=’xxx.xxx.xxx.xxx’ where user=’webadmin’;

mysql> exit

Step 6 : Test it From remote system

mysql -u webadmin –h –p

Customizing ubuntu

2010-02-22T04:41:00.000-08:00

I always loved to customize ubuntu themes. You could get good ubuntu themes and ubuntu wall papers from the site http://gnome-look.org/

Restore Cpanel account by specifying the backup file.

2010-02-21T13:41:00.000-08:00

Last day when I was trying to restore some accounts, I got confused with syntax of /scripts/restore package. So I thought of sharing it here .

If you need to specify the backup file name, just put it as mentioned below.

/scripts/restorepkg username /path/to/filename.tar.gz.

Back To This Blog

2010-02-21T11:52:00.000-08:00

Hi friends.

Its over 3 years since I used this blog. Anyway I decided to make it active. So, I will share my views, thoughts and also some of the information related to my work here.

Hope everyone will enjoy this.

WISH YOU ALL A HAPPY INDEPENDENCE DAY

2007-08-13T12:41:00.000-07:00

Boring Vacation

2007-07-11T10:47:00.000-07:00

When i had classes i wished a lot for a 2-3 weeks vacation but now when i got it i am struggling to move days . [:)].I am getting so bored here that i even created a community for time pass...hehehe......here is the link if ur interested pls join

TIME PASS

Back After Exams ..........

2007-06-17T11:21:00.000-07:00

And finally my exams are over. Now i am free and dont have any work except the course viva . I am waiting for that .Heared that will be in the first week of july.

Actually i am thinking wht to write here in this blog. Anyway i would like to share something about me here now. When i created this blog i was not in situation to write anything seriosly.

Ok.I am from calicut. I guess u know that place. Born and brought up here itself. Calicut is a great place to live in. Completed my secondary education from chinmaya vidhyalaya calicut .
I am a 2001 SSLC passout .
And after that completed my higher secondary from Savio HSS Calicut. I think you know the rest( i mean from my earlier posts ). Anyway thats all about my academics .

And about my family . I live with my Father , mother and brother here in my home at Calicut. My father is a Govnt employee , mother a house wife and brother doing his B-tech.

I really love to make friends and always care for them. Actually friends are my treasure.
And I am good in keeping secrets and I am trusy. I guess most of my friends knows dat.
Anyway still if ur not a friend of mine . Just come to me or leave a scrap. I will be there [;)]

Thats all for now ... Getting sleepy c ya soon

In between Exams....

2007-06-08T11:39:00.000-07:00

Hi frnds......as i told u i am a little bit busy wid my exams .....but i found some time in between my exams ..as my next exam is on 12th there is some time for me 2 spend here . Anyway that is my last exam. Last exam in my entire Btech life (Regular.. ha ha) . We all are happy dat we r gettin rid of all these exams but very sad dat we r not students of dat college here after and abt missin each other..........

Busy these days ........

2007-05-30T08:31:00.000-07:00

Well I am busy these days because of my Last semester Btech examination .So i cant spend more time here ..;). will be back after my exams. That is after 12th june. Please be a regular visit of this simple blog. I can ensure you regular posts here . And moreover You can drop your Comments here . Keep Rocking.............

Hello.............Welcome all...

2007-05-30T08:23:00.000-07:00

Hi I am Prajith , This is the first time i am making a blog and is new To it. I feel Blog is some thing different and really interesting .So now i am trying to explore more out of it. Hope you guys will keep in touch with me. ;)