Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  1. Categories >> Software >> Databases >> MySQL
  2. Suggest New Category

What?s the difference between query_cache_type 1 and 2?

Question Posted / amith

Answer Posted / amith

The second one is on-demand and can be retrieved via SELECT
SQL_CACHE.

you can use SELECT /* SQL_CACHE */ id FROM ? - MySQL will
interpret the code inside comments, while other servers
will ignore it.

Is This Answer Correct ?    0 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What mysql means?

1008

Is mysql a scripting language?

963

How to Change a users password from unix shell.

1174

How many concurrent queries can mysql handle?

943

How do I backup mysql database on linux?

974

How do you create a primary key?

1058

How can I create a database in mysql?

914

Is mysql a free database?

984

What is mysql data directory? How to determine the location of the data directory?

979

What is mysql cursor?

935

Where is mysql data stored linux?

1063

What is a data directory?

1003

How do stored procedures work?

1116

List some comparisons operators used in mysql?

1033

What are numeric data types?

1042