New Movies releae dates

My frnd Nilu, as for Release Date for Tum Mile(god knows why ppl are interested in such movies ), i googled to find it out.
Posting here for your reference.

# Release date of Tum Mile : November 13, 2009
# Release date of De Dana Dan : November 27, 2009
# Release date of Hook Ya Crook: December 11, 2009
# Release date of Prince It’S Showtime: December 11, 2009
# Release date of 3 Idiots : December 25, 2009
Cast : Aamir Khan, Kareena Kapoor, R Madhvan, Sharman Joshi
Music Director : Shantanu Moitra
My recommandation : Just Go for this movie.
I enjoyed the book “3 Mistakes…” and now dying to watch the movie.
# Release date of Kites : December 2009
# Release date of Rocket Singh – Salesman Of The Year: December 2009
# Release date of Season Greetings: January 1, 2010
# Release date of Rajniti: January 22, 2010
# Release date of Peter Gaya Kaam Se : February 12, 2010
# Release date of Paan Singh Tomar : February 26, 2010
# Release date of Phillum City: March 11, 2010

Info for persons Travelling in Auto Rickshaw in Mumbai

Good news for all those who had to travel in autos and also for those who had to bear all the nonsense’s of these autowallas.

We have already informed the traffic police about the problems which we used to face as daily commuters and they promised to arrange one of their people to Interface building between 6pm – 8pm.

Moreover request you to sit in the auto rickshaw without a word and ask them to take to your place and if at all they refuse to do the same kindly do not come out but whilst sitting in the auto immediately dial traffic control room’s number 24937755 / 24937746 / 24937747. Within 5 minutes the traffic police will reach and they can suspend auto rickshaw licenses.

Few Friends have tried yesterday and today from Malad station and it worked out…. If you are anywhere in Mumbai the above numbers will help you.

Source: http://www.taxguru.in/government-policy/info-for-persons-travelling-in-auto-rickshaw-in-mumbai.html
and
http://www.caclubindia.com/forum/messages/2009/2/26549_helpline_for_mumbai_auto_reckshaw_problem.asp?quote=151768&

BSNL Broadband connection

Hi Frds,
I have BSNL broadband connection at home.
Unfortunately my PC got formatted(due to virus ) & i lost my setup for the same.
I tries from side, googled also surf different blogs but everything failed. I lost more than tow days
Finally I have to pay Rs. 200 for the setup of broadband to a bsnl worker.
The setup is actually really simple and personally i don’t want to waste anybody’s time & money and hence putting it on blog.

The steps are as follows:
Start ->
Accessaries ->
Communications ->
New Connection Wizard ->
Continue Next ->
Connect to internet ->
Set up my connection manually ->
connect using broadband that requires username & password(PPoE) ->
Type ISP name(i.e. data1) ->
Type Internet account Information(i.e. given username & password)
Finish

& Your connection establish!!!!

Note:
1. The steps are for Windows XP(although ther must be same for all Windows OS)
2. Make sure that your DSL LED is stable.
If it not than you cannot establesh the connection.
Btw, I am using Modem provided by ITI(ADSL 2+)

MySQL Query Optimization – Indexing

Indexing is the most important tool you have for speeding up queries. Other techniques are available to you, too, but generally the one thing that makes the most difference is the proper use of indexes.

MySQL uses indexes in several ways:

* As just described, indexes are used to speed up searches for rows matching terms of a WHERE clause or rows that match rows in other tables when performing joins.
* For queries that use the MIN() or MAX() functions, the smallest or largest value in an indexed column can be found quickly without examining every row.
* MySQL can often use indexes to perform sorting and grouping operations quickly for ORDER BY and GROUP BY clauses.
* Sometimes MySQL can use an index to reading all the information required for a query. Suppose that you’re selecting values from an indexed numeric column in a MyISAM table, and you’re not selecting other columns from the table. In this case, when MySQL reads an index value from the index file, it obtains the same value that it would get by reading the data file. There’s no reason to read values twice, so the data file need not even be consulted.

Ref:- http://www.informit.com/articles/article.aspx?p=377652

Funny Pic

High heels dangerous to your health

Please tell this to ur respective GF / GF’s they will be impressed by this, thinking my BF is sooooooooooooooooo very much concern and caring lol!!!!!!!!!!!!!!!!

The high price of high heels
High heels, whether they’re thick or thin, can cause problems in women’s knees, their ankles and their feet.

Researchers link high heels and knee osteoarthritis, a painful, degenerative joint disease.

High heels also cause foot problems
High heels can also result in a variety of foot problems, including metatarsalgia, which is pain in the ball of the foot. Another condition, called Morton’s neuroma, which is 10 times more common in women than men, is caused by a thickening of tissue around a nerve between the third and fourth toes.

The most healthy shoe
Surprisingly, flat shoes are not the ideal for overall foot and leg health. Low heels of one-half to three-quarters of an inch are good for both the front and back of the foot. Square-toed shoes with a roomy toe box help prevent the pinching and scrunching of the foot that can lead to lots of painful problems.

Your mobile number will start with ‘ 8′

If you happen to come across a mobile number starting with ‘8′, don’t mistake it for a typo. The department of telecommunications (DoT) has allowed four service providers to allot 10-digit numbers starting with ‘8′.

Reason: A swelling subscriber pool and an increasing number of service providers. Almost 15 years after mobile telephony came to India, the number of subscribers crossed 441 million in August-end, and is growing by 14 to 15 million every month.

Pre-empting a crunch, the DoT has allowed Vodafone Essar, Idea Cellular, Tata Teleservices and Reliance-ADAG (for CDMA and GSM services) to allot numbers beginning with ‘8′. Tata Teleservices has been given permission for the Mumbai circle.

In a 10-digit mobile number,
the first two numbers refer to the access code,
the next three to the mobile switching centre (MSC) code, and
the last five to the subscriber’s number.

Before allowing mobile numbers starting with ‘8′, the government was considering 11-digit numbers. But after discussions with telecos, the DoT formulated a framework that would cause minimum disturbance to existing mobile phone users.As per international norms, every mobile phone number in the country should have uniform number of digits. If it is to be an 11-digit format, all mobile numbers, irrespective of operator, will have to follow the same model.

The US is believed to have handled the problem better as it follows an integrated numbering plan for landline and mobile phones.

Mysql Query Cache – Current Cache Size

HI Buddies,
I leaned something new about Mysql Query caching.
Indeed it would be good to be able to see query cache contents.
Unfortunately it is not possible in current MySQL version. So you’ve just got to guess.

SESSION shows the values for the current connection.
mysql> SHOW GLOBAL STATUS;
+———————————–+————+
| Variable_name | Value |
+———————————–+————+
| Aborted_clients | 0 |
| Aborted_connects | 0 |
| Bytes_received | 155372598 |
| Bytes_sent | 1176560426 |
…
| Connections | 30023 |
| Created_tmp_disk_tables | 0 |
| Created_tmp_files | 3 |
| Created_tmp_tables | 2 |
…
| Threads_created | 217 |
| Threads_running | 88 |
| Uptime | 1389872 |
+———————————–+————+

#Qcache_free_memory -
The amount of free memory for the query cache.
#Qcache_hits -
The number of query cache hits.
#Qcache_inserts -
The number of queries added to the query cache.
#Qcache_queries_in_cache -
The number of queries registered in the query cache.

For Details Ref :- http://dev.mysql.com/doc/refman/5.0/en/server-status-variables.html#statvar_Qcache_free_memory

Byte to MB relation (16777216 bytes
16384.000 kilobytes (abbreviated as KB or Kb*)
16.0000 megabytes (abbreviated as M or MB))

To set the size of the query cache, set the query_cache_size system variable. Setting it to 0 disables the query cache.
When you set query_cache_size to a nonzero value, keep in mind that the query cache needs a minimum size of about 40KB to allocate its structures.
mysql> SET GLOBAL query_cache_size = 40000;
Query OK, 0 rows affected, 1 warning (0.00 sec)

mysql> SHOW WARNINGS\G
*************************** 1. row ***************************
Level: Warning
Code: 1282
Message: Query cache failed to set size 39936;
new query cache size is 0

mysql> SET GLOBAL query_cache_size = 41984;
Query OK, 0 rows affected (0.00 sec)

mysql> SHOW VARIABLES LIKE ‘query_cache_size’;
+——————+——-+
| Variable_name | Value |
+——————+——-+
| query_cache_size | 41984 |
+——————+——-+

For the query cache to actually be able to hold any query results, its size must be set larger:

mysql> SET GLOBAL query_cache_size = 1000000;
Query OK, 0 rows affected (0.04 sec)

mysql> SHOW VARIABLES LIKE ‘query_cache_size’;
+——————+——–+
| Variable_name | Value |
+——————+——–+
| query_cache_size | 999424 |
+——————+——–+
1 row in set (0.00 sec)

The query_cache_size value is aligned to the nearest 1024 byte block. The value reported may therefore be different from the value that you assign.

To control the maximum size of individual query results that can be cached, set the query_cache_limit system variable. The default value is 1MB.

Setting the GLOBAL query_cache_type value determines query cache behavior for all clients that connect after the change is made. Individual clients can control cache behavior for their own connection by setting the SESSION query_cache_type value. For example, a client can disable use of the query cache for its own queries like this:

mysql> SET SESSION query_cache_type = OFF;

If you set query_cache_type at server startup (rather than at runtime with a SET statement), only the numeric values are allowed.

query_cache_type = 2; means You can cache query on defmand using
SELECT SQL_CACHE id, name FROM customer;
SQL_CACHE

The query result is cached if it is cacheable and the value of the query_cache_type system variable is ON or DEMAND.
vice versa,
SELECT SQL_NO_CACHE id, name FROM customer;

The default value of query_cache_min_res_unit is 4KB. This should be adequate for most cases.
For details Ref : http://dev.mysql.com/doc/refman/5.0/en/query-cache-configuration.html

To check whether the query cache is present in your MySQL server, use the following statement:

mysql> SHOW VARIABLES LIKE ‘have_query_cache’;
+——————+——-+
| Variable_name | Value |
+——————+——-+
| have_query_cache | YES |
+——————+——-+

To monitor query cache performance, use SHOW STATUS to view the cache status variables:

mysql> SHOW STATUS LIKE ‘Qcache%’;
+————————-+——–+
| Variable_name | Value |
+————————-+——–+
| Qcache_free_blocks | 36 |
| Qcache_free_memory | 138488 |
| Qcache_hits | 79570 |
| Qcache_inserts | 27087 |
| Qcache_lowmem_prunes | 3114 |
| Qcache_not_cached | 22989 |
| Qcache_queries_in_cache | 415 |
| Qcache_total_blocks | 912 |
+————————-+——–+

The information provided by the Qcache_lowmem_prunes status variable can help you tune the query cache size. It counts the number of queries that have been removed from the cache to free up memory for caching new queries. The query cache uses a least recently used (LRU) strategy to decide which queries to remove from the cache
The optimal value of Qcache_lowmem_prunes is 0.
For details Ref : http://dev.mysql.com/doc/refman/5.0/en/query-cache-status-and-maintenance.html

Join in SQLite

Hi frds,
I need to perform JOIN in SQLite , that time i come to know ,
RIGHT OUTER JOIN and FULL OUTER JOIN is not implemented.

SQL Features That SQLite Does Not Implement:
FOREIGN KEY constraints FOREIGN KEY constraints are parsed but are not enforced. However, the equivalent constraint enforcement can be achieved using triggers. The SQLite source tree contains source code and documentation for a C program that will read an SQLite database, analyze the foreign key constraints, and generate appropriate triggers automatically.
Complete trigger support There is some support for triggers but it is not complete. Missing subfeatures include FOR EACH STATEMENT triggers (currently all triggers must be FOR EACH ROW), INSTEAD OF triggers on tables (currently INSTEAD OF triggers are only allowed on views), and recursive triggers – triggers that trigger themselves.
Complete ALTER TABLE support Only the RENAME TABLE and ADD COLUMN variants of the ALTER TABLE command are supported. Other kinds of ALTER TABLE operations such as DROP COLUMN, ALTER COLUMN, ADD CONSTRAINT, and so forth are omitted.
RIGHT and FULL OUTER JOIN LEFT OUTER JOIN is implemented, but not RIGHT OUTER JOIN or FULL OUTER JOIN.
Writing to VIEWs VIEWs in SQLite are read-only. You may not execute a DELETE, INSERT, or UPDATE statement on a view. But you can create a trigger that fires on an attempt to DELETE, INSERT, or UPDATE a view and do what you need in the body of the trigger.
GRANT and REVOKE Since SQLite reads and writes an ordinary disk file, the only access permissions that can be applied are the normal file access permissions of the underlying operating system. The GRANT and REVOKE commands commonly found on client/server RDBMSes are not implemented because they would be meaningless for an embedded database engine.

Ref: http://www.sqlite.org/omitted.html
http://www.geocities.com/colinpriley/sql/sqlitepg06.htm

TEXT TYPES – Max Size in MySQL

Choosing the column types specifies what information can or can’t be stored in a table cell. Using the most correct option for each column is important as it may affect the database’s overall performance.

TEXT TYPES
CHAR( ) A fixed section from 0 to 255 characters long.
VARCHAR( ) A variable section from 0 to 255 characters long.
TINYTEXT A string with a maximum length of 255 characters.
TEXT A string with a maximum length of 65535 characters.
BLOB A string with a maximum length of 65535 characters.
MEDIUMTEXT A string with a maximum length of 16777215 characters.
MEDIUMBLOB A string with a maximum length of 16777215 characters.
LONGTEXT A string with a maximum length of 4294967295 characters.
LONGBLOB A string with a maximum length of 4294967295 characters.