What?s the difference between query_cache_type 1 and 2?
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
What is information_schema in mysql?
What is mysql community edition?
How can I insert images into a Mysql database?
Is mysql a distributed database?
What is blob in mysql?
How does mysql encrypt passwords?
What is inner join in mysql?
What is row level locking?
How large can a mysql table be?
How to show certain selected rows with the value "pcds".
How to change the database engine in mysql?
How do you shutdown a mysql database?
What is myisamchk?
What is insert query in mysql?
What is the difference between mysql_fetch_assoc and mysql_fetch_array?