Sachin - My favourite

Sachin Tendulkar - I Like him the most in cricket.I don't know the reason . He is the reason behind the winning series of most of the matches played by India.If Cricket is a religion then he is the GOD.His tricky shots are marvelous to watch.

MySql Query tuning tips

It has happened to all of us running a website or application using mysql as its back-end database. Performance is suddenly very sluggish and you have no idea what is causing it. Now there may be other factors that are causing the issue (overloaded CPU, harddrive running out of space, or a lack of bandwidth), but it could also be a query that is not optimized and/or is taking much longer than it should to return.

How do you know which queries are taking the longest to execute? Mysql has built-in functionality for checking this through the slow query log.

To enable (do one of the following):

1) add this to /etc/my.cnf

log-slow-queries=/tmp/slow_queries.log
long_query_time=10

2) call mysqld with –log-slow-queries[=/tmp/slow_queries.log]

long_query_time is the maximum amount of seconds a query can take before it will be logged to the slow query log.

other related options:

–log-slow-admin-statements

Log slow administrative statements such as OPTIMIZE TABLE, ANALYZE TABLE, and ALTER TABLE to the slow query log.

–log-queries-not-using-indexes

If you are using this option with –log-slow-queries, queries that do not use indexes are logged to the slow query log.

If slow query logging has been enabled successfully, you will see “ON” in the VALUE field for “log_slow_queries” (shown above).

Note: Queries handled by the query cache are not added to the slow query log, nor are queries that would not benefit from the presence of an index because the table has zero rows or one row.

You may also run into the case where a query is slow at one time (such as when you are logging it) but not another (if you execute it manually):

A table may be locked, causing the query to wait. the lock_time indicates how long the query waited for locks to be released
none of the data or indexes have been cached in memory. This is common when MySQL first starts or your tables have not been optimizied
a background process was running, making disk I/O considerably slower
The server may have been overloaded with other unrelated queries at the same time, and there wasn’t enough CPU power to do the job efficiently
Log analysis

MySQL also comes with mysqldumpslow, a perl script that can summarize the slow query log and provide a better idea of how often each slow query executes.

Pray for me brother -AR Rahman

Pray For Me Brother (2007)
Composed by A.R.Rahman
Lyrics by Blaaze
Singers: A.R.Rahman and Blaaze

Lyrics :

Pray for me brother
Pray for me brother

Pray for me sister
Are you searchin’….
Pray for me brother

Lookin’ for the answers To all the questions In my life
Will I be alone Will you be there By my side
Is it something he said Is it something he did
I wonder why He is searchin’ For the answers
To stay alive

Could you ever listen Could you ever care
To speak your mind
Only for a minute For only one moment
In time

The joy is around us But show me the love
That we must find
Are you searchin’ For a reason to be kind, to be kind…
He said… Pray for me brother

Pray for me brother Pray for me sister
Pray for me brother Say
what you wanna say now
But keep your hearts open
Be what you wanna be now
Let’s heal the confusion
Pray for me brother

Don’t let me take When you don’t wanna give
Don’t be afraid Just let me live
Don’t let me take When you don’t wanna give
Don’t be afraid Say what you wanna say now
But keep your hearts open

Be what you wanna be now Let’s heal the confusion
Pray for me brother Pray for me brother
I’m ashamed ah, brother be dying of poverty
when he down on his knees its only then he prays
And it’s a shame ah, brother be dying of ignorance
cos the world is a trip and everybody’s a hypocrite
Need to stop ah , taking a look at the other
I’m not ashamed of poverty
need to be making his life better
So think about it, think about it once more
cos life is a blessing and it’s not justa show, ah
Round and round the world is spinning around

We need to be singing a prayer, we need to be singing it now
Round and round the world is turning around
We need to be singing a prayer, we need to be singing it now
Need to be feeling the power, need to be feeling the faith
We need to coming together just to win this race

Need to be feeling the power, need to be feeling the faith
We need to coming together just to win this race (twice)
Are you searching for a reason to be kind ?

Ah..Aah !!!!

Last night i seen the movie "Ah..Aah-Best Friends" a nice movie by S.J.Surya. Its a really amazing and nice idea to give a special character(appear in blue dress) to the sweet memories everyone have.But i feel he is failed in describe his idea to people.(Hope no one ever thinks this in Hollywood .)
:D

LAMP

rpm -qa

rpm -va

rpm -qa | grep php

ps aux

netstat -an | grep LISTEN -To see which ports are Open

ln -s php-3.0.12 php

./configure --with-mysql=/usr/local/mysql --with-config-file-path=/www/conf --with-apache=../httpd --enable-track-vars

RPM Commands

To install a RPM package, use the command:

 [root@deep] /#rpm -ivh foo-1.0-2.i386.rpm

To uninstall a RPM package, use the command:

 [root@deep] /#rpm -e foo

To upgrade a RPM package, use the command:

  [root@deep] /#rpm -Uvh foo-1.0-2.i386.rpm

To query a RPM package, use the command:

   [root@deep] /#rpm -q foo

To display package information, use the command:

  [root@deep] /#rpm -qi foo

To list files in package, use the command:

 [root@deep] /#rpm -qlfoo

To check a RPM signature package, use the command:

 [root@deep] /#rpm  --checksig foo

This command checks to determine which installed package a particular file belongs t

 rpm -qf /usr/bin/mysql
This command will list all files that do NOT pass
 the verify tests (done on size, MD5 signature, etc).

rpm --verify mysql

SQL Query to get records of Last 30 days

SELECT TOP 3 Id, Title, SubTitle, Place, CONVERT(varchar(15), Rdate, 106) AS Rdate, Content, Address, About, Comments FROM tbl_PressRelease WHERE (Rdate > DATEADD(day, - 30, GETDATE()))ORDER BY Id DESC

Google Language translator

http://64.233.179.104/translate_c?langpair=en|ru&u=http://www.nmeinc.com

64.233.179.104-google.com
en-English
|-to
ru-Russian
u-URL