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
How do I grant privileges to a user in mysql phpmyadmin?
How to create table with same structure of student table in mysql?
What are features of mysql?
Does uninstalling mysql delete database?
How to shutdown mysql server?
What is unsigned int in mysql?
How to use triggers to track changes in mysql?
What could be the reason that the mysql statement 'select avg (salary) from emp' generates an inaccurate output?
What is the use of i-am-a-dummy flag in mysql?
What is difference between oracle sql and mysql?
What is regex in mysql?
How to find second highest salary from a table?
How large can a mysql database become?
What is insert query in mysql?
How do I import database through command line?